using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Neo.Afx.ComponentModel;
using Neo.Afx.Services.Notifications.Entities;

namespace Neo.Afx.Services.Notifications
{
    /// <summary>
    /// Notifications database context container
    /// </summary>
    public class NotificationsDatabase : Database<NotificationsContext>
    {
        /// <summary>
        /// Initializes a new instance of the <see cref="CorrespondenceDatabase"/> class.
        /// </summary>
        public NotificationsDatabase()
            : base(new NotificationsContext())
        {
        }

        #region UserName
        /// <summary>
        /// Gets the name of the user.
        /// </summary>
        /// <value>
        /// The name of the user.
        /// </value>
        public string UserName
        {
            get
            {
                if (HttpContext.Current.User != null && HttpContext.Current.User.Identity.IsAuthenticated)
                {
                    return HttpContext.Current.User.Identity.Name.ToLower();
                }

                return "";
            }
        }
        #endregion

        #region Create
        /// <summary>
        /// Creates the specified notification.
        /// </summary>
        /// <param name="userID">The userid that the notification will be displayed to.</param>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <param name="notificationCategoryID">The notification Category ID.</param>
        /// /// <param name="notificationTypeID">The notification Type ID.</param>
        /// <param name="notification">The notification.</param>
        /// <returns></returns>
        public KeyValuePair<long, string> Create(long userID, int entityID, long itemID, short notificationCategoryID, short notificationTypeID, string notification)
        {
            KeyValuePair<long, string> returnResult;

            try
            {
                var result = Context.Pr_NotificationCreate(userID, entityID, itemID, notificationCategoryID, notificationTypeID, notification, UserName).SingleOrDefault();

                returnResult = result.HasValue ? new KeyValuePair<long, string>(result.Value, (result.Value != -1) ? String.Empty : "Unknown error occured") : new KeyValuePair<long, string>(-1, "Unknown error occured");
            }
            catch (Exception ex)
            {
                returnResult = new KeyValuePair<long, string>(-1, ex.InnerException.Message);
            }

            return returnResult;
            }
        #endregion

            #region MarkAsRead
            /// <summary>
            /// Marks a notification as read.
            /// </summary>
            /// <param name="notificationID">The notification ID.</param>
            /// <returns></returns>
            public string MarkAsRead(long notificationID)
        {
            string error;
            try
            {
                var result = Context.Pr_NotificationMarkAsRead(notificationID, UserName).SingleOrDefault();

                if (result.HasValue)
                {
                    error = String.Empty;
                }
                else
                {
                    error = "Unknown error occured";
                }
            }
            catch (Exception ex)
            {
                error = ex.InnerException.Message;
            }

            return error;
        }
        #endregion

        #region GetNotification
        /// <summary>
        /// Gets the notification.
        /// </summary>
        /// <param name="notificationID">The notification ID.</param>
        /// <returns></returns>
        public Vw_Notifications GetNotification(long notificationID)
        {
            return Context.Vw_Notifications.Where(a => a.NotificationID == notificationID).FirstOrDefault();
        }
        #endregion

        #region GetNotifications
        /// <summary>
        /// Gets the messages.
        /// </summary>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <returns></returns>
        public IEnumerable<Vw_Notifications> GetNotifications(long userID, int entityID, long itemID, bool unreadOnly)
        {
            return Context.Pr_NotificationSearch(userID, entityID, itemID, unreadOnly).ToList();
        }
        #endregion

    }
}