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 FacilityMailAddressData : BaseData<PublicFacilityMailAddressModel>, Sleis.Data.IFacilityMailAddressData
    {

        public void UpdateMailAddress(ISession session, int facilityId, FacilityAddressModel address)
        {
            session.CreateSQLQuery("DELETE FROM P_FAC_MAIL_ADDR WHERE FAC_SITE_ID=:facilityId")
                   .SetInt32("facilityId", facilityId)
                   .ExecuteUpdate();

            if (address != null)
            {
                address.FacilityId = facilityId;
                session.Save(address);
            }
        }

        public FacilityAddressModel GetFacilityMailAddress(int facilityId)
        {
            return (from d in GetSession().Query<PublicFacilityMailAddressModel>()
                    where d.FacilityId == facilityId
                    select d).ToList().FirstOrDefault();

        }
    }
}