using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using NHibernate;

namespace Sleis.Data
{
    public class AgencyRegulationProgramData : BaseData, IRegulationProgramData
    {
        public bool DeleteAllByEmissionUnit(int emissionUnitId, ISession session)
        {
            ISQLQuery query = session.CreateSQLQuery("DELETE from M_EMIS_UNIT_REG_PGM where EMIS_UNIT_ID = :emissionUnitId");
            query.SetInt32("emissionUnitId", emissionUnitId);
            return query.ExecuteUpdate() > 0;
        }
        public bool DeleteAllByUnitProcess(int unitProcessId, ISession session)
        {
            ISQLQuery query = session.CreateSQLQuery("DELETE from M_UNIT_PROC_REG_PGM where UNIT_PROC_ID = :unitProcessId");
            query.SetInt32("unitProcessId", unitProcessId);
            return query.ExecuteUpdate() > 0;
        }
    }
}