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

namespace Neo.Afx.Admin.Form
{
    ///<summary>
    /// Afx admin database
    ///</summary>
    public class AfxAdminFormDatabase : Database<AfxAdminFormContext>
    {
        ///<summary>
        /// Constructor
        ///</summary>
        public AfxAdminFormDatabase()
            : base(new AfxAdminFormContext())
        {
        }

        #region GetChecklistTemplateStatuses

        /// <summary>
        /// Get Checklist Template Statuses based on count.
        /// </summary>
        /// <param name="count">Restricts amount of Checklist Template Statuses</param>
        /// <returns>List of Checklist Template Statuses</returns>
        public IEnumerable<ChecklistTemplateStatus> GetChecklistTemplateStatuses(int count)
        {
            return (from item in Context.ChecklistTemplateStatus where item.IsCancelled == false orderby item.Description ascending select item).Take(count).ToList();
        }

        /// <summary>
        /// Get all Checklist Template Statuses.
        /// </summary>
        /// <returns>List of Entites</returns>
        public IEnumerable<ChecklistTemplateStatus> GetChecklistTemplateStatuses()
        {
            return (from item in Context.ChecklistTemplateStatus where item.IsCancelled == false orderby item.Description ascending select item).ToList();
        }

        #endregion

        #region GetChecklistTemplates

        /// <summary>
        /// Get Checklist Template Statuses based on count.
        /// </summary>
        /// <param name="count">Restricts amount of Checklist Template Statuses</param>
        /// <returns>List of Checklist Template Statuses</returns>
        public IEnumerable<ChecklistTemplate> GetChecklistTemplates(int count)
        {
            return (from item in Context.ChecklistTemplates where item.IsCancelled == false orderby item.ChecklistTitle ascending select item).Take(count).ToList();
        }

        /// <summary>
        /// Get all Checklist Template Statuses.
        /// </summary>
        /// <returns>List of Entites</returns>
        public IEnumerable<ChecklistTemplate> GetChecklistTemplates()
        {
            return (from item in Context.ChecklistTemplates where item.IsCancelled == false orderby item.ChecklistTitle ascending select item).ToList();
        }

        #endregion

        #region GetCaptureFields

        /// <summary>
        /// Get Checklist Template Statuses based on count.
        /// </summary>
        /// <param name="count">Restricts amount of Checklist Template Statuses</param>
        /// <returns>List of Checklist Template Statuses</returns>
        public IEnumerable<CaptureField> GetCaptureFields(int count)
        {
            return (from item in Context.CaptureFields where item.IsCancelled == false orderby item.Description ascending select item).Take(count).ToList();
        }

        /// <summary>
        /// Get all Checklist Template Statuses.
        /// </summary>
        /// <returns>List of Entites</returns>
        public IEnumerable<CaptureField> GetCaptureFields()
        {
            return (from item in Context.CaptureFields where item.IsCancelled == false orderby item.Description ascending select item).ToList();
        }

        #endregion

        #region GetChecklistTemplateQuestions

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<ChecklistTemplateQuestion> GetChecklistTemplateQuestions()
        {
            return (from item in Context.ChecklistTemplateQuestions where item.IsCancelled == false 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<ChecklistTemplateQuestion> GetChecklistTemplateQuestions(int count)
        {
            return (from item in Context.ChecklistTemplateQuestions where item.IsCancelled == false select item).Take(count).ToList();
        }

        #endregion

    }
}