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

namespace Neo.Afx.Admin.Crm
{
    ///<summary>
    /// Afx admin database
    ///</summary>
    public class AfxAdminCrmDatabase : Database<AfxAdminCrmContext>
    {
        ///<summary>
        /// Constructor
        ///</summary>
        public AfxAdminCrmDatabase()
            : base(new AfxAdminCrmContext())
        {
        }

        ///<summary>
        /// Get list of messages from the crm.Messages table
        ///</summary>
        ///<param name="count">Top number of rows to be returned.</param>
        ///<returns>List of messages</returns>
        public IEnumerable<Message> GetMessages(int? count)
        {
            if(count.HasValue)
            {
                return (from m in Context.Messages
                        orderby m.MessageID descending
                        select m).Take(count.Value).ToList();
            }
            return (from m in Context.Messages
                    orderby m.MessageID descending
                    select m).ToList();
        }

        #region GetQueryTypes

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

        #endregion

        #region GetQueryStatus

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

        #endregion

        #region GetQuerySources

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

        #endregion


        /// <summary>
        /// Searches Messages Table and return a collection of matching results
        /// </summary>
        /// <param name="entityID">The Entity</param>
        /// <param name="itemID">The Item</param>
        /// <param name="sender">The Sender</param>
        /// <param name="recipients">The Recipients</param>
        /// <param name="isHtml">Is the Message HTML</param>
        /// <param name="createdByID">Who Created the Message</param>
        /// <param name="startDate">The Start Date to search from</param>
        /// <param name="endDate">The End Date to search up untill</param>
        /// <returns></returns>
        public IEnumerable<object> SearchMessages(short entityID, long itemID, string sender, string recipients, bool? isHtml, long createdByID, DateTime startDate, DateTime endDate)
        {
            return Context.Pr_MessageSearch(entityID, itemID, sender, recipients, isHtml, startDate, endDate).ToList();
        }

        /// <summary>
        /// Messages the template HTML tester.
        /// </summary>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <param name="messageTemplateID">The message template ID.</param>
        /// <returns></returns>
        public MessageTemplate MessageTemplateHtmlTester(short entityID, long itemID, long messageTemplateID)
        {
            return Context.Pr_MessageTemplateTester(entityID, itemID, messageTemplateID).FirstOrDefault();
        }

        /// <summary>
        /// Messages the template SQL tester.
        /// </summary>
        /// <param name="messageTemplateID">The message template ID.</param>
        /// <returns></returns>
        public IEnumerable<MessageTemplateSqlTest> MessageTemplateSqlTester(long messageTemplateID)
        {
            return Context.Pr_MessageTemplateSqlTester(messageTemplateID);
        }
    }
}