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

import com.bestray.healthcarecommonutil.dao.CodeValuesDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TCCodeType;
import com.bestray.healthcarecommonutil.vo.TCCodeValues;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Projections;
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 CodeValuesDaoImpl.
 *
 * @author user3
 */
@Repository
public class CodeValuesDaoImpl extends HibernateDaoSupport implements CodeValuesDao{
    
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    
    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#addToCodeValues(com.bestray.healthcareemr.Vo.TCCodeValues)
     */
    @Override
    public void addToCodeValues(TCCodeValues codevalues)throws DataAccessException {
        
        try{
            getHibernateTemplate().save(codevalues);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#searchForCodeValueName(java.lang.String, com.bestray.healthcareemr.Vo.TCCodeType)
     */
    @Override
    public List<TCCodeValues> searchForCodeValueName(String codeValueName, TCCodeType codetypeid)throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("searchForCodeValueName", new Object[]{codeValueName,codetypeid});
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#findAllValuesList(com.bestray.healthcareemr.Vo.TCCodeType, java.lang.String, int, int)
     */
    @Override
    public List<TCCodeValues> findAllValuesList(TCCodeType id,String expr,int min,int max)throws DataAccessException {
        try{
        Session session = getHibernateTemplate().getSessionFactory().openSession();
            Query query = session.getNamedQuery("findAllCodeValuesListById");
            //List<TDiagnosisMaster> diagnosisList = getHibernateTemplate().findByNamedQuery("findAllDiagnosisList","%"+expr+"%");
            query.setParameter(0,id );
            query.setParameter(1,"%"+expr+"%" );
            query.setFirstResult(min);
            query.setMaxResults(max-min);
            List<TCCodeValues> valuesList=query.list();
            return valuesList;
    }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#getDetails(java.lang.Long)
     */
    @Override
    public TCCodeValues getDetails(Long valuesId)throws DataAccessException {
        
        try{
            return getHibernateTemplate().get(TCCodeValues.class, valuesId);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#deleteValuesMaster(java.lang.Long)
     */
    @Override
    public void deleteValuesMaster(Long valuesId)throws DataAccessException,IllegalArgumentException {
        
        try{            
            getHibernateTemplate().delete(getHibernateTemplate().get(TCCodeValues.class, valuesId));            
        }catch(IllegalArgumentException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#getMaxId()
     */
    @Override
    public Long getMaxId() throws DataAccessException {
        
        try{
            Criteria criteria = getHibernateTemplate().getSessionFactory().openSession().createCriteria(TCCodeValues.class);
            criteria.setProjection(Projections.max("codeValueId"));
            Long maxId = (Long) criteria.uniqueResult();
            return maxId;
        }catch(Exception e){
            throw new DataAccessException();
        }        
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#numberOfCodeValueRecords(java.lang.String, com.bestray.healthcareemr.Vo.TCCodeType)
     */
    @Override
    public int numberOfCodeValueRecords(String expr,TCCodeType id)throws DataAccessException {
        try{
            List<TCCodeValues> codevalueList = getHibernateTemplate().findByNamedQuery("findAllCodeValuesListById",id,"%"+expr+"%");
            return codevalueList.size();
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.CodeValuesDao#getCodeValues(com.bestray.healthcareemr.Vo.TCCodeType)
     */
    @Override
    public List<TCCodeValues> getCodeValues(TCCodeType code) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findCodeValuesByCodetype",code);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    
    
}