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 PublicFacilitySiteAddressData : BaseData<PublicFacilitySiteAddressModel>, IFacilitySiteAddressData
    {

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

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

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

        }
    }
}