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 EmissionUnitData : BaseData<EmissionUnitModel>
    {
        public List<EmissionUnitModel> GetEmissionUnits(int facilityId)
        {
            return (from d in GetSession().Query<EmissionUnitModel>()
                   where d.FacilityId == facilityId
                   select d).ToList();
        }

        public List<string> GetEmissionUnitIdentifiers(int controlDeviceId, int reportId)
        {
            using(ISession session =GetSession ())
            {
                return (from d in session.Query<EmissionUnitModel>()
                        join e in session.Query<PublicEmissionUnitControlDeviceApproach>()
                        on d.Id equals e.EntityId
                        join f in session.Query<PublicEmissionUnitControlDevice>()
                        on e.Id equals f.DeviceApproachId
						join g in session.Query<PublicFacilityModel>()
                        on  d.FacilityId equals g.Id                        
                        where f.ControlDevice.DeviceId == controlDeviceId 
                        select d.Identifier).Distinct<string>().ToList();

            }
        }

        public EmissionUnitModel GetEmissionUnit(int emissionUnitId)
        {
            return (from d in GetSession().Query<EmissionUnitModel>()
                   where d.Id == emissionUnitId
                   select d).FirstOrDefault();
        }
    }
}