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

namespace Sleis.Data
{
    public class AgencyFacilitySiteAddressData : BaseData<AgencyFacilitySiteAddress>, IFacilitySiteAddressData
    {
        public void UpdateSiteAddress(ISession session, int facilityId, FacilityAddressModel address)
        {
            session.CreateSQLQuery("DELETE FROM M_FAC_SITE_ADDR WHERE FAC_SITE_ID=:facilityId")
                   .SetInt32("facilityId", facilityId)
                   .ExecuteUpdate();

            if (address != null)
            {
                address.Id = 0;//clear to always save as new.
                address.FacilityId = facilityId;
                session.Save(address);
            }
        }

        public FacilityAddressModel GetFacilitySiteAddress(int facilityId)
        {
            return GetSession().Query<AgencyFacilitySiteAddress>().FirstOrDefault(x=>x.FacilityId==facilityId) as FacilityAddressModel; 
        }
    }
}