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

namespace Neo.Afx.Admin.Report
{
    ///<summary>
    /// Afx admin database
    ///</summary>
    public class AfxAdminReportDatabase : Database<AfxAdminReportContext>
    {
        ///<summary>
        /// Constructor
        ///</summary>
        public AfxAdminReportDatabase()
            : base(new AfxAdminReportContext())
        {
        }

        #region GetReportDefinitions

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<ReportDefinition> GetReportDefinitions()
        {
            return (from item in Context.ReportDefinitions where item.IsCancelled == false orderby item.Description ascending select item).ToList();
        }

        /// <summary>
        /// Get data from table based on count.
        /// </summary>
        /// <param name="count">Restricts amount returned items in the collection.</param>
        /// <returns>List of objects.</returns>
        public IEnumerable<ReportDefinition> GetReportDefinitions(int count)
        {
            return (from item in Context.ReportDefinitions where item.IsCancelled == false orderby item.Description ascending select item).Take(count).ToList();
        }

        #endregion

        #region GetReportSevers

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<ReportServer> GetReportSevers()
        {
            return (from item in Context.ReportServers where item.IsCancelled == false orderby item.Title ascending select item).ToList();
        }

        /// <summary>
        /// Get data from table based on count.
        /// </summary>
        /// <param name="count">Restricts amount returned items in the collection.</param>
        /// <returns>List of objects.</returns>
        public IEnumerable<ReportServer> GetReportSevers(int count)
        {
            return (from item in Context.ReportServers where item.IsCancelled == false orderby item.Title ascending select item).Take(count).ToList();
        }

        #endregion

        #region GetReportGroups

        /// <summary>
        /// Get Report Servers based on count.
        /// </summary>
        /// <param name="count">Restricts amount returned items in the collection.</param>
        /// <returns>List of Report Servers.</returns>
        public IEnumerable<ReportGroup> GetReportGroups(int count)
        {
            return (from item in Context.ReportGroups where item.IsCancelled == false orderby item.Description ascending select item).Take(count).ToList();
        }

        /// <summary>
        /// Get all Report Servers.
        /// </summary>
        /// <returns>List of Report Servers.</returns>
        public IEnumerable<ReportGroup> GetReportGroups()
        {
            return (from item in Context.ReportGroups where item.IsCancelled == false orderby item.Description ascending select item).ToList();
        }

        #endregion
    }
}