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

import com.bestray.healthcarecommonutil.dao.BedMasterDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TBedMaster;
import com.bestray.healthcarecommonutil.vo.TRoomMaster;
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;

/**
 *
 * @author Anshu1
 */
@Repository
public class BedMasterDaoImpl extends HibernateDaoSupport implements BedMasterDao{

    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    
    @Override
    public void saveBedMaster(TBedMaster bed) throws DataAccessException {
        try{ 
            getHibernateTemplate().save(bed);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TBedMaster> findAllBedsList(String expr, int min, int max) throws DataAccessException {
        try{
             Session session = getHibernateTemplate().getSessionFactory().openSession();
             Query query = session.getNamedQuery("findAllBedsList");
             query.setParameter(0,"%"+expr+"%" );
             query.setFirstResult(min);
             query.setMaxResults(max-min);
             List<TBedMaster> bedsList=query.list();
             return bedsList;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    @Override
    public TBedMaster getBedDetailsById(Long bedId) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TBedMaster.class, bedId);
        }catch(Exception e){
            throw new DataAccessException();   
        }
    }

    @Override
    public void updateBedMaster(TBedMaster bedMaster) throws DataAccessException, HibernateOptimisticLockingFailureException {
        try{
            getHibernateTemplate().update(bedMaster);
        }catch(HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public int numberOfBedRecords(String expr) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllBedsList","%"+expr+"%").size();
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

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

    @Override
    public List<TBedMaster> findAllBedsByRoom(TRoomMaster room) throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllBedsByRoom",room);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    
}