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

import com.bestray.healthcarecommonutil.dao.GroupProcedureDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TGroupMaster;
import com.bestray.healthcarecommonutil.vo.TProcedureGroup;
import com.bestray.healthcarecommonutil.vo.TProcedureMaster;
import java.util.List;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

/**
 *
 * @author User1
 */
public class GroupProcedureDaoImpl extends HibernateDaoSupport implements GroupProcedureDao{
    
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }

    @Override
    public void saveGroupAndProcedure(TGroupMaster groupMaster, List<TProcedureMaster> procedureSelectedList) throws DataAccessException {
        try{ 
            Long groupId = (Long)getHibernateTemplate().save(groupMaster); 
            TGroupMaster group = getHibernateTemplate().get(TGroupMaster.class, groupId);
            for(TProcedureMaster procedure:procedureSelectedList){
                TProcedureGroup groupProcedure = new TProcedureGroup();
                groupProcedure.setGroup(group);
                groupProcedure.setProcedureMaster(procedure);
                getHibernateTemplate().save(groupProcedure);
            }
            
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public List<TProcedureGroup> getProcedureListByGroup(TGroupMaster group) throws DataAccessException {
      
        try{
            return getHibernateTemplate().findByNamedQuery("getProcedureListByGroup", group);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void updateGroupAndProcedure(TGroupMaster groupMaster, List<TProcedureMaster> procedureSelectedList) throws DataAccessException {
       
        try{
            getHibernateTemplate().deleteAll(getHibernateTemplate().findByNamedQuery("getProcedureListByGroup", groupMaster));
            for(TProcedureMaster procedure:procedureSelectedList){
                TProcedureGroup procedureGroup = new TProcedureGroup();
                procedureGroup.setProcedureMaster(procedure);
                procedureGroup.setGroup(groupMaster);
                getHibernateTemplate().save(procedureGroup);
            }
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    
}