using System;
using System.Linq;
using System.Web.Mvc;
using System.Collections.Generic;
using Neo.Afx.Mvc;
using Neo.Afx.Common;
using Neo.Afx.ViewModels;
using Neo.Afx.Services.Workflows;
using Neo.LegitimateLicences.Common;
using Neo.LegitimateLicences.Data.Models;
using Neo.LegitimateLicences.AppProviderIssueRequest.Models.Database;
using Neo.LegitimateLicences.Common.Helpers;

namespace Neo.LegitimateLicences.AppProviderIssueRequest
{
    public partial class AppProviderIssueRequestController : Neo.LegitimateLicences.Common.ControllerBase
    {
        #region Save
        [HttpPost]
        public JsonNetResult Save(AppProviderIssueDetail value)
        {
            try
            {
                var db = new LegitimateDatabase();
                
                // Update AppProviderIssueDetails record
                if (value.AppProviderIssueDetailID > 0)
                {
                    db.Context.Database.ExecuteSqlCommand(
                        @"UPDATE App.AppProviderIssueDetails
                          SET IsDocumentVerificationRequired = @p1,
                              UpdatedByID = @p2,
                              UpdatedDate = GETDATE()
                          WHERE AppProviderIssueDetailID = @p0",
                        new object[] { 
                            value.AppProviderIssueDetailID,
                            value.IsDocumentVerificationRequired,
                            Profile.UserID
                        });
                }

                // Execute post-form save workflow actions
                if (value.WorkflowInstanceID.HasValue)
                {
                    var workflowsDatabase = new WorkflowsDatabase();
                    workflowsDatabase.ExecutePostFormSave(value.WorkflowInstanceID.Value, Profile.UserID);
                }

                // Return updated form data
                var formData = Database.GetAppProviderIssueForm(value.AppProviderIssueDetailID, Profile.UserID);
                
                return new JsonNetResult
                {
                    Data = new JsonBaseResult
                    {
                        Result = formData,
                        Success = true
                    }
                };
            }
            catch (Exception ex)
            {
                return new JsonNetResult
                {
                    Data = new JsonBaseResult
                    {
                        Success = false,
                        ErrorCode = "ERROR",
                        Error = string.Format("Error: {0}", new LegitimateDatabase().GetInnermostMessage(ex))
                    }
                };
            }
        }
        #endregion
    }
}