using System.Collections.Generic;
using System.Linq;
using Neo.Afx.ComponentModel;

namespace Neo.Afx.Services.Reports
{
    /// <summary>
    /// The Report database.
    /// </summary>
    public class ReportDatabase : Database<ReportContext>
    {
        /// <summary>
        /// Initializes a new instance of the <see cref="ReportDatabase"/> class.
        /// </summary>
        public ReportDatabase()
            : base(new ReportContext())
        {
        }

        #region GetReportDefinitions
        /// <summary>
        /// Get a list of all report definitions
        /// </summary>
        /// <returns>A list of all report definitions with Group and Securities included</returns>
        public List<ReportDefinition> GetReportDefinitions()
        {
            return (from q in Context.ReportDefinitions.Include("Group")
                    where !q.IsCancelled
                    orderby q.Title
                    select q).ToList();
        }

        /// <summary>
        /// Gets the report definitions.
        /// </summary>
        /// <param name="reportGroupID">The report group ID.</param>
        /// <returns></returns>
        public List<ReportDefinition> GetReportDefinitions(int reportGroupID)
        {
            return (from q in Context.ReportDefinitions.Include("Group")
                    where !q.IsCancelled && q.ReportGroupID == reportGroupID
                    orderby q.Title
                    select q).ToList();
        }
        #endregion

        #region GetReportDefinition
        /// <summary>
        /// Get a report definition
        /// </summary>        
        public ReportDefinition GetReportDefinition(long reportDefinitionID)
        {
            var rd = (from q in Context.ReportDefinitions.Include("Group")
                      where !q.IsCancelled
                      && q.ReportDefinitionID == reportDefinitionID
                      select q).FirstOrDefault();

            return rd;
        }
        #endregion

        ////#region GetReportDefinitionCriterias
        /////// <summary>
        /////// Gets the report definition criterias.
        /////// </summary>
        /////// <returns>A list of all report definitions criterias</returns>
        ////public List<ReportDefinitionCriteria> GetReportDefinitionCriterias(long reportDefinitionID)
        ////{
        ////    return (from q in Context.ReportDefinitionCriterias
        ////            where !q.IsCancelled
        ////            && q.ReportDefinitionID == reportDefinitionID
        ////            orderby q.OrderBy
        ////            select q).ToList();
        ////}
        ////#endregion

        #region GetReportDefinitionWithServer
        /// <summary>
        /// Get a report definition
        /// </summary>        
        public ReportDefinition GetReportDefinitionWithServer(long reportDefinitionID)
        {
            return (from q in Context.ReportDefinitions.Include("Group").Include("Server")
                    where !q.IsCancelled
                    && q.ReportDefinitionID == reportDefinitionID
                    select q).FirstOrDefault();
        }
        #endregion
    }
}