//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated from a template.
//
//     Manual changes to this file may cause unexpected behavior in your application.
//     Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace Neo.LegitimateLicences.Data.Models
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class LegitimateEntities : DbContext
    {
        public LegitimateEntities()
            : base("name=LegitimateEntities")
        {
            this.Configuration.LazyLoadingEnabled = false;
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<GazetteDetail> GazetteDetails { get; set; }
        public virtual DbSet<SourceApplication> SourceApplications { get; set; }
        public virtual DbSet<Vw_ReceiptDetails> Vw_ReceiptDetails { get; set; }
        public virtual DbSet<ReceiptDetail> ReceiptDetails { get; set; }
        public virtual DbSet<DocumentTypes> DocumentTypes { get; set; }
        public virtual DbSet<AssociationModes> AssociationModes { get; set; }
        public virtual DbSet<AssociationTypes> AssociationTypes { get; set; }
        public virtual DbSet<AssociationStatus> AssociationStatus { get; set; }
        public virtual DbSet<VerifiedMember> VerifiedMembers { get; set; }
        public virtual DbSet<VerifiedMemberStatus> VerifiedMemberStatus { get; set; }
        public virtual DbSet<AdjudicationDetail> AdjudicationDetails { get; set; }
        public virtual DbSet<Province> Provinces { get; set; }
        public virtual DbSet<Region> Regions { get; set; }
        public virtual DbSet<Associations> Associations { get; set; }
        public virtual DbSet<Route> Routes { get; set; }
        public virtual DbSet<RouteStatus> RouteStatus1 { get; set; }
        public virtual DbSet<PaymentType> PaymentTypes { get; set; }
        public virtual DbSet<Place> Places { get; set; }
        public virtual DbSet<AdjudicationDetailStatus> AdjudicationDetailStatuses { get; set; }
        public virtual DbSet<Licence> Licences { get; set; }
        public virtual DbSet<LicenceStatus> LicenceStatuses { get; set; }
        public virtual DbSet<Vehicle> Vehicles { get; set; }
        public virtual DbSet<AdjudicationDecision> AdjudicationDecisions { get; set; }
        public virtual DbSet<GazetteDetailStatu> GazetteDetailStatus { get; set; }
        public virtual DbSet<AdjudicationPanel> AdjudicationPanels { get; set; }
        public virtual DbSet<Vw_AdjudicationPanel> Vw_AdjudicationPanel { get; set; }
        public virtual DbSet<ContractType> ContractTypes { get; set; }
        public virtual DbSet<IDType> IDTypes { get; set; }
        public virtual DbSet<PlaceType> PlaceTypes { get; set; }
        public virtual DbSet<RouteType> RouteTypes { get; set; }
        public virtual DbSet<ServiceType> ServiceTypes { get; set; }
        public virtual DbSet<VehicleMake> VehicleMakes { get; set; }
        public virtual DbSet<VehicleType> VehicleTypes { get; set; }
        public virtual DbSet<WaypointType> WaypointTypes { get; set; }
        public virtual DbSet<Vw_OperatingLicenceDetails> Vw_OperatingLicenceDetails { get; set; }
        public virtual DbSet<LicenceIssueDetail> LicenceIssueDetails { get; set; }
        public virtual DbSet<LicenceIssueInspectionDetail> LicenceIssueInspectionDetails { get; set; }
        public virtual DbSet<LicenceIssueInspectionOutcome> LicenceIssueInspectionOutcomes { get; set; }
        public virtual DbSet<Vw_LicenceIssueDetails> Vw_LicenceIssueDetails { get; set; }
        public virtual DbSet<AdjudicationType> AdjudicationTypes { get; set; }
        public virtual DbSet<Vw_Vehicles> Vw_Vehicles { get; set; }
        public virtual DbSet<Vw_Places> Vw_Places { get; set; }
        public virtual DbSet<Setting> Settings { get; set; }
        public virtual DbSet<LicenceServiceDetail> LicenceServiceDetails { get; set; }
        public virtual DbSet<Vw_NewRouteRequestDetails> Vw_NewRouteRequestDetails { get; set; }
        public virtual DbSet<CarryingCapacity> CarryingCapacities { get; set; }
        public virtual DbSet<LicenceException> LicenceExceptions { get; set; }
        public virtual DbSet<LicenceIssueDocument> LicenceIssueDocuments { get; set; }
        public virtual DbSet<Vw_LicenceUpliftmentExtensionRequestDetails> Vw_LicenceUpliftmentExtensionRequestDetails { get; set; }
        public virtual DbSet<Vw_GazetteApplication> Vw_GazetteApplications { get; set; }
        public virtual DbSet<Vw_AdjudicationDetails> Vw_AdjudicationDetails { get; set; }
        public virtual DbSet<Vw_ApplicationDetails> Vw_ApplicationDetails { get; set; }
        public virtual DbSet<Vw_ApplicationDetails_Light> Vw_ApplicationDetails_Light { get; set; }
        public virtual DbSet<Vw_ApplicationDetails_Receipts> Vw_ApplicationDetails_Receipts { get; set; }
        public virtual DbSet<Accreditation> Accreditations { get; set; }
        public virtual DbSet<AccreditationStatu> AccreditationStatus { get; set; }
        public virtual DbSet<GazetteType> GazetteTypes { get; set; }
        public virtual DbSet<DocumentTypeQuestion> DocumentTypeQuestions { get; set; }
        public virtual DbSet<ApplicationRequestType> ApplicationRequestTypes { get; set; }
        public virtual DbSet<ApplicationRequestTypeDocumentSetup> ApplicationRequestTypeDocumentSetups { get; set; }
        public virtual DbSet<ApplicationRequestTypeDivisionSetup> ApplicationRequestTypeDivisionSetups { get; set; }
        public virtual DbSet<LicenceRoute> LicenceRoutes { get; set; }
        public virtual DbSet<Vw_AdjudicationApplicationDetails> Vw_AdjudicationApplicationDetails { get; set; }
        public virtual DbSet<Stationery> Stationeries { get; set; }
        public virtual DbSet<Vw_Associations> Vw_Associations { get; set; }
        public virtual DbSet<Vw_OfficeLocation> Vw_OfficeLocations { get; set; }
        public virtual DbSet<LicenceDuration> LicenceDurations { get; set; }
        public virtual DbSet<OfficeLocationSetup> OfficeLocationSetups { get; set; }
        public virtual DbSet<OfficeLocationSetupDocumentTemplate> OfficeLocationSetupDocumentTemplates { get; set; }
        public virtual DbSet<LicencingBoard> LicencingBoards { get; set; }
        public virtual DbSet<DivisionType> DivisionTypes { get; set; }
        public virtual DbSet<Vw_VehicleModels> Vw_VehicleModels { get; set; }
        public virtual DbSet<VehicleModel> VehicleModels { get; set; }
        public virtual DbSet<ApplicationAllowedNewLicence> ApplicationAllowedNewLicences { get; set; }
        public virtual DbSet<StationeryBatch> StationeryBatches { get; set; }
        public virtual DbSet<Vw_LicenceCancelDetails> Vw_LicenceCancelDetails { get; set; }
        public virtual DbSet<Vw_Settings> Vw_Settings { get; set; }
        public virtual DbSet<Vw_ApplicationDetails_InProgress> Vw_ApplicationDetails_InProgress { get; set; }
        public virtual DbSet<Vw_VehicleMakes> Vw_VehicleMakes { get; set; }
        public virtual DbSet<Vw_LicencingBoards> Vw_LicencingBoards { get; set; }
        public virtual DbSet<Inspector> Inspectors { get; set; }
        public virtual DbSet<DivisionTypeAnnexureMapping> DivisionTypeAnnexureMappings { get; set; }
        public virtual DbSet<Vw_DivisionTypeAnnexureMappings> Vw_DivisionTypeAnnexureMappings { get; set; }
        public virtual DbSet<Vw_ApplicationRequestTypeDivisionSetup> Vw_ApplicationRequestTypeDivisionSetup { get; set; }
        public virtual DbSet<Vw_ApplicationRequestTypeDocumentSetup> Vw_ApplicationRequestTypeDocumentSetup { get; set; }
        public virtual DbSet<Vw_OfficeLocationSetup> Vw_OfficeLocationSetup { get; set; }
        public virtual DbSet<ServiceVehicleType> ServiceVehicleTypes { get; set; }
    
        public virtual ObjectResult<Pr_ApplicationDetailsAwaitingReceipts_Result> Pr_ApplicationDetailsAwaitingReceipts(Nullable<long> userID, string paymentTypeIDs)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var paymentTypeIDsParameter = paymentTypeIDs != null ?
                new ObjectParameter("PaymentTypeIDs", paymentTypeIDs) :
                new ObjectParameter("PaymentTypeIDs", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationDetailsAwaitingReceipts_Result>("Pr_ApplicationDetailsAwaitingReceipts", userIDParameter, paymentTypeIDsParameter);
        }
    
        public virtual ObjectResult<Vw_ReceiptDetails> Pr_ApplicationDetailsRecentReceipts()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ReceiptDetails>("Pr_ApplicationDetailsRecentReceipts");
        }
    
        public virtual ObjectResult<Vw_ReceiptDetails> Pr_ApplicationDetailsRecentReceipts(MergeOption mergeOption)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ReceiptDetails>("Pr_ApplicationDetailsRecentReceipts", mergeOption);
        }
    
        public virtual int Pr_ApplicationDetailsAwaitingGazettes(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationDetailsAwaitingGazettes", userIDParameter);
        }
    
        public virtual int Pr_GazetteDetailStatusUpdate(Nullable<long> userID, string comments, Nullable<long> gazetteDetailID, Nullable<short> gazetteDetailStatusID, Nullable<bool> isTransactionRequired)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var gazetteDetailIDParameter = gazetteDetailID.HasValue ?
                new ObjectParameter("GazetteDetailID", gazetteDetailID) :
                new ObjectParameter("GazetteDetailID", typeof(long));
    
            var gazetteDetailStatusIDParameter = gazetteDetailStatusID.HasValue ?
                new ObjectParameter("GazetteDetailStatusID", gazetteDetailStatusID) :
                new ObjectParameter("GazetteDetailStatusID", typeof(short));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_GazetteDetailStatusUpdate", userIDParameter, commentsParameter, gazetteDetailIDParameter, gazetteDetailStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual int Pr_ApplicationDetailsAwaitingAdjudication(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationDetailsAwaitingAdjudication", userIDParameter);
        }
    
        public virtual int Pr_ApplicationVerificationComplete(Nullable<long> applicationRequestDetailID, Nullable<long> workflowInstanceTaskID, string comments, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var workflowInstanceTaskIDParameter = workflowInstanceTaskID.HasValue ?
                new ObjectParameter("WorkflowInstanceTaskID", workflowInstanceTaskID) :
                new ObjectParameter("WorkflowInstanceTaskID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationVerificationComplete", applicationRequestDetailIDParameter, workflowInstanceTaskIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PrecheckDetailsUpsert(Nullable<long> precheckDetailID, Nullable<short> applicationRequestTypeID, Nullable<short> sourceApplicationID, string applicantName, string olPermitNumber, string iDNumber, string chassisNumber, string vehicleRegistrationNumber, Nullable<long> associationID, Nullable<bool> checkData, Nullable<short> precheckDetailIncompleteReasonID, string contactEmail, string contactCell, Nullable<long> numberOfVehiclesRequired, Nullable<long> userID, Nullable<short> modeID, Nullable<bool> calledFromSave)
        {
            var precheckDetailIDParameter = precheckDetailID.HasValue ?
                new ObjectParameter("PrecheckDetailID", precheckDetailID) :
                new ObjectParameter("PrecheckDetailID", typeof(long));
    
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(short));
    
            var sourceApplicationIDParameter = sourceApplicationID.HasValue ?
                new ObjectParameter("SourceApplicationID", sourceApplicationID) :
                new ObjectParameter("SourceApplicationID", typeof(short));
    
            var applicantNameParameter = applicantName != null ?
                new ObjectParameter("ApplicantName", applicantName) :
                new ObjectParameter("ApplicantName", typeof(string));
    
            var olPermitNumberParameter = olPermitNumber != null ?
                new ObjectParameter("OlPermitNumber", olPermitNumber) :
                new ObjectParameter("OlPermitNumber", typeof(string));
    
            var iDNumberParameter = iDNumber != null ?
                new ObjectParameter("IDNumber", iDNumber) :
                new ObjectParameter("IDNumber", typeof(string));
    
            var chassisNumberParameter = chassisNumber != null ?
                new ObjectParameter("ChassisNumber", chassisNumber) :
                new ObjectParameter("ChassisNumber", typeof(string));
    
            var vehicleRegistrationNumberParameter = vehicleRegistrationNumber != null ?
                new ObjectParameter("VehicleRegistrationNumber", vehicleRegistrationNumber) :
                new ObjectParameter("VehicleRegistrationNumber", typeof(string));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var checkDataParameter = checkData.HasValue ?
                new ObjectParameter("CheckData", checkData) :
                new ObjectParameter("CheckData", typeof(bool));
    
            var precheckDetailIncompleteReasonIDParameter = precheckDetailIncompleteReasonID.HasValue ?
                new ObjectParameter("PrecheckDetailIncompleteReasonID", precheckDetailIncompleteReasonID) :
                new ObjectParameter("PrecheckDetailIncompleteReasonID", typeof(short));
    
            var contactEmailParameter = contactEmail != null ?
                new ObjectParameter("ContactEmail", contactEmail) :
                new ObjectParameter("ContactEmail", typeof(string));
    
            var contactCellParameter = contactCell != null ?
                new ObjectParameter("ContactCell", contactCell) :
                new ObjectParameter("ContactCell", typeof(string));
    
            var numberOfVehiclesRequiredParameter = numberOfVehiclesRequired.HasValue ?
                new ObjectParameter("NumberOfVehiclesRequired", numberOfVehiclesRequired) :
                new ObjectParameter("NumberOfVehiclesRequired", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var modeIDParameter = modeID.HasValue ?
                new ObjectParameter("ModeID", modeID) :
                new ObjectParameter("ModeID", typeof(short));
    
            var calledFromSaveParameter = calledFromSave.HasValue ?
                new ObjectParameter("CalledFromSave", calledFromSave) :
                new ObjectParameter("CalledFromSave", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_PrecheckDetailsUpsert", precheckDetailIDParameter, applicationRequestTypeIDParameter, sourceApplicationIDParameter, applicantNameParameter, olPermitNumberParameter, iDNumberParameter, chassisNumberParameter, vehicleRegistrationNumberParameter, associationIDParameter, checkDataParameter, precheckDetailIncompleteReasonIDParameter, contactEmailParameter, contactCellParameter, numberOfVehiclesRequiredParameter, userIDParameter, modeIDParameter, calledFromSaveParameter);
        }
    
        public virtual int Pr_AdjudicationDetailStatusUpdate(Nullable<long> userID, string comments, Nullable<long> adjudicationDetailID, Nullable<short> adjudicationDetailStatusID, Nullable<bool> isTransactionRequired)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var adjudicationDetailStatusIDParameter = adjudicationDetailStatusID.HasValue ?
                new ObjectParameter("AdjudicationDetailStatusID", adjudicationDetailStatusID) :
                new ObjectParameter("AdjudicationDetailStatusID", typeof(short));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationDetailStatusUpdate", userIDParameter, commentsParameter, adjudicationDetailIDParameter, adjudicationDetailStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual int Pr_ApplicationAdjudicationDecisionApproval(Nullable<long> applicationRequestDetailID, Nullable<long> adjudicationDetailID, Nullable<bool> isApproved, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var isApprovedParameter = isApproved.HasValue ?
                new ObjectParameter("IsApproved", isApproved) :
                new ObjectParameter("IsApproved", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAdjudicationDecisionApproval", applicationRequestDetailIDParameter, adjudicationDetailIDParameter, isApprovedParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AdjudicationPanelMembersGet_Result> Pr_AdjudicationPanelMembersGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AdjudicationPanelMembersGet_Result>("Pr_AdjudicationPanelMembersGet", userIDParameter);
        }
    
        public virtual int Pr_AdjudicationPanelUpdate(Nullable<long> adjudicationDetailID, Nullable<long> panelMemberUserID)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var panelMemberUserIDParameter = panelMemberUserID.HasValue ?
                new ObjectParameter("PanelMemberUserID", panelMemberUserID) :
                new ObjectParameter("PanelMemberUserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationPanelUpdate", adjudicationDetailIDParameter, panelMemberUserIDParameter);
        }
    
        public virtual int Pr_LicenceIssueInspectionComplete(Nullable<long> licenceIssueDetailID, Nullable<short> licenceIssueInspectionOutcomeID, Nullable<long> inspectedByID, Nullable<System.DateTime> dateInspected, string engineNumber, string chassisNumber, Nullable<long> inspectionSheetDocumentID, Nullable<long> frontRegDocumentID, Nullable<long> chassisDocumentID, Nullable<long> engineDocumentID, Nullable<long> backRegDocumentID, Nullable<long> additional1DocumentID, Nullable<long> additional2DocumentID, Nullable<long> userID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", typeof(long));
    
            var licenceIssueInspectionOutcomeIDParameter = licenceIssueInspectionOutcomeID.HasValue ?
                new ObjectParameter("LicenceIssueInspectionOutcomeID", licenceIssueInspectionOutcomeID) :
                new ObjectParameter("LicenceIssueInspectionOutcomeID", typeof(short));
    
            var inspectedByIDParameter = inspectedByID.HasValue ?
                new ObjectParameter("InspectedByID", inspectedByID) :
                new ObjectParameter("InspectedByID", typeof(long));
    
            var dateInspectedParameter = dateInspected.HasValue ?
                new ObjectParameter("DateInspected", dateInspected) :
                new ObjectParameter("DateInspected", typeof(System.DateTime));
    
            var engineNumberParameter = engineNumber != null ?
                new ObjectParameter("EngineNumber", engineNumber) :
                new ObjectParameter("EngineNumber", typeof(string));
    
            var chassisNumberParameter = chassisNumber != null ?
                new ObjectParameter("ChassisNumber", chassisNumber) :
                new ObjectParameter("ChassisNumber", typeof(string));
    
            var inspectionSheetDocumentIDParameter = inspectionSheetDocumentID.HasValue ?
                new ObjectParameter("InspectionSheetDocumentID", inspectionSheetDocumentID) :
                new ObjectParameter("InspectionSheetDocumentID", typeof(long));
    
            var frontRegDocumentIDParameter = frontRegDocumentID.HasValue ?
                new ObjectParameter("FrontRegDocumentID", frontRegDocumentID) :
                new ObjectParameter("FrontRegDocumentID", typeof(long));
    
            var chassisDocumentIDParameter = chassisDocumentID.HasValue ?
                new ObjectParameter("ChassisDocumentID", chassisDocumentID) :
                new ObjectParameter("ChassisDocumentID", typeof(long));
    
            var engineDocumentIDParameter = engineDocumentID.HasValue ?
                new ObjectParameter("EngineDocumentID", engineDocumentID) :
                new ObjectParameter("EngineDocumentID", typeof(long));
    
            var backRegDocumentIDParameter = backRegDocumentID.HasValue ?
                new ObjectParameter("BackRegDocumentID", backRegDocumentID) :
                new ObjectParameter("BackRegDocumentID", typeof(long));
    
            var additional1DocumentIDParameter = additional1DocumentID.HasValue ?
                new ObjectParameter("Additional1DocumentID", additional1DocumentID) :
                new ObjectParameter("Additional1DocumentID", typeof(long));
    
            var additional2DocumentIDParameter = additional2DocumentID.HasValue ?
                new ObjectParameter("Additional2DocumentID", additional2DocumentID) :
                new ObjectParameter("Additional2DocumentID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceIssueInspectionComplete", licenceIssueDetailIDParameter, licenceIssueInspectionOutcomeIDParameter, inspectedByIDParameter, dateInspectedParameter, engineNumberParameter, chassisNumberParameter, inspectionSheetDocumentIDParameter, frontRegDocumentIDParameter, chassisDocumentIDParameter, engineDocumentIDParameter, backRegDocumentIDParameter, additional1DocumentIDParameter, additional2DocumentIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceIssuingComplete(Nullable<long> licenceIssueDetailID, Nullable<long> userID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceIssuingComplete", licenceIssueDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_ReceiptBatchGenerate(Nullable<long> receiptUserID, Nullable<long> userID)
        {
            var receiptUserIDParameter = receiptUserID.HasValue ?
                new ObjectParameter("ReceiptUserID", receiptUserID) :
                new ObjectParameter("ReceiptUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ReceiptBatchGenerate", receiptUserIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceStatusSummary_Result> Pr_LicenceStatusSummary(Nullable<long> searchRegionID, Nullable<long> associationID, Nullable<long> userID)
        {
            var searchRegionIDParameter = searchRegionID.HasValue ?
                new ObjectParameter("SearchRegionID", searchRegionID) :
                new ObjectParameter("SearchRegionID", typeof(long));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceStatusSummary_Result>("Pr_LicenceStatusSummary", searchRegionIDParameter, associationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_PrecheckVerificationComplete(Nullable<long> precheckDetailID, string comments, Nullable<long> userID)
        {
            var precheckDetailIDParameter = precheckDetailID.HasValue ?
                new ObjectParameter("PrecheckDetailID", precheckDetailID) :
                new ObjectParameter("PrecheckDetailID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_PrecheckVerificationComplete", precheckDetailIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceUpcomingExpiryCorrespondance(string licenceIdCsv, Nullable<long> userID)
        {
            var licenceIdCsvParameter = licenceIdCsv != null ?
                new ObjectParameter("LicenceIdCsv", licenceIdCsv) :
                new ObjectParameter("LicenceIdCsv", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceUpcomingExpiryCorrespondance", licenceIdCsvParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceExpiredCorrespondance(string licenceIdCsv, Nullable<long> userID)
        {
            var licenceIdCsvParameter = licenceIdCsv != null ?
                new ObjectParameter("LicenceIdCsv", licenceIdCsv) :
                new ObjectParameter("LicenceIdCsv", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceExpiredCorrespondance", licenceIdCsvParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesExpiredInGracePeriodGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesExpiredInGracePeriodGet", userIDParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesExpiredInGracePeriodGet(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesExpiredInGracePeriodGet", mergeOption, userIDParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesUpcomingExpiresGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesUpcomingExpiresGet", userIDParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesUpcomingExpiresGet(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesUpcomingExpiresGet", mergeOption, userIDParameter);
        }
    
        public virtual int Pr_PurificationDetailStatusUpdate(Nullable<long> updatedByID, string comments, Nullable<long> purificationDetailID, Nullable<short> purificationDetailStatusID, Nullable<bool> isTransactionRequired)
        {
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var purificationDetailIDParameter = purificationDetailID.HasValue ?
                new ObjectParameter("PurificationDetailID", purificationDetailID) :
                new ObjectParameter("PurificationDetailID", typeof(long));
    
            var purificationDetailStatusIDParameter = purificationDetailStatusID.HasValue ?
                new ObjectParameter("PurificationDetailStatusID", purificationDetailStatusID) :
                new ObjectParameter("PurificationDetailStatusID", typeof(short));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationDetailStatusUpdate", updatedByIDParameter, commentsParameter, purificationDetailIDParameter, purificationDetailStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual int Pr_PurificationExceptionsPending(Nullable<long> associationID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationExceptionsPending", associationIDParameter);
        }
    
        public virtual int Pr_PurificationPrechecksPending(Nullable<long> associationID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationPrechecksPending", associationIDParameter);
        }
    
        public virtual int Pr_PurificationWorkflowsInProgress(Nullable<long> associationID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationWorkflowsInProgress", associationIDParameter);
        }
    
        public virtual int Pr_PurificationDetailRetry(Nullable<long> purificationDetailID)
        {
            var purificationDetailIDParameter = purificationDetailID.HasValue ?
                new ObjectParameter("PurificationDetailID", purificationDetailID) :
                new ObjectParameter("PurificationDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationDetailRetry", purificationDetailIDParameter);
        }
    
        public virtual ObjectResult<Pr_MemberSearch_Result> Pr_MemberSearch(string memberName, string memberID, string memberEmail, Nullable<long> associationID, Nullable<long> userID)
        {
            var memberNameParameter = memberName != null ?
                new ObjectParameter("MemberName", memberName) :
                new ObjectParameter("MemberName", typeof(string));
    
            var memberIDParameter = memberID != null ?
                new ObjectParameter("MemberID", memberID) :
                new ObjectParameter("MemberID", typeof(string));
    
            var memberEmailParameter = memberEmail != null ?
                new ObjectParameter("MemberEmail", memberEmail) :
                new ObjectParameter("MemberEmail", typeof(string));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_MemberSearch_Result>("Pr_MemberSearch", memberNameParameter, memberIDParameter, memberEmailParameter, associationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AssociationSearch_Result> Pr_AssociationSearch(Nullable<long> searchRegionID, string associationName, Nullable<long> userID)
        {
            var searchRegionIDParameter = searchRegionID.HasValue ?
                new ObjectParameter("SearchRegionID", searchRegionID) :
                new ObjectParameter("SearchRegionID", typeof(long));
    
            var associationNameParameter = associationName != null ?
                new ObjectParameter("AssociationName", associationName) :
                new ObjectParameter("AssociationName", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AssociationSearch_Result>("Pr_AssociationSearch", searchRegionIDParameter, associationNameParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceSearch_Result> Pr_LicenceSearch(string operatingLicenceNumber, Nullable<long> memberID, Nullable<long> licenceStatusID, string registrationNumber, Nullable<long> associationID, Nullable<System.DateTime> dateOfIssueStartDate, Nullable<System.DateTime> dateOfIssueEndDate, Nullable<System.DateTime> dateOfExpiryStartDate, Nullable<System.DateTime> dateOfExpiryEndDate, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var memberIDParameter = memberID.HasValue ?
                new ObjectParameter("MemberID", memberID) :
                new ObjectParameter("MemberID", typeof(long));
    
            var licenceStatusIDParameter = licenceStatusID.HasValue ?
                new ObjectParameter("LicenceStatusID", licenceStatusID) :
                new ObjectParameter("LicenceStatusID", typeof(long));
    
            var registrationNumberParameter = registrationNumber != null ?
                new ObjectParameter("RegistrationNumber", registrationNumber) :
                new ObjectParameter("RegistrationNumber", typeof(string));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var dateOfIssueStartDateParameter = dateOfIssueStartDate.HasValue ?
                new ObjectParameter("DateOfIssueStartDate", dateOfIssueStartDate) :
                new ObjectParameter("DateOfIssueStartDate", typeof(System.DateTime));
    
            var dateOfIssueEndDateParameter = dateOfIssueEndDate.HasValue ?
                new ObjectParameter("DateOfIssueEndDate", dateOfIssueEndDate) :
                new ObjectParameter("DateOfIssueEndDate", typeof(System.DateTime));
    
            var dateOfExpiryStartDateParameter = dateOfExpiryStartDate.HasValue ?
                new ObjectParameter("DateOfExpiryStartDate", dateOfExpiryStartDate) :
                new ObjectParameter("DateOfExpiryStartDate", typeof(System.DateTime));
    
            var dateOfExpiryEndDateParameter = dateOfExpiryEndDate.HasValue ?
                new ObjectParameter("DateOfExpiryEndDate", dateOfExpiryEndDate) :
                new ObjectParameter("DateOfExpiryEndDate", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceSearch_Result>("Pr_LicenceSearch", operatingLicenceNumberParameter, memberIDParameter, licenceStatusIDParameter, registrationNumberParameter, associationIDParameter, dateOfIssueStartDateParameter, dateOfIssueEndDateParameter, dateOfExpiryStartDateParameter, dateOfExpiryEndDateParameter, userIDParameter);
        }
    
        public virtual int Pr_WriteEntry(Nullable<int> userID, string source, string action, string description, Nullable<bool> isCritical, Nullable<bool> isException, string entity, Nullable<long> itemID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(int));
    
            var sourceParameter = source != null ?
                new ObjectParameter("Source", source) :
                new ObjectParameter("Source", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var isCriticalParameter = isCritical.HasValue ?
                new ObjectParameter("IsCritical", isCritical) :
                new ObjectParameter("IsCritical", typeof(bool));
    
            var isExceptionParameter = isException.HasValue ?
                new ObjectParameter("IsException", isException) :
                new ObjectParameter("IsException", typeof(bool));
    
            var entityParameter = entity != null ?
                new ObjectParameter("Entity", entity) :
                new ObjectParameter("Entity", typeof(string));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_WriteEntry", userIDParameter, sourceParameter, actionParameter, descriptionParameter, isCriticalParameter, isExceptionParameter, entityParameter, itemIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_GazetteGetNumber(Nullable<short> gazetteTypeID, Nullable<short> divisionTypeID, Nullable<short> provinceID)
        {
            var gazetteTypeIDParameter = gazetteTypeID.HasValue ?
                new ObjectParameter("GazetteTypeID", gazetteTypeID) :
                new ObjectParameter("GazetteTypeID", typeof(short));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GazetteGetNumber", gazetteTypeIDParameter, divisionTypeIDParameter, provinceIDParameter);
        }
    
        public virtual int Pr_RouteStartVerificationWorkflow(Nullable<long> routeID, Nullable<long> applicationDetailID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteStartVerificationWorkflow", routeIDParameter, applicationDetailIDParameter);
        }
    
        public virtual ObjectResult<Pr_RouteSearch_Result> Pr_RouteSearch(Nullable<long> originPlaceID, Nullable<long> destinationPlaceID, string nationalRouteNumber, string boardRouteNumber, Nullable<long> associationID, string description, Nullable<long> routeStatusID, Nullable<bool> routesInVerification, Nullable<long> applicationDetailID, Nullable<long> applicationRequestTypeID)
        {
            var originPlaceIDParameter = originPlaceID.HasValue ?
                new ObjectParameter("OriginPlaceID", originPlaceID) :
                new ObjectParameter("OriginPlaceID", typeof(long));
    
            var destinationPlaceIDParameter = destinationPlaceID.HasValue ?
                new ObjectParameter("DestinationPlaceID", destinationPlaceID) :
                new ObjectParameter("DestinationPlaceID", typeof(long));
    
            var nationalRouteNumberParameter = nationalRouteNumber != null ?
                new ObjectParameter("NationalRouteNumber", nationalRouteNumber) :
                new ObjectParameter("NationalRouteNumber", typeof(string));
    
            var boardRouteNumberParameter = boardRouteNumber != null ?
                new ObjectParameter("BoardRouteNumber", boardRouteNumber) :
                new ObjectParameter("BoardRouteNumber", typeof(string));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var routeStatusIDParameter = routeStatusID.HasValue ?
                new ObjectParameter("RouteStatusID", routeStatusID) :
                new ObjectParameter("RouteStatusID", typeof(long));
    
            var routesInVerificationParameter = routesInVerification.HasValue ?
                new ObjectParameter("RoutesInVerification", routesInVerification) :
                new ObjectParameter("RoutesInVerification", typeof(bool));
    
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_RouteSearch_Result>("Pr_RouteSearch", originPlaceIDParameter, destinationPlaceIDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, associationIDParameter, descriptionParameter, routeStatusIDParameter, routesInVerificationParameter, applicationDetailIDParameter, applicationRequestTypeIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceRoutesGet_Result> Pr_LicenceRoutesGet(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceRoutesGet_Result>("Pr_LicenceRoutesGet", licenceIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AssociationOlasNeoUpdate(Nullable<long> updatedByID, Nullable<long> associationID, Nullable<long> olasID, Nullable<long> neoID, Nullable<bool> isTransactionRequired)
        {
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var olasIDParameter = olasID.HasValue ?
                new ObjectParameter("OlasID", olasID) :
                new ObjectParameter("OlasID", typeof(long));
    
            var neoIDParameter = neoID.HasValue ?
                new ObjectParameter("NeoID", neoID) :
                new ObjectParameter("NeoID", typeof(long));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AssociationOlasNeoUpdate", updatedByIDParameter, associationIDParameter, olasIDParameter, neoIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual ObjectResult<Pr_AssociationNeoMemberSearch_Result> Pr_AssociationNeoMemberSearch(Nullable<long> neoAssociationID, Nullable<long> associationMemberDataID)
        {
            var neoAssociationIDParameter = neoAssociationID.HasValue ?
                new ObjectParameter("NeoAssociationID", neoAssociationID) :
                new ObjectParameter("NeoAssociationID", typeof(long));
    
            var associationMemberDataIDParameter = associationMemberDataID.HasValue ?
                new ObjectParameter("AssociationMemberDataID", associationMemberDataID) :
                new ObjectParameter("AssociationMemberDataID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AssociationNeoMemberSearch_Result>("Pr_AssociationNeoMemberSearch", neoAssociationIDParameter, associationMemberDataIDParameter);
        }
    
        public virtual int Pr_RouteStartUpdateWorkflow(Nullable<long> routeID, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteStartUpdateWorkflow", routeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_RouteNodeAdd(Nullable<long> routeID, Nullable<long> placeID, Nullable<short> waypointTypeID, Nullable<double> distanceFromOrigin, Nullable<int> sequence, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var placeIDParameter = placeID.HasValue ?
                new ObjectParameter("PlaceID", placeID) :
                new ObjectParameter("PlaceID", typeof(long));
    
            var waypointTypeIDParameter = waypointTypeID.HasValue ?
                new ObjectParameter("WaypointTypeID", waypointTypeID) :
                new ObjectParameter("WaypointTypeID", typeof(short));
    
            var distanceFromOriginParameter = distanceFromOrigin.HasValue ?
                new ObjectParameter("DistanceFromOrigin", distanceFromOrigin) :
                new ObjectParameter("DistanceFromOrigin", typeof(double));
    
            var sequenceParameter = sequence.HasValue ?
                new ObjectParameter("Sequence", sequence) :
                new ObjectParameter("Sequence", typeof(int));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteNodeAdd", routeIDParameter, placeIDParameter, waypointTypeIDParameter, distanceFromOriginParameter, sequenceParameter, userIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_GazetteApplicationBypassExpiry(Nullable<long> applicationDetailID, string comment, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var commentParameter = comment != null ?
                new ObjectParameter("Comment", comment) :
                new ObjectParameter("Comment", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GazetteApplicationBypassExpiry", applicationDetailIDParameter, commentParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationAdjudicationRestart(Nullable<long> applicationAdjudicationID, Nullable<long> userID)
        {
            var applicationAdjudicationIDParameter = applicationAdjudicationID.HasValue ?
                new ObjectParameter("ApplicationAdjudicationID", applicationAdjudicationID) :
                new ObjectParameter("ApplicationAdjudicationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAdjudicationRestart", applicationAdjudicationIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationPanelRemove(Nullable<long> adjudicationDetailID, Nullable<long> adjudicationPanelID, Nullable<long> userID)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var adjudicationPanelIDParameter = adjudicationPanelID.HasValue ?
                new ObjectParameter("AdjudicationPanelID", adjudicationPanelID) :
                new ObjectParameter("AdjudicationPanelID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationPanelRemove", adjudicationDetailIDParameter, adjudicationPanelIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<ReceiptDetail> Pr_ReceiptsGetUnassigned(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ReceiptDetail>("Pr_ReceiptsGetUnassigned", userIDParameter);
        }
    
        public virtual ObjectResult<ReceiptDetail> Pr_ReceiptsGetUnassigned(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ReceiptDetail>("Pr_ReceiptsGetUnassigned", mergeOption, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_ReceiptCreateUnassignedReceipt(Nullable<long> applicationRequestTypeID, Nullable<long> paymentTypeID, string applicantName, string idNumber, string olPermitNumber, string vehicleRegistrationNumber, string chassisNumber, Nullable<long> userID)
        {
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(long));
    
            var paymentTypeIDParameter = paymentTypeID.HasValue ?
                new ObjectParameter("PaymentTypeID", paymentTypeID) :
                new ObjectParameter("PaymentTypeID", typeof(long));
    
            var applicantNameParameter = applicantName != null ?
                new ObjectParameter("ApplicantName", applicantName) :
                new ObjectParameter("ApplicantName", typeof(string));
    
            var idNumberParameter = idNumber != null ?
                new ObjectParameter("IdNumber", idNumber) :
                new ObjectParameter("IdNumber", typeof(string));
    
            var olPermitNumberParameter = olPermitNumber != null ?
                new ObjectParameter("OlPermitNumber", olPermitNumber) :
                new ObjectParameter("OlPermitNumber", typeof(string));
    
            var vehicleRegistrationNumberParameter = vehicleRegistrationNumber != null ?
                new ObjectParameter("VehicleRegistrationNumber", vehicleRegistrationNumber) :
                new ObjectParameter("VehicleRegistrationNumber", typeof(string));
    
            var chassisNumberParameter = chassisNumber != null ?
                new ObjectParameter("ChassisNumber", chassisNumber) :
                new ObjectParameter("ChassisNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ReceiptCreateUnassignedReceipt", applicationRequestTypeIDParameter, paymentTypeIDParameter, applicantNameParameter, idNumberParameter, olPermitNumberParameter, vehicleRegistrationNumberParameter, chassisNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_ReceiptAssignReceipt(Nullable<long> applicationDetailID, Nullable<long> receiptDetailID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var receiptDetailIDParameter = receiptDetailID.HasValue ?
                new ObjectParameter("ReceiptDetailID", receiptDetailID) :
                new ObjectParameter("ReceiptDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ReceiptAssignReceipt", applicationDetailIDParameter, receiptDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_GetAppsWithMissingOrginatingLicences_Result> Pr_Purification_GetAppsWithMissingOrginatingLicences(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_GetAppsWithMissingOrginatingLicences_Result>("Pr_Purification_GetAppsWithMissingOrginatingLicences", userIDParameter);
        }
    
        public virtual int Pr_Purification_UpdateAppsWithMissingOrginatingLicence(string applicationNumber, string orginatingLicenceNumber, Nullable<long> userID)
        {
            var applicationNumberParameter = applicationNumber != null ?
                new ObjectParameter("ApplicationNumber", applicationNumber) :
                new ObjectParameter("ApplicationNumber", typeof(string));
    
            var orginatingLicenceNumberParameter = orginatingLicenceNumber != null ?
                new ObjectParameter("OrginatingLicenceNumber", orginatingLicenceNumber) :
                new ObjectParameter("OrginatingLicenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Purification_UpdateAppsWithMissingOrginatingLicence", applicationNumberParameter, orginatingLicenceNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_Purification_UpdateBypassedExpiredLicence(string operatingLicenceNumber, Nullable<short> issueNumber, string reason, string applicationNumber, Nullable<long> sourceApplicationID, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var issueNumberParameter = issueNumber.HasValue ?
                new ObjectParameter("IssueNumber", issueNumber) :
                new ObjectParameter("IssueNumber", typeof(short));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var applicationNumberParameter = applicationNumber != null ?
                new ObjectParameter("ApplicationNumber", applicationNumber) :
                new ObjectParameter("ApplicationNumber", typeof(string));
    
            var sourceApplicationIDParameter = sourceApplicationID.HasValue ?
                new ObjectParameter("SourceApplicationID", sourceApplicationID) :
                new ObjectParameter("SourceApplicationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Purification_UpdateBypassedExpiredLicence", operatingLicenceNumberParameter, issueNumberParameter, reasonParameter, applicationNumberParameter, sourceApplicationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_LicencesLinkedToActiveOLASGet_Result> Pr_Purification_LicencesLinkedToActiveOLASGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_LicencesLinkedToActiveOLASGet_Result>("Pr_Purification_LicencesLinkedToActiveOLASGet", userIDParameter);
        }
    
        public virtual int Pr_LicenceSearchRelatedApplications(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceSearchRelatedApplications", licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_LicenceSearchRelatedIssues(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_LicenceSearchRelatedIssues", licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_LicenceSearchRelatedIssues(Nullable<long> licenceID, Nullable<long> userID, MergeOption mergeOption)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_LicenceSearchRelatedIssues", mergeOption, licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vehicle> Pr_VehicleSearch(string registrationNumber, string vinNumber, Nullable<long> userID)
        {
            var registrationNumberParameter = registrationNumber != null ?
                new ObjectParameter("RegistrationNumber", registrationNumber) :
                new ObjectParameter("RegistrationNumber", typeof(string));
    
            var vinNumberParameter = vinNumber != null ?
                new ObjectParameter("VinNumber", vinNumber) :
                new ObjectParameter("VinNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vehicle>("Pr_VehicleSearch", registrationNumberParameter, vinNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vehicle> Pr_VehicleSearch(string registrationNumber, string vinNumber, Nullable<long> userID, MergeOption mergeOption)
        {
            var registrationNumberParameter = registrationNumber != null ?
                new ObjectParameter("RegistrationNumber", registrationNumber) :
                new ObjectParameter("RegistrationNumber", typeof(string));
    
            var vinNumberParameter = vinNumber != null ?
                new ObjectParameter("VinNumber", vinNumber) :
                new ObjectParameter("VinNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vehicle>("Pr_VehicleSearch", mergeOption, registrationNumberParameter, vinNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_VehicleSearchLinkedLicences(Nullable<long> vehicleID, Nullable<long> userID)
        {
            var vehicleIDParameter = vehicleID.HasValue ?
                new ObjectParameter("VehicleID", vehicleID) :
                new ObjectParameter("VehicleID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_VehicleSearchLinkedLicences", vehicleIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_VehicleSearchLinkedLicences(Nullable<long> vehicleID, Nullable<long> userID, MergeOption mergeOption)
        {
            var vehicleIDParameter = vehicleID.HasValue ?
                new ObjectParameter("VehicleID", vehicleID) :
                new ObjectParameter("VehicleID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_VehicleSearchLinkedLicences", mergeOption, vehicleIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceIssueWorkflowGet_Result> Pr_LicenceIssueWorkflowGet(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueWorkflowGet_Result>("Pr_LicenceIssueWorkflowGet", licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceApplicationWorkflowGet_Result> Pr_LicenceApplicationWorkflowGet(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceApplicationWorkflowGet_Result>("Pr_LicenceApplicationWorkflowGet", licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceWorkflowDocumentsGet_Result> Pr_LicenceWorkflowDocumentsGet(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceWorkflowDocumentsGet_Result>("Pr_LicenceWorkflowDocumentsGet", licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceExceptionsCounts_Result> Pr_LicenceExceptionsCounts(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceExceptionsCounts_Result>("Pr_LicenceExceptionsCounts", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicencesWithExceptionGet_Result> Pr_LicencesWithExceptionGet(string exception, Nullable<long> userID)
        {
            var exceptionParameter = exception != null ?
                new ObjectParameter("Exception", exception) :
                new ObjectParameter("Exception", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicencesWithExceptionGet_Result>("Pr_LicencesWithExceptionGet", exceptionParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_VehicleUpsert(Nullable<long> vehicleID, string registrationNumber, string engineNumber, string vIN, Nullable<int> seatedCapacity, Nullable<int> standingCapacity, Nullable<long> grossMass, Nullable<short> vehicleMakeID, Nullable<short> vehicleModelID, Nullable<short> vehicleTypeID, Nullable<short> carryingCapacityID, string yearOfManufacture, Nullable<long> tare, Nullable<long> currentOdometerReading, Nullable<long> roadworthyCertificateDocID, Nullable<long> professionalDriversPermitDocID, Nullable<long> rankPermitDocID, Nullable<long> certificateOfRegistrationDocID, Nullable<long> olasID, Nullable<long> ltpsID, Nullable<long> userID, string auditDescription, Nullable<bool> forceUpdateIfExists)
        {
            var vehicleIDParameter = vehicleID.HasValue ?
                new ObjectParameter("VehicleID", vehicleID) :
                new ObjectParameter("VehicleID", typeof(long));
    
            var registrationNumberParameter = registrationNumber != null ?
                new ObjectParameter("RegistrationNumber", registrationNumber) :
                new ObjectParameter("RegistrationNumber", typeof(string));
    
            var engineNumberParameter = engineNumber != null ?
                new ObjectParameter("EngineNumber", engineNumber) :
                new ObjectParameter("EngineNumber", typeof(string));
    
            var vINParameter = vIN != null ?
                new ObjectParameter("VIN", vIN) :
                new ObjectParameter("VIN", typeof(string));
    
            var seatedCapacityParameter = seatedCapacity.HasValue ?
                new ObjectParameter("SeatedCapacity", seatedCapacity) :
                new ObjectParameter("SeatedCapacity", typeof(int));
    
            var standingCapacityParameter = standingCapacity.HasValue ?
                new ObjectParameter("StandingCapacity", standingCapacity) :
                new ObjectParameter("StandingCapacity", typeof(int));
    
            var grossMassParameter = grossMass.HasValue ?
                new ObjectParameter("GrossMass", grossMass) :
                new ObjectParameter("GrossMass", typeof(long));
    
            var vehicleMakeIDParameter = vehicleMakeID.HasValue ?
                new ObjectParameter("VehicleMakeID", vehicleMakeID) :
                new ObjectParameter("VehicleMakeID", typeof(short));
    
            var vehicleModelIDParameter = vehicleModelID.HasValue ?
                new ObjectParameter("VehicleModelID", vehicleModelID) :
                new ObjectParameter("VehicleModelID", typeof(short));
    
            var vehicleTypeIDParameter = vehicleTypeID.HasValue ?
                new ObjectParameter("VehicleTypeID", vehicleTypeID) :
                new ObjectParameter("VehicleTypeID", typeof(short));
    
            var carryingCapacityIDParameter = carryingCapacityID.HasValue ?
                new ObjectParameter("CarryingCapacityID", carryingCapacityID) :
                new ObjectParameter("CarryingCapacityID", typeof(short));
    
            var yearOfManufactureParameter = yearOfManufacture != null ?
                new ObjectParameter("YearOfManufacture", yearOfManufacture) :
                new ObjectParameter("YearOfManufacture", typeof(string));
    
            var tareParameter = tare.HasValue ?
                new ObjectParameter("Tare", tare) :
                new ObjectParameter("Tare", typeof(long));
    
            var currentOdometerReadingParameter = currentOdometerReading.HasValue ?
                new ObjectParameter("CurrentOdometerReading", currentOdometerReading) :
                new ObjectParameter("CurrentOdometerReading", typeof(long));
    
            var roadworthyCertificateDocIDParameter = roadworthyCertificateDocID.HasValue ?
                new ObjectParameter("RoadworthyCertificateDocID", roadworthyCertificateDocID) :
                new ObjectParameter("RoadworthyCertificateDocID", typeof(long));
    
            var professionalDriversPermitDocIDParameter = professionalDriversPermitDocID.HasValue ?
                new ObjectParameter("ProfessionalDriversPermitDocID", professionalDriversPermitDocID) :
                new ObjectParameter("ProfessionalDriversPermitDocID", typeof(long));
    
            var rankPermitDocIDParameter = rankPermitDocID.HasValue ?
                new ObjectParameter("RankPermitDocID", rankPermitDocID) :
                new ObjectParameter("RankPermitDocID", typeof(long));
    
            var certificateOfRegistrationDocIDParameter = certificateOfRegistrationDocID.HasValue ?
                new ObjectParameter("CertificateOfRegistrationDocID", certificateOfRegistrationDocID) :
                new ObjectParameter("CertificateOfRegistrationDocID", typeof(long));
    
            var olasIDParameter = olasID.HasValue ?
                new ObjectParameter("OlasID", olasID) :
                new ObjectParameter("OlasID", typeof(long));
    
            var ltpsIDParameter = ltpsID.HasValue ?
                new ObjectParameter("LtpsID", ltpsID) :
                new ObjectParameter("LtpsID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            var forceUpdateIfExistsParameter = forceUpdateIfExists.HasValue ?
                new ObjectParameter("ForceUpdateIfExists", forceUpdateIfExists) :
                new ObjectParameter("ForceUpdateIfExists", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_VehicleUpsert", vehicleIDParameter, registrationNumberParameter, engineNumberParameter, vINParameter, seatedCapacityParameter, standingCapacityParameter, grossMassParameter, vehicleMakeIDParameter, vehicleModelIDParameter, vehicleTypeIDParameter, carryingCapacityIDParameter, yearOfManufactureParameter, tareParameter, currentOdometerReadingParameter, roadworthyCertificateDocIDParameter, professionalDriversPermitDocIDParameter, rankPermitDocIDParameter, certificateOfRegistrationDocIDParameter, olasIDParameter, ltpsIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
        }
    
        public virtual int Pr_LicenceExceptionsUpdate(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceExceptionsUpdate", licenceIDParameter);
        }
    
        public virtual int Pr_MemberDetailsUpdate(Nullable<long> memberID, string surnameOrCompanyName, string firstNames, string postalAddress, string postalAddressCode, string physicalAddress, string physicalAddressCode, string telPhone, string telCell, string telFax, string email, string sARSIncomeTaxNumber, string tradeName, Nullable<long> businessTypeID, Nullable<long> userID)
        {
            var memberIDParameter = memberID.HasValue ?
                new ObjectParameter("MemberID", memberID) :
                new ObjectParameter("MemberID", typeof(long));
    
            var surnameOrCompanyNameParameter = surnameOrCompanyName != null ?
                new ObjectParameter("SurnameOrCompanyName", surnameOrCompanyName) :
                new ObjectParameter("SurnameOrCompanyName", typeof(string));
    
            var firstNamesParameter = firstNames != null ?
                new ObjectParameter("FirstNames", firstNames) :
                new ObjectParameter("FirstNames", typeof(string));
    
            var postalAddressParameter = postalAddress != null ?
                new ObjectParameter("PostalAddress", postalAddress) :
                new ObjectParameter("PostalAddress", typeof(string));
    
            var postalAddressCodeParameter = postalAddressCode != null ?
                new ObjectParameter("PostalAddressCode", postalAddressCode) :
                new ObjectParameter("PostalAddressCode", typeof(string));
    
            var physicalAddressParameter = physicalAddress != null ?
                new ObjectParameter("PhysicalAddress", physicalAddress) :
                new ObjectParameter("PhysicalAddress", typeof(string));
    
            var physicalAddressCodeParameter = physicalAddressCode != null ?
                new ObjectParameter("PhysicalAddressCode", physicalAddressCode) :
                new ObjectParameter("PhysicalAddressCode", typeof(string));
    
            var telPhoneParameter = telPhone != null ?
                new ObjectParameter("TelPhone", telPhone) :
                new ObjectParameter("TelPhone", typeof(string));
    
            var telCellParameter = telCell != null ?
                new ObjectParameter("TelCell", telCell) :
                new ObjectParameter("TelCell", typeof(string));
    
            var telFaxParameter = telFax != null ?
                new ObjectParameter("TelFax", telFax) :
                new ObjectParameter("TelFax", typeof(string));
    
            var emailParameter = email != null ?
                new ObjectParameter("Email", email) :
                new ObjectParameter("Email", typeof(string));
    
            var sARSIncomeTaxNumberParameter = sARSIncomeTaxNumber != null ?
                new ObjectParameter("SARSIncomeTaxNumber", sARSIncomeTaxNumber) :
                new ObjectParameter("SARSIncomeTaxNumber", typeof(string));
    
            var tradeNameParameter = tradeName != null ?
                new ObjectParameter("TradeName", tradeName) :
                new ObjectParameter("TradeName", typeof(string));
    
            var businessTypeIDParameter = businessTypeID.HasValue ?
                new ObjectParameter("BusinessTypeID", businessTypeID) :
                new ObjectParameter("BusinessTypeID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_MemberDetailsUpdate", memberIDParameter, surnameOrCompanyNameParameter, firstNamesParameter, postalAddressParameter, postalAddressCodeParameter, physicalAddressParameter, physicalAddressCodeParameter, telPhoneParameter, telCellParameter, telFaxParameter, emailParameter, sARSIncomeTaxNumberParameter, tradeNameParameter, businessTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceStatusUpdate(Nullable<long> userID, string comments, Nullable<long> licenceID, Nullable<short> licenceStatusID, Nullable<bool> isTransactionRequired)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var licenceStatusIDParameter = licenceStatusID.HasValue ?
                new ObjectParameter("LicenceStatusID", licenceStatusID) :
                new ObjectParameter("LicenceStatusID", typeof(short));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceStatusUpdate", userIDParameter, commentsParameter, licenceIDParameter, licenceStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesOverdueUpliftmentsGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesOverdueUpliftmentsGet", userIDParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesOverdueUpliftmentsGet(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesOverdueUpliftmentsGet", mergeOption, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationPostPone(Nullable<long> adjudicationDetailID, string reason, Nullable<long> userID)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationPostPone", adjudicationDetailIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceRouteAdd(Nullable<long> licenceID, Nullable<long> routeID, Nullable<short> serviceTypeID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceRouteAdd", licenceIDParameter, routeIDParameter, serviceTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceRouteRemove(Nullable<long> licenceID, Nullable<long> routeID, Nullable<short> serviceTypeID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceRouteRemove", licenceIDParameter, routeIDParameter, serviceTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationAdjudicationBypass(Nullable<long> applicationRequestDetailID, Nullable<short> adjudicationDecisionID, Nullable<int> licenceDurationID, Nullable<System.DateTime> licenceExpiryDate, Nullable<System.DateTime> actualAdjudicationDate, string comments, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var adjudicationDecisionIDParameter = adjudicationDecisionID.HasValue ?
                new ObjectParameter("AdjudicationDecisionID", adjudicationDecisionID) :
                new ObjectParameter("AdjudicationDecisionID", typeof(short));
    
            var licenceDurationIDParameter = licenceDurationID.HasValue ?
                new ObjectParameter("LicenceDurationID", licenceDurationID) :
                new ObjectParameter("LicenceDurationID", typeof(int));
    
            var licenceExpiryDateParameter = licenceExpiryDate.HasValue ?
                new ObjectParameter("LicenceExpiryDate", licenceExpiryDate) :
                new ObjectParameter("LicenceExpiryDate", typeof(System.DateTime));
    
            var actualAdjudicationDateParameter = actualAdjudicationDate.HasValue ?
                new ObjectParameter("ActualAdjudicationDate", actualAdjudicationDate) :
                new ObjectParameter("ActualAdjudicationDate", typeof(System.DateTime));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAdjudicationBypass", applicationRequestDetailIDParameter, adjudicationDecisionIDParameter, licenceDurationIDParameter, licenceExpiryDateParameter, actualAdjudicationDateParameter, commentsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationsStatusViewGet_Result> Pr_ApplicationsStatusViewGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationsStatusViewGet_Result>("Pr_ApplicationsStatusViewGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceIssueRequestsStatusViewGet_Result> Pr_LicenceIssueRequestsStatusViewGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueRequestsStatusViewGet_Result>("Pr_LicenceIssueRequestsStatusViewGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_NewRouteStatusViewGet_Result> Pr_NewRouteStatusViewGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_NewRouteStatusViewGet_Result>("Pr_NewRouteStatusViewGet", userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PlaceUpsert(Nullable<long> placeID, string description, Nullable<short> placeTypeID, Nullable<long> olasID, Nullable<long> ltpsID, Nullable<long> userID, string auditDescription, Nullable<bool> forceUpdateIfExists)
        {
            var placeIDParameter = placeID.HasValue ?
                new ObjectParameter("PlaceID", placeID) :
                new ObjectParameter("PlaceID", typeof(long));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var placeTypeIDParameter = placeTypeID.HasValue ?
                new ObjectParameter("PlaceTypeID", placeTypeID) :
                new ObjectParameter("PlaceTypeID", typeof(short));
    
            var olasIDParameter = olasID.HasValue ?
                new ObjectParameter("OlasID", olasID) :
                new ObjectParameter("OlasID", typeof(long));
    
            var ltpsIDParameter = ltpsID.HasValue ?
                new ObjectParameter("LtpsID", ltpsID) :
                new ObjectParameter("LtpsID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            var forceUpdateIfExistsParameter = forceUpdateIfExists.HasValue ?
                new ObjectParameter("ForceUpdateIfExists", forceUpdateIfExists) :
                new ObjectParameter("ForceUpdateIfExists", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_PlaceUpsert", placeIDParameter, descriptionParameter, placeTypeIDParameter, olasIDParameter, ltpsIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
        }
    
        public virtual int Pr_ApplicationAuditComplete(Nullable<long> applicationAuditID, Nullable<long> userID)
        {
            var applicationAuditIDParameter = applicationAuditID.HasValue ?
                new ObjectParameter("ApplicationAuditID", applicationAuditID) :
                new ObjectParameter("ApplicationAuditID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAuditComplete", applicationAuditIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationAuditCreate(Nullable<long> applicationDetailID, Nullable<short> applicationAuditTypeID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationAuditTypeIDParameter = applicationAuditTypeID.HasValue ?
                new ObjectParameter("ApplicationAuditTypeID", applicationAuditTypeID) :
                new ObjectParameter("ApplicationAuditTypeID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAuditCreate", applicationDetailIDParameter, applicationAuditTypeIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationAuditSearch_Result> Pr_ApplicationAuditSearch(Nullable<long> assignedToID, Nullable<long> auditedUserID, Nullable<bool> incompleteAuditsOnly, Nullable<long> userID)
        {
            var assignedToIDParameter = assignedToID.HasValue ?
                new ObjectParameter("AssignedToID", assignedToID) :
                new ObjectParameter("AssignedToID", typeof(long));
    
            var auditedUserIDParameter = auditedUserID.HasValue ?
                new ObjectParameter("AuditedUserID", auditedUserID) :
                new ObjectParameter("AuditedUserID", typeof(long));
    
            var incompleteAuditsOnlyParameter = incompleteAuditsOnly.HasValue ?
                new ObjectParameter("IncompleteAuditsOnly", incompleteAuditsOnly) :
                new ObjectParameter("IncompleteAuditsOnly", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationAuditSearch_Result>("Pr_ApplicationAuditSearch", assignedToIDParameter, auditedUserIDParameter, incompleteAuditsOnlyParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationAdjudicationDecisionReverse(Nullable<long> applicationAdjudicationID, Nullable<long> userID, string comments)
        {
            var applicationAdjudicationIDParameter = applicationAdjudicationID.HasValue ?
                new ObjectParameter("ApplicationAdjudicationID", applicationAdjudicationID) :
                new ObjectParameter("ApplicationAdjudicationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAdjudicationDecisionReverse", applicationAdjudicationIDParameter, userIDParameter, commentsParameter);
        }
    
        public virtual int Pr_ApplicationBlockedLicenceCreate(string operatingLicenceNumber, string reason, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationBlockedLicenceCreate", operatingLicenceNumberParameter, reasonParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationBlockedLicencesGet_Result> Pr_ApplicationBlockedLicencesGet()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationBlockedLicencesGet_Result>("Pr_ApplicationBlockedLicencesGet");
        }
    
        public virtual int Pr_VehicleIsNotUsed(string operatingLicenceNumber, string vIN, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var vINParameter = vIN != null ?
                new ObjectParameter("VIN", vIN) :
                new ObjectParameter("VIN", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleIsNotUsed", operatingLicenceNumberParameter, vINParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_RouteAssociationSummary_Result> Pr_RouteAssociationSummary(Nullable<long> routeID, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_RouteAssociationSummary_Result>("Pr_RouteAssociationSummary", routeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteCounts_Result> Pr_Purification_RouteCounts(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteCounts_Result>("Pr_Purification_RouteCounts", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteAwaitingRouteDescriptionChecks_Result> Pr_Purification_RouteAwaitingRouteDescriptionChecks(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteAwaitingRouteDescriptionChecks_Result>("Pr_Purification_RouteAwaitingRouteDescriptionChecks", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteDuplicateBoardRouteNumbers_Result> Pr_Purification_RouteDuplicateBoardRouteNumbers(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteDuplicateBoardRouteNumbers_Result>("Pr_Purification_RouteDuplicateBoardRouteNumbers", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteDuplicateNationalRouteNumbers_Result> Pr_Purification_RouteDuplicateNationalRouteNumbers(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteDuplicateNationalRouteNumbers_Result>("Pr_Purification_RouteDuplicateNationalRouteNumbers", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteDuplicatePlaces_Result> Pr_Purification_RouteDuplicatePlaces(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteDuplicatePlaces_Result>("Pr_Purification_RouteDuplicatePlaces", userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_Purification_RouteDescriptionUpdate(Nullable<long> routeID, Nullable<long> originPlaceID, Nullable<long> destinationPlaceID, string description, Nullable<long> routeTypeID, Nullable<long> timeTableDocumentID, Nullable<long> fareScheduleDocumentID, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var originPlaceIDParameter = originPlaceID.HasValue ?
                new ObjectParameter("OriginPlaceID", originPlaceID) :
                new ObjectParameter("OriginPlaceID", typeof(long));
    
            var destinationPlaceIDParameter = destinationPlaceID.HasValue ?
                new ObjectParameter("DestinationPlaceID", destinationPlaceID) :
                new ObjectParameter("DestinationPlaceID", typeof(long));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var routeTypeIDParameter = routeTypeID.HasValue ?
                new ObjectParameter("RouteTypeID", routeTypeID) :
                new ObjectParameter("RouteTypeID", typeof(long));
    
            var timeTableDocumentIDParameter = timeTableDocumentID.HasValue ?
                new ObjectParameter("TimeTableDocumentID", timeTableDocumentID) :
                new ObjectParameter("TimeTableDocumentID", typeof(long));
    
            var fareScheduleDocumentIDParameter = fareScheduleDocumentID.HasValue ?
                new ObjectParameter("FareScheduleDocumentID", fareScheduleDocumentID) :
                new ObjectParameter("FareScheduleDocumentID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_Purification_RouteDescriptionUpdate", routeIDParameter, originPlaceIDParameter, destinationPlaceIDParameter, descriptionParameter, routeTypeIDParameter, timeTableDocumentIDParameter, fareScheduleDocumentIDParameter, userIDParameter);
        }
    
        public virtual int Pr_Purification_RouteDelete(Nullable<long> routeID, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Purification_RouteDelete", routeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteDuplicateNationalRouteNumberDetails_Result> Pr_Purification_RouteDuplicateNationalRouteNumberDetails(string nationalRouteNumber, Nullable<long> userID)
        {
            var nationalRouteNumberParameter = nationalRouteNumber != null ?
                new ObjectParameter("NationalRouteNumber", nationalRouteNumber) :
                new ObjectParameter("NationalRouteNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteDuplicateNationalRouteNumberDetails_Result>("Pr_Purification_RouteDuplicateNationalRouteNumberDetails", nationalRouteNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_RouteMerge(Nullable<long> destinationRouteID, Nullable<long> obsoleteRouteID, Nullable<long> userID)
        {
            var destinationRouteIDParameter = destinationRouteID.HasValue ?
                new ObjectParameter("DestinationRouteID", destinationRouteID) :
                new ObjectParameter("DestinationRouteID", typeof(long));
    
            var obsoleteRouteIDParameter = obsoleteRouteID.HasValue ?
                new ObjectParameter("ObsoleteRouteID", obsoleteRouteID) :
                new ObjectParameter("ObsoleteRouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteMerge", destinationRouteIDParameter, obsoleteRouteIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RouteDuplicateBoardRouteNumberDetails_Result> Pr_Purification_RouteDuplicateBoardRouteNumberDetails(string boardRouteNumber, Nullable<long> userID)
        {
            var boardRouteNumberParameter = boardRouteNumber != null ?
                new ObjectParameter("BoardRouteNumber", boardRouteNumber) :
                new ObjectParameter("BoardRouteNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RouteDuplicateBoardRouteNumberDetails_Result>("Pr_Purification_RouteDuplicateBoardRouteNumberDetails", boardRouteNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_RoutesWithPotentialChangesFromOLAS_Result> Pr_Purification_RoutesWithPotentialChangesFromOLAS(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_RoutesWithPotentialChangesFromOLAS_Result>("Pr_Purification_RoutesWithPotentialChangesFromOLAS", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_VerificationTasksGet_Result> Pr_VerificationTasksGet(Nullable<long> workflowInstanceTaskID, Nullable<long> userID)
        {
            var workflowInstanceTaskIDParameter = workflowInstanceTaskID.HasValue ?
                new ObjectParameter("WorkflowInstanceTaskID", workflowInstanceTaskID) :
                new ObjectParameter("WorkflowInstanceTaskID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_VerificationTasksGet_Result>("Pr_VerificationTasksGet", workflowInstanceTaskIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ExceptionTasksGet_Result> Pr_ExceptionTasksGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ExceptionTasksGet_Result>("Pr_ExceptionTasksGet", userIDParameter);
        }
    
        public virtual int Pr_VehicleFlagVinAsCorrect(Nullable<long> vehicleID, Nullable<long> userID)
        {
            var vehicleIDParameter = vehicleID.HasValue ?
                new ObjectParameter("VehicleID", vehicleID) :
                new ObjectParameter("VehicleID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleFlagVinAsCorrect", vehicleIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationBlockedLicenceDelete(string operatingLicenceNumber, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationBlockedLicenceDelete", operatingLicenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_SearchApplicationServiceTypes_Result> Pr_Purification_SearchApplicationServiceTypes(string appReferenceNumber, Nullable<long> userID)
        {
            var appReferenceNumberParameter = appReferenceNumber != null ?
                new ObjectParameter("AppReferenceNumber", appReferenceNumber) :
                new ObjectParameter("AppReferenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchApplicationServiceTypes_Result>("Pr_Purification_SearchApplicationServiceTypes", appReferenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PurificationLicenceModeUpdate(Nullable<long> licenceID, Nullable<short> newModeID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var newModeIDParameter = newModeID.HasValue ?
                new ObjectParameter("NewModeID", newModeID) :
                new ObjectParameter("NewModeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_PurificationLicenceModeUpdate", licenceIDParameter, newModeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PurificationLicenceServiceTypeAdd(Nullable<long> licenceID, Nullable<short> serviceTypeID, string serviceTypeDescription, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var serviceTypeDescriptionParameter = serviceTypeDescription != null ?
                new ObjectParameter("ServiceTypeDescription", serviceTypeDescription) :
                new ObjectParameter("ServiceTypeDescription", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_PurificationLicenceServiceTypeAdd", licenceIDParameter, serviceTypeIDParameter, serviceTypeDescriptionParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PurificationLicenceServiceTypeRemove(Nullable<long> licenceID, Nullable<long> licenceServcieDetailID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var licenceServcieDetailIDParameter = licenceServcieDetailID.HasValue ?
                new ObjectParameter("LicenceServcieDetailID", licenceServcieDetailID) :
                new ObjectParameter("LicenceServcieDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_PurificationLicenceServiceTypeRemove", licenceIDParameter, licenceServcieDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_FindMember_Result> Pr_Purification_FindMember(string idNumber, Nullable<long> userID)
        {
            var idNumberParameter = idNumber != null ?
                new ObjectParameter("IdNumber", idNumber) :
                new ObjectParameter("IdNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_FindMember_Result>("Pr_Purification_FindMember", idNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_AssociationRouteAdd(Nullable<long> associationID, Nullable<long> routeID, Nullable<long> userID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AssociationRouteAdd", associationIDParameter, routeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AssociationRouteRemove(Nullable<long> associationID, Nullable<long> routeID, Nullable<long> userID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AssociationRouteRemove", associationIDParameter, routeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Route> Pr_AssociationRoutesGet(Nullable<long> associationID, Nullable<long> userID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Route>("Pr_AssociationRoutesGet", associationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Route> Pr_AssociationRoutesGet(Nullable<long> associationID, Nullable<long> userID, MergeOption mergeOption)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Route>("Pr_AssociationRoutesGet", mergeOption, associationIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationBlockedIDNumberCreate(string iDNumber, string reason, Nullable<long> userID)
        {
            var iDNumberParameter = iDNumber != null ?
                new ObjectParameter("IDNumber", iDNumber) :
                new ObjectParameter("IDNumber", typeof(string));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationBlockedIDNumberCreate", iDNumberParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationBlockedIDNumberDelete(string iDNumber, Nullable<long> userID)
        {
            var iDNumberParameter = iDNumber != null ?
                new ObjectParameter("IDNumber", iDNumber) :
                new ObjectParameter("IDNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationBlockedIDNumberDelete", iDNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationBlockedIDNumbersGet_Result> Pr_ApplicationBlockedIDNumbersGet()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationBlockedIDNumbersGet_Result>("Pr_ApplicationBlockedIDNumbersGet");
        }
    
        public virtual int Pr_LicenceIssueWithoutPrint(Nullable<long> licenceID, string reason, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceIssueWithoutPrint", licenceIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_ReceiptCancellation(Nullable<long> receiptDetailID, string reason, Nullable<long> userID)
        {
            var receiptDetailIDParameter = receiptDetailID.HasValue ?
                new ObjectParameter("ReceiptDetailID", receiptDetailID) :
                new ObjectParameter("ReceiptDetailID", typeof(long));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ReceiptCancellation", receiptDetailIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_DocumentResultsSync(Nullable<long> entityID, Nullable<long> itemID, Nullable<long> workflowEntityID, Nullable<long> workflowItemID, Nullable<long> userID)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(long));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var workflowEntityIDParameter = workflowEntityID.HasValue ?
                new ObjectParameter("WorkflowEntityID", workflowEntityID) :
                new ObjectParameter("WorkflowEntityID", typeof(long));
    
            var workflowItemIDParameter = workflowItemID.HasValue ?
                new ObjectParameter("WorkflowItemID", workflowItemID) :
                new ObjectParameter("WorkflowItemID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DocumentResultsSync", entityIDParameter, itemIDParameter, workflowEntityIDParameter, workflowItemIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceIssueDetailVerificationComplete(Nullable<long> licenceIssueDetailDetailID, Nullable<long> workflowInstanceTaskID, string comments, Nullable<long> userID)
        {
            var licenceIssueDetailDetailIDParameter = licenceIssueDetailDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailDetailID", licenceIssueDetailDetailID) :
                new ObjectParameter("LicenceIssueDetailDetailID", typeof(long));
    
            var workflowInstanceTaskIDParameter = workflowInstanceTaskID.HasValue ?
                new ObjectParameter("WorkflowInstanceTaskID", workflowInstanceTaskID) :
                new ObjectParameter("WorkflowInstanceTaskID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceIssueDetailVerificationComplete", licenceIssueDetailDetailIDParameter, workflowInstanceTaskIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationVehicleDetailsInBulkVerificationUpdate(Nullable<long> applicationVehicleDetailsInBulkID, Nullable<long> applicationDetailID, Nullable<bool> isVerified, Nullable<bool> isException, string exceptionDetails, Nullable<bool> isLastVehicleToBeVerified, Nullable<long> userID)
        {
            var applicationVehicleDetailsInBulkIDParameter = applicationVehicleDetailsInBulkID.HasValue ?
                new ObjectParameter("ApplicationVehicleDetailsInBulkID", applicationVehicleDetailsInBulkID) :
                new ObjectParameter("ApplicationVehicleDetailsInBulkID", typeof(long));
    
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var isVerifiedParameter = isVerified.HasValue ?
                new ObjectParameter("IsVerified", isVerified) :
                new ObjectParameter("IsVerified", typeof(bool));
    
            var isExceptionParameter = isException.HasValue ?
                new ObjectParameter("IsException", isException) :
                new ObjectParameter("IsException", typeof(bool));
    
            var exceptionDetailsParameter = exceptionDetails != null ?
                new ObjectParameter("ExceptionDetails", exceptionDetails) :
                new ObjectParameter("ExceptionDetails", typeof(string));
    
            var isLastVehicleToBeVerifiedParameter = isLastVehicleToBeVerified.HasValue ?
                new ObjectParameter("IsLastVehicleToBeVerified", isLastVehicleToBeVerified) :
                new ObjectParameter("IsLastVehicleToBeVerified", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationVehicleDetailsInBulkVerificationUpdate", applicationVehicleDetailsInBulkIDParameter, applicationDetailIDParameter, isVerifiedParameter, isExceptionParameter, exceptionDetailsParameter, isLastVehicleToBeVerifiedParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationPrecheckDocumentList_Result> Pr_ApplicationPrecheckDocumentList(Nullable<short> applicationRequestTypeID)
        {
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationPrecheckDocumentList_Result>("Pr_ApplicationPrecheckDocumentList", applicationRequestTypeIDParameter);
        }
    
        public virtual ObjectResult<Pr_PrecheckDocumentListGet_Result> Pr_PrecheckDocumentListGet(Nullable<long> preCheckDetailID)
        {
            var preCheckDetailIDParameter = preCheckDetailID.HasValue ?
                new ObjectParameter("PreCheckDetailID", preCheckDetailID) :
                new ObjectParameter("PreCheckDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_PrecheckDocumentListGet_Result>("Pr_PrecheckDocumentListGet", preCheckDetailIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceIssueDetaisReport_Result> Pr_LicenceIssueDetaisReport(Nullable<long> licenceIssueDetailID, Nullable<long> userID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueDetaisReport_Result>("Pr_LicenceIssueDetaisReport", licenceIssueDetailIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceVehicleDelink(Nullable<long> licenceID, string reasonForDelink, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var reasonForDelinkParameter = reasonForDelink != null ?
                new ObjectParameter("ReasonForDelink", reasonForDelink) :
                new ObjectParameter("ReasonForDelink", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceVehicleDelink", licenceIDParameter, reasonForDelinkParameter, userIDParameter);
        }
    
        public virtual int Pr_RouteSendToPurification(Nullable<long> routeID, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteSendToPurification", routeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationRemoveApplication(Nullable<long> applicationDetailID, Nullable<long> adjudicationDetailID, string reason, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationRemoveApplication", applicationDetailIDParameter, adjudicationDetailIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationAddApplication(Nullable<long> applicationDetailID, Nullable<long> adjudicationDetailID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationAddApplication", applicationDetailIDParameter, adjudicationDetailIDParameter, userIDParameter);
        }
    
        [DbFunction("LegitimateEntities", "Fn_GetSourceApplicationRecordsFromSourceSystem")]
        public virtual IQueryable<Fn_GetSourceApplicationRecordsFromSourceSystem_Result> Fn_GetSourceApplicationRecordsFromSourceSystem(string olPermitNumber, Nullable<short> sourceApplicationID, Nullable<bool> inlcudeActiveOnly, Nullable<bool> includeLastExpiredIfNoActiveFound)
        {
            var olPermitNumberParameter = olPermitNumber != null ?
                new ObjectParameter("OlPermitNumber", olPermitNumber) :
                new ObjectParameter("OlPermitNumber", typeof(string));
    
            var sourceApplicationIDParameter = sourceApplicationID.HasValue ?
                new ObjectParameter("SourceApplicationID", sourceApplicationID) :
                new ObjectParameter("SourceApplicationID", typeof(short));
    
            var inlcudeActiveOnlyParameter = inlcudeActiveOnly.HasValue ?
                new ObjectParameter("InlcudeActiveOnly", inlcudeActiveOnly) :
                new ObjectParameter("InlcudeActiveOnly", typeof(bool));
    
            var includeLastExpiredIfNoActiveFoundParameter = includeLastExpiredIfNoActiveFound.HasValue ?
                new ObjectParameter("IncludeLastExpiredIfNoActiveFound", includeLastExpiredIfNoActiveFound) :
                new ObjectParameter("IncludeLastExpiredIfNoActiveFound", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<Fn_GetSourceApplicationRecordsFromSourceSystem_Result>("[LegitimateEntities].[Fn_GetSourceApplicationRecordsFromSourceSystem](@OlPermitNumber, @SourceApplicationID, @InlcudeActiveOnly, @IncludeLastExpiredIfNoActiveFound)", olPermitNumberParameter, sourceApplicationIDParameter, inlcudeActiveOnlyParameter, includeLastExpiredIfNoActiveFoundParameter);
        }
    
        public virtual ObjectResult<string> Pr_GetAdjudicationAgendeUserEmails()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GetAdjudicationAgendeUserEmails");
        }
    
        public virtual ObjectResult<Pr_LicenceIssueTrackingSearch_Result> Pr_LicenceIssueTrackingSearch(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueTrackingSearch_Result>("Pr_LicenceIssueTrackingSearch", userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> Pr_LicenceIssueTrackingFlag(string licencesToBeFlaggedAsSent, Nullable<bool> p30DaysLetterSent, Nullable<bool> p60DaysLetterSent, Nullable<bool> p90DaysLetterSent, Nullable<long> userID)
        {
            var licencesToBeFlaggedAsSentParameter = licencesToBeFlaggedAsSent != null ?
                new ObjectParameter("LicencesToBeFlaggedAsSent", licencesToBeFlaggedAsSent) :
                new ObjectParameter("LicencesToBeFlaggedAsSent", typeof(string));
    
            var p30DaysLetterSentParameter = p30DaysLetterSent.HasValue ?
                new ObjectParameter("p30DaysLetterSent", p30DaysLetterSent) :
                new ObjectParameter("p30DaysLetterSent", typeof(bool));
    
            var p60DaysLetterSentParameter = p60DaysLetterSent.HasValue ?
                new ObjectParameter("p60DaysLetterSent", p60DaysLetterSent) :
                new ObjectParameter("p60DaysLetterSent", typeof(bool));
    
            var p90DaysLetterSentParameter = p90DaysLetterSent.HasValue ?
                new ObjectParameter("p90DaysLetterSent", p90DaysLetterSent) :
                new ObjectParameter("p90DaysLetterSent", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("Pr_LicenceIssueTrackingFlag", licencesToBeFlaggedAsSentParameter, p30DaysLetterSentParameter, p60DaysLetterSentParameter, p90DaysLetterSentParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceIssueTrackingExtend_Result> Pr_LicenceIssueTrackingExtend(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueTrackingExtend_Result>("Pr_LicenceIssueTrackingExtend", licenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pw_GetItemIDFromReference(string referenceNumber)
        {
            var referenceNumberParameter = referenceNumber != null ?
                new ObjectParameter("referenceNumber", referenceNumber) :
                new ObjectParameter("referenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pw_GetItemIDFromReference", referenceNumberParameter);
        }
    
        public virtual int Pr_LicenceUpliftmentExtensionDetailVerificationComplete(Nullable<long> licenceUpliftmentExtensionRequestDetailID, Nullable<long> workflowInstanceTaskID, string comments, Nullable<long> userID)
        {
            var licenceUpliftmentExtensionRequestDetailIDParameter = licenceUpliftmentExtensionRequestDetailID.HasValue ?
                new ObjectParameter("LicenceUpliftmentExtensionRequestDetailID", licenceUpliftmentExtensionRequestDetailID) :
                new ObjectParameter("LicenceUpliftmentExtensionRequestDetailID", typeof(long));
    
            var workflowInstanceTaskIDParameter = workflowInstanceTaskID.HasValue ?
                new ObjectParameter("WorkflowInstanceTaskID", workflowInstanceTaskID) :
                new ObjectParameter("WorkflowInstanceTaskID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceUpliftmentExtensionDetailVerificationComplete", licenceUpliftmentExtensionRequestDetailIDParameter, workflowInstanceTaskIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ExtensionTasksGet_Result> Pr_ExtensionTasksGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ExtensionTasksGet_Result>("Pr_ExtensionTasksGet", userIDParameter);
        }
    
        public virtual int Pr_ApplicationVerificationHandleError(Nullable<long> applicationDetailID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationVerificationHandleError", applicationDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationGetDocuments_Result> Pr_ApplicationGetDocuments(Nullable<long> applicationRequestDetailID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationGetDocuments_Result>("Pr_ApplicationGetDocuments", applicationRequestDetailIDParameter);
        }
    
        public virtual int Pr_ApplicationAddDocument(Nullable<long> applicationRequestDetailID, Nullable<long> documentTypeID, Nullable<long> documentID, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(long));
    
            var documentIDParameter = documentID.HasValue ?
                new ObjectParameter("DocumentID", documentID) :
                new ObjectParameter("DocumentID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAddDocument", applicationRequestDetailIDParameter, documentTypeIDParameter, documentIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetApplicationTypesForConversion_Result> Pr_GetApplicationTypesForConversion(string applicationNumber, Nullable<long> userID)
        {
            var applicationNumberParameter = applicationNumber != null ?
                new ObjectParameter("ApplicationNumber", applicationNumber) :
                new ObjectParameter("ApplicationNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetApplicationTypesForConversion_Result>("Pr_GetApplicationTypesForConversion", applicationNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetReceipt_Result> Pr_GetReceipt(string receiptNumber, Nullable<long> userID)
        {
            var receiptNumberParameter = receiptNumber != null ?
                new ObjectParameter("ReceiptNumber", receiptNumber) :
                new ObjectParameter("ReceiptNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetReceipt_Result>("Pr_GetReceipt", receiptNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_SetReceiptToZero(Nullable<long> receiptDetailID, string reason, Nullable<long> userID)
        {
            var receiptDetailIDParameter = receiptDetailID.HasValue ?
                new ObjectParameter("ReceiptDetailID", receiptDetailID) :
                new ObjectParameter("ReceiptDetailID", typeof(long));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SetReceiptToZero", receiptDetailIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetCashupUsers_Result> Pr_GetCashupUsers(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetCashupUsers_Result>("Pr_GetCashupUsers", userIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_GetCashupDetails(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GetCashupDetails", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetUserDetails_Result> Pr_GetUserDetails(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetUserDetails_Result>("Pr_GetUserDetails", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetRecentCashups_Result> Pr_GetRecentCashups(Nullable<long> receiptUserID, Nullable<long> userID)
        {
            var receiptUserIDParameter = receiptUserID.HasValue ?
                new ObjectParameter("ReceiptUserID", receiptUserID) :
                new ObjectParameter("ReceiptUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetRecentCashups_Result>("Pr_GetRecentCashups", receiptUserIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationCreateReceipt(Nullable<long> applicationRequestDetailID, string receiptType, Nullable<int> receiptNumberOfCopies, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var receiptTypeParameter = receiptType != null ?
                new ObjectParameter("ReceiptType", receiptType) :
                new ObjectParameter("ReceiptType", typeof(string));
    
            var receiptNumberOfCopiesParameter = receiptNumberOfCopies.HasValue ?
                new ObjectParameter("ReceiptNumberOfCopies", receiptNumberOfCopies) :
                new ObjectParameter("ReceiptNumberOfCopies", typeof(int));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateReceipt", applicationRequestDetailIDParameter, receiptTypeParameter, receiptNumberOfCopiesParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetUserDataOnIdSearch_Result> Pr_GetUserDataOnIdSearch(string oldIDNumber, string newIDNumber)
        {
            var oldIDNumberParameter = oldIDNumber != null ?
                new ObjectParameter("OldIDNumber", oldIDNumber) :
                new ObjectParameter("OldIDNumber", typeof(string));
    
            var newIDNumberParameter = newIDNumber != null ?
                new ObjectParameter("NewIDNumber", newIDNumber) :
                new ObjectParameter("NewIDNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetUserDataOnIdSearch_Result>("Pr_GetUserDataOnIdSearch", oldIDNumberParameter, newIDNumberParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationDetails_Light> Pr_ApplicationSearch(string applicationRequestTypes, Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, Nullable<short> applicationStatusID, Nullable<short> applicationSubStatusID, string steps, Nullable<long> userID)
        {
            var applicationRequestTypesParameter = applicationRequestTypes != null ?
                new ObjectParameter("ApplicationRequestTypes", applicationRequestTypes) :
                new ObjectParameter("ApplicationRequestTypes", typeof(string));
    
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var applicationStatusIDParameter = applicationStatusID.HasValue ?
                new ObjectParameter("ApplicationStatusID", applicationStatusID) :
                new ObjectParameter("ApplicationStatusID", typeof(short));
    
            var applicationSubStatusIDParameter = applicationSubStatusID.HasValue ?
                new ObjectParameter("ApplicationSubStatusID", applicationSubStatusID) :
                new ObjectParameter("ApplicationSubStatusID", typeof(short));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationDetails_Light>("Pr_ApplicationSearch", applicationRequestTypesParameter, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, applicationStatusIDParameter, applicationSubStatusIDParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationDetails_Light> Pr_ApplicationSearch(string applicationRequestTypes, Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, Nullable<short> applicationStatusID, Nullable<short> applicationSubStatusID, string steps, Nullable<long> userID, MergeOption mergeOption)
        {
            var applicationRequestTypesParameter = applicationRequestTypes != null ?
                new ObjectParameter("ApplicationRequestTypes", applicationRequestTypes) :
                new ObjectParameter("ApplicationRequestTypes", typeof(string));
    
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var applicationStatusIDParameter = applicationStatusID.HasValue ?
                new ObjectParameter("ApplicationStatusID", applicationStatusID) :
                new ObjectParameter("ApplicationStatusID", typeof(short));
    
            var applicationSubStatusIDParameter = applicationSubStatusID.HasValue ?
                new ObjectParameter("ApplicationSubStatusID", applicationSubStatusID) :
                new ObjectParameter("ApplicationSubStatusID", typeof(short));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationDetails_Light>("Pr_ApplicationSearch", mergeOption, applicationRequestTypesParameter, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, applicationStatusIDParameter, applicationSubStatusIDParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_ApplicationSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_ApplicationSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_LicenceIssuingSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_LicenceIssuingSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_LicenceIssueDetails> Pr_LicenceIssuingSearch(string applicationRequestTypes, Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID)
        {
            var applicationRequestTypesParameter = applicationRequestTypes != null ?
                new ObjectParameter("ApplicationRequestTypes", applicationRequestTypes) :
                new ObjectParameter("ApplicationRequestTypes", typeof(string));
    
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_LicenceIssueDetails>("Pr_LicenceIssuingSearch", applicationRequestTypesParameter, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_LicenceIssueDetails> Pr_LicenceIssuingSearch(string applicationRequestTypes, Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID, MergeOption mergeOption)
        {
            var applicationRequestTypesParameter = applicationRequestTypes != null ?
                new ObjectParameter("ApplicationRequestTypes", applicationRequestTypes) :
                new ObjectParameter("ApplicationRequestTypes", typeof(string));
    
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_LicenceIssueDetails>("Pr_LicenceIssuingSearch", mergeOption, applicationRequestTypesParameter, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_InspectorInspectionsGet_Result> Pr_InspectorInspectionsGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_InspectorInspectionsGet_Result>("Pr_InspectorInspectionsGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationsAwaitingInspectionsGet_Result> Pr_ApplicationsAwaitingInspectionsGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationsAwaitingInspectionsGet_Result>("Pr_ApplicationsAwaitingInspectionsGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_InspectorsGet_Result> Pr_InspectorsGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_InspectorsGet_Result>("Pr_InspectorsGet", userIDParameter);
        }
    
        public virtual int Pr_ApplicationInspectionDetailUpdate(Nullable<long> applicationDetailID, Nullable<short> inspectionStatusID, Nullable<long> inspectorID, Nullable<System.DateTime> inspectionDateFrom, Nullable<System.DateTime> inspectionDateTo, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var inspectionStatusIDParameter = inspectionStatusID.HasValue ?
                new ObjectParameter("InspectionStatusID", inspectionStatusID) :
                new ObjectParameter("InspectionStatusID", typeof(short));
    
            var inspectorIDParameter = inspectorID.HasValue ?
                new ObjectParameter("InspectorID", inspectorID) :
                new ObjectParameter("InspectorID", typeof(long));
    
            var inspectionDateFromParameter = inspectionDateFrom.HasValue ?
                new ObjectParameter("InspectionDateFrom", inspectionDateFrom) :
                new ObjectParameter("InspectionDateFrom", typeof(System.DateTime));
    
            var inspectionDateToParameter = inspectionDateTo.HasValue ?
                new ObjectParameter("InspectionDateTo", inspectionDateTo) :
                new ObjectParameter("InspectionDateTo", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationInspectionDetailUpdate", applicationDetailIDParameter, inspectionStatusIDParameter, inspectorIDParameter, inspectionDateFromParameter, inspectionDateToParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationsAwaitingInspectionOutcomesGet_Result> Pr_ApplicationsAwaitingInspectionOutcomesGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationsAwaitingInspectionOutcomesGet_Result>("Pr_ApplicationsAwaitingInspectionOutcomesGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AccreditationSearch_Result> Pr_AccreditationSearch(string accreditationNumber, Nullable<long> memberID, Nullable<long> accreditationStatusID, Nullable<System.DateTime> dateOfIssueStartDate, Nullable<System.DateTime> dateOfIssueEndDate, Nullable<System.DateTime> dateOfExpiryStartDate, Nullable<System.DateTime> dateOfExpiryEndDate, Nullable<long> userID)
        {
            var accreditationNumberParameter = accreditationNumber != null ?
                new ObjectParameter("AccreditationNumber", accreditationNumber) :
                new ObjectParameter("AccreditationNumber", typeof(string));
    
            var memberIDParameter = memberID.HasValue ?
                new ObjectParameter("MemberID", memberID) :
                new ObjectParameter("MemberID", typeof(long));
    
            var accreditationStatusIDParameter = accreditationStatusID.HasValue ?
                new ObjectParameter("AccreditationStatusID", accreditationStatusID) :
                new ObjectParameter("AccreditationStatusID", typeof(long));
    
            var dateOfIssueStartDateParameter = dateOfIssueStartDate.HasValue ?
                new ObjectParameter("DateOfIssueStartDate", dateOfIssueStartDate) :
                new ObjectParameter("DateOfIssueStartDate", typeof(System.DateTime));
    
            var dateOfIssueEndDateParameter = dateOfIssueEndDate.HasValue ?
                new ObjectParameter("DateOfIssueEndDate", dateOfIssueEndDate) :
                new ObjectParameter("DateOfIssueEndDate", typeof(System.DateTime));
    
            var dateOfExpiryStartDateParameter = dateOfExpiryStartDate.HasValue ?
                new ObjectParameter("DateOfExpiryStartDate", dateOfExpiryStartDate) :
                new ObjectParameter("DateOfExpiryStartDate", typeof(System.DateTime));
    
            var dateOfExpiryEndDateParameter = dateOfExpiryEndDate.HasValue ?
                new ObjectParameter("DateOfExpiryEndDate", dateOfExpiryEndDate) :
                new ObjectParameter("DateOfExpiryEndDate", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AccreditationSearch_Result>("Pr_AccreditationSearch", accreditationNumberParameter, memberIDParameter, accreditationStatusIDParameter, dateOfIssueStartDateParameter, dateOfIssueEndDateParameter, dateOfExpiryStartDateParameter, dateOfExpiryEndDateParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_AccreditationIssuingSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_AccreditationIssuingSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_PrintoutCreate_Result> Pr_PrintoutCreate(Nullable<int> entityID, Nullable<long> itemID, Nullable<short> printoutTypeID, Nullable<long> printedByID, Nullable<bool> isRePrint, string reprintReason, Nullable<bool> isTestPrint, string documentNumber)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(int));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var printoutTypeIDParameter = printoutTypeID.HasValue ?
                new ObjectParameter("PrintoutTypeID", printoutTypeID) :
                new ObjectParameter("PrintoutTypeID", typeof(short));
    
            var printedByIDParameter = printedByID.HasValue ?
                new ObjectParameter("PrintedByID", printedByID) :
                new ObjectParameter("PrintedByID", typeof(long));
    
            var isRePrintParameter = isRePrint.HasValue ?
                new ObjectParameter("IsRePrint", isRePrint) :
                new ObjectParameter("IsRePrint", typeof(bool));
    
            var reprintReasonParameter = reprintReason != null ?
                new ObjectParameter("ReprintReason", reprintReason) :
                new ObjectParameter("ReprintReason", typeof(string));
    
            var isTestPrintParameter = isTestPrint.HasValue ?
                new ObjectParameter("IsTestPrint", isTestPrint) :
                new ObjectParameter("IsTestPrint", typeof(bool));
    
            var documentNumberParameter = documentNumber != null ?
                new ObjectParameter("DocumentNumber", documentNumber) :
                new ObjectParameter("DocumentNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_PrintoutCreate_Result>("Pr_PrintoutCreate", entityIDParameter, itemIDParameter, printoutTypeIDParameter, printedByIDParameter, isRePrintParameter, reprintReasonParameter, isTestPrintParameter, documentNumberParameter);
        }
    
        public virtual ObjectResult<Pr_PrintoutGetByToken_Result> Pr_PrintoutGetByToken(string verificationToken, Nullable<long> userID)
        {
            var verificationTokenParameter = verificationToken != null ?
                new ObjectParameter("VerificationToken", verificationToken) :
                new ObjectParameter("VerificationToken", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_PrintoutGetByToken_Result>("Pr_PrintoutGetByToken", verificationTokenParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationAdjudicationDecisionCommit(Nullable<long> applicationAdjudicationID, Nullable<short> adjudicationDecisionID, Nullable<int> licenceDurationID, Nullable<System.DateTime> licenceExpiryDate, string comments, Nullable<long> userID)
        {
            var applicationAdjudicationIDParameter = applicationAdjudicationID.HasValue ?
                new ObjectParameter("ApplicationAdjudicationID", applicationAdjudicationID) :
                new ObjectParameter("ApplicationAdjudicationID", typeof(long));
    
            var adjudicationDecisionIDParameter = adjudicationDecisionID.HasValue ?
                new ObjectParameter("AdjudicationDecisionID", adjudicationDecisionID) :
                new ObjectParameter("AdjudicationDecisionID", typeof(short));
    
            var licenceDurationIDParameter = licenceDurationID.HasValue ?
                new ObjectParameter("LicenceDurationID", licenceDurationID) :
                new ObjectParameter("LicenceDurationID", typeof(int));
    
            var licenceExpiryDateParameter = licenceExpiryDate.HasValue ?
                new ObjectParameter("LicenceExpiryDate", licenceExpiryDate) :
                new ObjectParameter("LicenceExpiryDate", typeof(System.DateTime));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAdjudicationDecisionCommit", applicationAdjudicationIDParameter, adjudicationDecisionIDParameter, licenceDurationIDParameter, licenceExpiryDateParameter, commentsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AccreditationIssueSearch_Result> Pr_AccreditationIssueSearch(string applicationRequestTypes, Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID)
        {
            var applicationRequestTypesParameter = applicationRequestTypes != null ?
                new ObjectParameter("ApplicationRequestTypes", applicationRequestTypes) :
                new ObjectParameter("ApplicationRequestTypes", typeof(string));
    
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AccreditationIssueSearch_Result>("Pr_AccreditationIssueSearch", applicationRequestTypesParameter, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AdvancedSearch_Result> Pr_AdvancedSearch(string searchTerm, Nullable<long> userID)
        {
            var searchTermParameter = searchTerm != null ?
                new ObjectParameter("SearchTerm", searchTerm) :
                new ObjectParameter("SearchTerm", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AdvancedSearch_Result>("Pr_AdvancedSearch", searchTermParameter, userIDParameter);
        }
    
        public virtual int Pr_AccreditationStatusUpdate(Nullable<long> userID, string comments, Nullable<long> accreditationID, Nullable<short> accreditationStatusID, Nullable<bool> isTransactionRequired)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var accreditationIDParameter = accreditationID.HasValue ?
                new ObjectParameter("AccreditationID", accreditationID) :
                new ObjectParameter("AccreditationID", typeof(long));
    
            var accreditationStatusIDParameter = accreditationStatusID.HasValue ?
                new ObjectParameter("AccreditationStatusID", accreditationStatusID) :
                new ObjectParameter("AccreditationStatusID", typeof(short));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AccreditationStatusUpdate", userIDParameter, commentsParameter, accreditationIDParameter, accreditationStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual ObjectResult<Pr_Dashboard_AvgProcessingTime_Result> Pr_Dashboard_AvgProcessingTime(string applicationrequestTypeIDs, Nullable<System.DateTime> dateFrom, Nullable<System.DateTime> dateTo, Nullable<long> userID)
        {
            var applicationrequestTypeIDsParameter = applicationrequestTypeIDs != null ?
                new ObjectParameter("ApplicationrequestTypeIDs", applicationrequestTypeIDs) :
                new ObjectParameter("ApplicationrequestTypeIDs", typeof(string));
    
            var dateFromParameter = dateFrom.HasValue ?
                new ObjectParameter("DateFrom", dateFrom) :
                new ObjectParameter("DateFrom", typeof(System.DateTime));
    
            var dateToParameter = dateTo.HasValue ?
                new ObjectParameter("DateTo", dateTo) :
                new ObjectParameter("DateTo", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Dashboard_AvgProcessingTime_Result>("Pr_Dashboard_AvgProcessingTime", applicationrequestTypeIDsParameter, dateFromParameter, dateToParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_NewRouteRequestSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_NewRouteRequestSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_NewRouteRequestDetails> Pr_NewRouteRequestSearch(Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID)
        {
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_NewRouteRequestDetails>("Pr_NewRouteRequestSearch", includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_NewRouteRequestDetails> Pr_NewRouteRequestSearch(Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID, MergeOption mergeOption)
        {
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_NewRouteRequestDetails>("Pr_NewRouteRequestSearch", mergeOption, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestTypeDivisionSetupCreate(Nullable<short> applicationRequestTypeID, Nullable<short> divisionTypeID, Nullable<short> provinceID, Nullable<long> userID)
        {
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(short));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestTypeDivisionSetupCreate", applicationRequestTypeIDParameter, divisionTypeIDParameter, provinceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationRequestTypeDivisionSetupSearch_Result> Pr_ApplicationRequestTypeDivisionSetupSearch(Nullable<short> applicationRequestTypeID, Nullable<short> divisionTypeID, Nullable<short> provinceID, Nullable<long> userID)
        {
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(short));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationRequestTypeDivisionSetupSearch_Result>("Pr_ApplicationRequestTypeDivisionSetupSearch", applicationRequestTypeIDParameter, divisionTypeIDParameter, provinceIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestTypeDocumentCancel(Nullable<int> applicationRequestTypeDocumentID, Nullable<long> userID)
        {
            var applicationRequestTypeDocumentIDParameter = applicationRequestTypeDocumentID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeDocumentID", applicationRequestTypeDocumentID) :
                new ObjectParameter("ApplicationRequestTypeDocumentID", typeof(int));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestTypeDocumentCancel", applicationRequestTypeDocumentIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestTypeDocumentUpsert(Nullable<int> applicationRequestTypeDocumentID, Nullable<short> divisionTypeID, Nullable<short> provinceID, Nullable<short> applicationRequestTypeID, Nullable<short> documentTypeID, Nullable<long> workflowTemplateID, string isAvailableForUpload, string isMandatory, Nullable<long> userID)
        {
            var applicationRequestTypeDocumentIDParameter = applicationRequestTypeDocumentID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeDocumentID", applicationRequestTypeDocumentID) :
                new ObjectParameter("ApplicationRequestTypeDocumentID", typeof(int));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(short));
    
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(short));
    
            var workflowTemplateIDParameter = workflowTemplateID.HasValue ?
                new ObjectParameter("WorkflowTemplateID", workflowTemplateID) :
                new ObjectParameter("WorkflowTemplateID", typeof(long));
    
            var isAvailableForUploadParameter = isAvailableForUpload != null ?
                new ObjectParameter("IsAvailableForUpload", isAvailableForUpload) :
                new ObjectParameter("IsAvailableForUpload", typeof(string));
    
            var isMandatoryParameter = isMandatory != null ?
                new ObjectParameter("IsMandatory", isMandatory) :
                new ObjectParameter("IsMandatory", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestTypeDocumentUpsert", applicationRequestTypeDocumentIDParameter, divisionTypeIDParameter, provinceIDParameter, applicationRequestTypeIDParameter, documentTypeIDParameter, workflowTemplateIDParameter, isAvailableForUploadParameter, isMandatoryParameter, userIDParameter);
        }
    
        public virtual int Pr_DocumentTypeCancel(Nullable<long> documentTypeID, Nullable<long> userID)
        {
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DocumentTypeCancel", documentTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_DocumentTypeQuestionCancel(string documentTypeQuestionIDs, Nullable<long> documentTypeID, Nullable<long> userID)
        {
            var documentTypeQuestionIDsParameter = documentTypeQuestionIDs != null ?
                new ObjectParameter("DocumentTypeQuestionIDs", documentTypeQuestionIDs) :
                new ObjectParameter("DocumentTypeQuestionIDs", typeof(string));
    
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DocumentTypeQuestionCancel", documentTypeQuestionIDsParameter, documentTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_DocumentTypeQuestionUpsert(Nullable<long> documentTypeQuestionID, Nullable<long> documentTypeID, Nullable<short> captureFieldID, string question, Nullable<long> orderBy, Nullable<long> userID)
        {
            var documentTypeQuestionIDParameter = documentTypeQuestionID.HasValue ?
                new ObjectParameter("DocumentTypeQuestionID", documentTypeQuestionID) :
                new ObjectParameter("DocumentTypeQuestionID", typeof(long));
    
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(long));
    
            var captureFieldIDParameter = captureFieldID.HasValue ?
                new ObjectParameter("CaptureFieldID", captureFieldID) :
                new ObjectParameter("CaptureFieldID", typeof(short));
    
            var questionParameter = question != null ?
                new ObjectParameter("Question", question) :
                new ObjectParameter("Question", typeof(string));
    
            var orderByParameter = orderBy.HasValue ?
                new ObjectParameter("OrderBy", orderBy) :
                new ObjectParameter("OrderBy", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DocumentTypeQuestionUpsert", documentTypeQuestionIDParameter, documentTypeIDParameter, captureFieldIDParameter, questionParameter, orderByParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_DocumentTypeUpsert(Nullable<long> documentTypeID, string description, Nullable<bool> isDocumentTitleEditable, Nullable<bool> isExpiryDateRequired, Nullable<bool> isUniqueEntityDocument, Nullable<long> userID)
        {
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(long));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var isDocumentTitleEditableParameter = isDocumentTitleEditable.HasValue ?
                new ObjectParameter("IsDocumentTitleEditable", isDocumentTitleEditable) :
                new ObjectParameter("IsDocumentTitleEditable", typeof(bool));
    
            var isExpiryDateRequiredParameter = isExpiryDateRequired.HasValue ?
                new ObjectParameter("IsExpiryDateRequired", isExpiryDateRequired) :
                new ObjectParameter("IsExpiryDateRequired", typeof(bool));
    
            var isUniqueEntityDocumentParameter = isUniqueEntityDocument.HasValue ?
                new ObjectParameter("IsUniqueEntityDocument", isUniqueEntityDocument) :
                new ObjectParameter("IsUniqueEntityDocument", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_DocumentTypeUpsert", documentTypeIDParameter, descriptionParameter, isDocumentTitleEditableParameter, isExpiryDateRequiredParameter, isUniqueEntityDocumentParameter, userIDParameter);
        }
    
        public virtual int Pr_UpdateMember(string idNumber, string surnameOrCompanyName, string firstNames, string postalAddress, string postalAddressCode, string physicalAddress, string physicalAddressCode, string telPhone, string telCell, string telFax, string email, string sARSIncomeTaxNumber, string tradeName, Nullable<long> businessTypeID, Nullable<long> userID)
        {
            var idNumberParameter = idNumber != null ?
                new ObjectParameter("IdNumber", idNumber) :
                new ObjectParameter("IdNumber", typeof(string));
    
            var surnameOrCompanyNameParameter = surnameOrCompanyName != null ?
                new ObjectParameter("SurnameOrCompanyName", surnameOrCompanyName) :
                new ObjectParameter("SurnameOrCompanyName", typeof(string));
    
            var firstNamesParameter = firstNames != null ?
                new ObjectParameter("FirstNames", firstNames) :
                new ObjectParameter("FirstNames", typeof(string));
    
            var postalAddressParameter = postalAddress != null ?
                new ObjectParameter("PostalAddress", postalAddress) :
                new ObjectParameter("PostalAddress", typeof(string));
    
            var postalAddressCodeParameter = postalAddressCode != null ?
                new ObjectParameter("PostalAddressCode", postalAddressCode) :
                new ObjectParameter("PostalAddressCode", typeof(string));
    
            var physicalAddressParameter = physicalAddress != null ?
                new ObjectParameter("PhysicalAddress", physicalAddress) :
                new ObjectParameter("PhysicalAddress", typeof(string));
    
            var physicalAddressCodeParameter = physicalAddressCode != null ?
                new ObjectParameter("PhysicalAddressCode", physicalAddressCode) :
                new ObjectParameter("PhysicalAddressCode", typeof(string));
    
            var telPhoneParameter = telPhone != null ?
                new ObjectParameter("TelPhone", telPhone) :
                new ObjectParameter("TelPhone", typeof(string));
    
            var telCellParameter = telCell != null ?
                new ObjectParameter("TelCell", telCell) :
                new ObjectParameter("TelCell", typeof(string));
    
            var telFaxParameter = telFax != null ?
                new ObjectParameter("TelFax", telFax) :
                new ObjectParameter("TelFax", typeof(string));
    
            var emailParameter = email != null ?
                new ObjectParameter("Email", email) :
                new ObjectParameter("Email", typeof(string));
    
            var sARSIncomeTaxNumberParameter = sARSIncomeTaxNumber != null ?
                new ObjectParameter("SARSIncomeTaxNumber", sARSIncomeTaxNumber) :
                new ObjectParameter("SARSIncomeTaxNumber", typeof(string));
    
            var tradeNameParameter = tradeName != null ?
                new ObjectParameter("TradeName", tradeName) :
                new ObjectParameter("TradeName", typeof(string));
    
            var businessTypeIDParameter = businessTypeID.HasValue ?
                new ObjectParameter("BusinessTypeID", businessTypeID) :
                new ObjectParameter("BusinessTypeID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_UpdateMember", idNumberParameter, surnameOrCompanyNameParameter, firstNamesParameter, postalAddressParameter, postalAddressCodeParameter, physicalAddressParameter, physicalAddressCodeParameter, telPhoneParameter, telCellParameter, telFaxParameter, emailParameter, sARSIncomeTaxNumberParameter, tradeNameParameter, businessTypeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_FindMember_Result> Pr_FindMember(string idNumber, Nullable<long> userID)
        {
            var idNumberParameter = idNumber != null ?
                new ObjectParameter("IdNumber", idNumber) :
                new ObjectParameter("IdNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_FindMember_Result>("Pr_FindMember", idNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchApplicationRoutes_Result> Pr_SearchApplicationRoutes(string appReferenceNumber, Nullable<long> userID)
        {
            var appReferenceNumberParameter = appReferenceNumber != null ?
                new ObjectParameter("AppReferenceNumber", appReferenceNumber) :
                new ObjectParameter("AppReferenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchApplicationRoutes_Result>("Pr_SearchApplicationRoutes", appReferenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchLicenceRoutes_Result> Pr_SearchLicenceRoutes(string lirReferenceNumber, Nullable<long> userID)
        {
            var lirReferenceNumberParameter = lirReferenceNumber != null ?
                new ObjectParameter("LirReferenceNumber", lirReferenceNumber) :
                new ObjectParameter("LirReferenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchLicenceRoutes_Result>("Pr_SearchLicenceRoutes", lirReferenceNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRouteRemove(Nullable<long> applicationLicenceID, Nullable<long> verifiedRouteID, string applicationNationalRouteNumber, string applicationBoardRouteNumber, Nullable<long> userID)
        {
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var verifiedRouteIDParameter = verifiedRouteID.HasValue ?
                new ObjectParameter("VerifiedRouteID", verifiedRouteID) :
                new ObjectParameter("VerifiedRouteID", typeof(long));
    
            var applicationNationalRouteNumberParameter = applicationNationalRouteNumber != null ?
                new ObjectParameter("ApplicationNationalRouteNumber", applicationNationalRouteNumber) :
                new ObjectParameter("ApplicationNationalRouteNumber", typeof(string));
    
            var applicationBoardRouteNumberParameter = applicationBoardRouteNumber != null ?
                new ObjectParameter("ApplicationBoardRouteNumber", applicationBoardRouteNumber) :
                new ObjectParameter("ApplicationBoardRouteNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRouteRemove", applicationLicenceIDParameter, verifiedRouteIDParameter, applicationNationalRouteNumberParameter, applicationBoardRouteNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRouteAdd(Nullable<long> applicationLicenceID, Nullable<short> serviceTypeID, string nationalRouteNumber, string boardRouteNumber, Nullable<long> userID)
        {
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var nationalRouteNumberParameter = nationalRouteNumber != null ?
                new ObjectParameter("NationalRouteNumber", nationalRouteNumber) :
                new ObjectParameter("NationalRouteNumber", typeof(string));
    
            var boardRouteNumberParameter = boardRouteNumber != null ?
                new ObjectParameter("BoardRouteNumber", boardRouteNumber) :
                new ObjectParameter("BoardRouteNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRouteAdd", applicationLicenceIDParameter, serviceTypeIDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationLicenseSearch_Result> Pr_ApplicationLicenseSearch(string applicationNumber, Nullable<long> userID)
        {
            var applicationNumberParameter = applicationNumber != null ?
                new ObjectParameter("ApplicationNumber", applicationNumber) :
                new ObjectParameter("ApplicationNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationLicenseSearch_Result>("Pr_ApplicationLicenseSearch", applicationNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceServiceTypesGet_Result> Pr_LicenceServiceTypesGet(Nullable<long> applicationLicenceID, Nullable<long> userID)
        {
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceServiceTypesGet_Result>("Pr_LicenceServiceTypesGet", applicationLicenceIDParameter, userIDParameter);
        }
    
        public virtual int Pr_PurificationLicenceRouteRemove(Nullable<long> licenceID, Nullable<long> verifiedRouteID, string licenceNationalRouteNumber, string licenceBoardRouteNumber, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var verifiedRouteIDParameter = verifiedRouteID.HasValue ?
                new ObjectParameter("VerifiedRouteID", verifiedRouteID) :
                new ObjectParameter("VerifiedRouteID", typeof(long));
    
            var licenceNationalRouteNumberParameter = licenceNationalRouteNumber != null ?
                new ObjectParameter("LicenceNationalRouteNumber", licenceNationalRouteNumber) :
                new ObjectParameter("LicenceNationalRouteNumber", typeof(string));
    
            var licenceBoardRouteNumberParameter = licenceBoardRouteNumber != null ?
                new ObjectParameter("LicenceBoardRouteNumber", licenceBoardRouteNumber) :
                new ObjectParameter("LicenceBoardRouteNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationLicenceRouteRemove", licenceIDParameter, verifiedRouteIDParameter, licenceNationalRouteNumberParameter, licenceBoardRouteNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_VerifiedLicenceServiceTypesGet_Result> Pr_VerifiedLicenceServiceTypesGet(Nullable<long> licenceID, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_VerifiedLicenceServiceTypesGet_Result>("Pr_VerifiedLicenceServiceTypesGet", licenceIDParameter, userIDParameter);
        }
    
        public virtual int Pr_PurificationLicenceRouteAdd(Nullable<long> licenceIssueDetailID, Nullable<short> serviceTypeID, string nationalRouteNumber, string boardRouteNumber, Nullable<long> userID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", typeof(long));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var nationalRouteNumberParameter = nationalRouteNumber != null ?
                new ObjectParameter("NationalRouteNumber", nationalRouteNumber) :
                new ObjectParameter("NationalRouteNumber", typeof(string));
    
            var boardRouteNumberParameter = boardRouteNumber != null ?
                new ObjectParameter("BoardRouteNumber", boardRouteNumber) :
                new ObjectParameter("BoardRouteNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PurificationLicenceRouteAdd", licenceIssueDetailIDParameter, serviceTypeIDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_GetUserDataOnIdSearch_Result> Pr_Purification_GetUserDataOnIdSearch(string oldIDNumber, string newIDNumber, Nullable<long> userID)
        {
            var oldIDNumberParameter = oldIDNumber != null ?
                new ObjectParameter("OldIDNumber", oldIDNumber) :
                new ObjectParameter("OldIDNumber", typeof(string));
    
            var newIDNumberParameter = newIDNumber != null ?
                new ObjectParameter("NewIDNumber", newIDNumber) :
                new ObjectParameter("NewIDNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_GetUserDataOnIdSearch_Result>("Pr_Purification_GetUserDataOnIdSearch", oldIDNumberParameter, newIDNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_UpdateIdNumber(string oldIDNumber, string newIDNumber, Nullable<long> userID)
        {
            var oldIDNumberParameter = oldIDNumber != null ?
                new ObjectParameter("OldIDNumber", oldIDNumber) :
                new ObjectParameter("OldIDNumber", typeof(string));
    
            var newIDNumberParameter = newIDNumber != null ?
                new ObjectParameter("NewIDNumber", newIDNumber) :
                new ObjectParameter("NewIDNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_UpdateIdNumber", oldIDNumberParameter, newIDNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_AdjudicationApplicationDetails> Pr_AdjudicationApplicationListGet(Nullable<long> adjudicationDetailID, Nullable<long> userID)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_AdjudicationApplicationDetails>("Pr_AdjudicationApplicationListGet", adjudicationDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_AdjudicationApplicationDetails> Pr_AdjudicationApplicationListGet(Nullable<long> adjudicationDetailID, Nullable<long> userID, MergeOption mergeOption)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_AdjudicationApplicationDetails>("Pr_AdjudicationApplicationListGet", mergeOption, adjudicationDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_GazetteSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_GazetteSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_AdjudicationSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_AdjudicationSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AdjudicationApplicationSearch_Result> Pr_AdjudicationApplicationSearch(Nullable<short> applicationSubStatusID, Nullable<short> adjudicationTypeID, Nullable<long> userID)
        {
            var applicationSubStatusIDParameter = applicationSubStatusID.HasValue ?
                new ObjectParameter("ApplicationSubStatusID", applicationSubStatusID) :
                new ObjectParameter("ApplicationSubStatusID", typeof(short));
    
            var adjudicationTypeIDParameter = adjudicationTypeID.HasValue ?
                new ObjectParameter("AdjudicationTypeID", adjudicationTypeID) :
                new ObjectParameter("AdjudicationTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AdjudicationApplicationSearch_Result>("Pr_AdjudicationApplicationSearch", applicationSubStatusIDParameter, adjudicationTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_StationeryBatchCreate(Nullable<short> stationeryBatchTypeID, string fromNumber, string toNumber, Nullable<long> intFromNumber, Nullable<long> intToNumber, string prefix, Nullable<long> userID)
        {
            var stationeryBatchTypeIDParameter = stationeryBatchTypeID.HasValue ?
                new ObjectParameter("StationeryBatchTypeID", stationeryBatchTypeID) :
                new ObjectParameter("StationeryBatchTypeID", typeof(short));
    
            var fromNumberParameter = fromNumber != null ?
                new ObjectParameter("FromNumber", fromNumber) :
                new ObjectParameter("FromNumber", typeof(string));
    
            var toNumberParameter = toNumber != null ?
                new ObjectParameter("ToNumber", toNumber) :
                new ObjectParameter("ToNumber", typeof(string));
    
            var intFromNumberParameter = intFromNumber.HasValue ?
                new ObjectParameter("IntFromNumber", intFromNumber) :
                new ObjectParameter("IntFromNumber", typeof(long));
    
            var intToNumberParameter = intToNumber.HasValue ?
                new ObjectParameter("IntToNumber", intToNumber) :
                new ObjectParameter("IntToNumber", typeof(long));
    
            var prefixParameter = prefix != null ?
                new ObjectParameter("Prefix", prefix) :
                new ObjectParameter("Prefix", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_StationeryBatchCreate", stationeryBatchTypeIDParameter, fromNumberParameter, toNumberParameter, intFromNumberParameter, intToNumberParameter, prefixParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_StationeryBatchesGet_Result> Pr_StationeryBatchesGet(string searchType, Nullable<long> userID)
        {
            var searchTypeParameter = searchType != null ?
                new ObjectParameter("SearchType", searchType) :
                new ObjectParameter("SearchType", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_StationeryBatchesGet_Result>("Pr_StationeryBatchesGet", searchTypeParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Stationery> Pr_StationeryAssignPrecheck(string fromNumber, Nullable<long> numberOfPagesIssued, Nullable<long> userID)
        {
            var fromNumberParameter = fromNumber != null ?
                new ObjectParameter("FromNumber", fromNumber) :
                new ObjectParameter("FromNumber", typeof(string));
    
            var numberOfPagesIssuedParameter = numberOfPagesIssued.HasValue ?
                new ObjectParameter("NumberOfPagesIssued", numberOfPagesIssued) :
                new ObjectParameter("NumberOfPagesIssued", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Stationery>("Pr_StationeryAssignPrecheck", fromNumberParameter, numberOfPagesIssuedParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Stationery> Pr_StationeryAssignPrecheck(string fromNumber, Nullable<long> numberOfPagesIssued, Nullable<long> userID, MergeOption mergeOption)
        {
            var fromNumberParameter = fromNumber != null ?
                new ObjectParameter("FromNumber", fromNumber) :
                new ObjectParameter("FromNumber", typeof(string));
    
            var numberOfPagesIssuedParameter = numberOfPagesIssued.HasValue ?
                new ObjectParameter("NumberOfPagesIssued", numberOfPagesIssued) :
                new ObjectParameter("NumberOfPagesIssued", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Stationery>("Pr_StationeryAssignPrecheck", mergeOption, fromNumberParameter, numberOfPagesIssuedParameter, userIDParameter);
        }
    
        public virtual int Pr_StationeryAssign(Nullable<long> assignToID, string fromNumber, Nullable<long> numberOfPagesIssued, Nullable<long> userID)
        {
            var assignToIDParameter = assignToID.HasValue ?
                new ObjectParameter("AssignToID", assignToID) :
                new ObjectParameter("AssignToID", typeof(long));
    
            var fromNumberParameter = fromNumber != null ?
                new ObjectParameter("FromNumber", fromNumber) :
                new ObjectParameter("FromNumber", typeof(string));
    
            var numberOfPagesIssuedParameter = numberOfPagesIssued.HasValue ?
                new ObjectParameter("NumberOfPagesIssued", numberOfPagesIssued) :
                new ObjectParameter("NumberOfPagesIssued", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_StationeryAssign", assignToIDParameter, fromNumberParameter, numberOfPagesIssuedParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Stationery> Pr_FirstStationeryNumberGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Stationery>("Pr_FirstStationeryNumberGet", userIDParameter);
        }
    
        public virtual ObjectResult<Stationery> Pr_FirstStationeryNumberGet(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Stationery>("Pr_FirstStationeryNumberGet", mergeOption, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_IssuedStationeryGet_Result> Pr_IssuedStationeryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_IssuedStationeryGet_Result>("Pr_IssuedStationeryGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_IssuedToStationeryGet_Result> Pr_IssuedToStationeryGet(Nullable<long> issuedToID, string stationeryStatusIDs, Nullable<long> userID)
        {
            var issuedToIDParameter = issuedToID.HasValue ?
                new ObjectParameter("IssuedToID", issuedToID) :
                new ObjectParameter("IssuedToID", typeof(long));
    
            var stationeryStatusIDsParameter = stationeryStatusIDs != null ?
                new ObjectParameter("StationeryStatusIDs", stationeryStatusIDs) :
                new ObjectParameter("StationeryStatusIDs", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_IssuedToStationeryGet_Result>("Pr_IssuedToStationeryGet", issuedToIDParameter, stationeryStatusIDsParameter, userIDParameter);
        }
    
        public virtual int Pr_ReturnedIssuedStationery(Nullable<long> issuedToID, Nullable<long> stationeryID, Nullable<short> stationeryStatusID, Nullable<long> stationeryScanDocID, string comments, Nullable<long> userID)
        {
            var issuedToIDParameter = issuedToID.HasValue ?
                new ObjectParameter("IssuedToID", issuedToID) :
                new ObjectParameter("IssuedToID", typeof(long));
    
            var stationeryIDParameter = stationeryID.HasValue ?
                new ObjectParameter("StationeryID", stationeryID) :
                new ObjectParameter("StationeryID", typeof(long));
    
            var stationeryStatusIDParameter = stationeryStatusID.HasValue ?
                new ObjectParameter("StationeryStatusID", stationeryStatusID) :
                new ObjectParameter("StationeryStatusID", typeof(short));
    
            var stationeryScanDocIDParameter = stationeryScanDocID.HasValue ?
                new ObjectParameter("StationeryScanDocID", stationeryScanDocID) :
                new ObjectParameter("StationeryScanDocID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ReturnedIssuedStationery", issuedToIDParameter, stationeryIDParameter, stationeryStatusIDParameter, stationeryScanDocIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual int Pr_StationeryTransfer(string fromNumber, Nullable<long> numberOfPagesIssued, Nullable<short> stationeryBatchTypeID, Nullable<short> officeLocationID, string externalPartyDescription, string externalPartyContactName, string externalPartyContactEmail, string staioneryIDs, Nullable<long> userID)
        {
            var fromNumberParameter = fromNumber != null ?
                new ObjectParameter("FromNumber", fromNumber) :
                new ObjectParameter("FromNumber", typeof(string));
    
            var numberOfPagesIssuedParameter = numberOfPagesIssued.HasValue ?
                new ObjectParameter("NumberOfPagesIssued", numberOfPagesIssued) :
                new ObjectParameter("NumberOfPagesIssued", typeof(long));
    
            var stationeryBatchTypeIDParameter = stationeryBatchTypeID.HasValue ?
                new ObjectParameter("StationeryBatchTypeID", stationeryBatchTypeID) :
                new ObjectParameter("StationeryBatchTypeID", typeof(short));
    
            var officeLocationIDParameter = officeLocationID.HasValue ?
                new ObjectParameter("OfficeLocationID", officeLocationID) :
                new ObjectParameter("OfficeLocationID", typeof(short));
    
            var externalPartyDescriptionParameter = externalPartyDescription != null ?
                new ObjectParameter("ExternalPartyDescription", externalPartyDescription) :
                new ObjectParameter("ExternalPartyDescription", typeof(string));
    
            var externalPartyContactNameParameter = externalPartyContactName != null ?
                new ObjectParameter("ExternalPartyContactName", externalPartyContactName) :
                new ObjectParameter("ExternalPartyContactName", typeof(string));
    
            var externalPartyContactEmailParameter = externalPartyContactEmail != null ?
                new ObjectParameter("ExternalPartyContactEmail", externalPartyContactEmail) :
                new ObjectParameter("ExternalPartyContactEmail", typeof(string));
    
            var staioneryIDsParameter = staioneryIDs != null ?
                new ObjectParameter("StaioneryIDs", staioneryIDs) :
                new ObjectParameter("StaioneryIDs", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_StationeryTransfer", fromNumberParameter, numberOfPagesIssuedParameter, stationeryBatchTypeIDParameter, officeLocationIDParameter, externalPartyDescriptionParameter, externalPartyContactNameParameter, externalPartyContactEmailParameter, staioneryIDsParameter, userIDParameter);
        }
    
        public virtual int Pr_StationeryBatchReceived(Nullable<long> stationeryBatchID, Nullable<long> userID)
        {
            var stationeryBatchIDParameter = stationeryBatchID.HasValue ?
                new ObjectParameter("StationeryBatchID", stationeryBatchID) :
                new ObjectParameter("StationeryBatchID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_StationeryBatchReceived", stationeryBatchIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Stationery> Pr_StationeryNumberGetNext(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Stationery>("Pr_StationeryNumberGetNext", userIDParameter);
        }
    
        public virtual ObjectResult<Stationery> Pr_StationeryNumberGetNext(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Stationery>("Pr_StationeryNumberGetNext", mergeOption, userIDParameter);
        }
    
        public virtual int Pr_StationeryStatusHistoryUpdate(Nullable<long> stationeryID, Nullable<short> stationeryStatusID, string comments, Nullable<long> userID)
        {
            var stationeryIDParameter = stationeryID.HasValue ?
                new ObjectParameter("StationeryID", stationeryID) :
                new ObjectParameter("StationeryID", typeof(long));
    
            var stationeryStatusIDParameter = stationeryStatusID.HasValue ?
                new ObjectParameter("StationeryStatusID", stationeryStatusID) :
                new ObjectParameter("StationeryStatusID", typeof(short));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_StationeryStatusHistoryUpdate", stationeryIDParameter, stationeryStatusIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual int Pr_PrintoutUpdate(Nullable<int> entityID, Nullable<long> itemID, string verificationToken, string documentNumber, Nullable<bool> printedSuccussfully, Nullable<long> userID)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(int));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var verificationTokenParameter = verificationToken != null ?
                new ObjectParameter("VerificationToken", verificationToken) :
                new ObjectParameter("VerificationToken", typeof(string));
    
            var documentNumberParameter = documentNumber != null ?
                new ObjectParameter("DocumentNumber", documentNumber) :
                new ObjectParameter("DocumentNumber", typeof(string));
    
            var printedSuccussfullyParameter = printedSuccussfully.HasValue ?
                new ObjectParameter("PrintedSuccussfully", printedSuccussfully) :
                new ObjectParameter("PrintedSuccussfully", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PrintoutUpdate", entityIDParameter, itemIDParameter, verificationTokenParameter, documentNumberParameter, printedSuccussfullyParameter, userIDParameter);
        }
    
        public virtual int Pr_PrintoutSaveData(string verificationToken, string json, Nullable<long> userID)
        {
            var verificationTokenParameter = verificationToken != null ?
                new ObjectParameter("VerificationToken", verificationToken) :
                new ObjectParameter("VerificationToken", typeof(string));
    
            var jsonParameter = json != null ?
                new ObjectParameter("Json", json) :
                new ObjectParameter("Json", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PrintoutSaveData", verificationTokenParameter, jsonParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AdjudicationSearch_Result> Pr_AdjudicationSearch(Nullable<short> adjudicationDetailStatusID, Nullable<System.DateTime> adjudicationDateFrom, Nullable<System.DateTime> adjudicationDateTo, Nullable<long> userID)
        {
            var adjudicationDetailStatusIDParameter = adjudicationDetailStatusID.HasValue ?
                new ObjectParameter("AdjudicationDetailStatusID", adjudicationDetailStatusID) :
                new ObjectParameter("AdjudicationDetailStatusID", typeof(short));
    
            var adjudicationDateFromParameter = adjudicationDateFrom.HasValue ?
                new ObjectParameter("AdjudicationDateFrom", adjudicationDateFrom) :
                new ObjectParameter("AdjudicationDateFrom", typeof(System.DateTime));
    
            var adjudicationDateToParameter = adjudicationDateTo.HasValue ?
                new ObjectParameter("AdjudicationDateTo", adjudicationDateTo) :
                new ObjectParameter("AdjudicationDateTo", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AdjudicationSearch_Result>("Pr_AdjudicationSearch", adjudicationDetailStatusIDParameter, adjudicationDateFromParameter, adjudicationDateToParameter, userIDParameter);
        }
    
        public virtual ObjectResult<AdjudicationDetail> Pr_AdjudicationCreate(Nullable<short> adjudicationTypeID, Nullable<System.DateTime> meetingDate, Nullable<System.DateTime> meetingDateEnd, Nullable<short> maxAdjudicationAutoApplicationCount, Nullable<long> adjudicationOfficeLocationID, Nullable<long> userID)
        {
            var adjudicationTypeIDParameter = adjudicationTypeID.HasValue ?
                new ObjectParameter("AdjudicationTypeID", adjudicationTypeID) :
                new ObjectParameter("AdjudicationTypeID", typeof(short));
    
            var meetingDateParameter = meetingDate.HasValue ?
                new ObjectParameter("MeetingDate", meetingDate) :
                new ObjectParameter("MeetingDate", typeof(System.DateTime));
    
            var meetingDateEndParameter = meetingDateEnd.HasValue ?
                new ObjectParameter("MeetingDateEnd", meetingDateEnd) :
                new ObjectParameter("MeetingDateEnd", typeof(System.DateTime));
    
            var maxAdjudicationAutoApplicationCountParameter = maxAdjudicationAutoApplicationCount.HasValue ?
                new ObjectParameter("MaxAdjudicationAutoApplicationCount", maxAdjudicationAutoApplicationCount) :
                new ObjectParameter("MaxAdjudicationAutoApplicationCount", typeof(short));
    
            var adjudicationOfficeLocationIDParameter = adjudicationOfficeLocationID.HasValue ?
                new ObjectParameter("AdjudicationOfficeLocationID", adjudicationOfficeLocationID) :
                new ObjectParameter("AdjudicationOfficeLocationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<AdjudicationDetail>("Pr_AdjudicationCreate", adjudicationTypeIDParameter, meetingDateParameter, meetingDateEndParameter, maxAdjudicationAutoApplicationCountParameter, adjudicationOfficeLocationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<AdjudicationDetail> Pr_AdjudicationCreate(Nullable<short> adjudicationTypeID, Nullable<System.DateTime> meetingDate, Nullable<System.DateTime> meetingDateEnd, Nullable<short> maxAdjudicationAutoApplicationCount, Nullable<long> adjudicationOfficeLocationID, Nullable<long> userID, MergeOption mergeOption)
        {
            var adjudicationTypeIDParameter = adjudicationTypeID.HasValue ?
                new ObjectParameter("AdjudicationTypeID", adjudicationTypeID) :
                new ObjectParameter("AdjudicationTypeID", typeof(short));
    
            var meetingDateParameter = meetingDate.HasValue ?
                new ObjectParameter("MeetingDate", meetingDate) :
                new ObjectParameter("MeetingDate", typeof(System.DateTime));
    
            var meetingDateEndParameter = meetingDateEnd.HasValue ?
                new ObjectParameter("MeetingDateEnd", meetingDateEnd) :
                new ObjectParameter("MeetingDateEnd", typeof(System.DateTime));
    
            var maxAdjudicationAutoApplicationCountParameter = maxAdjudicationAutoApplicationCount.HasValue ?
                new ObjectParameter("MaxAdjudicationAutoApplicationCount", maxAdjudicationAutoApplicationCount) :
                new ObjectParameter("MaxAdjudicationAutoApplicationCount", typeof(short));
    
            var adjudicationOfficeLocationIDParameter = adjudicationOfficeLocationID.HasValue ?
                new ObjectParameter("AdjudicationOfficeLocationID", adjudicationOfficeLocationID) :
                new ObjectParameter("AdjudicationOfficeLocationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<AdjudicationDetail>("Pr_AdjudicationCreate", mergeOption, adjudicationTypeIDParameter, meetingDateParameter, meetingDateEndParameter, maxAdjudicationAutoApplicationCountParameter, adjudicationOfficeLocationIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationUpdateDates(Nullable<long> adjudicationDetailID, Nullable<System.DateTime> meetingDate, Nullable<System.DateTime> meetingDateEnd, Nullable<long> userID)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var meetingDateParameter = meetingDate.HasValue ?
                new ObjectParameter("MeetingDate", meetingDate) :
                new ObjectParameter("MeetingDate", typeof(System.DateTime));
    
            var meetingDateEndParameter = meetingDateEnd.HasValue ?
                new ObjectParameter("MeetingDateEnd", meetingDateEnd) :
                new ObjectParameter("MeetingDateEnd", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationUpdateDates", adjudicationDetailIDParameter, meetingDateParameter, meetingDateEndParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationAdjudicationGet_Result> Pr_ApplicationAdjudicationGet(Nullable<long> applicationAdjudicationID, Nullable<long> userID)
        {
            var applicationAdjudicationIDParameter = applicationAdjudicationID.HasValue ?
                new ObjectParameter("ApplicationAdjudicationID", applicationAdjudicationID) :
                new ObjectParameter("ApplicationAdjudicationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationAdjudicationGet_Result>("Pr_ApplicationAdjudicationGet", applicationAdjudicationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AppDocumentsAwaitingVerificationGet_Result> Pr_AppDocumentsAwaitingVerificationGet(Nullable<long> entityID, Nullable<long> itemID)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(long));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AppDocumentsAwaitingVerificationGet_Result>("Pr_AppDocumentsAwaitingVerificationGet", entityIDParameter, itemIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationLicenceTemporaryReplacementGet_Result> Pr_ApplicationLicenceTemporaryReplacementGet(Nullable<long> applicationLicenceID, Nullable<long> userID)
        {
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationLicenceTemporaryReplacementGet_Result>("Pr_ApplicationLicenceTemporaryReplacementGet", applicationLicenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_VerifiedLicenceXmlGet(string iDNumber, string operatingLicenceNumber, string registrationNumber, string vehicleChassisNumber)
        {
            var iDNumberParameter = iDNumber != null ?
                new ObjectParameter("IDNumber", iDNumber) :
                new ObjectParameter("IDNumber", typeof(string));
    
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var registrationNumberParameter = registrationNumber != null ?
                new ObjectParameter("RegistrationNumber", registrationNumber) :
                new ObjectParameter("RegistrationNumber", typeof(string));
    
            var vehicleChassisNumberParameter = vehicleChassisNumber != null ?
                new ObjectParameter("VehicleChassisNumber", vehicleChassisNumber) :
                new ObjectParameter("VehicleChassisNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_VerifiedLicenceXmlGet", iDNumberParameter, operatingLicenceNumberParameter, registrationNumberParameter, vehicleChassisNumberParameter);
        }
    
        public virtual int Pr_OfficeLocationSetupDocumentTemplateUpsert(Nullable<long> officeLocationID, Nullable<long> preAdjudicationLetterDocumentID, Nullable<long> preAdjudicationObjectionLetterDocumentID, Nullable<long> postAdjudicationLetterApprovedDocumentID, Nullable<long> postAdjudicationLetterPostponedDocumentID, Nullable<long> postAdjudicationLetterRefusedDocumentID, Nullable<long> postAdjudicationLetterCancelledDocumentID, Nullable<long> postAdjudicationLetterWithdrawnDocumentID, Nullable<long> postAdjudicationLetterStruckOffDocumentID, Nullable<long> licenceAnnexure_AdjudicationPanelDocumentID, Nullable<long> tATConfirmationReceipt_DocumentID, Nullable<long> userID)
        {
            var officeLocationIDParameter = officeLocationID.HasValue ?
                new ObjectParameter("OfficeLocationID", officeLocationID) :
                new ObjectParameter("OfficeLocationID", typeof(long));
    
            var preAdjudicationLetterDocumentIDParameter = preAdjudicationLetterDocumentID.HasValue ?
                new ObjectParameter("PreAdjudicationLetterDocumentID", preAdjudicationLetterDocumentID) :
                new ObjectParameter("PreAdjudicationLetterDocumentID", typeof(long));
    
            var preAdjudicationObjectionLetterDocumentIDParameter = preAdjudicationObjectionLetterDocumentID.HasValue ?
                new ObjectParameter("PreAdjudicationObjectionLetterDocumentID", preAdjudicationObjectionLetterDocumentID) :
                new ObjectParameter("PreAdjudicationObjectionLetterDocumentID", typeof(long));
    
            var postAdjudicationLetterApprovedDocumentIDParameter = postAdjudicationLetterApprovedDocumentID.HasValue ?
                new ObjectParameter("PostAdjudicationLetterApprovedDocumentID", postAdjudicationLetterApprovedDocumentID) :
                new ObjectParameter("PostAdjudicationLetterApprovedDocumentID", typeof(long));
    
            var postAdjudicationLetterPostponedDocumentIDParameter = postAdjudicationLetterPostponedDocumentID.HasValue ?
                new ObjectParameter("PostAdjudicationLetterPostponedDocumentID", postAdjudicationLetterPostponedDocumentID) :
                new ObjectParameter("PostAdjudicationLetterPostponedDocumentID", typeof(long));
    
            var postAdjudicationLetterRefusedDocumentIDParameter = postAdjudicationLetterRefusedDocumentID.HasValue ?
                new ObjectParameter("PostAdjudicationLetterRefusedDocumentID", postAdjudicationLetterRefusedDocumentID) :
                new ObjectParameter("PostAdjudicationLetterRefusedDocumentID", typeof(long));
    
            var postAdjudicationLetterCancelledDocumentIDParameter = postAdjudicationLetterCancelledDocumentID.HasValue ?
                new ObjectParameter("PostAdjudicationLetterCancelledDocumentID", postAdjudicationLetterCancelledDocumentID) :
                new ObjectParameter("PostAdjudicationLetterCancelledDocumentID", typeof(long));
    
            var postAdjudicationLetterWithdrawnDocumentIDParameter = postAdjudicationLetterWithdrawnDocumentID.HasValue ?
                new ObjectParameter("PostAdjudicationLetterWithdrawnDocumentID", postAdjudicationLetterWithdrawnDocumentID) :
                new ObjectParameter("PostAdjudicationLetterWithdrawnDocumentID", typeof(long));
    
            var postAdjudicationLetterStruckOffDocumentIDParameter = postAdjudicationLetterStruckOffDocumentID.HasValue ?
                new ObjectParameter("PostAdjudicationLetterStruckOffDocumentID", postAdjudicationLetterStruckOffDocumentID) :
                new ObjectParameter("PostAdjudicationLetterStruckOffDocumentID", typeof(long));
    
            var licenceAnnexure_AdjudicationPanelDocumentIDParameter = licenceAnnexure_AdjudicationPanelDocumentID.HasValue ?
                new ObjectParameter("LicenceAnnexure_AdjudicationPanelDocumentID", licenceAnnexure_AdjudicationPanelDocumentID) :
                new ObjectParameter("LicenceAnnexure_AdjudicationPanelDocumentID", typeof(long));
    
            var tATConfirmationReceipt_DocumentIDParameter = tATConfirmationReceipt_DocumentID.HasValue ?
                new ObjectParameter("TATConfirmationReceipt_DocumentID", tATConfirmationReceipt_DocumentID) :
                new ObjectParameter("TATConfirmationReceipt_DocumentID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_OfficeLocationSetupDocumentTemplateUpsert", officeLocationIDParameter, preAdjudicationLetterDocumentIDParameter, preAdjudicationObjectionLetterDocumentIDParameter, postAdjudicationLetterApprovedDocumentIDParameter, postAdjudicationLetterPostponedDocumentIDParameter, postAdjudicationLetterRefusedDocumentIDParameter, postAdjudicationLetterCancelledDocumentIDParameter, postAdjudicationLetterWithdrawnDocumentIDParameter, postAdjudicationLetterStruckOffDocumentIDParameter, licenceAnnexure_AdjudicationPanelDocumentIDParameter, tATConfirmationReceipt_DocumentIDParameter, userIDParameter);
        }
    
        public virtual int Pr_OfficeLocationSetupUpsert(Nullable<long> officeLocationID, string locationName, string locationAddress, Nullable<short> divisionTypeID, Nullable<short> provinceID, Nullable<short> regionID, Nullable<short> licencingBoardID, Nullable<long> paymentClerkUserID, Nullable<long> assessorUserID, Nullable<long> seniorManagerApproverUserID, Nullable<long> inspectionCapturerUserID, Nullable<long> referralCapturerUserID, Nullable<bool> handlesGazetting, string gazetteNumberPrefix, Nullable<long> adjudicationOfficerUserID, Nullable<long> adjudicationSecrataryUserID, string adjudicationAgendaEmails, Nullable<short> adjudicationHearingQuorumCount, Nullable<short> adjudicationMeetingQuorumCount, Nullable<short> maxAdjudicationAutoApplicationCount, Nullable<long> businessRuleBypassApproverUserID, string adjudicationContactName, string adjudicationContactTelPhone, string adjudicationContactEmail, Nullable<long> routeCapturerUserID, Nullable<long> routeApproverUserID, Nullable<long> userID)
        {
            var officeLocationIDParameter = officeLocationID.HasValue ?
                new ObjectParameter("OfficeLocationID", officeLocationID) :
                new ObjectParameter("OfficeLocationID", typeof(long));
    
            var locationNameParameter = locationName != null ?
                new ObjectParameter("LocationName", locationName) :
                new ObjectParameter("LocationName", typeof(string));
    
            var locationAddressParameter = locationAddress != null ?
                new ObjectParameter("LocationAddress", locationAddress) :
                new ObjectParameter("LocationAddress", typeof(string));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var regionIDParameter = regionID.HasValue ?
                new ObjectParameter("RegionID", regionID) :
                new ObjectParameter("RegionID", typeof(short));
    
            var licencingBoardIDParameter = licencingBoardID.HasValue ?
                new ObjectParameter("LicencingBoardID", licencingBoardID) :
                new ObjectParameter("LicencingBoardID", typeof(short));
    
            var paymentClerkUserIDParameter = paymentClerkUserID.HasValue ?
                new ObjectParameter("PaymentClerkUserID", paymentClerkUserID) :
                new ObjectParameter("PaymentClerkUserID", typeof(long));
    
            var assessorUserIDParameter = assessorUserID.HasValue ?
                new ObjectParameter("AssessorUserID", assessorUserID) :
                new ObjectParameter("AssessorUserID", typeof(long));
    
            var seniorManagerApproverUserIDParameter = seniorManagerApproverUserID.HasValue ?
                new ObjectParameter("SeniorManagerApproverUserID", seniorManagerApproverUserID) :
                new ObjectParameter("SeniorManagerApproverUserID", typeof(long));
    
            var inspectionCapturerUserIDParameter = inspectionCapturerUserID.HasValue ?
                new ObjectParameter("InspectionCapturerUserID", inspectionCapturerUserID) :
                new ObjectParameter("InspectionCapturerUserID", typeof(long));
    
            var referralCapturerUserIDParameter = referralCapturerUserID.HasValue ?
                new ObjectParameter("ReferralCapturerUserID", referralCapturerUserID) :
                new ObjectParameter("ReferralCapturerUserID", typeof(long));
    
            var handlesGazettingParameter = handlesGazetting.HasValue ?
                new ObjectParameter("HandlesGazetting", handlesGazetting) :
                new ObjectParameter("HandlesGazetting", typeof(bool));
    
            var gazetteNumberPrefixParameter = gazetteNumberPrefix != null ?
                new ObjectParameter("GazetteNumberPrefix", gazetteNumberPrefix) :
                new ObjectParameter("GazetteNumberPrefix", typeof(string));
    
            var adjudicationOfficerUserIDParameter = adjudicationOfficerUserID.HasValue ?
                new ObjectParameter("AdjudicationOfficerUserID", adjudicationOfficerUserID) :
                new ObjectParameter("AdjudicationOfficerUserID", typeof(long));
    
            var adjudicationSecrataryUserIDParameter = adjudicationSecrataryUserID.HasValue ?
                new ObjectParameter("AdjudicationSecrataryUserID", adjudicationSecrataryUserID) :
                new ObjectParameter("AdjudicationSecrataryUserID", typeof(long));
    
            var adjudicationAgendaEmailsParameter = adjudicationAgendaEmails != null ?
                new ObjectParameter("AdjudicationAgendaEmails", adjudicationAgendaEmails) :
                new ObjectParameter("AdjudicationAgendaEmails", typeof(string));
    
            var adjudicationHearingQuorumCountParameter = adjudicationHearingQuorumCount.HasValue ?
                new ObjectParameter("AdjudicationHearingQuorumCount", adjudicationHearingQuorumCount) :
                new ObjectParameter("AdjudicationHearingQuorumCount", typeof(short));
    
            var adjudicationMeetingQuorumCountParameter = adjudicationMeetingQuorumCount.HasValue ?
                new ObjectParameter("AdjudicationMeetingQuorumCount", adjudicationMeetingQuorumCount) :
                new ObjectParameter("AdjudicationMeetingQuorumCount", typeof(short));
    
            var maxAdjudicationAutoApplicationCountParameter = maxAdjudicationAutoApplicationCount.HasValue ?
                new ObjectParameter("MaxAdjudicationAutoApplicationCount", maxAdjudicationAutoApplicationCount) :
                new ObjectParameter("MaxAdjudicationAutoApplicationCount", typeof(short));
    
            var businessRuleBypassApproverUserIDParameter = businessRuleBypassApproverUserID.HasValue ?
                new ObjectParameter("BusinessRuleBypassApproverUserID", businessRuleBypassApproverUserID) :
                new ObjectParameter("BusinessRuleBypassApproverUserID", typeof(long));
    
            var adjudicationContactNameParameter = adjudicationContactName != null ?
                new ObjectParameter("AdjudicationContactName", adjudicationContactName) :
                new ObjectParameter("AdjudicationContactName", typeof(string));
    
            var adjudicationContactTelPhoneParameter = adjudicationContactTelPhone != null ?
                new ObjectParameter("AdjudicationContactTelPhone", adjudicationContactTelPhone) :
                new ObjectParameter("AdjudicationContactTelPhone", typeof(string));
    
            var adjudicationContactEmailParameter = adjudicationContactEmail != null ?
                new ObjectParameter("AdjudicationContactEmail", adjudicationContactEmail) :
                new ObjectParameter("AdjudicationContactEmail", typeof(string));
    
            var routeCapturerUserIDParameter = routeCapturerUserID.HasValue ?
                new ObjectParameter("RouteCapturerUserID", routeCapturerUserID) :
                new ObjectParameter("RouteCapturerUserID", typeof(long));
    
            var routeApproverUserIDParameter = routeApproverUserID.HasValue ?
                new ObjectParameter("RouteApproverUserID", routeApproverUserID) :
                new ObjectParameter("RouteApproverUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_OfficeLocationSetupUpsert", officeLocationIDParameter, locationNameParameter, locationAddressParameter, divisionTypeIDParameter, provinceIDParameter, regionIDParameter, licencingBoardIDParameter, paymentClerkUserIDParameter, assessorUserIDParameter, seniorManagerApproverUserIDParameter, inspectionCapturerUserIDParameter, referralCapturerUserIDParameter, handlesGazettingParameter, gazetteNumberPrefixParameter, adjudicationOfficerUserIDParameter, adjudicationSecrataryUserIDParameter, adjudicationAgendaEmailsParameter, adjudicationHearingQuorumCountParameter, adjudicationMeetingQuorumCountParameter, maxAdjudicationAutoApplicationCountParameter, businessRuleBypassApproverUserIDParameter, adjudicationContactNameParameter, adjudicationContactTelPhoneParameter, adjudicationContactEmailParameter, routeCapturerUserIDParameter, routeApproverUserIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestTypeDocumentUpdateSqlRules(Nullable<short> documentTypeID, Nullable<long> workflowTemplateID)
        {
            var documentTypeIDParameter = documentTypeID.HasValue ?
                new ObjectParameter("DocumentTypeID", documentTypeID) :
                new ObjectParameter("DocumentTypeID", typeof(short));
    
            var workflowTemplateIDParameter = workflowTemplateID.HasValue ?
                new ObjectParameter("WorkflowTemplateID", workflowTemplateID) :
                new ObjectParameter("WorkflowTemplateID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestTypeDocumentUpdateSqlRules", documentTypeIDParameter, workflowTemplateIDParameter);
        }
    
        public virtual int Pr_LicencingBoardUpsert(Nullable<long> licencingBoardID, string description, Nullable<long> provinceID, Nullable<short> isCancelled, Nullable<long> userID)
        {
            var licencingBoardIDParameter = licencingBoardID.HasValue ?
                new ObjectParameter("LicencingBoardID", licencingBoardID) :
                new ObjectParameter("LicencingBoardID", typeof(long));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(long));
    
            var isCancelledParameter = isCancelled.HasValue ?
                new ObjectParameter("IsCancelled", isCancelled) :
                new ObjectParameter("IsCancelled", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicencingBoardUpsert", licencingBoardIDParameter, descriptionParameter, provinceIDParameter, isCancelledParameter, userIDParameter);
        }
    
        public virtual int Pr_VehicleModelCancel(Nullable<short> vehicleModelID, Nullable<long> userID, string auditDescription)
        {
            var vehicleModelIDParameter = vehicleModelID.HasValue ?
                new ObjectParameter("VehicleModelID", vehicleModelID) :
                new ObjectParameter("VehicleModelID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleModelCancel", vehicleModelIDParameter, userIDParameter, auditDescriptionParameter);
        }
    
        public virtual int Pr_VehicleModelUpsert(Nullable<short> vehicleModelID, Nullable<short> vehicleMakeID, string description, Nullable<short> seatedCapacityExcludingDriver, Nullable<short> standingCapacity, Nullable<long> grossWeight, Nullable<long> tareWeight, Nullable<short> vehicleTypeID, Nullable<short> carryingCapacityID, Nullable<bool> isValidModel, Nullable<long> userID)
        {
            var vehicleModelIDParameter = vehicleModelID.HasValue ?
                new ObjectParameter("VehicleModelID", vehicleModelID) :
                new ObjectParameter("VehicleModelID", typeof(short));
    
            var vehicleMakeIDParameter = vehicleMakeID.HasValue ?
                new ObjectParameter("VehicleMakeID", vehicleMakeID) :
                new ObjectParameter("VehicleMakeID", typeof(short));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var seatedCapacityExcludingDriverParameter = seatedCapacityExcludingDriver.HasValue ?
                new ObjectParameter("SeatedCapacityExcludingDriver", seatedCapacityExcludingDriver) :
                new ObjectParameter("SeatedCapacityExcludingDriver", typeof(short));
    
            var standingCapacityParameter = standingCapacity.HasValue ?
                new ObjectParameter("StandingCapacity", standingCapacity) :
                new ObjectParameter("StandingCapacity", typeof(short));
    
            var grossWeightParameter = grossWeight.HasValue ?
                new ObjectParameter("GrossWeight", grossWeight) :
                new ObjectParameter("GrossWeight", typeof(long));
    
            var tareWeightParameter = tareWeight.HasValue ?
                new ObjectParameter("TareWeight", tareWeight) :
                new ObjectParameter("TareWeight", typeof(long));
    
            var vehicleTypeIDParameter = vehicleTypeID.HasValue ?
                new ObjectParameter("VehicleTypeID", vehicleTypeID) :
                new ObjectParameter("VehicleTypeID", typeof(short));
    
            var carryingCapacityIDParameter = carryingCapacityID.HasValue ?
                new ObjectParameter("CarryingCapacityID", carryingCapacityID) :
                new ObjectParameter("CarryingCapacityID", typeof(short));
    
            var isValidModelParameter = isValidModel.HasValue ?
                new ObjectParameter("IsValidModel", isValidModel) :
                new ObjectParameter("IsValidModel", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleModelUpsert", vehicleModelIDParameter, vehicleMakeIDParameter, descriptionParameter, seatedCapacityExcludingDriverParameter, standingCapacityParameter, grossWeightParameter, tareWeightParameter, vehicleTypeIDParameter, carryingCapacityIDParameter, isValidModelParameter, userIDParameter);
        }
    
        public virtual int Pr_LicencingBoardCancel(Nullable<short> licencingBoardID, Nullable<long> userID, string auditDescription)
        {
            var licencingBoardIDParameter = licencingBoardID.HasValue ?
                new ObjectParameter("LicencingBoardID", licencingBoardID) :
                new ObjectParameter("LicencingBoardID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicencingBoardCancel", licencingBoardIDParameter, userIDParameter, auditDescriptionParameter);
        }
    
        public virtual int Pr_VehicleMakeCancel(Nullable<short> vehicleMakeID, Nullable<long> userID, string auditDescription)
        {
            var vehicleMakeIDParameter = vehicleMakeID.HasValue ?
                new ObjectParameter("VehicleMakeID", vehicleMakeID) :
                new ObjectParameter("VehicleMakeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleMakeCancel", vehicleMakeIDParameter, userIDParameter, auditDescriptionParameter);
        }
    
        public virtual int Pr_VehicleMakeUpsert(Nullable<short> vehicleMakeID, string description, Nullable<bool> isCancelled, Nullable<long> userID)
        {
            var vehicleMakeIDParameter = vehicleMakeID.HasValue ?
                new ObjectParameter("VehicleMakeID", vehicleMakeID) :
                new ObjectParameter("VehicleMakeID", typeof(short));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var isCancelledParameter = isCancelled.HasValue ?
                new ObjectParameter("IsCancelled", isCancelled) :
                new ObjectParameter("IsCancelled", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleMakeUpsert", vehicleMakeIDParameter, descriptionParameter, isCancelledParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetReceiptDetails_Result> Pr_GetReceiptDetails(Nullable<long> receiptDetailID, Nullable<long> userID)
        {
            var receiptDetailIDParameter = receiptDetailID.HasValue ?
                new ObjectParameter("ReceiptDetailID", receiptDetailID) :
                new ObjectParameter("ReceiptDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetReceiptDetails_Result>("Pr_GetReceiptDetails", receiptDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationAwaitingCorrectionsGet_Result> Pr_ApplicationAwaitingCorrectionsGet(Nullable<long> assignedToID, Nullable<long> userID)
        {
            var assignedToIDParameter = assignedToID.HasValue ?
                new ObjectParameter("AssignedToID", assignedToID) :
                new ObjectParameter("AssignedToID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationAwaitingCorrectionsGet_Result>("Pr_ApplicationAwaitingCorrectionsGet", assignedToIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetApplicationAllowedNewLicences_Result> Pr_GetApplicationAllowedNewLicences(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetApplicationAllowedNewLicences_Result>("Pr_GetApplicationAllowedNewLicences", userIDParameter);
        }
    
        public virtual int Pr_Purification_InsertAllowedNewLicence(Nullable<long> applicationAllowedNewLicenceID, string memberName, string idNumberOrBusinessRegistrationNumber, Nullable<long> associationID, string registrationNumber, Nullable<short> applicationAllowedNewLicenceTypeID, string operatingLicenceNumber, string applicationReferenceNumber, Nullable<long> userID)
        {
            var applicationAllowedNewLicenceIDParameter = applicationAllowedNewLicenceID.HasValue ?
                new ObjectParameter("ApplicationAllowedNewLicenceID", applicationAllowedNewLicenceID) :
                new ObjectParameter("ApplicationAllowedNewLicenceID", typeof(long));
    
            var memberNameParameter = memberName != null ?
                new ObjectParameter("MemberName", memberName) :
                new ObjectParameter("MemberName", typeof(string));
    
            var idNumberOrBusinessRegistrationNumberParameter = idNumberOrBusinessRegistrationNumber != null ?
                new ObjectParameter("IdNumberOrBusinessRegistrationNumber", idNumberOrBusinessRegistrationNumber) :
                new ObjectParameter("IdNumberOrBusinessRegistrationNumber", typeof(string));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            var registrationNumberParameter = registrationNumber != null ?
                new ObjectParameter("RegistrationNumber", registrationNumber) :
                new ObjectParameter("RegistrationNumber", typeof(string));
    
            var applicationAllowedNewLicenceTypeIDParameter = applicationAllowedNewLicenceTypeID.HasValue ?
                new ObjectParameter("ApplicationAllowedNewLicenceTypeID", applicationAllowedNewLicenceTypeID) :
                new ObjectParameter("ApplicationAllowedNewLicenceTypeID", typeof(short));
    
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var applicationReferenceNumberParameter = applicationReferenceNumber != null ?
                new ObjectParameter("ApplicationReferenceNumber", applicationReferenceNumber) :
                new ObjectParameter("ApplicationReferenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Purification_InsertAllowedNewLicence", applicationAllowedNewLicenceIDParameter, memberNameParameter, idNumberOrBusinessRegistrationNumberParameter, associationIDParameter, registrationNumberParameter, applicationAllowedNewLicenceTypeIDParameter, operatingLicenceNumberParameter, applicationReferenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_MemberGet_Result> Pr_MemberGet(Nullable<long> memberID, string iDNumberOrBusinessRegistrationNo, Nullable<long> userID)
        {
            var memberIDParameter = memberID.HasValue ?
                new ObjectParameter("MemberID", memberID) :
                new ObjectParameter("MemberID", typeof(long));
    
            var iDNumberOrBusinessRegistrationNoParameter = iDNumberOrBusinessRegistrationNo != null ?
                new ObjectParameter("IDNumberOrBusinessRegistrationNo", iDNumberOrBusinessRegistrationNo) :
                new ObjectParameter("IDNumberOrBusinessRegistrationNo", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_MemberGet_Result>("Pr_MemberGet", memberIDParameter, iDNumberOrBusinessRegistrationNoParameter, userIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_GetSystemSettings(string settingName)
        {
            var settingNameParameter = settingName != null ?
                new ObjectParameter("SettingName", settingName) :
                new ObjectParameter("SettingName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GetSystemSettings", settingNameParameter);
        }
    
        public virtual ObjectResult<Pr_TaskSearch_Result> Pr_TaskSearch(Nullable<long> assignedToUserID, Nullable<long> userID)
        {
            var assignedToUserIDParameter = assignedToUserID.HasValue ?
                new ObjectParameter("AssignedToUserID", assignedToUserID) :
                new ObjectParameter("AssignedToUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_TaskSearch_Result>("Pr_TaskSearch", assignedToUserIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_ApplicationAnalytics_ApplicationCreatedBySummmary(Nullable<System.DateTime> fromDate, Nullable<System.DateTime> toDate, Nullable<long> userID)
        {
            var fromDateParameter = fromDate.HasValue ?
                new ObjectParameter("FromDate", fromDate) :
                new ObjectParameter("FromDate", typeof(System.DateTime));
    
            var toDateParameter = toDate.HasValue ?
                new ObjectParameter("ToDate", toDate) :
                new ObjectParameter("ToDate", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_ApplicationAnalytics_ApplicationCreatedBySummmary", fromDateParameter, toDateParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_ApplicationAnalytics_ApplicationPerRegion(Nullable<System.DateTime> fromDate, Nullable<System.DateTime> toDate, Nullable<long> userID)
        {
            var fromDateParameter = fromDate.HasValue ?
                new ObjectParameter("FromDate", fromDate) :
                new ObjectParameter("FromDate", typeof(System.DateTime));
    
            var toDateParameter = toDate.HasValue ?
                new ObjectParameter("ToDate", toDate) :
                new ObjectParameter("ToDate", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_ApplicationAnalytics_ApplicationPerRegion", fromDateParameter, toDateParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_ApplicationAnalytics_ApplicationRequestTypeSummmary(Nullable<System.DateTime> fromDate, Nullable<System.DateTime> toDate, Nullable<long> userID)
        {
            var fromDateParameter = fromDate.HasValue ?
                new ObjectParameter("FromDate", fromDate) :
                new ObjectParameter("FromDate", typeof(System.DateTime));
    
            var toDateParameter = toDate.HasValue ?
                new ObjectParameter("ToDate", toDate) :
                new ObjectParameter("ToDate", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_ApplicationAnalytics_ApplicationRequestTypeSummmary", fromDateParameter, toDateParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationAnalyticsSearch_Result> Pr_ApplicationAnalyticsSearch(Nullable<System.DateTime> fromDate, Nullable<System.DateTime> toDate, string applicationRequestTypeIDs, string createdBy, Nullable<long> searchRegionID, Nullable<long> userID)
        {
            var fromDateParameter = fromDate.HasValue ?
                new ObjectParameter("FromDate", fromDate) :
                new ObjectParameter("FromDate", typeof(System.DateTime));
    
            var toDateParameter = toDate.HasValue ?
                new ObjectParameter("ToDate", toDate) :
                new ObjectParameter("ToDate", typeof(System.DateTime));
    
            var applicationRequestTypeIDsParameter = applicationRequestTypeIDs != null ?
                new ObjectParameter("ApplicationRequestTypeIDs", applicationRequestTypeIDs) :
                new ObjectParameter("ApplicationRequestTypeIDs", typeof(string));
    
            var createdByParameter = createdBy != null ?
                new ObjectParameter("CreatedBy", createdBy) :
                new ObjectParameter("CreatedBy", typeof(string));
    
            var searchRegionIDParameter = searchRegionID.HasValue ?
                new ObjectParameter("SearchRegionID", searchRegionID) :
                new ObjectParameter("SearchRegionID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationAnalyticsSearch_Result>("Pr_ApplicationAnalyticsSearch", fromDateParameter, toDateParameter, applicationRequestTypeIDsParameter, createdByParameter, searchRegionIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_ReceiptDetails> Pr_NonBatchedCashReceiptDetailsGet(Nullable<long> receiptUserID, Nullable<long> userID)
        {
            var receiptUserIDParameter = receiptUserID.HasValue ?
                new ObjectParameter("ReceiptUserID", receiptUserID) :
                new ObjectParameter("ReceiptUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ReceiptDetails>("Pr_NonBatchedCashReceiptDetailsGet", receiptUserIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_ReceiptDetails> Pr_NonBatchedCashReceiptDetailsGet(Nullable<long> receiptUserID, Nullable<long> userID, MergeOption mergeOption)
        {
            var receiptUserIDParameter = receiptUserID.HasValue ?
                new ObjectParameter("ReceiptUserID", receiptUserID) :
                new ObjectParameter("ReceiptUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ReceiptDetails>("Pr_NonBatchedCashReceiptDetailsGet", mergeOption, receiptUserIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AddReceiptToApplication(Nullable<long> receiptDetailID, string applicationReferenceNumber, string reason, Nullable<long> userID)
        {
            var receiptDetailIDParameter = receiptDetailID.HasValue ?
                new ObjectParameter("ReceiptDetailID", receiptDetailID) :
                new ObjectParameter("ReceiptDetailID", typeof(long));
    
            var applicationReferenceNumberParameter = applicationReferenceNumber != null ?
                new ObjectParameter("ApplicationReferenceNumber", applicationReferenceNumber) :
                new ObjectParameter("ApplicationReferenceNumber", typeof(string));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AddReceiptToApplication", receiptDetailIDParameter, applicationReferenceNumberParameter, reasonParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchCashups_Result> Pr_SearchCashups(Nullable<long> paymentClerkID, Nullable<System.DateTime> fromDate, Nullable<System.DateTime> toDate, Nullable<long> userID)
        {
            var paymentClerkIDParameter = paymentClerkID.HasValue ?
                new ObjectParameter("PaymentClerkID", paymentClerkID) :
                new ObjectParameter("PaymentClerkID", typeof(long));
    
            var fromDateParameter = fromDate.HasValue ?
                new ObjectParameter("FromDate", fromDate) :
                new ObjectParameter("FromDate", typeof(System.DateTime));
    
            var toDateParameter = toDate.HasValue ?
                new ObjectParameter("ToDate", toDate) :
                new ObjectParameter("ToDate", typeof(System.DateTime));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchCashups_Result>("Pr_SearchCashups", paymentClerkIDParameter, fromDateParameter, toDateParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestTypeDivisionSetupUpdate(Nullable<short> applicationRequestTypeID, Nullable<short> divisionTypeID, Nullable<short> provinceID, string isAssessorApprovalRequiredRule, string isSeniorManagerApprovalRequiredRule, string isFinalisationTasksRequiredRule, string isInspectionRequiredRule, string isReferralRequiredRule, string isAdjudicationRequiredRule, string adjudicationTypeRule, string isGazettingRequiredRule, string gazetteTypeRule, Nullable<long> userID)
        {
            var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
                new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
                new ObjectParameter("ApplicationRequestTypeID", typeof(short));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var isAssessorApprovalRequiredRuleParameter = isAssessorApprovalRequiredRule != null ?
                new ObjectParameter("IsAssessorApprovalRequiredRule", isAssessorApprovalRequiredRule) :
                new ObjectParameter("IsAssessorApprovalRequiredRule", typeof(string));
    
            var isSeniorManagerApprovalRequiredRuleParameter = isSeniorManagerApprovalRequiredRule != null ?
                new ObjectParameter("IsSeniorManagerApprovalRequiredRule", isSeniorManagerApprovalRequiredRule) :
                new ObjectParameter("IsSeniorManagerApprovalRequiredRule", typeof(string));
    
            var isFinalisationTasksRequiredRuleParameter = isFinalisationTasksRequiredRule != null ?
                new ObjectParameter("IsFinalisationTasksRequiredRule", isFinalisationTasksRequiredRule) :
                new ObjectParameter("IsFinalisationTasksRequiredRule", typeof(string));
    
            var isInspectionRequiredRuleParameter = isInspectionRequiredRule != null ?
                new ObjectParameter("IsInspectionRequiredRule", isInspectionRequiredRule) :
                new ObjectParameter("IsInspectionRequiredRule", typeof(string));
    
            var isReferralRequiredRuleParameter = isReferralRequiredRule != null ?
                new ObjectParameter("IsReferralRequiredRule", isReferralRequiredRule) :
                new ObjectParameter("IsReferralRequiredRule", typeof(string));
    
            var isAdjudicationRequiredRuleParameter = isAdjudicationRequiredRule != null ?
                new ObjectParameter("IsAdjudicationRequiredRule", isAdjudicationRequiredRule) :
                new ObjectParameter("IsAdjudicationRequiredRule", typeof(string));
    
            var adjudicationTypeRuleParameter = adjudicationTypeRule != null ?
                new ObjectParameter("AdjudicationTypeRule", adjudicationTypeRule) :
                new ObjectParameter("AdjudicationTypeRule", typeof(string));
    
            var isGazettingRequiredRuleParameter = isGazettingRequiredRule != null ?
                new ObjectParameter("IsGazettingRequiredRule", isGazettingRequiredRule) :
                new ObjectParameter("IsGazettingRequiredRule", typeof(string));
    
            var gazetteTypeRuleParameter = gazetteTypeRule != null ?
                new ObjectParameter("GazetteTypeRule", gazetteTypeRule) :
                new ObjectParameter("GazetteTypeRule", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestTypeDivisionSetupUpdate", applicationRequestTypeIDParameter, divisionTypeIDParameter, provinceIDParameter, isAssessorApprovalRequiredRuleParameter, isSeniorManagerApprovalRequiredRuleParameter, isFinalisationTasksRequiredRuleParameter, isInspectionRequiredRuleParameter, isReferralRequiredRuleParameter, isAdjudicationRequiredRuleParameter, adjudicationTypeRuleParameter, isGazettingRequiredRuleParameter, gazetteTypeRuleParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationConversionChangeType(Nullable<long> applicationDetailID, Nullable<int> newApplicationRequestTypeID, string reason, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var newApplicationRequestTypeIDParameter = newApplicationRequestTypeID.HasValue ?
                new ObjectParameter("NewApplicationRequestTypeID", newApplicationRequestTypeID) :
                new ObjectParameter("NewApplicationRequestTypeID", typeof(int));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationConversionChangeType", applicationDetailIDParameter, newApplicationRequestTypeIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual ObjectResult<ApplicationRequestTypeDivisionSetup> Pr_ApplicationRequestTypeDivisionSetupClone(Nullable<short> oldApplicationRequestTypeID, Nullable<short> oldDivisionTypeID, Nullable<short> oldProvinceID, Nullable<short> newApplicationRequestTypeID, Nullable<short> newDivisionTypeID, Nullable<short> newProvinceID, Nullable<long> userID)
        {
            var oldApplicationRequestTypeIDParameter = oldApplicationRequestTypeID.HasValue ?
                new ObjectParameter("OldApplicationRequestTypeID", oldApplicationRequestTypeID) :
                new ObjectParameter("OldApplicationRequestTypeID", typeof(short));
    
            var oldDivisionTypeIDParameter = oldDivisionTypeID.HasValue ?
                new ObjectParameter("OldDivisionTypeID", oldDivisionTypeID) :
                new ObjectParameter("OldDivisionTypeID", typeof(short));
    
            var oldProvinceIDParameter = oldProvinceID.HasValue ?
                new ObjectParameter("OldProvinceID", oldProvinceID) :
                new ObjectParameter("OldProvinceID", typeof(short));
    
            var newApplicationRequestTypeIDParameter = newApplicationRequestTypeID.HasValue ?
                new ObjectParameter("NewApplicationRequestTypeID", newApplicationRequestTypeID) :
                new ObjectParameter("NewApplicationRequestTypeID", typeof(short));
    
            var newDivisionTypeIDParameter = newDivisionTypeID.HasValue ?
                new ObjectParameter("NewDivisionTypeID", newDivisionTypeID) :
                new ObjectParameter("NewDivisionTypeID", typeof(short));
    
            var newProvinceIDParameter = newProvinceID.HasValue ?
                new ObjectParameter("NewProvinceID", newProvinceID) :
                new ObjectParameter("NewProvinceID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ApplicationRequestTypeDivisionSetup>("Pr_ApplicationRequestTypeDivisionSetupClone", oldApplicationRequestTypeIDParameter, oldDivisionTypeIDParameter, oldProvinceIDParameter, newApplicationRequestTypeIDParameter, newDivisionTypeIDParameter, newProvinceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<ApplicationRequestTypeDivisionSetup> Pr_ApplicationRequestTypeDivisionSetupClone(Nullable<short> oldApplicationRequestTypeID, Nullable<short> oldDivisionTypeID, Nullable<short> oldProvinceID, Nullable<short> newApplicationRequestTypeID, Nullable<short> newDivisionTypeID, Nullable<short> newProvinceID, Nullable<long> userID, MergeOption mergeOption)
        {
            var oldApplicationRequestTypeIDParameter = oldApplicationRequestTypeID.HasValue ?
                new ObjectParameter("OldApplicationRequestTypeID", oldApplicationRequestTypeID) :
                new ObjectParameter("OldApplicationRequestTypeID", typeof(short));
    
            var oldDivisionTypeIDParameter = oldDivisionTypeID.HasValue ?
                new ObjectParameter("OldDivisionTypeID", oldDivisionTypeID) :
                new ObjectParameter("OldDivisionTypeID", typeof(short));
    
            var oldProvinceIDParameter = oldProvinceID.HasValue ?
                new ObjectParameter("OldProvinceID", oldProvinceID) :
                new ObjectParameter("OldProvinceID", typeof(short));
    
            var newApplicationRequestTypeIDParameter = newApplicationRequestTypeID.HasValue ?
                new ObjectParameter("NewApplicationRequestTypeID", newApplicationRequestTypeID) :
                new ObjectParameter("NewApplicationRequestTypeID", typeof(short));
    
            var newDivisionTypeIDParameter = newDivisionTypeID.HasValue ?
                new ObjectParameter("NewDivisionTypeID", newDivisionTypeID) :
                new ObjectParameter("NewDivisionTypeID", typeof(short));
    
            var newProvinceIDParameter = newProvinceID.HasValue ?
                new ObjectParameter("NewProvinceID", newProvinceID) :
                new ObjectParameter("NewProvinceID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ApplicationRequestTypeDivisionSetup>("Pr_ApplicationRequestTypeDivisionSetupClone", mergeOption, oldApplicationRequestTypeIDParameter, oldDivisionTypeIDParameter, oldProvinceIDParameter, newApplicationRequestTypeIDParameter, newDivisionTypeIDParameter, newProvinceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_BusinessRuleBypassRequestInprogressGet_Result> Pr_BusinessRuleBypassRequestInprogressGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_BusinessRuleBypassRequestInprogressGet_Result>("Pr_BusinessRuleBypassRequestInprogressGet", userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_AdjudicationSummaryExceptionsGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_AdjudicationSummaryExceptionsGet", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_TAT_ApplicationsPendingDataReleaseGet_Result> Pr_TAT_ApplicationsPendingDataReleaseGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_TAT_ApplicationsPendingDataReleaseGet_Result>("Pr_TAT_ApplicationsPendingDataReleaseGet", userIDParameter);
        }
    
        public virtual int Pr_TAT_ApplicationsReleaseData(Nullable<long> tATApplicationDetailID, string comments, Nullable<long> userID)
        {
            var tATApplicationDetailIDParameter = tATApplicationDetailID.HasValue ?
                new ObjectParameter("TATApplicationDetailID", tATApplicationDetailID) :
                new ObjectParameter("TATApplicationDetailID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_TAT_ApplicationsReleaseData", tATApplicationDetailIDParameter, commentsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DashboardOutcome> Pr_Dashboard_LicenceCancelSummaryGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DashboardOutcome>("Pr_Dashboard_LicenceCancelSummaryGet", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_LicenceCancelDetails> Pr_LicenceCancelSearch(Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID)
        {
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_LicenceCancelDetails>("Pr_LicenceCancelSearch", includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_LicenceCancelDetails> Pr_LicenceCancelSearch(Nullable<bool> includeWorkflowsAwaitingInfoOnly, Nullable<bool> includeActiveWorkflowsOnly, Nullable<bool> includeActiveTasksOnly, string steps, Nullable<long> userID, MergeOption mergeOption)
        {
            var includeWorkflowsAwaitingInfoOnlyParameter = includeWorkflowsAwaitingInfoOnly.HasValue ?
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", includeWorkflowsAwaitingInfoOnly) :
                new ObjectParameter("IncludeWorkflowsAwaitingInfoOnly", typeof(bool));
    
            var includeActiveWorkflowsOnlyParameter = includeActiveWorkflowsOnly.HasValue ?
                new ObjectParameter("IncludeActiveWorkflowsOnly", includeActiveWorkflowsOnly) :
                new ObjectParameter("IncludeActiveWorkflowsOnly", typeof(bool));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var stepsParameter = steps != null ?
                new ObjectParameter("Steps", steps) :
                new ObjectParameter("Steps", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_LicenceCancelDetails>("Pr_LicenceCancelSearch", mergeOption, includeWorkflowsAwaitingInfoOnlyParameter, includeActiveWorkflowsOnlyParameter, includeActiveTasksOnlyParameter, stepsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_SettingUpsert(string settingName, string settingValue, Nullable<long> userID, string auditDescription)
        {
            var settingNameParameter = settingName != null ?
                new ObjectParameter("SettingName", settingName) :
                new ObjectParameter("SettingName", typeof(string));
    
            var settingValueParameter = settingValue != null ?
                new ObjectParameter("SettingValue", settingValue) :
                new ObjectParameter("SettingValue", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_SettingUpsert", settingNameParameter, settingValueParameter, userIDParameter, auditDescriptionParameter);
        }
    
        public virtual int Pr_InspectorCancel(Nullable<short> inspectorID, Nullable<long> userID, string auditDescription)
        {
            var inspectorIDParameter = inspectorID.HasValue ?
                new ObjectParameter("InspectorID", inspectorID) :
                new ObjectParameter("InspectorID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var auditDescriptionParameter = auditDescription != null ?
                new ObjectParameter("AuditDescription", auditDescription) :
                new ObjectParameter("AuditDescription", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_InspectorCancel", inspectorIDParameter, userIDParameter, auditDescriptionParameter);
        }
    
        public virtual ObjectResult<Pr_InspectorsGetView_Result> Pr_InspectorsGetView()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_InspectorsGetView_Result>("Pr_InspectorsGetView");
        }
    
        public virtual int Pr_InspectorUpsert(Nullable<long> inspectorID, string name, Nullable<long> officeLocationID, Nullable<long> userID)
        {
            var inspectorIDParameter = inspectorID.HasValue ?
                new ObjectParameter("InspectorID", inspectorID) :
                new ObjectParameter("InspectorID", typeof(long));
    
            var nameParameter = name != null ?
                new ObjectParameter("Name", name) :
                new ObjectParameter("Name", typeof(string));
    
            var officeLocationIDParameter = officeLocationID.HasValue ?
                new ObjectParameter("OfficeLocationID", officeLocationID) :
                new ObjectParameter("OfficeLocationID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_InspectorUpsert", inspectorIDParameter, nameParameter, officeLocationIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DivisionTypeAnnexureMapping> Pr_DivisionTypeAnnexureMappingSearch(Nullable<short> serviceTypeID, Nullable<short> vehicleTypeID, Nullable<long> userID)
        {
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var vehicleTypeIDParameter = vehicleTypeID.HasValue ?
                new ObjectParameter("VehicleTypeID", vehicleTypeID) :
                new ObjectParameter("VehicleTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DivisionTypeAnnexureMapping>("Pr_DivisionTypeAnnexureMappingSearch", serviceTypeIDParameter, vehicleTypeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<DivisionTypeAnnexureMapping> Pr_DivisionTypeAnnexureMappingSearch(Nullable<short> serviceTypeID, Nullable<short> vehicleTypeID, Nullable<long> userID, MergeOption mergeOption)
        {
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var vehicleTypeIDParameter = vehicleTypeID.HasValue ?
                new ObjectParameter("VehicleTypeID", vehicleTypeID) :
                new ObjectParameter("VehicleTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DivisionTypeAnnexureMapping>("Pr_DivisionTypeAnnexureMappingSearch", mergeOption, serviceTypeIDParameter, vehicleTypeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Dashboard_SystemAdministrator_Result> Pr_Dashboard_SystemAdministrator(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Dashboard_SystemAdministrator_Result>("Pr_Dashboard_SystemAdministrator", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Dashboard_SystemAdministrator_FailedTasks_Result> Pr_Dashboard_SystemAdministrator_FailedTasks(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Dashboard_SystemAdministrator_FailedTasks_Result>("Pr_Dashboard_SystemAdministrator_FailedTasks", userIDParameter);
        }
    
        public virtual int Pr_Dashboard_SystemAdministrator_RequestCorrection(Nullable<long> instanceTaskID, Nullable<long> userID)
        {
            var instanceTaskIDParameter = instanceTaskID.HasValue ?
                new ObjectParameter("InstanceTaskID", instanceTaskID) :
                new ObjectParameter("InstanceTaskID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Dashboard_SystemAdministrator_RequestCorrection", instanceTaskIDParameter, userIDParameter);
        }
    
        public virtual int Pr_Dashboard_SystemAdministrator_RetryFailedTasks(Nullable<long> instanceTaskID, Nullable<long> userID)
        {
            var instanceTaskIDParameter = instanceTaskID.HasValue ?
                new ObjectParameter("InstanceTaskID", instanceTaskID) :
                new ObjectParameter("InstanceTaskID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Dashboard_SystemAdministrator_RetryFailedTasks", instanceTaskIDParameter, userIDParameter);
        }
    
        public virtual int Pr_DivisionTypeAnnexureMappingCancel(Nullable<long> divisionTypeAnnexureMappingID, Nullable<short> divisionTypeID, Nullable<short> provinceID, Nullable<short> serviceTypeID, Nullable<long> userID)
        {
            var divisionTypeAnnexureMappingIDParameter = divisionTypeAnnexureMappingID.HasValue ?
                new ObjectParameter("DivisionTypeAnnexureMappingID", divisionTypeAnnexureMappingID) :
                new ObjectParameter("DivisionTypeAnnexureMappingID", typeof(long));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DivisionTypeAnnexureMappingCancel", divisionTypeAnnexureMappingIDParameter, divisionTypeIDParameter, provinceIDParameter, serviceTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_DivisionTypeAnnexureMappingUpsert(Nullable<long> divisionTypeAnnexureMappingID, Nullable<short> divisionTypeID, Nullable<short> provinceID, Nullable<short> serviceTypeID, Nullable<short> vehicleTypeID, Nullable<long> annexureDocumentID, Nullable<long> userID)
        {
            var divisionTypeAnnexureMappingIDParameter = divisionTypeAnnexureMappingID.HasValue ?
                new ObjectParameter("DivisionTypeAnnexureMappingID", divisionTypeAnnexureMappingID) :
                new ObjectParameter("DivisionTypeAnnexureMappingID", typeof(long));
    
            var divisionTypeIDParameter = divisionTypeID.HasValue ?
                new ObjectParameter("DivisionTypeID", divisionTypeID) :
                new ObjectParameter("DivisionTypeID", typeof(short));
    
            var provinceIDParameter = provinceID.HasValue ?
                new ObjectParameter("ProvinceID", provinceID) :
                new ObjectParameter("ProvinceID", typeof(short));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var vehicleTypeIDParameter = vehicleTypeID.HasValue ?
                new ObjectParameter("VehicleTypeID", vehicleTypeID) :
                new ObjectParameter("VehicleTypeID", typeof(short));
    
            var annexureDocumentIDParameter = annexureDocumentID.HasValue ?
                new ObjectParameter("AnnexureDocumentID", annexureDocumentID) :
                new ObjectParameter("AnnexureDocumentID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DivisionTypeAnnexureMappingUpsert", divisionTypeAnnexureMappingIDParameter, divisionTypeIDParameter, provinceIDParameter, serviceTypeIDParameter, vehicleTypeIDParameter, annexureDocumentIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchApplicationLicenceVehicleType_Result> Pr_SearchApplicationLicenceVehicleType(string applicationLicenceReferenceNumber, Nullable<long> userID)
        {
            var applicationLicenceReferenceNumberParameter = applicationLicenceReferenceNumber != null ?
                new ObjectParameter("ApplicationLicenceReferenceNumber", applicationLicenceReferenceNumber) :
                new ObjectParameter("ApplicationLicenceReferenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchApplicationLicenceVehicleType_Result>("Pr_SearchApplicationLicenceVehicleType", applicationLicenceReferenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchApplicationServiceTypes_Result> Pr_SearchApplicationServiceTypes(string applicationLicenceReferenceNumber, Nullable<long> userID)
        {
            var applicationLicenceReferenceNumberParameter = applicationLicenceReferenceNumber != null ?
                new ObjectParameter("ApplicationLicenceReferenceNumber", applicationLicenceReferenceNumber) :
                new ObjectParameter("ApplicationLicenceReferenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchApplicationServiceTypes_Result>("Pr_SearchApplicationServiceTypes", applicationLicenceReferenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchLicenceVehicleTypes_Result> Pr_SearchLicenceVehicleTypes(string operatingLicenceNumber, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchLicenceVehicleTypes_Result>("Pr_SearchLicenceVehicleTypes", operatingLicenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_SearchLicenceServiceTypes_Result> Pr_SearchLicenceServiceTypes(string operatingLicenceNumber, Nullable<long> userID)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_SearchLicenceServiceTypes_Result>("Pr_SearchLicenceServiceTypes", operatingLicenceNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_ApplicationLicenceVehicleTypeUpdate(Nullable<long> applicationDetailID, Nullable<long> applicationLicenceID, Nullable<short> newVehicleTypeID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var newVehicleTypeIDParameter = newVehicleTypeID.HasValue ?
                new ObjectParameter("NewVehicleTypeID", newVehicleTypeID) :
                new ObjectParameter("NewVehicleTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ApplicationLicenceVehicleTypeUpdate", applicationDetailIDParameter, applicationLicenceIDParameter, newVehicleTypeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_ApplicationServiceTypeAdd(Nullable<long> applicationDetailID, Nullable<long> applicationLicenceID, Nullable<short> serviceTypeID, string serviceTypeDescription, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", typeof(short));
    
            var serviceTypeDescriptionParameter = serviceTypeDescription != null ?
                new ObjectParameter("ServiceTypeDescription", serviceTypeDescription) :
                new ObjectParameter("ServiceTypeDescription", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ApplicationServiceTypeAdd", applicationDetailIDParameter, applicationLicenceIDParameter, serviceTypeIDParameter, serviceTypeDescriptionParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_ApplicationServiceTypeRemove(Nullable<long> applicationDetailID, Nullable<long> applicationLicenceID, Nullable<long> applicationLicenceServiceDetailID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var applicationLicenceServiceDetailIDParameter = applicationLicenceServiceDetailID.HasValue ?
                new ObjectParameter("ApplicationLicenceServiceDetailID", applicationLicenceServiceDetailID) :
                new ObjectParameter("ApplicationLicenceServiceDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ApplicationServiceTypeRemove", applicationDetailIDParameter, applicationLicenceIDParameter, applicationLicenceServiceDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationLicenseGet_Result> Pr_ApplicationLicenseGet(string applicationNumber, Nullable<long> userID)
        {
            var applicationNumberParameter = applicationNumber != null ?
                new ObjectParameter("ApplicationNumber", applicationNumber) :
                new ObjectParameter("ApplicationNumber", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationLicenseGet_Result>("Pr_ApplicationLicenseGet", applicationNumberParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_ApplicationServiceTypeUpdate(Nullable<long> applicationDetailID, Nullable<long> applicationLicenceID, Nullable<long> applicationLicenceServiceDetailID, Nullable<short> newServiceTypeID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var applicationLicenceServiceDetailIDParameter = applicationLicenceServiceDetailID.HasValue ?
                new ObjectParameter("ApplicationLicenceServiceDetailID", applicationLicenceServiceDetailID) :
                new ObjectParameter("ApplicationLicenceServiceDetailID", typeof(long));
    
            var newServiceTypeIDParameter = newServiceTypeID.HasValue ?
                new ObjectParameter("NewServiceTypeID", newServiceTypeID) :
                new ObjectParameter("NewServiceTypeID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ApplicationServiceTypeUpdate", applicationDetailIDParameter, applicationLicenceIDParameter, applicationLicenceServiceDetailIDParameter, newServiceTypeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetSetupAvailableOptions_Result> Pr_GetSetupAvailableOptions(Nullable<short> entityID, Nullable<long> userID)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetSetupAvailableOptions_Result>("Pr_GetSetupAvailableOptions", entityIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_PrintGazetteReport_Result> Pr_PrintGazetteReport(Nullable<long> gazetteDetailID, Nullable<long> gazetteRegionID, Nullable<long> userID)
        {
            var gazetteDetailIDParameter = gazetteDetailID.HasValue ?
                new ObjectParameter("GazetteDetailID", gazetteDetailID) :
                new ObjectParameter("GazetteDetailID", typeof(long));
    
            var gazetteRegionIDParameter = gazetteRegionID.HasValue ?
                new ObjectParameter("GazetteRegionID", gazetteRegionID) :
                new ObjectParameter("GazetteRegionID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_PrintGazetteReport_Result>("Pr_PrintGazetteReport", gazetteDetailIDParameter, gazetteRegionIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationGazetteRoutesGet_Result> Pr_ApplicationGazetteRoutesGet(Nullable<long> applicationDetailID, Nullable<long> applicationLicenceID, Nullable<long> userID)
        {
            var applicationDetailIDParameter = applicationDetailID.HasValue ?
                new ObjectParameter("ApplicationDetailID", applicationDetailID) :
                new ObjectParameter("ApplicationDetailID", typeof(long));
    
            var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
                new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
                new ObjectParameter("ApplicationLicenceID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationGazetteRoutesGet_Result>("Pr_ApplicationGazetteRoutesGet", applicationDetailIDParameter, applicationLicenceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_GazetteRoutesGet_Result> Pr_GazetteRoutesGet(Nullable<long> gazetteDetailID, Nullable<long> userID)
        {
            var gazetteDetailIDParameter = gazetteDetailID.HasValue ?
                new ObjectParameter("GazetteDetailID", gazetteDetailID) :
                new ObjectParameter("GazetteDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GazetteRoutesGet_Result>("Pr_GazetteRoutesGet", gazetteDetailIDParameter, userIDParameter);
        }
    }
}