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

import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.exception.ProcessingException;
import com.bestray.healthcarecommonutil.vo.TAnesthesiaDetails;
import com.bestray.healthcarecommonutil.vo.TDiagnosisMaster;
import com.bestray.healthcarecommonutil.vo.TEncounterDiagnosis;
import com.bestray.healthcarecommonutil.vo.TEncounterHistoryVisit;
import com.bestray.healthcarecommonutil.vo.TEncounterMedication;
import com.bestray.healthcarecommonutil.vo.TEncounterProcedure;
import com.bestray.healthcarecommonutil.vo.TEncounterVitalSign;
import com.bestray.healthcarecommonutil.vo.TPatEncToDo;
import com.bestray.healthcarecommonutil.vo.TPatient;
import com.bestray.healthcarecommonutil.vo.TPatientEncounter;
import com.bestray.healthcareinpatient.dao.InpatientRoundingDao;
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 user3
 */
@Repository
public class InpatientRoundingDaoImpl extends HibernateDaoSupport implements InpatientRoundingDao{
private TEncounterVitalSign encounterVitalSign;
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    
    @Override
    public TPatientEncounter getIPEncounterByPatient(TPatient patient) throws DataAccessException {
        try{
            List<TPatientEncounter> enc = getHibernateTemplate().findByNamedQuery("getIPEncounterByPatient", patient);
            return enc.size()>0?enc.get(0):null;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /*@Override
    public TPatientEncounter createIPEncounter(TPatientEncounter enc) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().saveOrUpdate(enc);
            return enc;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }*/

    @Override
    public TEncounterMedication saveMedication(TEncounterMedication encounterMedication) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().saveOrUpdate(encounterMedication);
            return encounterMedication;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TEncounterMedication> getEncounterMedication(TPatientEncounter encounter,int status) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("medicationbyenc", encounter,status);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TEncounterMedication> getEncounterMedicationByEncIdnType(TPatientEncounter encounter,String type) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("medicationByEncidnType", encounter,type);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
     @Override
     public List<TEncounterProcedure>  getEncounterProcedureByEncIdnType(TPatientEncounter encounter,String type) throws DataAccessException{
         try{
            return getHibernateTemplate().findByNamedQuery("procedureByEncidnType", encounter,type);
        }catch(Exception e){
            throw new DataAccessException();
        }
     }
     
     @Override
    public List<TEncounterVitalSign> getEncounterVitalsignByEncIdnType(TPatientEncounter encounter,String type) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("vitalSignByEncidnType", encounter,type);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TEncounterMedication getEncounterMedicationById(Long encmedid) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TEncounterMedication.class, encmedid);
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

   /* @Override
    public TEncounterMedication reorderMedication(TEncounterMedication encmed) throws DataAccessException {
        throw new UnsupportedOperationException("Not supported yet.");
    }*/

    @Override
    public TPatientEncounter getEncounterById(Long encid) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TPatientEncounter.class, encid);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TEncounterProcedure saveProcedure(TEncounterProcedure encounterProcedure) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().saveOrUpdate(encounterProcedure);
            return encounterProcedure;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

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

    @Override
    public void deleteEncProc(TEncounterProcedure encproc) throws DataAccessException {
        try{
            getHibernateTemplate().delete(encproc);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatientEncounter saveIPEncounter(TPatientEncounter inpatenc) throws DataAccessException {
        try{
            getHibernateTemplate().saveOrUpdate(inpatenc);
            return inpatenc;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatEncToDo saveToDo(TPatEncToDo encounterToDo) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().saveOrUpdate(encounterToDo);
            return encounterToDo;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
//Prasanta
    @Override
    public void saveVitalSign(TEncounterVitalSign encounterVitalSign) throws ProcessingException, HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().saveOrUpdate(encounterVitalSign);
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new ProcessingException();
        }
    }
    public void saveAnesthesiaDetails(TAnesthesiaDetails anesthesiaDetails) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().saveOrUpdate(anesthesiaDetails);
            
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    public List<TEncounterVitalSign> getAllVitalSignsForPatient(TPatientEncounter encounter) throws DataAccessException{
        try{
            return getHibernateTemplate().findByNamedQuery("getVitalSignListByInpatientId",encounter);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
     public TEncounterVitalSign  getVitalsignDetailById(long id)throws ProcessingException {
        try{ 
        return getHibernateTemplate().get(TEncounterVitalSign.class,id);             
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            e.printStackTrace();
            throw new ProcessingException();
        }
    }
     public TAnesthesiaDetails  getAnesthesiaDetailById(long id)throws DataAccessException {
        try{ 
        return getHibernateTemplate().get(TAnesthesiaDetails.class,id);             
        }catch(HibernateOptimisticLockingFailureException e){
            e.printStackTrace();
            throw e;
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        } 
     }
     public List<TAnesthesiaDetails> getAllAnesthesiaDetailsForPatient(TPatientEncounter encounter) throws DataAccessException{
       try{
            return getHibernateTemplate().findByNamedQuery("getAnesthesiaListByInpatientId",encounter);
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }  
     }
    @Override
    public List<TPatEncToDo> getTasksForEncounter(TPatientEncounter encounter) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("tasksbyenc", encounter);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatEncToDo getEncTask(Long enctaskid) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TPatEncToDo.class, enctaskid);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void deleteEncTask(TPatEncToDo enctodo) throws DataAccessException {
        try{
            getHibernateTemplate().delete(enctodo);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    @Override
    public void deleteAnesthesiaDetails(TAnesthesiaDetails anesthesiaDetails) throws DataAccessException {
        try{
            getHibernateTemplate().delete(anesthesiaDetails);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    @Override
    public void deleteEncounterMedication(TEncounterMedication encmed) throws DataAccessException{
       try{
            getHibernateTemplate().delete(encmed);
        }catch(Exception e){
            throw new DataAccessException();
        } 
    }
    @Override
    public void deleteEncounterProcedure(TEncounterProcedure encProc)throws DataAccessException{
        try{
            getHibernateTemplate().delete(encProc);
        }catch(Exception e){
            throw new DataAccessException();
        } 
    }
    
     @Override
    public void  deleteEncounterVitalSign(TEncounterVitalSign encVitalSign)throws DataAccessException{
        try{
            getHibernateTemplate().delete(encVitalSign);
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        } 
    }
    @Override
    public void saveEncounterHistoryVisit(TEncounterHistoryVisit encounterHistoryVisit) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{ 
            getHibernateTemplate().save(encounterHistoryVisit);
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    @Override
    public TEncounterDiagnosis saveDiagnosis(TEncounterDiagnosis encounterDiagnosis) throws DataAccessException {
        try{ 
            getHibernateTemplate().saveOrUpdate(encounterDiagnosis);
            return encounterDiagnosis;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TEncounterDiagnosis> getEncounterDiagnosis(TPatientEncounter encounter) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("diagnosisbyenc", encounter);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void deleteEncDiag(TEncounterDiagnosis ediag) throws DataAccessException {
        try{
            getHibernateTemplate().delete(ediag);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
}