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

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

        #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 entity ID.
        /// </summary>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <param name="comment">The comment.</param>
        /// <returns></returns>
        public KeyValuePair<long, string> Create(int entityID, long itemID, string comment)
        {
            KeyValuePair<long, string> returnResult;

            try
            {
                var result = Context.Pr_CommentCreate(entityID, itemID, comment, 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 Update
        /// <summary>
        /// Updates the specified comment ID.
        /// </summary>
        /// <param name="commentID">The comment ID.</param>
        /// <param name="comment">The comment.</param>
        /// <returns></returns>
        public string Update(long commentID, string comment)
        {
            string error;
            try
            {
                var result = Context.Pr_CommentUpdate(commentID, comment, UserName).SingleOrDefault();

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

            return error;
        }
        #endregion

        #region Delete
        /// <summary>
        /// Deletes the specified comment ID.
        /// </summary>
        /// <param name="commentID">The comment ID.</param>
        /// <returns></returns>
        public string Delete(long commentID)
        {
            string error;
            try
            {
                var result = Context.Pr_CommentDelete(commentID, UserName).SingleOrDefault();

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

            return error;
        }
        #endregion

        #region GetComment
        /// <summary>
        /// Gets the comment.
        /// </summary>
        /// <param name="commentID">The comment ID.</param>
        /// <returns></returns>
        public Comment GetComment(long commentID)
        {
            return Context.Comments.Include("UserCreatedBy").Where(a => a.CommentID == commentID && a.IsCancelled == false).FirstOrDefault();
        }
        #endregion

        #region GetComments
        /// <summary>
        /// Gets the comments.
        /// </summary>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <returns></returns>
        public IEnumerable<Comment> GetComments(int entityID, long itemID)
        {
            return from q in Context.Comments.Include("UserCreatedBy")
                   where q.EntityID == entityID && q.ItemID == itemID && !q.IsCancelled
                   select q;
        }
        #endregion
    }
}