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

namespace Neo.Afx.WinService.Messages
{
    /// <summary>
    /// The Crm database.
    /// </summary>
    public class MessageDatabase : Database<MessageContext>
    {
        public MessageDatabase(string efConnectionString)
            : base(new MessageContext(efConnectionString))
        {
        }

        #region MessageEntityID

        int _messageEntityID;
        public int MessageEntityID
        {
            get
            {
                if(_messageEntityID == 0)
                {
                    _messageEntityID = Context.Database.SqlQuery<int>("SELECT [System].[GetEntityID]('message')").FirstOrDefault();
                }
                return _messageEntityID;
            }
        }

        #endregion

        #region GetMailSetting

        public MailSetting GetMailSetting()
        {
            return GetByID<MailSetting>(1);
        }

        #endregion

        #region GetSmsSetting

        public SmsSetting GetSmsSetting()
        {
            return GetByID<SmsSetting>(1);
        }

        #endregion

        #region GetPendingMessages

        /// <summary>
        /// Gets a list of pending <see cref="Message"/>.
        /// </summary>
        /// <param name="messageType">The type of the message.</param>
        /// <returns>
        /// A list of pending <see cref="Message"/>.
        /// </returns>
        public IQueryable<Message> GetPendingMessages(MessageTypeEnum messageType)
        {
            return from q in Context.Messages
                   where !q.IsCancelled && q.MessageTypeID == (byte)messageType && q.SentDate == null
                   orderby q.CreatedDate descending
                   select q;
        }

        #endregion

        #region GetAttachments

        /// <summary>
        /// Gets a list of <see cref="Document"/>.
        /// </summary>
        /// <param name="message">The message for which attachments should be returned.</param>
        /// <returns>
        /// A list of <see cref="Document"/>.
        /// </returns>
        public IQueryable<DocumentContent> GetAttachments(Message message)
        {
            return from d in Context.DocumentContents
                   where !d.Document.IsCancelled && d.Document.EntityID == MessageEntityID && d.Document.ItemID == message.MessageID
                   select d;
        }

        #endregion

        #region CreateTemplatedEmails

        public void CreateTemplatedEmails(int templateID)
        {
            Context.Pr_MessageCreateTemplatedEmails(templateID);
        } 

        #endregion

    }

}