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 SubmissionDocumentData : BaseData<SubmissionDocumentModel>
    {
		public List<SubmissionDocumentModel> GetSubmissionDocumentHistory(int reportId)
		{
			List<SubmissionDocumentModel> list = null;

			using (ISession session = GetSession())
			{
				list = (from d in session.Query<SubmissionDocumentModel>()
						where d.ReportId == reportId && 
							(d.Status == SubmissionDocumentStatus.Submitted 
								|| d.Status == SubmissionDocumentStatus.Repudiated 
								|| d.Status == SubmissionDocumentStatus.RepudiationRequested)                                
						select new SubmissionDocumentModel()
                        {
                          Id = d.Id,
                          ContenType = d.ContenType,
                          SubmittinguserId = d.SubmittinguserId,
                          //SubmittingUser = d.SubmittingUser,
                          GeneratedOn = d.GeneratedOn,
                          Name = d.Name,
                          Number = d.Number,
                          ReportId = d.ReportId,
                          SignedOn = d.SignedOn,
                          Status = d.Status                          
                        }).ToList<SubmissionDocumentModel>();
			}

			return list;
		}
    }
}