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 PublicControlDeviceData : BaseData<PublicControlDevice>, IControlDeviceData
    {
        
        public List<ControlDeviceModel> GetControlDevicesByFacility(int facilityId)
        {
            using(ISession session= GetSession())
            {
                var list = from d in session.Query<PublicControlDevice>()
                           where d.FacilityId == facilityId
                           select d;
                return list.ToList<ControlDeviceModel>();
            }
        }
        public List<ControlDeviceModel> GetControlDevicesByReport(int reportId)
        {
            using(ISession session = GetSession())
            {
                return( from d in session.Query<PublicControlDevice>()
                           join pf in session.Query<PublicFacilityModel>()
                            on d.FacilityId equals pf.Id
                            join pr in session.Query<PublicReportModel>()
                            on pf.ReportId equals pr.Id
                            where pr.ReportId == reportId
                            select d).ToList<ControlDeviceModel>();
            }
        }
        /*
       
        public List<PublicControlDevice> GetControlDevicesByEmissionUnitId(int emissionUnitId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<PublicEmissionUnitControlApproach>()
                        where d.EmissionUnitId == emissionUnitId
                        join e in session.Query<PublicEmissionUnitControlDevice>()
                        on d.Id equals e.DeviceApproachId
                        join f in session.Query<PublicControlDeviceModel>()
                        on e.ControlDevice.DeviceId equals f.Id
                        select f).Distinct().ToList();
            }
        }

        */
        public List<string> GetControlDeviceIdentifiersByUnitProcessId(int unitProcessId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<PublicUnitProcessControlApproach>()
                        where d.UnitProcessId == unitProcessId
                        join e in session.Query<PublicUnitProcessControlDevice>()
                        on d.Id equals e.ControlApproachId
                        join f in session.Query<PublicControlDevice>()
                        on e.ControlDeviceId equals f.Id
                        select f.Identifier).Distinct<string>().ToList();
            }
        }
        public List<ControlDeviceModel> GetControlDevicesByUnitProcess(int unitProcessId)
        {
            using (ISession session = GetSession())
            {
                return (from ca in session.Query<PublicUnitProcessControlApproach>()
                        join ucd in session.Query<PublicUnitProcessControlDevice>() on ca.Id equals ucd.ControlApproachId
                        join cd in session.Query<PublicControlDevice>() on ucd.ControlDeviceId equals cd.Id
                        where ca.UnitProcessId == unitProcessId
                        select cd).Distinct().ToList<ControlDeviceModel>();
            }
        }
        public List<ControlDeviceModel> GetControlDevicesByEmissionUnit(int emissionUnitId)
        {
            using (ISession session = GetSession())
            {
                return (from ca in session.Query<PublicEmissionUnitControlApproach>()
                        join ucd in session.Query<PublicEmissionUnitControlDevice>() on ca.Id equals ucd.ControlApproachId
                        join cd in session.Query<PublicControlDevice>() on ucd.ControlDeviceId equals cd.Id
                        where ca.EmissionUnitId == emissionUnitId
                        select cd).Distinct().ToList<ControlDeviceModel>();
            }
        }
        /*
        public List<PublicControlDeviceModel> GetControlDevicesByUnitProcessId(int unitProcessId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<PublicUnitProcessControlDeviceApproach>()
                        where d.EntityId == unitProcessId
                        join e in session.Query<PublicUnitProcessControlDevice>()
                        on d.Id equals e.DeviceApproachId
                        join f in session.Query<PublicControlDeviceModel>()
                        on e.ControlDevice.DeviceId equals f.Id
                        select f).Distinct().ToList();
            }
        }
         */
        public bool CanDelete(int id)
        {
            throw new NotImplementedException();
        }
		public bool IsIdentifierUnique(ControlDeviceModel controlDevice)
		{
			using (ISession session = GetSession())
			{
				return (from cd in session.Query<PublicControlDevice>()
						where cd.Identifier == controlDevice.Identifier && cd.Id != controlDevice.Id && cd.FacilityId == controlDevice.FacilityId
						select cd).Count() == 0;
			}
		}
    }
}