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

import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TEncounterProcedure;
import com.bestray.healthcarecommonutil.vo.TPatEncOrderResults;
import com.bestray.healthcarecommonutil.vo.TPatEncOrderSpecimen;
import com.bestray.healthcarecommonutil.vo.TPatient;
import com.bestray.healthcarecommonutil.vo.TPatientEncounter;
import com.bestray.healthcarecommonutil.vo.TProcedureMaster;
import com.bestray.labinformationsystem.dao.LabInformationDao;
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 LabInformationDaoImpl extends HibernateDaoSupport implements LabInformationDao{

    
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }

    @Override
    public void saveSpecimenDetails(TPatEncOrderSpecimen patEncOrderSpecimen) throws DataAccessException {
        try{ 
            getHibernateTemplate().save(patEncOrderSpecimen);
          }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void deleteProcedureEncounter(TProcedureMaster procrdure, TPatientEncounter encounter) throws DataAccessException, IllegalArgumentException {
        try{
            getHibernateTemplate().deleteAll(getHibernateTemplate().findByNamedQuery("deleteByEncounterAndProcedure", procrdure,encounter));
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TEncounterProcedure getProcedureEncounterByID(Long ID) throws DataAccessException {
       try{
            TEncounterProcedure encounterProcedure = (TEncounterProcedure)getHibernateTemplate().get(TEncounterProcedure.class, ID);
            return encounterProcedure;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public Long saveProcedureEncounter(TEncounterProcedure encounterProcedure) throws DataAccessException {
        try{ 
            return (Long)getHibernateTemplate().save(encounterProcedure);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void upDateProcedureEncounter(TEncounterProcedure encounterProcedure) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{
            getHibernateTemplate().update(encounterProcedure);
        }catch(HibernateOptimisticLockingFailureException  e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public Long saveOrderResults(TPatEncOrderResults encOrderResult) throws DataAccessException {
        try{ 
            return (Long)getHibernateTemplate().save(encOrderResult);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TPatEncOrderResults> getComponentResultsByEncounterAndOrder(TEncounterProcedure orderDetails, TPatientEncounter encounter) throws DataAccessException {
        try{
            
            return getHibernateTemplate().findByNamedQuery("getComponentResultsByEncounterAndOrder", orderDetails,encounter);
            
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    @Override
    public void deleteOrderResultsEncounter(TEncounterProcedure encPro, TPatientEncounter encounter) throws DataAccessException, IllegalArgumentException{
        try{
            
            getHibernateTemplate().deleteAll(getHibernateTemplate().findByNamedQuery("deleteOrderResultsEncounter", encPro,encounter));
            
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void deleteSpecimenDetailsEncounter(TEncounterProcedure encPro, TPatientEncounter encounter) throws DataAccessException, IllegalArgumentException{
        try{
            
            getHibernateTemplate().deleteAll(getHibernateTemplate().findByNamedQuery("deleteSpecimenDetailsEncounter", encPro,encounter));
            
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatEncOrderResults getEncOrderResultsByID(Long ID) throws DataAccessException {
        try{
            TPatEncOrderResults encOrderResult = (TPatEncOrderResults)getHibernateTemplate().get(TPatEncOrderResults.class, ID);
           return encOrderResult;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void updateOrderResults(TPatEncOrderResults encOrderResult) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{
            getHibernateTemplate().update(encOrderResult);
        }catch(HibernateOptimisticLockingFailureException  e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /*@Override
    public List<TProcedureComponent> getComponentListByProcedure(TProcedureMaster procedure) throws DataAccessException {
        throw new UnsupportedOperationException("Not supported yet.");
    }*/

    @Override
    public List<TPatientEncounter> getEncounterDates(TPatient patient) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("getEncounterByPatient", patient,"OP");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TEncounterProcedure> getLabsProcedure(TPatientEncounter patientEncounter) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("procedurebyenc", patientEncounter);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatientEncounter saveNewEncForSelectedPatient(TPatientEncounter enc) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().save(enc);
            return enc;
        }catch(HibernateOptimisticLockingFailureException  e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatientEncounter getencforlab(TPatient patient, String enctype) throws DataAccessException {
        try{
            List<TPatientEncounter> penclist = getHibernateTemplate().findByNamedQuery("getEncounterByPatient", patient,enctype);
            return penclist.isEmpty()?null:penclist.get(0);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TPatientEncounter> getOpLabEncounterDates(TPatient patient) throws DataAccessException {
        try{
            return getHibernateTemplate().find("from TPatientEncounter t where t.patient = ? and t.encType IN('OP','LAB') and t.encStatus = 'Opened'" , patient);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TPatientEncounter> getAllClosedEncounters(TPatient patient) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("getAllClosedEncounters", patient);
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
}