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

namespace Neo.LegitimateLicences.Routes.Controllers
{
    public partial class RoutesController : Neo.LegitimateLicences.Common.ControllerBase
    {
        #region Action Results
        #region Default
        public ActionResult Default()
        {
            var database = new LegitimateDatabase();
            if (!SecurityHelper.UserHasAccessToSecurable(Profile.Securables.ToList(), Common.SecurableEnum.RoutesModule))
            {
                return RedirectToAction("Default", "Applications");
            }

            var model = new DefaultModel
            {
                Routes = new List<Route>(),
                Lookups = GetLookups()
            };

            ViewBag.Controller = "Members";
            ViewBag.Page = "Home";
            return View("Default", model);
        }
        #endregion
        #endregion

        #region JSON endpoints

        // All JSON endpoints require [HttpPost] to prevent JSON hijacking.
        // With [HttpPost], returning arrays is allowed.  
        // See http://haacked.com/archive/2009/06/25/json-hijacking.aspx

        [HttpPost]
        public JsonResult SearchVerifiedRoutes(long? originSearch, long? destinationSearch, long? assocationSearch, string nationalRouteNumberSearch, string boardRouteNumberOriginSearch, bool? includeRoutesInVerification, long? routeStatusID, long? applicationDetailID, long? applicationRequestTypeID)
        {
            var database = new LegitimateDatabase();
            IEnumerable<Pr_RouteSearch_Result> data = new List<Pr_RouteSearch_Result>();
            var success = true;
            var errorMessage = "";
            try
            {
                data = database.SearchVerifiedRoutes(originSearch, destinationSearch, assocationSearch, nationalRouteNumberSearch, boardRouteNumberOriginSearch, includeRoutesInVerification, routeStatusID, applicationDetailID, applicationRequestTypeID);
            }
            catch (Exception ex)
            {
                success = false;
                errorMessage = database.GetInnermostMessage(ex);
            }
            return Json(new
            {
                data,
                success,
                errorMessage
            }, JsonSerializerOptions.FormatDateTime);
        }
        #endregion

        #region GetLookups
        public List<LookupList> GetLookups()
        {
            var lookups = new List<LookupList>();
            var integrationStore = new SqlIntegrationStore();
            try
            {
                integrationStore.Open();

                lookups.Add(new LookupList("ApplicationRequestTypes", integrationStore.GetDataEntities("ApplicationRequestTypes", string.Empty)));
                lookups.Add(new LookupList("ApplicationActiveWorkflows", integrationStore.GetDataEntities("ActiveWorkflows", string.Empty)));
                lookups.Add(new LookupList("ApplicationWorkflowInstanceStatus", integrationStore.GetDataEntities("WorkflowInstanceStatus", string.Empty)));
                lookups.Add(new LookupList("ApplicationWorkflowTemplateSteps", integrationStore.GetDataEntities("WorkflowTemplateSteps", string.Empty)));
                lookups.Add(new LookupList("VerifiedRouteStatus", integrationStore.GetDataEntities("VerifiedRouteStatus", string.Empty)));
            }
            finally
            {
                integrationStore.Close();
            }

            return lookups;
        }
        #endregion
    }
}