/*
 * 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.TRole;
import com.bestray.healthcareemr.Dao.UserRoleDao;
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 UserRoleDaoImpl extends HibernateDaoSupport implements UserRoleDao {

    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    
    @Override
    public void saveRole(TRole role)throws DataAccessException {
        try{             
            getHibernateTemplate().save(role);            
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TRole> getRoleList()throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllRoleNameList");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public TRole getRoleByRoleId(Long roleid)throws DataAccessException {
        try{
            return getHibernateTemplate().get(TRole.class, roleid);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public void updateRole(TRole role)throws DataAccessException,HibernateOptimisticLockingFailureException{
        try{             
            getHibernateTemplate().update(role);            
        }catch(HibernateOptimisticLockingFailureException ex){
            throw ex;
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TRole> findRolesByName(String name) throws DataAccessException {
        return getHibernateTemplate().findByNamedParam("from TRole role where role.roleName like :roleName", "roleName", '%' + name + '%');
    }
    
}