using System;
using System.Text;
using System.Data;
using System.Linq;
using System.Web.Mvc;
using System.Data.Entity.Validation;
using System.Collections.Generic;
using Neo.Afx.Mvc;
using Neo.Afx.ViewModels;
using Neo.Afx.ComponentModel;
using Neo.Afx.Services.Integration;
using Neo.Afx.Services.Workflows;
using Neo.Afx.Services.Workflows.Entities;
using Neo.Afx.Services.Forms.Entities;
using Neo.LegitimateLicences.Common;
using Neo.LegitimateLicences.Data.Models;
using Neo.LegitimateLicences.BusinessRuleBypassRequest.Models;
using Neo.LegitimateLicences.Data;
using Neo.Afx.Services.Audits;
using Neo.LegitimateLicences.Common.Helpers;
using Neo.LegitimateLicences.BusinessRuleBypassRequest.Models.Database;

using BusinessRuleBypassRequestDetail = Neo.LegitimateLicences.BusinessRuleBypassRequest.Models.Database.BusinessRuleBypassRequestDetail;
using Neo.Afx.Common;

namespace Neo.LegitimateLicences.BusinessRuleBypassRequest
{
    public partial class BusinessRuleBypassRequestController
    {
        
        #region Save
        [HttpPost]
        public JsonNetResult Save(BusinessRuleBypassRequestDetail value)
        {
            if (!SecurityHelper.UserHasAccessToSecurable(Profile.Securables.ToList(), Common.SecurableEnum.BusinessRuleBypassRequestModule))
            {
                throw new Exception("Security error");
            }

            var changes = new List<string>();
            var auditDb = new AuditsDatabase();

            if (value.BusinessRuleBypassRequestDetailID == Database.NewID)
            {
                value.CreatedDate = DateTime.Now;
                value.CreatedByID = Profile.UserID;
                value.UpdatedDate = DateTime.Now;
                value.UpdatedByID = Profile.UserID;

                Database.Insert(value);
            }
            else
            {
                var routeDb = new BusinessRuleBypassRequestDatabase(); //don't use database as we need the values refreshed every time
                var existingModel = routeDb.GetBusinessRuleBypassRequestForm(value.BusinessRuleBypassRequestDetailID, Profile.UserID);
                if (existingModel != null && existingModel.UpdatedDate.ToLongTimeString() != value.UpdatedDate.ToLongTimeString())
                {
                    return new JsonNetResult()
                    {
                        Data = new JsonBaseResult()
                        {
                            Success = false,
                            ErrorCode = "ERROR",
                            Error = "The record has been modified by someone else. Please try again."
                        }
                    };
                }

                value.UpdatedDate = DateTime.Now;
                value.UpdatedByID = Profile.UserID;                

                Database.Update(value);
                changes.AddRange(auditDb.GetEntityDifferences<Models.Database.BusinessRuleBypassRequestDetail>(existingModel, value, "BusinessRuleBypassRequestDetailID"));
            }

            try
            {
                Database.Save();
                WorkflowsDatabase workflowsDatabase = new WorkflowsDatabase();
                workflowsDatabase.ExecutePostFormSave(value.WorkflowInstanceID.Value, Profile.UserID);
                
                if (changes.Count > 0)
                {
                    auditDb.WriteEntries(2 /*Application*/, 2 /*Updated*/, changes, 1032 /*BusinessRuleBypassRequests*/, value.BusinessRuleBypassRequestDetailID, Profile.UserID);
                }
            }
            catch (Exception ex)
            {
                return new JsonNetResult()
                {
                    Data = new JsonBaseResult()
                    {
                        Success = false,
                        ErrorCode = "ERROR",
                        Error = string.Format("Error: {0}", new LegitimateDatabase().GetInnermostMessage(ex))
                    }
                };
            }

            var formDb = new BusinessRuleBypassRequestDatabase();
            var formData =  formDb.GetBusinessRuleBypassRequestForm(value.BusinessRuleBypassRequestDetailID, Profile.UserID);
            
             return new JsonNetResult()
                    {
                        Data = new JsonBaseResult()
                        { 
                            Result = formData,
                            Success = true                            
                        }
                    };
        }
        #endregion

    }
}