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

import com.bestray.healthcarecommonutil.dao.InventoryMasterDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TInventoryMaster;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
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;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author user3
 */

@Repository
public class InventoryMasterDaoImpl extends HibernateDaoSupport implements InventoryMasterDao{
     
    
     @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
     
     
    @Override
    public void saveInventoryMaster(List<TInventoryMaster> inventory) throws DataAccessException {
        try{ 
                for(TInventoryMaster in:inventory){
                        getHibernateTemplate().save(in);
                   }
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TInventoryMaster updateInventoryMaster(TInventoryMaster inventory) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{
            getHibernateTemplate().saveOrUpdate(inventory);
            return inventory;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

    @Override
    public List<TInventoryMaster> getAllInventory() throws DataAccessException {
         try{
            return getHibernateTemplate().findByNamedQuery("findAllInventory");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void deleteInventoryMaster(TInventoryMaster inventory) throws DataAccessException {
         try{ 
              getHibernateTemplate().delete(inventory);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    @Override
    public int numberOfProcedureRecords(String expr) throws DataAccessException {
        try{
            List<TInventoryMaster> inventoryMasterList = getHibernateTemplate().findByNamedQuery("findInventoryListBySearch","%"+expr+"%");
            return inventoryMasterList.size();
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public boolean checkInventoryForDuplicate(TInventoryMaster inventory) throws DataAccessException {
        try{
            List<TInventoryMaster> inventoryMasterList = getHibernateTemplate().findByNamedQuery("checkInventoryForDuplicate",inventory.getInventoryMed(),inventory.getInventoryBatchNumber(),inventory.getInventoryMfrs());
            if(inventoryMasterList.size()>0){
                return true;
            }else{
                return false;
            }
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    //findAllInventoryByExpiryDate

    @Override
    public int numberOfMedicineRecords(String expr)throws DataAccessException {
        try{
            List<TInventoryMaster> expireMedicineList = getHibernateTemplate().findByNamedQuery("findAllMedicineByExpiryDate","%"+expr+"%");
            return expireMedicineList.size();
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

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