//------------------------------------------------------------------------------
// <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.Legitimate.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<ApplicationRequestType> ApplicationRequestTypes { get; set; }
        public virtual DbSet<Vw_ApplicationRequestDetails> Vw_ApplicationRequestDetails { get; set; }
        public virtual DbSet<Vw_Associations> Vw_Associations { get; set; }
        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<ApplicationRequestTypeDocuments> ApplicationRequestTypeDocuments { 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<ApplicationDocument> ApplicationDocuments { get; set; }
        public virtual DbSet<Vehicle> Vehicles { get; set; }
        public virtual DbSet<PrecheckDetail> PrecheckDetails { 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<Mode> Modes { 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_PrecheckDetailsIncomplete> Vw_PrecheckDetailsIncomplete { get; set; }
        public virtual DbSet<Vw_OperatingLicenceDetails> Vw_OperatingLicenceDetails { get; set; }
        public virtual DbSet<ApplicationRequestDetail> ApplicationRequestDetails { get; set; }
        public virtual DbSet<RouteNode> RouteNodes { 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<PrecheckDetailIncompleteReason> PrecheckDetailIncompleteReasons { get; set; }
        public virtual DbSet<Vw_Vehicles> Vw_Vehicles { get; set; }
        public virtual DbSet<AssociationCleanupSummary> AssociationCleanupSummaries { get; set; }
        public virtual DbSet<Vw_PurificationDetails> Vw_PurificationDetails { get; set; }
        public virtual DbSet<PurificationDetail> PurificationDetails { get; set; }
        public virtual DbSet<PurificationDetailStatu> PurificationDetailStatus { get; set; }
        public virtual DbSet<Vw_AssociationsPurificationCount> Vw_AssociationsPurificationCount { 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<Vw_GazetteApplication> Vw_GazetteApplications { get; set; }
        public virtual DbSet<ApplicationAllowedExpiredLicence> ApplicationAllowedExpiredLicences { get; set; }
        public virtual DbSet<Vw_AdjudicationApplicantDetails> Vw_AdjudicationApplicantDetails { get; set; }
        public virtual DbSet<CarryingCapacity> CarryingCapacities { get; set; }
        public virtual DbSet<LicenceException> LicenceExceptions { get; set; }
        public virtual DbSet<ApplicationAudit> ApplicationAudits { get; set; }
        public virtual DbSet<Vw_ApplicationRequestDetails_Receipts> Vw_ApplicationRequestDetails_Receipts { get; set; }
        public virtual DbSet<ApplicationAllowedNewLicence> ApplicationAllowedNewLicences { get; set; }
        public virtual DbSet<LicenceIssueDocument> LicenceIssueDocuments { get; set; }
        public virtual DbSet<ApplicationVehicleDetailsInBulk> ApplicationVehicleDetailsInBulks { get; set; }
        public virtual DbSet<Vw_LicenceUpliftmentExtensionRequestDetails> Vw_LicenceUpliftmentExtensionRequestDetails { get; set; }
    
        public virtual ObjectResult<Pr_ApplicationRequestDetailsAwaitingReceipts_Result> Pr_ApplicationRequestDetailsAwaitingReceipts(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_ApplicationRequestDetailsAwaitingReceipts_Result>("Pr_ApplicationRequestDetailsAwaitingReceipts", userIDParameter, paymentTypeIDsParameter);
        }
    
        public virtual ObjectResult<Vw_ReceiptDetails> Pr_ApplicationRequestDetailsRecentReceipts()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ReceiptDetails>("Pr_ApplicationRequestDetailsRecentReceipts");
        }
    
        public virtual ObjectResult<Vw_ReceiptDetails> Pr_ApplicationRequestDetailsRecentReceipts(MergeOption mergeOption)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ReceiptDetails>("Pr_ApplicationRequestDetailsRecentReceipts", mergeOption);
        }
    
        public virtual ObjectResult<Pr_ApplicationRequestDetailsSearch_Result> Pr_ApplicationRequestDetailsSearch(Nullable<long> applicationRequestDetailID, Nullable<short> workflowInstanceStatusID, string workflowTaskSteps, Nullable<bool> includeActiveTasksOnly, Nullable<long> adjudicationDetailID, Nullable<bool> hasAdjudicationDecision, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var workflowInstanceStatusIDParameter = workflowInstanceStatusID.HasValue ?
                new ObjectParameter("WorkflowInstanceStatusID", workflowInstanceStatusID) :
                new ObjectParameter("WorkflowInstanceStatusID", typeof(short));
    
            var workflowTaskStepsParameter = workflowTaskSteps != null ?
                new ObjectParameter("WorkflowTaskSteps", workflowTaskSteps) :
                new ObjectParameter("WorkflowTaskSteps", typeof(string));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var hasAdjudicationDecisionParameter = hasAdjudicationDecision.HasValue ?
                new ObjectParameter("HasAdjudicationDecision", hasAdjudicationDecision) :
                new ObjectParameter("HasAdjudicationDecision", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationRequestDetailsSearch_Result>("Pr_ApplicationRequestDetailsSearch", applicationRequestDetailIDParameter, workflowInstanceStatusIDParameter, workflowTaskStepsParameter, includeActiveTasksOnlyParameter, adjudicationDetailIDParameter, hasAdjudicationDecisionParameter, userIDParameter);
        }
    
        public virtual int Pr_LogPrintReceipt(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_LogPrintReceipt", receiptDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationRequestDetails> Pr_ApplicationRequestDetailsAwaitingGazettes(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationRequestDetails>("Pr_ApplicationRequestDetailsAwaitingGazettes", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationRequestDetails> Pr_ApplicationRequestDetailsAwaitingGazettes(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationRequestDetails>("Pr_ApplicationRequestDetailsAwaitingGazettes", mergeOption, userIDParameter);
        }
    
        public virtual int Pr_GazetteDetailStatusUpdate(Nullable<long> updatedByID, string comments, Nullable<long> gazetteDetailID, Nullable<short> gazetteDetailStatusID, 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 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", updatedByIDParameter, commentsParameter, gazetteDetailIDParameter, gazetteDetailStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationRequestDetails> Pr_ApplicationRequestDetailsAwaitingAdjudication(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationRequestDetails>("Pr_ApplicationRequestDetailsAwaitingAdjudication", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationRequestDetails> Pr_ApplicationRequestDetailsAwaitingAdjudication(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationRequestDetails>("Pr_ApplicationRequestDetailsAwaitingAdjudication", mergeOption, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestVerificationComplete(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_ApplicationRequestVerificationComplete", 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<short> serviceTypeID, 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 serviceTypeIDParameter = serviceTypeID.HasValue ?
                new ObjectParameter("ServiceTypeID", serviceTypeID) :
                new ObjectParameter("ServiceTypeID", 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, serviceTypeIDParameter, calledFromSaveParameter);
        }
    
        public virtual int Pr_AdjudicationDetailStatusUpdate(Nullable<long> updatedByID, string comments, Nullable<long> adjudicationDetailID, Nullable<short> adjudicationDetailStatusID, 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 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", updatedByIDParameter, commentsParameter, adjudicationDetailIDParameter, adjudicationDetailStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual int Pr_ApplicationRequestAdjudicationDecisionCommit(Nullable<long> applicationRequestDetailID, Nullable<long> adjudicationDetailID, Nullable<short> adjudicationDecisionID, Nullable<int> licenceDurationID, Nullable<System.DateTime> licenceExpiryDate, string comments, 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 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_ApplicationRequestAdjudicationDecisionCommit", applicationRequestDetailIDParameter, adjudicationDetailIDParameter, adjudicationDecisionIDParameter, licenceDurationIDParameter, licenceExpiryDateParameter, commentsParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestAdjudicationDecisionApproval(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_ApplicationRequestAdjudicationDecisionApproval", applicationRequestDetailIDParameter, adjudicationDetailIDParameter, isApprovedParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_AdjudicationPanelMembersGet_Result> Pr_AdjudicationPanelMembersGet()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AdjudicationPanelMembersGet_Result>("Pr_AdjudicationPanelMembersGet");
        }
    
        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 ObjectResult<Pr_LicenceIssueDetailsSearch_Result> Pr_LicenceIssueDetailsSearch(Nullable<long> licenceIssueDetailID, Nullable<short> workflowInstanceStatusID, string workflowTaskSteps, Nullable<bool> includeActiveTasksOnly, Nullable<long> userID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", typeof(long));
    
            var workflowInstanceStatusIDParameter = workflowInstanceStatusID.HasValue ?
                new ObjectParameter("WorkflowInstanceStatusID", workflowInstanceStatusID) :
                new ObjectParameter("WorkflowInstanceStatusID", typeof(short));
    
            var workflowTaskStepsParameter = workflowTaskSteps != null ?
                new ObjectParameter("WorkflowTaskSteps", workflowTaskSteps) :
                new ObjectParameter("WorkflowTaskSteps", typeof(string));
    
            var includeActiveTasksOnlyParameter = includeActiveTasksOnly.HasValue ?
                new ObjectParameter("IncludeActiveTasksOnly", includeActiveTasksOnly) :
                new ObjectParameter("IncludeActiveTasksOnly", typeof(bool));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueDetailsSearch_Result>("Pr_LicenceIssueDetailsSearch", licenceIssueDetailIDParameter, workflowInstanceStatusIDParameter, workflowTaskStepsParameter, includeActiveTasksOnlyParameter, 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> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_ReceiptBatchGenerate", userIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceStatusSummary_Result> Pr_LicenceStatusSummary(Nullable<long> regionID, Nullable<long> associationID)
        {
            var regionIDParameter = regionID.HasValue ?
                new ObjectParameter("RegionID", regionID) :
                new ObjectParameter("RegionID", typeof(long));
    
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceStatusSummary_Result>("Pr_LicenceStatusSummary", regionIDParameter, associationIDParameter);
        }
    
        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()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesExpiredInGracePeriodGet");
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesExpiredInGracePeriodGet(MergeOption mergeOption)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesExpiredInGracePeriodGet", mergeOption);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesUpcomingExpiresGet()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesUpcomingExpiresGet");
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesUpcomingExpiresGet(MergeOption mergeOption)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesUpcomingExpiresGet", mergeOption);
        }
    
        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 ObjectResult<Vw_PurificationDetails> Pr_PurificationExceptionsPending(Nullable<long> associationID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_PurificationDetails>("Pr_PurificationExceptionsPending", associationIDParameter);
        }
    
        public virtual ObjectResult<Vw_PurificationDetails> Pr_PurificationExceptionsPending(Nullable<long> associationID, MergeOption mergeOption)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_PurificationDetails>("Pr_PurificationExceptionsPending", mergeOption, associationIDParameter);
        }
    
        public virtual ObjectResult<Vw_PurificationDetails> Pr_PurificationPrechecksPending(Nullable<long> associationID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_PurificationDetails>("Pr_PurificationPrechecksPending", associationIDParameter);
        }
    
        public virtual ObjectResult<Vw_PurificationDetails> Pr_PurificationPrechecksPending(Nullable<long> associationID, MergeOption mergeOption)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_PurificationDetails>("Pr_PurificationPrechecksPending", mergeOption, associationIDParameter);
        }
    
        public virtual ObjectResult<Vw_PurificationDetails> Pr_PurificationWorkflowsInProgress(Nullable<long> associationID)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_PurificationDetails>("Pr_PurificationWorkflowsInProgress", associationIDParameter);
        }
    
        public virtual ObjectResult<Vw_PurificationDetails> Pr_PurificationWorkflowsInProgress(Nullable<long> associationID, MergeOption mergeOption)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_PurificationDetails>("Pr_PurificationWorkflowsInProgress", mergeOption, 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)
        {
            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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_MemberSearch_Result>("Pr_MemberSearch", memberNameParameter, memberIDParameter, memberEmailParameter, associationIDParameter);
        }
    
        public virtual ObjectResult<Pr_AssociationSearch_Result> Pr_AssociationSearch(Nullable<long> regionID, string associationName)
        {
            var regionIDParameter = regionID.HasValue ?
                new ObjectParameter("RegionID", regionID) :
                new ObjectParameter("RegionID", typeof(long));
    
            var associationNameParameter = associationName != null ?
                new ObjectParameter("AssociationName", associationName) :
                new ObjectParameter("AssociationName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_AssociationSearch_Result>("Pr_AssociationSearch", regionIDParameter, associationNameParameter);
        }
    
        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)
        {
            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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceSearch_Result>("Pr_LicenceSearch", operatingLicenceNumberParameter, memberIDParameter, licenceStatusIDParameter, registrationNumberParameter, associationIDParameter, dateOfIssueStartDateParameter, dateOfIssueEndDateParameter, dateOfExpiryStartDateParameter, dateOfExpiryEndDateParameter);
        }
    
        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()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GazetteGetNumber");
        }
    
        public virtual int Pr_RouteStartVerificationWorkflow(Nullable<long> routeID, Nullable<long> applicationRequestDetailID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteStartVerificationWorkflow", routeIDParameter, applicationRequestDetailIDParameter);
        }
    
        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> applicationRequestDetailID, 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 applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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, applicationRequestDetailIDParameter, applicationRequestTypeIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceRoutesGet_Result> Pr_LicenceRoutesGet(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceRoutesGet_Result>("Pr_LicenceRoutesGet", licenceIDParameter);
        }
    
        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> applicationRequestDetailID, string comment, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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", applicationRequestDetailIDParameter, commentParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationAdjudicationRestart(Nullable<long> applicationRequestDetailID, Nullable<long> adjudicationDetailID, 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 userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAdjudicationRestart", applicationRequestDetailIDParameter, adjudicationDetailIDParameter, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationPanelRemove(Nullable<long> adjudicationDetailID, Nullable<long> adjudicationPanelID)
        {
            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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AdjudicationPanelRemove", adjudicationDetailIDParameter, adjudicationPanelIDParameter);
        }
    
        public virtual ObjectResult<ReceiptDetail> Pr_ReceiptsGetUnassigned()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ReceiptDetail>("Pr_ReceiptsGetUnassigned");
        }
    
        public virtual ObjectResult<ReceiptDetail> Pr_ReceiptsGetUnassigned(MergeOption mergeOption)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ReceiptDetail>("Pr_ReceiptsGetUnassigned", mergeOption);
        }
    
        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> applicationRequestDetailID, Nullable<long> receiptDetailID, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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", applicationRequestDetailIDParameter, receiptDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_GetAppsWithMissingOrginatingLicences_Result> Pr_Purification_GetAppsWithMissingOrginatingLicences()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_GetAppsWithMissingOrginatingLicences_Result>("Pr_Purification_GetAppsWithMissingOrginatingLicences");
        }
    
        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()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_LicencesLinkedToActiveOLASGet_Result>("Pr_Purification_LicencesLinkedToActiveOLASGet");
        }
    
        public virtual ObjectResult<Vw_ApplicationRequestDetails> Pr_LicenceSearchRelatedApplications(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationRequestDetails>("Pr_LicenceSearchRelatedApplications", licenceIDParameter);
        }
    
        public virtual ObjectResult<Vw_ApplicationRequestDetails> Pr_LicenceSearchRelatedApplications(Nullable<long> licenceID, MergeOption mergeOption)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_ApplicationRequestDetails>("Pr_LicenceSearchRelatedApplications", mergeOption, licenceIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_LicenceSearchRelatedIssues(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_LicenceSearchRelatedIssues", licenceIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_LicenceSearchRelatedIssues(Nullable<long> licenceID, MergeOption mergeOption)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_LicenceSearchRelatedIssues", mergeOption, licenceIDParameter);
        }
    
        public virtual ObjectResult<Vehicle> Pr_VehicleSearch(string registrationNumber, string vinNumber)
        {
            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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vehicle>("Pr_VehicleSearch", registrationNumberParameter, vinNumberParameter);
        }
    
        public virtual ObjectResult<Vehicle> Pr_VehicleSearch(string registrationNumber, string vinNumber, 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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vehicle>("Pr_VehicleSearch", mergeOption, registrationNumberParameter, vinNumberParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_VehicleSearchLinkedLicences(Nullable<long> vehicleID)
        {
            var vehicleIDParameter = vehicleID.HasValue ?
                new ObjectParameter("VehicleID", vehicleID) :
                new ObjectParameter("VehicleID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_VehicleSearchLinkedLicences", vehicleIDParameter);
        }
    
        public virtual ObjectResult<Vw_OperatingLicenceDetails> Pr_VehicleSearchLinkedLicences(Nullable<long> vehicleID, MergeOption mergeOption)
        {
            var vehicleIDParameter = vehicleID.HasValue ?
                new ObjectParameter("VehicleID", vehicleID) :
                new ObjectParameter("VehicleID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_OperatingLicenceDetails>("Pr_VehicleSearchLinkedLicences", mergeOption, vehicleIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceIssueWorkflowGet_Result> Pr_LicenceIssueWorkflowGet(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueWorkflowGet_Result>("Pr_LicenceIssueWorkflowGet", licenceIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceApplicationWorkflowGet_Result> Pr_LicenceApplicationWorkflowGet(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceApplicationWorkflowGet_Result>("Pr_LicenceApplicationWorkflowGet", licenceIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceWorkflowDocumentsGet_Result> Pr_LicenceWorkflowDocumentsGet(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceWorkflowDocumentsGet_Result>("Pr_LicenceWorkflowDocumentsGet", licenceIDParameter);
        }
    
        public virtual ObjectResult<Pr_LicenceExceptionsCounts_Result> Pr_LicenceExceptionsCounts()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceExceptionsCounts_Result>("Pr_LicenceExceptionsCounts");
        }
    
        public virtual ObjectResult<Pr_LicencesWithExceptionGet_Result> Pr_LicencesWithExceptionGet(string exception)
        {
            var exceptionParameter = exception != null ?
                new ObjectParameter("Exception", exception) :
                new ObjectParameter("Exception", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicencesWithExceptionGet_Result>("Pr_LicencesWithExceptionGet", exceptionParameter);
        }
    
        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> vehicleTypeID, Nullable<short> carryingCapacityID, string yearOfManufacture, 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 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 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, vehicleTypeIDParameter, carryingCapacityIDParameter, yearOfManufactureParameter, 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 sARSReasonIfNoTaxNumber, 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 sARSReasonIfNoTaxNumberParameter = sARSReasonIfNoTaxNumber != null ?
                new ObjectParameter("SARSReasonIfNoTaxNumber", sARSReasonIfNoTaxNumber) :
                new ObjectParameter("SARSReasonIfNoTaxNumber", 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, sARSReasonIfNoTaxNumberParameter, tradeNameParameter, businessTypeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceStatusUpdate(Nullable<long> updatedByID, string comments, Nullable<long> licenceID, Nullable<short> licenceStatusID, 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 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", updatedByIDParameter, commentsParameter, licenceIDParameter, licenceStatusIDParameter, isTransactionRequiredParameter);
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesOverdueUpliftmentsGet()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesOverdueUpliftmentsGet");
        }
    
        public virtual ObjectResult<Licence> Pr_LicencesOverdueUpliftmentsGet(MergeOption mergeOption)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Licence>("Pr_LicencesOverdueUpliftmentsGet", mergeOption);
        }
    
        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<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 userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceRouteAdd", licenceIDParameter, routeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_LicenceRouteRemove(Nullable<long> licenceID, Nullable<long> routeID, 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 userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceRouteRemove", licenceIDParameter, routeIDParameter, userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestAdjudicationBypass(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_ApplicationRequestAdjudicationBypass", applicationRequestDetailIDParameter, adjudicationDecisionIDParameter, licenceDurationIDParameter, licenceExpiryDateParameter, actualAdjudicationDateParameter, commentsParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_ApplicationRequestsStatusViewGet_Result> Pr_ApplicationRequestsStatusViewGet(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_ApplicationRequestsStatusViewGet_Result>("Pr_ApplicationRequestsStatusViewGet", 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> applicationrequestDetailID, Nullable<short> applicationAuditTypeID)
        {
            var applicationrequestDetailIDParameter = applicationrequestDetailID.HasValue ?
                new ObjectParameter("ApplicationrequestDetailID", applicationrequestDetailID) :
                new ObjectParameter("ApplicationrequestDetailID", typeof(long));
    
            var applicationAuditTypeIDParameter = applicationAuditTypeID.HasValue ?
                new ObjectParameter("ApplicationAuditTypeID", applicationAuditTypeID) :
                new ObjectParameter("ApplicationAuditTypeID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationAuditCreate", applicationrequestDetailIDParameter, 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 ObjectResult<Nullable<long>> Pr_ApplicationAdjudicationDecisionReverse(Nullable<long> adjudicationDetailID, Nullable<long> applicationRequestDetailID, Nullable<long> userID, string comments)
        {
            var adjudicationDetailIDParameter = adjudicationDetailID.HasValue ?
                new ObjectParameter("AdjudicationDetailID", adjudicationDetailID) :
                new ObjectParameter("AdjudicationDetailID", typeof(long));
    
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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<Nullable<long>>("Pr_ApplicationAdjudicationDecisionReverse", adjudicationDetailIDParameter, applicationRequestDetailIDParameter, 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)
        {
            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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_VehicleIsNotUsed", operatingLicenceNumberParameter, vINParameter);
        }
    
        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_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 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_SearchApplicationMode_Result> Pr_Purification_SearchApplicationMode(string appReferenceNumber)
        {
            var appReferenceNumberParameter = appReferenceNumber != null ?
                new ObjectParameter("AppReferenceNumber", appReferenceNumber) :
                new ObjectParameter("AppReferenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchApplicationMode_Result>("Pr_Purification_SearchApplicationMode", appReferenceNumberParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_SearchApplicationServiceTypes_Result> Pr_Purification_SearchApplicationServiceTypes(string appReferenceNumber)
        {
            var appReferenceNumberParameter = appReferenceNumber != null ?
                new ObjectParameter("AppReferenceNumber", appReferenceNumber) :
                new ObjectParameter("AppReferenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchApplicationServiceTypes_Result>("Pr_Purification_SearchApplicationServiceTypes", appReferenceNumberParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_SearchLicenceMode_Result> Pr_Purification_SearchLicenceMode(string operatingLicenceNumber)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchLicenceMode_Result>("Pr_Purification_SearchLicenceMode", operatingLicenceNumberParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_SearchLicenceServiceTypes_Result> Pr_Purification_SearchLicenceServiceTypes(string operatingLicenceNumber)
        {
            var operatingLicenceNumberParameter = operatingLicenceNumber != null ?
                new ObjectParameter("OperatingLicenceNumber", operatingLicenceNumber) :
                new ObjectParameter("OperatingLicenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchLicenceServiceTypes_Result>("Pr_Purification_SearchLicenceServiceTypes", operatingLicenceNumberParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PurificationApplicationModeUpdate(Nullable<long> applicationRequestDetailID, Nullable<short> newModeID, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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_PurificationApplicationModeUpdate", applicationRequestDetailIDParameter, newModeIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PurificationApplicationServiceTypeAdd(Nullable<long> applicationRequestDetailID, Nullable<short> serviceTypeID, string serviceTypeDescription, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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_PurificationApplicationServiceTypeAdd", applicationRequestDetailIDParameter, serviceTypeIDParameter, serviceTypeDescriptionParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_PurificationApplicationServiceTypeRemove(Nullable<long> applicationRequestDetailID, Nullable<long> applicationServiceDetailID, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var applicationServiceDetailIDParameter = applicationServiceDetailID.HasValue ?
                new ObjectParameter("ApplicationServiceDetailID", applicationServiceDetailID) :
                new ObjectParameter("ApplicationServiceDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_PurificationApplicationServiceTypeRemove", applicationRequestDetailIDParameter, applicationServiceDetailIDParameter, 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_Purification_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 sARSReasonIfNoTaxNumber, 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 sARSReasonIfNoTaxNumberParameter = sARSReasonIfNoTaxNumber != null ?
                new ObjectParameter("SARSReasonIfNoTaxNumber", sARSReasonIfNoTaxNumber) :
                new ObjectParameter("SARSReasonIfNoTaxNumber", 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_Purification_UpdateMember", idNumberParameter, surnameOrCompanyNameParameter, firstNamesParameter, postalAddressParameter, postalAddressCodeParameter, physicalAddressParameter, physicalAddressCodeParameter, telPhoneParameter, telCellParameter, telFaxParameter, emailParameter, sARSIncomeTaxNumberParameter, sARSReasonIfNoTaxNumberParameter, tradeNameParameter, businessTypeIDParameter, 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)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Route>("Pr_AssociationRoutesGet", associationIDParameter);
        }
    
        public virtual ObjectResult<Route> Pr_AssociationRoutesGet(Nullable<long> associationID, MergeOption mergeOption)
        {
            var associationIDParameter = associationID.HasValue ?
                new ObjectParameter("AssociationID", associationID) :
                new ObjectParameter("AssociationID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Route>("Pr_AssociationRoutesGet", mergeOption, associationIDParameter);
        }
    
        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> applicationRequestDetailID, 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 applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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, applicationRequestDetailIDParameter, 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> applicationRequestDetailID, Nullable<long> adjudicationDetailID, string reason, 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 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", applicationRequestDetailIDParameter, adjudicationDetailIDParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_AdjudicationAddApplication(string applicationReferenceNumber, Nullable<long> adjudicationDetailID, Nullable<long> userID)
        {
            var applicationReferenceNumberParameter = applicationReferenceNumber != null ?
                new ObjectParameter("ApplicationReferenceNumber", applicationReferenceNumber) :
                new ObjectParameter("ApplicationReferenceNumber", typeof(string));
    
            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", applicationReferenceNumberParameter, adjudicationDetailIDParameter, userIDParameter);
        }
    
        [DbFunction("LegitimateEntities", "Fn_GetSourceApplicationRecordsFromSourceSystem")]
        public virtual IQueryable<Fn_GetSourceApplicationRecordsFromSourceSystem_Result> Fn_GetSourceApplicationRecordsFromSourceSystem(string olPermitNumber, Nullable<short> sourceApplicationID, Nullable<short> modeID, 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 modeIDParameter = modeID.HasValue ?
                new ObjectParameter("ModeID", modeID) :
                new ObjectParameter("ModeID", 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, @ModeID, @InlcudeActiveOnly, @IncludeLastExpiredIfNoActiveFound)", olPermitNumberParameter, sourceApplicationIDParameter, modeIDParameter, 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> regionID, Nullable<long> userID)
        {
            var regionIDParameter = regionID.HasValue ?
                new ObjectParameter("RegionID", regionID) :
                new ObjectParameter("RegionID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_LicenceIssueTrackingSearch_Result>("Pr_LicenceIssueTrackingSearch", regionIDParameter, 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<Pr_Purification_SearchApplicationRoutes_Result> Pr_Purification_SearchApplicationRoutes(string appReferenceNumber)
        {
            var appReferenceNumberParameter = appReferenceNumber != null ?
                new ObjectParameter("AppReferenceNumber", appReferenceNumber) :
                new ObjectParameter("AppReferenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchApplicationRoutes_Result>("Pr_Purification_SearchApplicationRoutes", appReferenceNumberParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_SearchLicenceRoutes_Result> Pr_Purification_SearchLicenceRoutes(string lirReferenceNumber)
        {
            var lirReferenceNumberParameter = lirReferenceNumber != null ?
                new ObjectParameter("lirReferenceNumber", lirReferenceNumber) :
                new ObjectParameter("lirReferenceNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Purification_SearchLicenceRoutes_Result>("Pr_Purification_SearchLicenceRoutes", lirReferenceNumberParameter);
        }
    
        public virtual int Pr_PurificationApplicationRouteAdd(Nullable<long> applicationRequestDetailID, string nationalRouteNumber, string boardRouteNumber, string reason, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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 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_PurificationApplicationRouteAdd", applicationRequestDetailIDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_PurificationApplicationRouteRemove(Nullable<long> applicationRequestDetailID, string applicationNationalRouteNumber, string applicationBoardRouteNumber, string reason, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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 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_PurificationApplicationRouteRemove", applicationRequestDetailIDParameter, applicationNationalRouteNumberParameter, applicationBoardRouteNumberParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_PurificationLicenceRouteAdd(Nullable<long> licenceIssueDetailIDD, string nationalRouteNumber, string boardRouteNumber, string reason, Nullable<long> userID)
        {
            var licenceIssueDetailIDDParameter = licenceIssueDetailIDD.HasValue ?
                new ObjectParameter("licenceIssueDetailIDD", licenceIssueDetailIDD) :
                new ObjectParameter("licenceIssueDetailIDD", 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 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_PurificationLicenceRouteAdd", licenceIssueDetailIDDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, reasonParameter, userIDParameter);
        }
    
        public virtual int Pr_PurificationLicenceRouteRemove(Nullable<long> licenceID, string licenceNationalRouteNumber, string licenceBoardRouteNumber, string reason, Nullable<long> userID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", 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 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_PurificationLicenceRouteRemove", licenceIDParameter, licenceNationalRouteNumberParameter, licenceBoardRouteNumberParameter, reasonParameter, 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> applicationRequestDetailID, Nullable<long> userID)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationVerificationHandleError", applicationRequestDetailIDParameter, 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)
        {
            var applicationNumberParameter = applicationNumber != null ?
                new ObjectParameter("ApplicationNumber", applicationNumber) :
                new ObjectParameter("ApplicationNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetApplicationTypesForConversion_Result>("Pr_GetApplicationTypesForConversion", applicationNumberParameter);
        }
    
        public virtual int Pr_ApplicationConversionChangeType(Nullable<long> applicationRequestDetailID, Nullable<int> newApplicationRequestTypeID, string reason)
        {
            var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
                new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
                new ObjectParameter("ApplicationRequestDetailID", 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));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationConversionChangeType", applicationRequestDetailIDParameter, newApplicationRequestTypeIDParameter, reasonParameter);
        }
    
        public virtual ObjectResult<Pr_GetReceipt_Result> Pr_GetReceipt(string receiptNumber)
        {
            var receiptNumberParameter = receiptNumber != null ?
                new ObjectParameter("ReceiptNumber", receiptNumber) :
                new ObjectParameter("ReceiptNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetReceipt_Result>("Pr_GetReceipt", receiptNumberParameter);
        }
    
        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 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_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> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetRecentCashups_Result>("Pr_GetRecentCashups", userIDParameter);
        }
    
        public virtual int Pr_ApplicationRequestCreateReceipt(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_ApplicationRequestCreateReceipt", 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 int Pr_UpdateIdNumber(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_UpdateIdNumber", oldIDNumberParameter, newIDNumberParameter);
        }
    
        public virtual ObjectResult<Pr_Purification_GetUserDataOnIdSearch_Result> Pr_Purification_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_Purification_GetUserDataOnIdSearch_Result>("Pr_Purification_GetUserDataOnIdSearch", oldIDNumberParameter, newIDNumberParameter);
        }
    
        public virtual int Pr_Purification_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_Purification_UpdateIdNumber", oldIDNumberParameter, newIDNumberParameter, userIDParameter);
        }
    
        public virtual int Pr_Purification_ApplicationRouteChangeUpdate(Nullable<long> applicationRouteDetailID, Nullable<short> newRouteChangeTypeID, string reason, Nullable<long> userID)
        {
            var applicationRouteDetailIDParameter = applicationRouteDetailID.HasValue ?
                new ObjectParameter("ApplicationRouteDetailID", applicationRouteDetailID) :
                new ObjectParameter("ApplicationRouteDetailID", typeof(long));
    
            var newRouteChangeTypeIDParameter = newRouteChangeTypeID.HasValue ?
                new ObjectParameter("NewRouteChangeTypeID", newRouteChangeTypeID) :
                new ObjectParameter("NewRouteChangeTypeID", typeof(short));
    
            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_Purification_ApplicationRouteChangeUpdate", applicationRouteDetailIDParameter, newRouteChangeTypeIDParameter, reasonParameter, userIDParameter);
        }
    }
}