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 PublicReportAttachmentData : BaseData<ReportAttachment>, IReportAttachmentData
    {

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

        public ReportAttachment GetReportAttachment(int attachmentId)
        {

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

        //this convert management reportId to public reportId
        public int GetReportAttachmentReportId(int reportId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<PublicReportModel>()
                        where d.ReportId == reportId    
                        select d.Id ).First<Int32>();
            }
        }

    }
}