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

import com.bestray.healthcarecommonutil.dao.DoctorInformationDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TDepartmentMaster;
import com.bestray.healthcarecommonutil.vo.TDoctorInformation;
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;


// TODO: Auto-generated Javadoc
/**
 * The Class DoctorInformationDaoImpl.
 */
@Repository
public class DoctorInformationDaoImpl extends HibernateDaoSupport implements DoctorInformationDao {

    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    /* 
    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#saveDoctorInformation(com.bestray.healthcareemr.Vo.TDoctorInformation)
     */
    @Override
    public void saveDoctorInformation(TDoctorInformation doctorInformation) throws DataAccessException {
        
        try{ 
            getHibernateTemplate().save(doctorInformation);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#findAllDoctors(java.lang.Long)
     */
    @Override
    public List<TDoctorInformation> findAllDoctors(TDepartmentMaster DepartmentId)throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllDoctorsByDepartment",DepartmentId);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#findDoctorDetailsById(java.lang.Integer)
     */
    @Override
    public TDoctorInformation findDoctorDetailsById(Integer doctorID) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TDoctorInformation.class, doctorID);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#numberOfDoctorInformationRecords(java.lang.String)
     */
    @Override
    public int numberOfDoctorInformationRecords(String expr) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findNumberOfDoctors","%"+expr+"%").size();
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#findAllDrInformationList(java.lang.String, int, int)
     */
    @Override
    public List<TDoctorInformation> findAllDrInformationList(String expr, int min, int max) throws DataAccessException {
       try{
            
             Session session = getHibernateTemplate().getSessionFactory().openSession();
             Query query = session.getNamedQuery("findNumberOfDoctors");
             query.setParameter(0,"%"+expr+"%" );
             query.setFirstResult(min);
             query.setMaxResults(max-min);
             List<TDoctorInformation> doctorList=query.list();
             return doctorList;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#deleteAlldoctorInfo(java.lang.Integer)
     */
    @Override
    public void deleteAlldoctorInfo(Integer drId) throws DataAccessException,IllegalArgumentException {
        try{
            getHibernateTemplate().delete(getHibernateTemplate().get(TDoctorInformation.class, drId));
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#updateDoctorInformation(com.bestray.healthcareemr.Vo.TDoctorInformation)
     */
    @Override
    public void updateDoctorInformation(TDoctorInformation doctorInformation) throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{            
            getHibernateTemplate().update(doctorInformation);            
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.DoctorInformationDao#findAllDoctorList()
     */
    @Override
    public List<TDoctorInformation> findAllDoctorList() throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllDoctorList");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TDoctorInformation> getDoctorsByName(String name) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findNumberOfDoctors","%"+name+"%");
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

    
}