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 PurificationMapping
        public ActionResult PurificationMapping(long AssociationID)
            {
            if (!SecurityHelper.UserHasAccessToSecurable(Profile.Securables.ToList(), Securable.ApplicationsModule_Purification))
            {
                return RedirectToAction("Default", "Applications");
            }

            var database = new LegitimateDatabase();

                var lookups = new List<LookupList>();
                var QueryString1 = "AssociationID=" + AssociationID.ToString();
                var QueryString2 = "";
                var QueryString3 = "";
                var integrationStore = new SqlIntegrationStore();
                try
                {
                    integrationStore.Open();

                    lookups.Add(new LookupList("Associations", integrationStore.GetDataEntities("Associations", QueryString1)));
                    lookups.Add(new LookupList("NeoAssociations", integrationStore.GetDataEntities("NeoAssociations", QueryString2)));
                    lookups.Add(new LookupList("OLASAssociations", integrationStore.GetDataEntities("OLASAssociations", QueryString3)));
                }
                finally
                {
                    integrationStore.Close();
                }

                var model = new PurificationMappingModel
                {
                    Lookups = lookups,
                    AssociationID = AssociationID
                };
                ViewBag.Controller = "Applications";
                ViewBag.Page = "PurificationMapping";
                return View("PurificationMapping", model);
            }
            #endregion
        #endregion

        #region UpdateVerificationAssociation

            [HttpPost]
            public JsonResult UpdateVerificationAssociation(long AssociationID ,long OlasID ,long NeoID)
            {
                var success = false;
                var database = new LegitimateDatabase();
                var message = "";

                try {
                    success = database.UpdateAssociationOlasNeo(Profile.UserID, AssociationID, OlasID, NeoID, true);
                }
                catch(Exception ex) {
                    success = false;
                    message = ex.InnerException.Message;
                }

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

        #endregion
    }
}