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

namespace Sleis.Data
{
    public abstract class ReleasePointData<T> :BaseData<T> where T: ReleasePoint
    {
        public List<Sleis.Models.ReleasePoint> GetMasterReleasePoints(int facilityId)
        {
            using (ISession session = GetSession())
            {
                return (
                        from r in session.Query<AgencyReleasePoint>()
                        join f in session.Query<AgencyFacilityModel>()
                         on r.FacilityId equals f.Id
                        where facilityId == r.FacilityId && f.IsMaster == true
                        select r
                        )
                        .Distinct()
                        .ToList<ReleasePoint>();
            }
        }
    }
}