/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.healthcarecommonutil.daoimpl;

import com.bestray.healthcarecommonutil.dao.StockiestDetailMasterDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TStockiestDetailMaster;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.classic.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;

/**
 *
 * @author user3
 */
@Repository
public class StockiestDetailMasterDaoImpl extends HibernateDaoSupport implements StockiestDetailMasterDao {
    
    
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }

    @Override
    public void saveStockiestMaster(TStockiestDetailMaster stockiest) throws DataAccessException {
         try{ 
           
            getHibernateTemplate().save(stockiest);
            
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TStockiestDetailMaster> findAllStockiestList(String expr, int min, int max) throws DataAccessException {
         try{
             Session session = getHibernateTemplate().getSessionFactory().openSession();
             Query query = session.getNamedQuery("findAllStockiestList");
             query.setParameter(0,"%"+expr+"%" );
             query.setFirstResult(min);
             query.setMaxResults(max-min);
             List<TStockiestDetailMaster> stockiestList=query.list();
             return stockiestList;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void deleteStockiestMaster(Long stockiestId) throws DataAccessException, IllegalArgumentException {
         try{
            
            getHibernateTemplate().delete(getHibernateTemplate().get(TStockiestDetailMaster.class, stockiestId));
            
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TStockiestDetailMaster getStockiestDetails(Long stockiestId) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TStockiestDetailMaster.class, stockiestId);
        }catch(Exception e){
            throw new DataAccessException();   
        }
    }

    @Override
    public void updateStockiestMaster(TStockiestDetailMaster stockiest) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{
            getHibernateTemplate().update(stockiest);
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public int numberOfStockiestRecords(String expr) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllStockiestList","%"+expr+"%").size();
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TStockiestDetailMaster> getStockiestByName(String expr) throws DataAccessException {
         try{
            return getHibernateTemplate().findByNamedQuery("searchAllStockiestList","%"+expr+"%","%"+expr+"%");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TStockiestDetailMaster> getAllStockiest() throws DataAccessException {
         try{
            return getHibernateTemplate().findByNamedQuery("findAllStockiest");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public boolean isDuplicateStockist(TStockiestDetailMaster stockist) throws DataAccessException {
        try{
            List<TStockiestDetailMaster> stockistList = getHibernateTemplate().findByNamedQuery("findDuplicateStockist",stockist.getStockiestName(),stockist.getStockiestDLNumber(),stockist.getStockiestTINnumber());
            if(!stockistList.isEmpty()){
                return true;
            }else{
                return false;
            }
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
}