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

namespace Sleis.Data
{
	public class AmendmentRequestData : BaseData<BaseIdentityModel>
	{
		public int GetPendingRequestsCount()
		{
			using (ISession session = GetSession())
			{
				/*ISQLQuery query = session.CreateSQLQuery(@"	SELECT COUNT(1) as count
															FROM M_AMEND_RQST 
															WHERE RQST_CLOSED_BY_USER_ID IS NULL AND RQST_CLOSED_DATE IS  NULL");
				return query.UniqueResult<int>();
                 * */
                return session.Query<AmendmentRequestModel>().Where(a => a.ClosedByUserId == null && a.ClosedDate == null).Count();
			}

		}
        public List<AmendmentRequestModel> GetPendingRequests()
        {
            using (ISession session = GetSession())
            {
                return session.Query<AmendmentRequestModel>().Where(a => a.ClosedByUserId == null && a.ClosedDate == null).ToList();
            }
        }
        public DateTime? HasPendingRequest(int reportId)
        {
            using (ISession session = GetSession())
            {
				IEnumerable<DateTime> result = (from d in session.Query<AmendmentRequestModel>()
												where d.ReportId == reportId && d.ClosedByUserId == null && d.ClosedDate == null
												select d.RequestDate);
				if (result.Count<DateTime>() == 0)
				{
					return null;
				}
				else
				{
					return result.First<DateTime>();
				}
            }

        }
	}
}