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 PublicEmissionUnitData : BaseData<PublicEmissionUnit>, IEmissionUnitData
    {
        /*
		public List<EmissionUnit> GetEmissionUnits(int facilityId)
        {
            return (from d in GetSession().Query<PublicEmissionUnit>()
                   where d.FacilityId == facilityId
                   select d).ToList<EmissionUnit>();
        }
        */
        public List<EmissionUnit> GetEmissionUnitsByFacility(int facilityId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<PublicEmissionUnit>()                        
                        where d.FacilityId == facilityId
                        select d).ToList<EmissionUnit>();
            }
        }
		public List<EmissionUnit> GetEmissionUnitsByReport(int reportId)
		{
			using (ISession session = GetSession())
			{
				return (from d in session.Query<PublicEmissionUnit>()
						join g in session.Query<PublicFacilityModel>()
						on d.FacilityId equals g.Id
                        join pr in session.Query<PublicReportModel>()
                        on g.ReportId equals pr.Id
						where pr.ReportId == reportId
						select d).ToList<EmissionUnit>();
			}
		}

        public List<string> GetEmissionUnitIdentifiers(int controlDeviceId, int reportId)
        {
            using(ISession session =GetSession ())
            {
                return (from d in session.Query<PublicEmissionUnit>()
                        join e in session.Query<PublicEmissionUnitControlApproach>()
                        on d.Id equals e.EmissionUnitId
                        join f in session.Query<PublicEmissionUnitControlDevice>()
                        on e.Id equals f.ControlApproachId
						join g in session.Query<PublicFacilityModel>()
                        on  d.FacilityId equals g.Id                        
                        where f.ControlDeviceId == controlDeviceId 
                        select d.Identifier).Distinct<string>().ToList();

            }
        }
        public List<EmissionUnit> GetEmissionUnitsByControlDevice(int controlDeviceId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<PublicEmissionUnit>()
                        join e in session.Query<PublicEmissionUnitControlApproach>()
                        on d.Id equals e.EmissionUnitId
                        join f in session.Query<PublicEmissionUnitControlDevice>()
                        on e.Id equals f.ControlApproachId
                        join g in session.Query<PublicFacilityModel>()
                        on d.FacilityId equals g.Id
                        where f.ControlDeviceId == controlDeviceId
                        select d).Distinct().ToList<EmissionUnit>();

            }
        }
        public bool CanDelete(int id)
        {
            throw new NotImplementedException();
        }
		public bool IsIdentifierUnique(EmissionUnit emissionUnit)
		{
			using (ISession session = GetSession())
			{
				return (from eu in session.Query<PublicEmissionUnit>()
						where eu.Identifier == emissionUnit.Identifier && eu.Id != emissionUnit.Id && eu.FacilityId == emissionUnit.FacilityId
						select eu).Count() == 0;
			}
		}
        /*
		public EmissionUnit GetEmissionUnit(int emissionUnitId)
        {
            return (from d in GetSession().Query<PublicEmissionUnit>()
                   where d.Id == emissionUnitId
                   select d).FirstOrDefault().As<EmissionUnit>();
        }
         * */
    }
}