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

namespace Sleis.Data
{
    public class AgencyFacilityMailAddressData : BaseData<AgencyFacilityMailAddress>, IFacilityMailAddressData
    {
        public void UpdateMailAddress(ISession session, int facilityId, FacilityAddressModel address)
        {
            session.CreateSQLQuery("DELETE FROM M_FAC_MAIL_ADDR WHERE FAC_SITE_ID=:facilityId")
                   .SetInt32("facilityId", facilityId)
                   .ExecuteUpdate();

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

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