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 FacilityNaicsData : NaicsData<PublicFacilityNaicsModel>, IFacilityNaicsData
    {
        public override void SaveOrUpdate(ISession session, int facilityId, string code)
        {

            session.CreateSQLQuery("DELETE FROM P_FAC_NAICS WHERE FAC_SITE_ID=:facilityId")
                   .SetInt32("facilityId", facilityId)
                   .ExecuteUpdate();

            PublicFacilityNaicsModel model = new PublicFacilityNaicsModel();
            model.FacilityId = facilityId;
            model.IsPrimaryIndicator = 1;
            model.Naics = code;

            session.Save(model);
        }        
    }
}