using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using NHibernate;
using NHibernate.Linq;
using Sleis.Models;
using Sleis.Infrastructure;

namespace Sleis.Data
{
    public class PublicEntityControlDeviceData : BaseData, Sleis.Data.IEntityControlDeviceData
    {
        
        /*public List<T1> GetControlDevicesByEntityId<T1, T2>(int entityId) where T1: EntityControlDevice
                                                                                           where T2: ControlApproach
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<T2>()
                        where d.EntityId == entityId
                        join e in session.Query<T1>()
                        on d.Id equals e.DeviceApproachId
                        orderby e.ControlDevice.Index ascending
                        select e).Distinct<T1>().ToList();
            }
        }
        */
        public bool DeleteAllEmissionUnitRelatedByControlApproach(int controlApproachId, ISession session)
        {
            ISQLQuery query = session.CreateSQLQuery("DELETE from P_EMIS_UNIT_CTRL_DEVC where EMIS_UNIT_CTRL_APCH_ID = :controlApproachId");
            query.SetInt32("controlApproachId", controlApproachId);
            return query.ExecuteUpdate() > 0;
        }

        public bool DeleteAllUnitProcessRelatedByControlApproach(int controlApproachId, ISession session)
        {
            ISQLQuery query = session.CreateSQLQuery("DELETE from P_UNIT_PROC_CTRL_DEVC where UNIT_PROC_CTRL_APCH_ID = :controlApproachId");
            query.SetInt32("controlApproachId", controlApproachId);
            return query.ExecuteUpdate() > 0;
        }

      
    }
}