using System;
using System.Collections.Generic;
using System.Web.Mvc;
using Neo.Legitimate.Applications.Models;
using Neo.Legitimate.Data.Models;
using Pilotfish.Afx.Mvc;
using Pilotfish.Afx.Services.Integration;
using Pilotfish.Afx.ViewModels;
using Neo.Legitimate.Common;
using System.Linq;

namespace Neo.Legitimate.Applications.Controllers
{
    public partial class ApplicationsController : Neo.Legitimate.Common.ControllerBase
    {
        #region Action Results
        #region PurificationNeoMemberEditor
        public ActionResult PurificationNeoMemberEditor(long AssociationID, string AssociationName, long AssociationMemberDataID, long ParentAssociationID)
        {
            if (!SecurityHelper.UserHasAccessToSecurable(Profile.Securables.ToList(), Securable.ApplicationsModule_Purification_ManageNeoverifieddata))
            {
                return RedirectToAction("Default", "Applications");
            }

            var database = new LegitimateDatabase();
            var list = new List<Pr_AssociationNeoMemberSearch_Result>();

            list.Add(new Pr_AssociationNeoMemberSearch_Result());

            list[0].AssociationMemberDataID = -1;
            list[0].AssociationID = (int)AssociationID;
            list[0].Association_Name = AssociationName;

            var model = new PurificationNeoMemberEditorModel
            {
                SearchResults = AssociationMemberDataID == -1 ? list : database.GetNeoMembers(AssociationID, AssociationMemberDataID),
                AssociationID = AssociationID,
                ParentAssociationID = ParentAssociationID
            };

            ViewBag.Controller = "Applications";
            ViewBag.Page = "PurificationMapping";
            return View("PurificationNeoMemberEditor", model);
        }
        #endregion
        #endregion

        #region Save/Insert Neo Verified Members
        [HttpPost]
        public JsonResult NeoVerifiedMemberSaveInsert(List<Pr_AssociationNeoMemberSearch_Result> SearchResults)
        {
            if (!SecurityHelper.UserHasAccessToSecurable(Profile.Securables.ToList(), Securable.ApplicationsModule_Purification_ManageNeoverifieddata))
            {
                throw new Exception("Security error");
            }

            var success = false;
            var message = "";
            var placeHolder = new Object();

            var queryString = "associationmemberdataid=" + SearchResults[0].AssociationMemberDataID + "&associationid=" + SearchResults[0].AssociationID + "&association_name=" + SearchResults[0].Association_Name + "&surname_or_company_name=" + SearchResults[0].Surname_Or_Company_Name + "&member_first_name=" + SearchResults[0].Member_First_Name + "&member_id_number=" + SearchResults[0].Member_ID_Number + "&id_type=" + SearchResults[0].ID_Type + "&postal_address=" + SearchResults[0].Postal_Address + "&postal_address_code=" + SearchResults[0].Postal_Address_Code + "&physical_address=" + SearchResults[0].Physical_Address + "&tax_number=" + SearchResults[0].Tax_Number + "&tel_number=" + SearchResults[0].Tel__Number + "&fax_number=" + SearchResults[0].Fax_Number + "&cell_number=" + SearchResults[0].Cell_Number + "&email_address=" + SearchResults[0].Email_Address + "&ol_permit_number=" + SearchResults[0].OL_Permit_Number + "&vehicle_chassis_number=" + SearchResults[0].Vehicle_Chassis_Number + "&vehicle_registration=" + SearchResults[0].vehicle_registration + "&legitimateapplicationrequestdetailid=" + SearchResults[0].LegitimateApplicationRequestDetailID + "&istransactionrequired=1";
            var integrationStore = new SqlIntegrationStore();

            try
            {
                integrationStore.Open();

                placeHolder = integrationStore.GetDataEntities("NeoVerifiedUpdateInsert", queryString);
                success = true;
            }
            catch (Exception ex)
            {
                success = false;
                message = ex.InnerException.Message;
            }
            finally
            {
                integrationStore.Close();
            }

            return Json(new { success, message });
        }
        #endregion

        #region Delete/IsCancelled Neo Verified Members
        [HttpPost]
        public JsonResult NeoVerifiedMemberDelete(List<Pr_AssociationNeoMemberSearch_Result> SearchResults)
        {
            if (!SecurityHelper.UserHasAccessToSecurable(Profile.Securables.ToList(), Securable.ApplicationsModule_Purification_ManageNeoverifieddata))
            {
                throw new Exception("Security error");
            }

            var success = false;
            var message = "";
            var placeHolder = new Object();

            var queryString = "associationmemberdataid=" + SearchResults[0].AssociationMemberDataID + "&istransactionrequired=1";
            var integrationStore = new SqlIntegrationStore();

            try
            {
                integrationStore.Open();
                placeHolder = integrationStore.GetDataEntities("NeoVerifiedMemberDelete", queryString);
                success = true;
            }
            catch (Exception ex)
            {
                success = false;
                message = ex.InnerException.Message;
            }
            finally
            {
                integrationStore.Close();
            }

            return Json(new { success, message });
        }
        #endregion
    }
}