biomart.DAO.RetailerDAO.java Source code

Introduction

Here is the source code for biomart.DAO.RetailerDAO.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package biomart.DAO;

import biomart.Bean.PersonalDetailsBean;
import biomart.Util.Util;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;

/**
 *
 * @author bala
 */
public class RetailerDAO {

    public PersonalDetailsBean viewRetailerDetails(String userId) {
        Session session = Util.getSessionFactory().openSession();
        PersonalDetailsBean personalDetailsBean = (PersonalDetailsBean) session.get(PersonalDetailsBean.class,
                userId);
        session.close();
        return personalDetailsBean;
    }

    public List<PersonalDetailsBean> getAllRetailers() {
        Session session = Util.getSessionFactory().openSession();
        Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
        criteria.add(Restrictions.eq("type", "R"));
        List<PersonalDetailsBean> personalDetailsBeans = criteria.list();
        session.close();
        return personalDetailsBeans;
    }

    public String getRetailerId(String storeName) {

        Session session = Util.getSessionFactory().openSession();
        Criteria criteria = session.createCriteria(PersonalDetailsBean.class);
        criteria.add(Restrictions.eq("storeName", storeName));
        PersonalDetailsBean personalDetailsBean = null;
        if (!criteria.list().isEmpty()) {
            personalDetailsBean = (PersonalDetailsBean) criteria.list().get(0);
            session.close();
            return personalDetailsBean.getUserId();
        }
        session.close();
        return null;
    }

}