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

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

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

        #region Create
        /// <summary>
        /// Creates the specified query type ID.
        /// </summary>
        /// <param name="queryTypeID">The query type ID.</param>
        /// <param name="querySourceID">The query source ID.</param>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <param name="assignedToUserRoleID">The assigned to user role ID.</param>
        /// <param name="assignedToUserID">The assigned to user ID.</param>
        /// <param name="assignedToUserDate">The assigned to user date.</param>
        /// <param name="description">The description.</param>
        /// <param name="responseEmailAddress">The response email address.</param>
        /// <param name="responseContactAddress">The response contact address.</param>
        /// <returns></returns>
        public KeyValuePair<long, string> Create(short queryTypeID, short querySourceID, int entityID, long itemID, short assignedToUserRoleID, long assignedToUserID, DateTime assignedToUserDate, string description, string responseEmailAddress, string responseContactAddress)
        {
            KeyValuePair<long, string> returnResult;

            try
            {
                var result = Context.Pr_QueryCreate(queryTypeID, querySourceID, entityID, itemID, assignedToUserRoleID, assignedToUserID, assignedToUserDate, description, responseEmailAddress, responseContactAddress, 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 query ID.
        /// </summary>
        /// <param name="queryID">The query ID.</param>
        /// <param name="queryTypeID">The query type ID.</param>
        /// <param name="querySourceID">The query source ID.</param>
        /// <param name="assignedToUserRoleID">The assigned to user role ID.</param>
        /// <param name="assignedToUserID">The assigned to user ID.</param>
        /// <param name="assignedToUserDate">The assigned to user date.</param>
        /// <param name="description">The description.</param>
        /// <param name="responseEmailAddresses">The response email addresses.</param>
        /// <param name="responseContactNumbers">The response contact numbers.</param>
        /// <returns></returns>
        public string Update(long queryID, short queryTypeID, short querySourceID, short? assignedToUserRoleID, long? assignedToUserID, DateTime? assignedToUserDate, string description, string responseEmailAddresses, string responseContactNumbers)
        {
            string error;
            try
            {
                var result = Context.Pr_QueryUpdate(queryID, queryTypeID, querySourceID, assignedToUserRoleID, assignedToUserID, assignedToUserDate, description, responseEmailAddresses, responseContactNumbers, 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 UpdateStatus
        /// <summary>
        /// Updates the status.
        /// </summary>
        /// <param name="queryID">The query ID.</param>
        /// <param name="queryStatusID">The query status ID.</param>
        /// <returns></returns>
        public string UpdateStatus(long queryID, short queryStatusID)
        {
            string error;
            try
            {
                var result = Context.Pr_QueryUpdateStatus(queryID, queryStatusID, 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 query ID.
        /// </summary>
        /// <param name="queryID">The query ID.</param>
        /// <returns></returns>
        public string Delete(long queryID)
        {
            string error;
            try
            {
                var result = Context.Pr_QueryDelete(queryID, 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 GetQuery
        /// <summary>
        /// Gets the query.
        /// </summary>
        /// <param name="queryID">The query ID.</param>
        /// <returns></returns>
        public Query GetQuery(long queryID)
        {
            return Context.Queries.Where(a => a.QueryID == queryID).FirstOrDefault();
        }
        #endregion

        #region GetQueries
        /// <summary>
        /// Gets the queries.
        /// </summary>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <returns></returns>
        public IEnumerable<Vw_Queries> GetQueries(int entityID, long itemID)
        {
            return GetQueries(entityID, itemID, "", "", "").ToList();
        }

        /// <summary>
        /// Gets the queries.
        /// </summary>
        /// <param name="entityID">The entity ID.</param>
        /// <param name="itemID">The item ID.</param>
        /// <param name="queryStatus">The query status.</param>
        /// <param name="assignedToUserRoleID">The assigned to user role ID.</param>
        /// <param name="assignedToUserID">The assigned to user ID.</param>
        /// <returns></returns>
        public IEnumerable<Vw_Queries> GetQueries(int entityID, long itemID, string queryStatus, string assignedToUserRoleID, string assignedToUserID)
        {
            return Context.Pr_QuerySearch(entityID, itemID, queryStatus, assignedToUserRoleID, assignedToUserID).ToList();
        }
        #endregion

        #region GetQueryStatuses
        /// <summary>
        /// Gets the query statuses.
        /// </summary>
        /// <returns></returns>
        public IEnumerable<QueryStatus> GetQueryStatuses()
        {
            return from q in Context.QueryStatus
                   where !q.IsCancelled
                   select q;
        }
        #endregion

        #region GetQuerySources
        /// <summary>
        /// Gets the query sources.
        /// </summary>
        /// <returns></returns>
        public IEnumerable<QuerySource> GetQuerySources()
        {
            return from q in Context.QuerySources
                   where !q.IsCancelled
                   select q;
        }
        #endregion

        #region GetQueryTypes
        /// <summary>
        /// Gets the query types.
        /// </summary>
        /// <returns></returns>
        public IEnumerable<QueryType> GetQueryTypes()
        {
            return from q in Context.QueryTypes
                   where !q.IsCancelled
                   select q;
        }
        #endregion
    }
}