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

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

        #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 UpdateChecklistResults
        /////// <summary>
        /////// Updates the checklist results.
        /////// </summary>
        /////// <param name="results">The results.</param>
        /////// <param name="itemID">The item ID.</param>
        ////public void UpdateChecklistResults(List<ChecklistResult> results, long itemID)
        ////{
        ////    foreach(var checklistResult in results)
        ////    {
        ////        Context.Pr_ChecklistResultUpsert(checklistResult.EntityID,
        ////            itemID,
        ////            checklistResult.ChecklistTemplateQuestionID,
        ////            checklistResult.Result, checklistResult.Comments, UserName).SingleOrDefault();
        ////    }
        ////}
        ////#endregion

        ////#region GetChecklistTemplates
        /////// <summary>
        /////// Gets the checklist templates.
        /////// </summary>
        /////// <param name="entityID">The entity ID.</param>
        /////// <param name="itemID">The item ID.</param>
        /////// <param name="checklistTemplateStatusID">The checklist template status ID.</param>
        /////// <returns></returns>
        ////public IEnumerable<ChecklistTemplate> GetChecklistTemplates(int entityID, long itemID, short checklistTemplateStatusID)
        ////{
        ////    return from q in Context.ChecklistTemplates
        ////           where q.EntityID == entityID &&
        ////            q.ItemID == itemID &&
        ////            q.ChecklistTemplateStatusID == checklistTemplateStatusID
        ////           select q;
        ////}
        ////#endregion

        ////#region GetChecklistTemplateQuestions
        /////// <summary>
        /////// Gets the checklist template questions.
        /////// </summary>
        /////// <param name="checklistTemplateID">The checklist template ID.</param>
        /////// <returns></returns>
        ////public IEnumerable<ChecklistTemplateQuestion> GetChecklistTemplateQuestions(long checklistTemplateID)
        ////{
        ////    return from q in Context.ChecklistTemplateQuestions
        ////           where q.ChecklistTemplateID == checklistTemplateID
        ////           && q.IsCancelled == false
        ////           orderby q.OrderBy
        ////           select q;
        ////}
        ////#endregion

        ////#region GetChecklistTemplateQuestionsAll
        /////// <summary>
        /////// Gets the checklist template questions all.
        /////// </summary>
        /////// <param name="entityID">The entity ID.</param>
        /////// <param name="itemID">The item ID.</param>
        /////// <returns></returns>
        ////public IEnumerable<ChecklistTemplateQuestion> GetChecklistTemplateQuestionsAll(int entityID, long itemID)
        ////{
        ////    return from q in Context.ChecklistTemplateQuestions.Include("ChecklistTemplate")
        ////           where q.ChecklistTemplate.EntityID == entityID &&
        ////            q.ChecklistTemplate.ItemID == itemID &&
        ////            q.ChecklistTemplate.ChecklistTemplateStatusID == (short)ChecklistTemplateStatusEnum.Active
        ////            && q.IsCancelled == false
        ////           orderby q.OrderBy
        ////           select q;
        ////}
        ////#endregion

        ////#region GetChecklistResults
        /////// <summary>
        /////// Gets the checklist results.
        /////// </summary>
        /////// <param name="entityID">The entity ID.</param>
        /////// <param name="itemID">The item ID.</param>
        /////// <returns></returns>
        ////public IEnumerable<ChecklistResult> GetChecklistResults(int entityID, long itemID)
        ////{
        ////    int[] dateCapureFieldIds = { 4, 5 }; //as defined in Form.CaptureFields
        ////    var results = from q in Context.ChecklistResults.Include("ChecklistTemplateQuestion").Include("ChecklistTemplateQuestion.ChecklistTemplate")
        ////                  where q.EntityID == entityID && q.ItemID == itemID && q.ChecklistTemplateQuestion.IsCancelled == false
        ////                  orderby q.ChecklistTemplateQuestion.OrderBy
        ////                  select q;

        ////    //clean out the timezone from the captured date
        ////    foreach(var r in results)
        ////    {
        ////        if(dateCapureFieldIds.Contains(r.ChecklistTemplateQuestion.CaptureFieldID))
        ////        {
        ////            if(r.Result != null && r.Result.Contains("T"))
        ////            {
        ////                r.Result = Convert.ToDateTime(r.Result).ToString("G"); //get rid of the T 
        ////            }
        ////        }
        ////    }

        ////    return results;
        ////}
        ////#endregion

        ////#region GetChecklistResult
        /////// <summary>
        /////// Gets the checklist result.
        /////// </summary>
        /////// <param name="checklistResultID">The checklist result ID.</param>
        /////// <returns></returns>
        ////public ChecklistResult GetChecklistResult(long checklistResultID)
        ////{
        ////    return Context.ChecklistResults.Include("ChecklistTemplateQuestion").Where(a => a.ChecklistResultID == checklistResultID).FirstOrDefault();
        ////}
        ////#endregion

        #region GetCaptureFields
        /// <summary>
        /// Gets the capture fields.
        /// </summary>
        /// <returns></returns>
        public IEnumerable<CaptureField> GetCaptureFields()
        {
            return from q in Context.CaptureFields
                   where !q.IsCancelled
                   select q;
        }
        #endregion

        ////#region GetChecklistTemplateStatuses
        /////// <summary>
        /////// Gets the checklist template statuses.
        /////// </summary>
        /////// <returns></returns>
        ////public IEnumerable<ChecklistTemplateStatus> GetChecklistTemplateStatuses()
        ////{
        ////    return from q in Context.ChecklistTemplateStatuses
        ////           where !q.IsCancelled
        ////           select q;
        ////}
        ////#endregion

        ////#region CreateHyperLink
        /////// <summary>
        /////// Creates the hyper link.
        /////// </summary>
        /////// <param name="entityID">The entity ID.</param>
        /////// <param name="itemID">The item ID.</param>
        /////// <param name="title">The title.</param>
        /////// <param name="description">The description.</param>
        /////// <param name="url">The URL.</param>
        /////// <param name="thumbnailUrl">The thumbnail URL.</param>
        /////// <param name="openInNewWindow"><code>true</code> if Open in new window; <code>false</code> otherwise.</param>
        /////// <returns></returns>
        ////public KeyValuePair<long, string> CreateHyperLink(int entityID, long itemID, string title, string description, string url, string thumbnailUrl, bool openInNewWindow)
        ////{
        ////    KeyValuePair<long, string> returnResult;

        ////    try
        ////    {
        ////        var result = Context.Pr_HyperLinkCreate(entityID, itemID, title, description, url, thumbnailUrl, openInNewWindow, 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 UpdateHyperLink
        /////// <summary>
        /////// Updates the hyper link.
        /////// </summary>
        /////// <param name="hyperLinkID">The hyper link ID.</param>
        /////// <param name="title">The title.</param>
        /////// <param name="description">The description.</param>
        /////// <param name="url">The URL.</param>
        /////// <param name="thumbnailUrl">The thumbnail URL.</param>
        /////// <param name="openInNewWindow"><code>true</code> if Open in new window; <code>false</code> otherwise.</param>
        /////// <returns></returns>
        ////public string UpdateHyperLink(long hyperLinkID, string title, string description, string url, string thumbnailUrl, bool openInNewWindow)
        ////{
        ////    string error;
        ////    try
        ////    {
        ////        var result = Context.Pr_HyperLinkUpdate(hyperLinkID, title, description, url, thumbnailUrl, openInNewWindow, 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 DeleteHyperLink
        /////// <summary>
        /////// Deletes the hyper link.
        /////// </summary>
        /////// <param name="hyperLinkID">The hyper link ID.</param>
        /////// <returns></returns>
        ////public string DeleteHyperLink(long hyperLinkID)
        ////{
        ////    string error;
        ////    try
        ////    {
        ////        var result = Context.Pr_HyperLinkDelete(hyperLinkID, 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 GetHyperlink
        /////// <summary>
        /////// Gets the hyperlink.
        /////// </summary>
        /////// <param name="hyperLinkID">The hyper link ID.</param>
        /////// <returns></returns>
        ////public HyperLink GetHyperlink(long hyperLinkID)
        ////{
        ////    return Context.HyperLinks.Include("UserCreatedBy").Where(a => a.HyperLinkID == hyperLinkID).FirstOrDefault();
        ////}
        ////#endregion

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

        ////#region GetForms
        /////// <summary>
        /////// Gets a list of all the forms in the system
        /////// </summary>        
        /////// <returns></returns>
        ////public Form GetFormForWorkflow(long workflowID)
        ////{
        ////    var obj = (from q in Context.Forms
        ////               where q.WorkflowID == workflowID 
        ////               select q).FirstOrDefault();

        ////    return obj;
        ////}
        ////#endregion

        ////#region GetActiveFormTemplate
        /////// <summary>
        /////// Gets the form, including sections and fields.
        /////// </summary>
        /////// <param name="formID">The form ID.</param>        
        /////// <returns></returns>
        ////public FormTemplate GetActiveFormTemplate(long formID)
        ////{
        ////    var obj = (from q in Context.FormTemplates.Include("Form").Include("FormTemplateSections").Include("FormTemplateSections.FormTemplateSectionFields")
        ////           where q.FormID == formID && q.FormTemplateStatusID == 1 //Active
        ////           select q).FirstOrDefault();
            
        ////    obj.FormTemplateSections = obj.FormTemplateSections.OrderBy(a => a.OrderBy).ToList();
        ////    foreach (var fs in obj.FormTemplateSections)
        ////    {
        ////        fs.FormTemplateSectionFields = fs.FormTemplateSectionFields.OrderBy(a => a.OrderBy).ToList();
        ////    }

        ////    return obj;
        ////}
        ////#endregion

        ////#region GetFormTag
        ////public FormTag GetFormTag(long formTagID)
        ////{
        ////    return (from tag in Context.FormTags
        ////            where tag.FormTagID == formTagID
        ////            select tag).FirstOrDefault();
        ////} 
        ////#endregion

        ////#region GetFormTemplateSectionFields
        ////public IEnumerable<FormTemplateSectionField> GetFormTemplateSectionFields()
        ////{
        ////    return (from tag in Context.FormTemplateSectionFields
        ////            select tag);
        ////}
        ////#endregion

        ////#region GetFormTemplateChecks
        ////public IEnumerable<FormTemplateDocumentCheck> GetFormTemplateDocumentChecks()
        ////{
        ////    return (from tag in Context.FormTemplateDocumentChecks                    
        ////            select tag);
        ////}
        ////#endregion
    }
}