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

namespace Sleis.Data
{
	public class AgencyReportAttachmentData : BaseData<ReportAttachment>, IReportAttachmentData
	{

		public List<ReportAttachment> GetReportAttachments(int reportId)
		{
			using (ISession session = GetSession())
			{
				return (from d in session.Query<AgencyReport>()
						join r in session.Query<AgencyReportAttachment>()
							on d.Id equals r.Attachment.ReportId
						where d.Id == reportId
						select r).Distinct<ReportAttachment>().ToList();
			}
		}

		public ReportAttachment GetReportAttachment(int attachmentId)
		{
			using (ISession session = GetSession())
			{
				return (ReportAttachment)(from d in session.Query<AgencyReportAttachment>()
						where d.Id == attachmentId
						select d).FirstOrDefault<AgencyReportAttachment>();
			}
		}

		public int GetReportAttachmentReportId(int reportId)
		{
			return reportId;
		}
	}
}