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

import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TAccount;
import com.bestray.healthcarecommonutil.vo.TDepartmentMaster;
import com.bestray.healthcarecommonutil.vo.TDoctorInformation;
import com.bestray.healthcareemr.Dao.UserAccountDao;
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 UserAccountDaoImpl.
 *
 * @author user3
 */
@Repository
public class UserAccountDaoImpl extends HibernateDaoSupport implements UserAccountDao{

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

    
    
    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.UserAccountDao#saveAccount(com.bestray.healthcareemr.Vo.TAccount)
     */
    @Override
    public TAccount saveAccount(TAccount account)throws DataAccessException,HibernateOptimisticLockingFailureException {
        try{             
            getHibernateTemplate().saveOrUpdate(account);  
            return account;
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }


    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.UserAccountDao#getDepartmentList()
     */
    @Override
    public List<TDepartmentMaster> getDepartmentList() throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllDepartments");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Dao.UserAccountDao#getDocInfoFromDocId(java.lang.String)
     */
    @Override
    public TDoctorInformation getDocInfoFromDocId(String docid) throws DataAccessException {
        try{
            List<TDoctorInformation> doclist = getHibernateTemplate().findByNamedQuery("findDocInfoBYId",new Object[]{Long.parseLong(docid)});
            return doclist.isEmpty()?null:doclist.get(0);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

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

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

    @Override
    public void deleteAccount(TAccount account) throws DataAccessException,IllegalArgumentException {
        try{             
             getHibernateTemplate().delete(account);
        }catch(IllegalArgumentException e){
             throw e;
        }catch(Exception e){
             throw new DataAccessException();
        }
    }
    
    @Override
    public TAccount authorize(TAccount account) throws DataAccessException{
        try{
            List<TAccount> acc = getHibernateTemplate().findByNamedQuery("findAllUserList",account.getUserName());
            return (acc.size()>0)? acc.get(0) :null;
         }catch(Exception e){
             e.printStackTrace();
            throw new DataAccessException();
        }    
    }

    @Override
    public List<TAccount> allAccountList() throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("getAllAccountList");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TAccount> getUserByUsername(String username) throws DataAccessException {
        return getHibernateTemplate().findByNamedParam("from TAccount acc where acc.userName like :userName", "userName", '%' + username + '%');
    }
   
}