using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using Neo.LegitimateLicences.Common;
using Neo.Afx.ComponentModel;
using Neo.Afx.Security;
using Neo.LegitimateLicences.Common.Helpers;
using System.Threading;
using System.Data.Entity;

namespace Neo.LegitimateLicences.Data.Models
{
    public partial class LegitimateDatabase 
    {

        #region SearchApplicationRequestTypeSetup
        public List<Pr_ApplicationRequestTypeDivisionSetupSearch_Result> SearchApplicationRequestTypeSetup(short? applicationRequestTypeID, short? documentTypeID, short? provinceID, long userID)
        {
            return Context.Pr_ApplicationRequestTypeDivisionSetupSearch(applicationRequestTypeID, documentTypeID, provinceID, userID).ToList();
        }
        #endregion

        #region SearchViewApplicationRequestTypeSetup
        public List<Vw_ApplicationRequestTypeDivisionSetup> SearchViewApplicationRequestTypeSetup()
        {
            return Context.Vw_ApplicationRequestTypeDivisionSetup.ToList();
        }
        #endregion

        #region GetApplicationRequestTypeDivisionSetup
        public Vw_ApplicationRequestTypeDivisionSetup GetApplicationRequestTypeDivisionSetup(long applicationRequestTypeDivisionSetupID)
        {
            var applicationRequestTypeDivisionSetup = Context.Vw_ApplicationRequestTypeDivisionSetup.Where(a => a.ApplicationRequestTypeDivisionSetupID == applicationRequestTypeDivisionSetupID).FirstOrDefault();
            if (applicationRequestTypeDivisionSetup == null)
            {
                applicationRequestTypeDivisionSetup = new Vw_ApplicationRequestTypeDivisionSetup();
            }
            return applicationRequestTypeDivisionSetup;
        }
        #endregion

        #region GetApplicationRequestTypeDocumentSetup
        public List<Vw_ApplicationRequestTypeDocumentSetup> GetApplicationRequestTypeDocumentSetup(short divisionTypeID, short provinceID, short applicationRequestTypeID, long workflowTemplateID)
        {
            return Context.Vw_ApplicationRequestTypeDocumentSetup.Where(a => a.DivisionTypeID == divisionTypeID && a.ProvinceID == provinceID && a.ApplicationRequestTypeID == applicationRequestTypeID && a.WorkflowTemplateID == workflowTemplateID && !a.IsCancelled).ToList();
        }
        #endregion

        #region UpsertApplicationRequestTypeDocument
        public void UpsertApplicationRequestTypeDocument(int applicationRequestTypeDocumentID, short? divisionTypeID, short? provinceID, short applicationRequestTypeID, short documentTypeID, long workflowTemplateID, string isAvailableForUpload, string isMandatory, long userID)
        {
            Context.Pr_ApplicationRequestTypeDocumentUpsert(applicationRequestTypeDocumentID, divisionTypeID, provinceID, applicationRequestTypeID, documentTypeID, workflowTemplateID, isAvailableForUpload, isMandatory, userID);
        }
        #endregion

        #region CancelApplicationRequestTypeDocument
        public void CancelApplicationRequestTypeDocument(int applicationRequestTypeDocumentID, long userID)
        {
            Context.Pr_ApplicationRequestTypeDocumentCancel(applicationRequestTypeDocumentID, userID);
        }
        #endregion

        #region CreateApplicationRequestTypeDivisionSetup
        public  void CreateApplicationRequestTypeDivisionSetup(ApplicationRequestTypeDivisionSetup applicationRequestTypeDivisionSetup, long userID)
        {
             Context.Pr_ApplicationRequestTypeDivisionSetupCreate(applicationRequestTypeDivisionSetup.ApplicationRequestTypeID, applicationRequestTypeDivisionSetup.DivisionTypeID, applicationRequestTypeDivisionSetup.ProvinceID, userID);
        }
        #endregion


        #region UpdateApplicationRequestTypeDivisionSetup
        public void UpdateApplicationRequestTypeDivisionSetup(ApplicationRequestTypeDivisionSetup applicationRequestTypeDivisionSetup, long userID)
        {
            Context.Pr_ApplicationRequestTypeDivisionSetupUpdate(applicationRequestTypeDivisionSetup.ApplicationRequestTypeID, applicationRequestTypeDivisionSetup.DivisionTypeID, applicationRequestTypeDivisionSetup.ProvinceID, applicationRequestTypeDivisionSetup.IsAssessorApprovalRequiredRule, applicationRequestTypeDivisionSetup.IsSeniorManagerApprovalRequiredRule, applicationRequestTypeDivisionSetup.IsFinalisationTasksRequiredRule, applicationRequestTypeDivisionSetup.IsInspectionRequiredRule, applicationRequestTypeDivisionSetup.IsReferralRequiredRule, applicationRequestTypeDivisionSetup.IsAdjudicationRequiredRule, applicationRequestTypeDivisionSetup.AdjudicationTypeRule, applicationRequestTypeDivisionSetup.IsGazettingRequiredRule, applicationRequestTypeDivisionSetup.GazetteTypeRule, userID);
        }
        #endregion

        #region CloneApplicationRequestTypeDivisionSetup
        public ApplicationRequestTypeDivisionSetup CloneApplicationRequestTypeDivisionSetup(short oldApplicationRequestTypeID, short oldDivisionTypeID, short oldProvinceID, short newApplicationRequestTypeID, short newDivisionTypeID, short newProvinceID, long userID)
        {
            return Context.Pr_ApplicationRequestTypeDivisionSetupClone(oldApplicationRequestTypeID, oldDivisionTypeID, oldProvinceID, newApplicationRequestTypeID, newDivisionTypeID, newProvinceID, userID).FirstOrDefault();
        }
        #endregion

        #region SaveDivisionTypeAnnexureMapping
        public void SaveDivisionTypeAnnexureMapping(long DivisionTypeAnnexureMappingID, short DivisionTypeID, short ProvinceID, short ServiceTypeID, short? VehicleTypeID, long? AnnexureDocumentID, long userID)
        {
            Context.Pr_DivisionTypeAnnexureMappingUpsert(DivisionTypeAnnexureMappingID, DivisionTypeID, ProvinceID, ServiceTypeID, VehicleTypeID, AnnexureDocumentID, userID);
        }
        #endregion

        #region CancelDivisionTypeAnnexureMapping
        public void CancelDivisionTypeAnnexureMapping(long DivisionTypeAnnexureMappingID, short DivisionTypeID, short ProvinceID, short ServiceTypeID, long userID)
        {
            Context.Pr_DivisionTypeAnnexureMappingCancel(DivisionTypeAnnexureMappingID, DivisionTypeID, ProvinceID, ServiceTypeID, userID);
        }
        #endregion

        #region GetSetupAvailableOptions
        public List<Pr_GetSetupAvailableOptions_Result> GetSetupAvailableOptions(short entityID, long userID)
        {
            return Context.Pr_GetSetupAvailableOptions(entityID, userID).ToList();
        }
        #endregion

       

    }
}