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

import com.bestray.healthcarecommonutil.dao.LabReceiptDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TEncounterProcedure;
import com.bestray.healthcarecommonutil.vo.TPatLabReceipt;
import com.bestray.healthcarecommonutil.vo.TPatient;
import com.bestray.healthcarecommonutil.vo.TPatientEncounter;
import java.util.Date;
import java.util.List;
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;

/**
 *
 * @author User1
 */
@Repository
public class LabReceiptDaoImpl extends HibernateDaoSupport implements LabReceiptDao{

    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    
    @Override
    public String getIdToInsert() throws DataAccessException {
        try{
            List<TPatLabReceipt> receiptIds = getHibernateTemplate().findByNamedQuery("findMaxReceiptId");
            return (receiptIds.isEmpty())?"1000":receiptIds.get(0).getReceiptNumber();
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public Long saveReceiptDetails(TPatLabReceipt labReceipt) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{             
            return (Long)getHibernateTemplate().save(labReceipt);            
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void updateReceiptDetails(TPatLabReceipt labReceipt) throws DataAccessException {
        try{            
            getHibernateTemplate().update(labReceipt);            
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatLabReceipt findAvailableLabReceipt(TPatient patientinfo, TPatientEncounter encounter) throws DataAccessException {
        try{
            List<TPatLabReceipt> labRecpts = getHibernateTemplate().findByNamedQuery("findAvailableLabReceipt",patientinfo,encounter);
            if(!labRecpts.isEmpty()){
                return labRecpts.get(0);
            }else{
                return null;
            }
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TPatLabReceipt> showLabReceiptList(Date date, String month, int monthyear, int year) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("getLabReceiptList",date,month,monthyear,year);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void updateEncProcedureList(List<TEncounterProcedure> encproList) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{            
            getHibernateTemplate().saveOrUpdateAll(encproList);            
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TEncounterProcedure> getEncounterLabsProcedure(TPatientEncounter enc) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("procedurebyenc", enc);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
}