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

namespace Sleis.Data
{
    public class AgencyCommentData : BaseData, Sleis.Data.ICommentData
    {
        public int DeleteReleasePointComments(int releasePointId, ISession session)
        {
            return session.CreateSQLQuery("DELETE FROM M_REL_PT_CMNT WHERE REL_PT_ID=:releasePointId")
               .SetInt32("releasePointId", releasePointId)
               .ExecuteUpdate();  
        }
        public int DeleteUnitProcessComments(int unitProcessId, ISession session)
        {
            return session.CreateSQLQuery("DELETE FROM M_UNIT_PROC_CMNT WHERE UNIT_PROC_ID=:unitProcessId")
               .SetInt32("unitProcessId", unitProcessId)
               .ExecuteUpdate(); 
        }
    }
}