//------------------------------------------------------------------------------
//
// 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.
//
//------------------------------------------------------------------------------
namespace Neo.LegitimateLicences.ApplicationRequest.Models.Database
{
using System;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Data.Entity.Core.Objects;
using System.Linq;
public partial class ApplicationContext : DbContext
{
public ApplicationContext()
: base("name=ApplicationContext")
{
this.Configuration.LazyLoadingEnabled = false;
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
throw new UnintentionalCodeFirstException();
}
public virtual DbSet ApplicationAdjudicationDecisions { get; set; }
public virtual DbSet ApplicationAdjudications { get; set; }
public virtual DbSet ApplicationApplicantDetails { get; set; }
public virtual DbSet ApplicationContractDetails { get; set; }
public virtual DbSet ApplicationDetails { get; set; }
public virtual DbSet ApplicationLicenceRouteDetails { get; set; }
public virtual DbSet ApplicationLicences { get; set; }
public virtual DbSet ApplicationLicenceServiceDetails { get; set; }
public virtual DbSet ApplicationLicenceVehicleDetails { get; set; }
public virtual DbSet ApplicationObjections { get; set; }
public virtual DbSet ApplicationPreviousLicenceHolders { get; set; }
public virtual DbSet ApplicationProxyDetails { get; set; }
public virtual DbSet Vw_ApplicationDetails_Light { get; set; }
public virtual DbSet ApplicationNPTRDetails { get; set; }
public virtual DbSet ApplicationInspectionDetails { get; set; }
public virtual DbSet ApplicationReferrals { get; set; }
public virtual DbSet ReferralTypes { get; set; }
public virtual DbSet ServiceTypes { get; set; }
public virtual DbSet AdjudicationDecisions { get; set; }
public virtual DbSet Users { get; set; }
public virtual DbSet LicenceDurations { get; set; }
public virtual DbSet ApplicationLicenceRouteDetailPlaces { get; set; }
public virtual DbSet ReceiptDetails { get; set; }
public virtual DbSet Vehicles { get; set; }
public virtual DbSet AdjudicationDetails { get; set; }
public virtual DbSet AdjudicationDetailStatus { get; set; }
public virtual DbSet Vw_ApplicationLicences { get; set; }
public virtual DbSet Vw_ApplicationLicenceVehicleDetails { get; set; }
public virtual DbSet ApplicationTags { get; set; }
public virtual DbSet Vw_ApplicationTags { get; set; }
public virtual DbSet ApplicationRequestTypes { get; set; }
public virtual DbSet ApplicationLicencePreviousVehicleDetails { get; set; }
public virtual DbSet PaymentTypes { get; set; }
public virtual DbSet ApplicationTATDetails { get; set; }
public virtual DbSet GazetteDetails { get; set; }
public virtual DbSet LicenceIssueDetails { get; set; }
public virtual DbSet Vw_LicenceIssueVehicleDetails { get; set; }
[DbFunction("ApplicationContext", "Fn_GetApplicationRequestTypeDocuments")]
public virtual IQueryable Fn_GetApplicationRequestTypeDocuments(Nullable applicationRequestTypeID, Nullable isLtpsConversion, Nullable workflowTemplateID, Nullable divisionTypeID, Nullable provinceID, Nullable memberID)
{
var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
new ObjectParameter("ApplicationRequestTypeID", typeof(short));
var isLtpsConversionParameter = isLtpsConversion.HasValue ?
new ObjectParameter("IsLtpsConversion", isLtpsConversion) :
new ObjectParameter("IsLtpsConversion", typeof(bool));
var workflowTemplateIDParameter = workflowTemplateID.HasValue ?
new ObjectParameter("WorkflowTemplateID", workflowTemplateID) :
new ObjectParameter("WorkflowTemplateID", typeof(long));
var divisionTypeIDParameter = divisionTypeID.HasValue ?
new ObjectParameter("DivisionTypeID", divisionTypeID) :
new ObjectParameter("DivisionTypeID", typeof(short));
var provinceIDParameter = provinceID.HasValue ?
new ObjectParameter("ProvinceID", provinceID) :
new ObjectParameter("ProvinceID", typeof(short));
var memberIDParameter = memberID.HasValue ?
new ObjectParameter("MemberID", memberID) :
new ObjectParameter("MemberID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.CreateQuery("[ApplicationContext].[Fn_GetApplicationRequestTypeDocuments](@ApplicationRequestTypeID, @IsLtpsConversion, @WorkflowTemplateID, @DivisionTypeID, @ProvinceID, @MemberID)", applicationRequestTypeIDParameter, isLtpsConversionParameter, workflowTemplateIDParameter, divisionTypeIDParameter, provinceIDParameter, memberIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreate(Nullable applicationPrecheckDetailID, Nullable userID)
{
var applicationPrecheckDetailIDParameter = applicationPrecheckDetailID.HasValue ?
new ObjectParameter("ApplicationPrecheckDetailID", applicationPrecheckDetailID) :
new ObjectParameter("ApplicationPrecheckDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreate", applicationPrecheckDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreate(Nullable applicationPrecheckDetailID, Nullable userID, MergeOption mergeOption)
{
var applicationPrecheckDetailIDParameter = applicationPrecheckDetailID.HasValue ?
new ObjectParameter("ApplicationPrecheckDetailID", applicationPrecheckDetailID) :
new ObjectParameter("ApplicationPrecheckDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreate", mergeOption, applicationPrecheckDetailIDParameter, userIDParameter);
}
public virtual int Pr_ApplicationPostSaveProcess(Nullable applicationDetailID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationPostSaveProcess", applicationDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationLicenceRoute_AddExisting(Nullable applicationLicenceID, Nullable routeID, Nullable serviceTypeID, Nullable userID)
{
var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
new ObjectParameter("ApplicationLicenceID", typeof(long));
var routeIDParameter = routeID.HasValue ?
new ObjectParameter("RouteID", routeID) :
new ObjectParameter("RouteID", typeof(long));
var serviceTypeIDParameter = serviceTypeID.HasValue ?
new ObjectParameter("ServiceTypeID", serviceTypeID) :
new ObjectParameter("ServiceTypeID", typeof(short));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceRoute_AddExisting", applicationLicenceIDParameter, routeIDParameter, serviceTypeIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationLicenceRoute_AddExisting(Nullable applicationLicenceID, Nullable routeID, Nullable serviceTypeID, Nullable userID, MergeOption mergeOption)
{
var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
new ObjectParameter("ApplicationLicenceID", typeof(long));
var routeIDParameter = routeID.HasValue ?
new ObjectParameter("RouteID", routeID) :
new ObjectParameter("RouteID", typeof(long));
var serviceTypeIDParameter = serviceTypeID.HasValue ?
new ObjectParameter("ServiceTypeID", serviceTypeID) :
new ObjectParameter("ServiceTypeID", typeof(short));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceRoute_AddExisting", mergeOption, applicationLicenceIDParameter, routeIDParameter, serviceTypeIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreateGetMemberLicences(string idNumberOrBusinessRegistrationNumber, Nullable userID)
{
var idNumberOrBusinessRegistrationNumberParameter = idNumberOrBusinessRegistrationNumber != null ?
new ObjectParameter("IdNumberOrBusinessRegistrationNumber", idNumberOrBusinessRegistrationNumber) :
new ObjectParameter("IdNumberOrBusinessRegistrationNumber", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateGetMemberLicences", idNumberOrBusinessRegistrationNumberParameter, userIDParameter);
}
public virtual ObjectResult Pr_Dashboard_ApplicationWorkflowStatusGet(Nullable applicationDetailID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_Dashboard_ApplicationWorkflowStatusGet", applicationDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationLicenceRouteDescriptionCalculate(Nullable applicationLicenceRouteDetailID, Nullable userID)
{
var applicationLicenceRouteDetailIDParameter = applicationLicenceRouteDetailID.HasValue ?
new ObjectParameter("ApplicationLicenceRouteDetailID", applicationLicenceRouteDetailID) :
new ObjectParameter("ApplicationLicenceRouteDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceRouteDescriptionCalculate", applicationLicenceRouteDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationFailedDocumentVerificationsGet(Nullable applicationDetailID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationFailedDocumentVerificationsGet", applicationDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreateGetMemberAccreditation(Nullable memberID, Nullable userID)
{
var memberIDParameter = memberID.HasValue ?
new ObjectParameter("MemberID", memberID) :
new ObjectParameter("MemberID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateGetMemberAccreditation", memberIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreateGetApplicationsInProgress(string iDNumberOrBusinessRegistrationNumber, Nullable userID)
{
var iDNumberOrBusinessRegistrationNumberParameter = iDNumberOrBusinessRegistrationNumber != null ?
new ObjectParameter("IDNumberOrBusinessRegistrationNumber", iDNumberOrBusinessRegistrationNumber) :
new ObjectParameter("IDNumberOrBusinessRegistrationNumber", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateGetApplicationsInProgress", iDNumberOrBusinessRegistrationNumberParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreateGetTransferSummary(string tranferToIdNumber, string tranferOperatingLicenceNumbers, Nullable userID)
{
var tranferToIdNumberParameter = tranferToIdNumber != null ?
new ObjectParameter("TranferToIdNumber", tranferToIdNumber) :
new ObjectParameter("TranferToIdNumber", typeof(string));
var tranferOperatingLicenceNumbersParameter = tranferOperatingLicenceNumbers != null ?
new ObjectParameter("TranferOperatingLicenceNumbers", tranferOperatingLicenceNumbers) :
new ObjectParameter("TranferOperatingLicenceNumbers", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateGetTransferSummary", tranferToIdNumberParameter, tranferOperatingLicenceNumbersParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationLicenceRoute_RemoveRoute(Nullable applicationLicenceID, Nullable applicationLicenceRouteDetailID, Nullable userID)
{
var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
new ObjectParameter("ApplicationLicenceID", typeof(long));
var applicationLicenceRouteDetailIDParameter = applicationLicenceRouteDetailID.HasValue ?
new ObjectParameter("ApplicationLicenceRouteDetailID", applicationLicenceRouteDetailID) :
new ObjectParameter("ApplicationLicenceRouteDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceRoute_RemoveRoute", applicationLicenceIDParameter, applicationLicenceRouteDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationPrecheckCreate(Nullable applicationRequestTypeID, Nullable sourceApplicationID, string applicantName, string telCell, Nullable idTypeID, string idOrBusinessRegistrationNumber, string originatingLicenceNumbers, string originatingAccreditationNumber, Nullable vehicleTypeID, string serviceTypeIDs, Nullable numberOfLicencesRequired, Nullable applicationProvinceID, Nullable applicationRegionID, Nullable applicationAssociationID, string applicationAllowedNewLicenceIDs, string selectedRouteIDs, Nullable parentApplicationDetailID, Nullable parentApplicationLicenceID, Nullable userID)
{
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 telCellParameter = telCell != null ?
new ObjectParameter("TelCell", telCell) :
new ObjectParameter("TelCell", typeof(string));
var idTypeIDParameter = idTypeID.HasValue ?
new ObjectParameter("IdTypeID", idTypeID) :
new ObjectParameter("IdTypeID", typeof(short));
var idOrBusinessRegistrationNumberParameter = idOrBusinessRegistrationNumber != null ?
new ObjectParameter("IdOrBusinessRegistrationNumber", idOrBusinessRegistrationNumber) :
new ObjectParameter("IdOrBusinessRegistrationNumber", typeof(string));
var originatingLicenceNumbersParameter = originatingLicenceNumbers != null ?
new ObjectParameter("OriginatingLicenceNumbers", originatingLicenceNumbers) :
new ObjectParameter("OriginatingLicenceNumbers", typeof(string));
var originatingAccreditationNumberParameter = originatingAccreditationNumber != null ?
new ObjectParameter("OriginatingAccreditationNumber", originatingAccreditationNumber) :
new ObjectParameter("OriginatingAccreditationNumber", typeof(string));
var vehicleTypeIDParameter = vehicleTypeID.HasValue ?
new ObjectParameter("VehicleTypeID", vehicleTypeID) :
new ObjectParameter("VehicleTypeID", typeof(short));
var serviceTypeIDsParameter = serviceTypeIDs != null ?
new ObjectParameter("ServiceTypeIDs", serviceTypeIDs) :
new ObjectParameter("ServiceTypeIDs", typeof(string));
var numberOfLicencesRequiredParameter = numberOfLicencesRequired.HasValue ?
new ObjectParameter("NumberOfLicencesRequired", numberOfLicencesRequired) :
new ObjectParameter("NumberOfLicencesRequired", typeof(long));
var applicationProvinceIDParameter = applicationProvinceID.HasValue ?
new ObjectParameter("ApplicationProvinceID", applicationProvinceID) :
new ObjectParameter("ApplicationProvinceID", typeof(short));
var applicationRegionIDParameter = applicationRegionID.HasValue ?
new ObjectParameter("ApplicationRegionID", applicationRegionID) :
new ObjectParameter("ApplicationRegionID", typeof(short));
var applicationAssociationIDParameter = applicationAssociationID.HasValue ?
new ObjectParameter("ApplicationAssociationID", applicationAssociationID) :
new ObjectParameter("ApplicationAssociationID", typeof(long));
var applicationAllowedNewLicenceIDsParameter = applicationAllowedNewLicenceIDs != null ?
new ObjectParameter("ApplicationAllowedNewLicenceIDs", applicationAllowedNewLicenceIDs) :
new ObjectParameter("ApplicationAllowedNewLicenceIDs", typeof(string));
var selectedRouteIDsParameter = selectedRouteIDs != null ?
new ObjectParameter("SelectedRouteIDs", selectedRouteIDs) :
new ObjectParameter("SelectedRouteIDs", typeof(string));
var parentApplicationDetailIDParameter = parentApplicationDetailID.HasValue ?
new ObjectParameter("ParentApplicationDetailID", parentApplicationDetailID) :
new ObjectParameter("ParentApplicationDetailID", typeof(long));
var parentApplicationLicenceIDParameter = parentApplicationLicenceID.HasValue ?
new ObjectParameter("ParentApplicationLicenceID", parentApplicationLicenceID) :
new ObjectParameter("ParentApplicationLicenceID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationPrecheckCreate", applicationRequestTypeIDParameter, sourceApplicationIDParameter, applicantNameParameter, telCellParameter, idTypeIDParameter, idOrBusinessRegistrationNumberParameter, originatingLicenceNumbersParameter, originatingAccreditationNumberParameter, vehicleTypeIDParameter, serviceTypeIDsParameter, numberOfLicencesRequiredParameter, applicationProvinceIDParameter, applicationRegionIDParameter, applicationAssociationIDParameter, applicationAllowedNewLicenceIDsParameter, selectedRouteIDsParameter, parentApplicationDetailIDParameter, parentApplicationLicenceIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_GetApplicationRequestTypeDocuments(Nullable applicationPrecheckDetailID, Nullable applicationRequestTypeID, Nullable workflowTemplateID, Nullable memberID, Nullable userID, Nullable primaryServiceTypeID)
{
var applicationPrecheckDetailIDParameter = applicationPrecheckDetailID.HasValue ?
new ObjectParameter("ApplicationPrecheckDetailID", applicationPrecheckDetailID) :
new ObjectParameter("ApplicationPrecheckDetailID", typeof(long));
var applicationRequestTypeIDParameter = applicationRequestTypeID.HasValue ?
new ObjectParameter("ApplicationRequestTypeID", applicationRequestTypeID) :
new ObjectParameter("ApplicationRequestTypeID", typeof(short));
var workflowTemplateIDParameter = workflowTemplateID.HasValue ?
new ObjectParameter("WorkflowTemplateID", workflowTemplateID) :
new ObjectParameter("WorkflowTemplateID", typeof(long));
var memberIDParameter = memberID.HasValue ?
new ObjectParameter("MemberID", memberID) :
new ObjectParameter("MemberID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
var primaryServiceTypeIDParameter = primaryServiceTypeID.HasValue ?
new ObjectParameter("PrimaryServiceTypeID", primaryServiceTypeID) :
new ObjectParameter("PrimaryServiceTypeID", typeof(short));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_GetApplicationRequestTypeDocuments", applicationPrecheckDetailIDParameter, applicationRequestTypeIDParameter, workflowTemplateIDParameter, memberIDParameter, userIDParameter, primaryServiceTypeIDParameter);
}
public virtual int Pr_ApplicationLicenceDetailUpdate(Nullable applicationLicenceID, Nullable specialLicenceDateFrom, Nullable specialLicenceDateTo, string specialLicenceDetails, string reasonForAmendment, Nullable userID)
{
var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
new ObjectParameter("ApplicationLicenceID", typeof(long));
var specialLicenceDateFromParameter = specialLicenceDateFrom.HasValue ?
new ObjectParameter("SpecialLicenceDateFrom", specialLicenceDateFrom) :
new ObjectParameter("SpecialLicenceDateFrom", typeof(System.DateTime));
var specialLicenceDateToParameter = specialLicenceDateTo.HasValue ?
new ObjectParameter("SpecialLicenceDateTo", specialLicenceDateTo) :
new ObjectParameter("SpecialLicenceDateTo", typeof(System.DateTime));
var specialLicenceDetailsParameter = specialLicenceDetails != null ?
new ObjectParameter("SpecialLicenceDetails", specialLicenceDetails) :
new ObjectParameter("SpecialLicenceDetails", typeof(string));
var reasonForAmendmentParameter = reasonForAmendment != null ?
new ObjectParameter("ReasonForAmendment", reasonForAmendment) :
new ObjectParameter("ReasonForAmendment", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceDetailUpdate", applicationLicenceIDParameter, specialLicenceDateFromParameter, specialLicenceDateToParameter, specialLicenceDetailsParameter, reasonForAmendmentParameter, userIDParameter);
}
public virtual ObjectResult Pr_MemberAssociationSearch(Nullable memberID, Nullable userID)
{
var memberIDParameter = memberID.HasValue ?
new ObjectParameter("MemberID", memberID) :
new ObjectParameter("MemberID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_MemberAssociationSearch", memberIDParameter, userIDParameter);
}
public virtual int Pr_ApplicationTagCreate(Nullable applicationDetailID, Nullable tagID, Nullable isUserTag, Nullable allowDuplicate, Nullable createdByID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var tagIDParameter = tagID.HasValue ?
new ObjectParameter("TagID", tagID) :
new ObjectParameter("TagID", typeof(long));
var isUserTagParameter = isUserTag.HasValue ?
new ObjectParameter("IsUserTag", isUserTag) :
new ObjectParameter("IsUserTag", typeof(bool));
var allowDuplicateParameter = allowDuplicate.HasValue ?
new ObjectParameter("AllowDuplicate", allowDuplicate) :
new ObjectParameter("AllowDuplicate", typeof(bool));
var createdByIDParameter = createdByID.HasValue ?
new ObjectParameter("CreatedByID", createdByID) :
new ObjectParameter("CreatedByID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationTagCreate", applicationDetailIDParameter, tagIDParameter, isUserTagParameter, allowDuplicateParameter, createdByIDParameter);
}
public virtual int Pr_ApplicationTagRemove(Nullable applicationDetailID, Nullable tagID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var tagIDParameter = tagID.HasValue ?
new ObjectParameter("TagID", tagID) :
new ObjectParameter("TagID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationTagRemove", applicationDetailIDParameter, tagIDParameter, userIDParameter);
}
public virtual int Pr_ApplicationTagClear(Nullable applicationTagID, Nullable applicationDetailID, Nullable isTagCleared, string comments, Nullable userID)
{
var applicationTagIDParameter = applicationTagID.HasValue ?
new ObjectParameter("ApplicationTagID", applicationTagID) :
new ObjectParameter("ApplicationTagID", typeof(long));
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var isTagClearedParameter = isTagCleared.HasValue ?
new ObjectParameter("IsTagCleared", isTagCleared) :
new ObjectParameter("IsTagCleared", typeof(bool));
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_ApplicationTagClear", applicationTagIDParameter, applicationDetailIDParameter, isTagClearedParameter, commentsParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreateGetMemberAllowedNewSummary(string idNumberOrBusinessRegistrationNumber, Nullable userID)
{
var idNumberOrBusinessRegistrationNumberParameter = idNumberOrBusinessRegistrationNumber != null ?
new ObjectParameter("IdNumberOrBusinessRegistrationNumber", idNumberOrBusinessRegistrationNumber) :
new ObjectParameter("IdNumberOrBusinessRegistrationNumber", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateGetMemberAllowedNewSummary", idNumberOrBusinessRegistrationNumberParameter, userIDParameter);
}
public virtual int Pr_ApplicationLicenceRouteDetailUpdate(Nullable applicationLicenceID, Nullable applicationLicenceRouteDetailID, string routeOrigin, string routeDestination, string routeDescription, Nullable userID)
{
var applicationLicenceIDParameter = applicationLicenceID.HasValue ?
new ObjectParameter("ApplicationLicenceID", applicationLicenceID) :
new ObjectParameter("ApplicationLicenceID", typeof(long));
var applicationLicenceRouteDetailIDParameter = applicationLicenceRouteDetailID.HasValue ?
new ObjectParameter("ApplicationLicenceRouteDetailID", applicationLicenceRouteDetailID) :
new ObjectParameter("ApplicationLicenceRouteDetailID", typeof(long));
var routeOriginParameter = routeOrigin != null ?
new ObjectParameter("RouteOrigin", routeOrigin) :
new ObjectParameter("RouteOrigin", typeof(string));
var routeDestinationParameter = routeDestination != null ?
new ObjectParameter("RouteDestination", routeDestination) :
new ObjectParameter("RouteDestination", typeof(string));
var routeDescriptionParameter = routeDescription != null ?
new ObjectParameter("RouteDescription", routeDescription) :
new ObjectParameter("RouteDescription", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceRouteDetailUpdate", applicationLicenceIDParameter, applicationLicenceRouteDetailIDParameter, routeOriginParameter, routeDestinationParameter, routeDescriptionParameter, userIDParameter);
}
public virtual int Pr_ReceiptApplicationPaymentTypeUpdate(Nullable applicationDetailID, Nullable receiptDetailID, Nullable paymentTypeID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var receiptDetailIDParameter = receiptDetailID.HasValue ?
new ObjectParameter("ReceiptDetailID", receiptDetailID) :
new ObjectParameter("ReceiptDetailID", typeof(long));
var paymentTypeIDParameter = paymentTypeID.HasValue ?
new ObjectParameter("PaymentTypeID", paymentTypeID) :
new ObjectParameter("PaymentTypeID", typeof(short));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ReceiptApplicationPaymentTypeUpdate", applicationDetailIDParameter, receiptDetailIDParameter, paymentTypeIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicantUnassignedReceiptGet(Nullable applicantDetailID, Nullable userID)
{
var applicantDetailIDParameter = applicantDetailID.HasValue ?
new ObjectParameter("ApplicantDetailID", applicantDetailID) :
new ObjectParameter("ApplicantDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicantUnassignedReceiptGet", applicantDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicantUnassignedReceiptGet(Nullable applicantDetailID, Nullable userID, MergeOption mergeOption)
{
var applicantDetailIDParameter = applicantDetailID.HasValue ?
new ObjectParameter("ApplicantDetailID", applicantDetailID) :
new ObjectParameter("ApplicantDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicantUnassignedReceiptGet", mergeOption, applicantDetailIDParameter, userIDParameter);
}
public virtual int Pr_ReceiptAddToApplication(Nullable receiptDetailID, Nullable applicationDetailID, Nullable userID)
{
var receiptDetailIDParameter = receiptDetailID.HasValue ?
new ObjectParameter("ReceiptDetailID", receiptDetailID) :
new ObjectParameter("ReceiptDetailID", typeof(long));
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ReceiptAddToApplication", receiptDetailIDParameter, applicationDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_TAT_AdjudicationPrecheckSearch(string applicantIDNumber, string applicantName, string oLAndPermitNumber, string applicationLicenceReferenceNumber, Nullable userID)
{
var applicantIDNumberParameter = applicantIDNumber != null ?
new ObjectParameter("ApplicantIDNumber", applicantIDNumber) :
new ObjectParameter("ApplicantIDNumber", typeof(string));
var applicantNameParameter = applicantName != null ?
new ObjectParameter("ApplicantName", applicantName) :
new ObjectParameter("ApplicantName", typeof(string));
var oLAndPermitNumberParameter = oLAndPermitNumber != null ?
new ObjectParameter("OLAndPermitNumber", oLAndPermitNumber) :
new ObjectParameter("OLAndPermitNumber", typeof(string));
var applicationLicenceReferenceNumberParameter = applicationLicenceReferenceNumber != null ?
new ObjectParameter("ApplicationLicenceReferenceNumber", applicationLicenceReferenceNumber) :
new ObjectParameter("ApplicationLicenceReferenceNumber", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_TAT_AdjudicationPrecheckSearch", applicantIDNumberParameter, applicantNameParameter, oLAndPermitNumberParameter, applicationLicenceReferenceNumberParameter, userIDParameter);
}
public virtual ObjectResult Pr_TAT_ApplicationCreate(Nullable applicationPrecheckDetailID, Nullable userID)
{
var applicationPrecheckDetailIDParameter = applicationPrecheckDetailID.HasValue ?
new ObjectParameter("ApplicationPrecheckDetailID", applicationPrecheckDetailID) :
new ObjectParameter("ApplicationPrecheckDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_TAT_ApplicationCreate", applicationPrecheckDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_TAT_ApplicationCreate(Nullable applicationPrecheckDetailID, Nullable userID, MergeOption mergeOption)
{
var applicationPrecheckDetailIDParameter = applicationPrecheckDetailID.HasValue ?
new ObjectParameter("ApplicationPrecheckDetailID", applicationPrecheckDetailID) :
new ObjectParameter("ApplicationPrecheckDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_TAT_ApplicationCreate", mergeOption, applicationPrecheckDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationLicenceRadiusRouteDescriptionCalculate(Nullable applicationLicenceRouteDetailID, Nullable userID)
{
var applicationLicenceRouteDetailIDParameter = applicationLicenceRouteDetailID.HasValue ?
new ObjectParameter("ApplicationLicenceRouteDetailID", applicationLicenceRouteDetailID) :
new ObjectParameter("ApplicationLicenceRouteDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationLicenceRadiusRouteDescriptionCalculate", applicationLicenceRouteDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationCreateGetAssociationRoutes(Nullable associationID, Nullable userID)
{
var associationIDParameter = associationID.HasValue ?
new ObjectParameter("AssociationID", associationID) :
new ObjectParameter("AssociationID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCreateGetAssociationRoutes", associationIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationGazetteGet(Nullable applicationDetailID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationGazetteGet", applicationDetailIDParameter, userIDParameter);
}
public virtual ObjectResult Pr_ApplicationRequestNewRouteRequestsGet(Nullable applicationDetailID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestNewRouteRequestsGet", applicationDetailIDParameter, userIDParameter);
}
public virtual int Pr_DocumentsPrecheckUpdate(Nullable documentsPrecheckID, Nullable received)
{
var documentsPrecheckIDParameter = documentsPrecheckID.HasValue ?
new ObjectParameter("DocumentsPrecheckID", documentsPrecheckID) :
new ObjectParameter("DocumentsPrecheckID", typeof(long));
var receivedParameter = received.HasValue ?
new ObjectParameter("Received", received) :
new ObjectParameter("Received", typeof(bool));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DocumentsPrecheckUpdate", documentsPrecheckIDParameter, receivedParameter);
}
public virtual ObjectResult Pr_ApplicationReceiptsGet(Nullable applicationDetailID, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationReceiptsGet", applicationDetailIDParameter, userIDParameter);
}
public virtual int Pr_ReceiptApplicationProofOfPaymentRefNoUpdate(Nullable applicationDetailID, Nullable receiptDetailID, string proofOfPaymentRefNo, Nullable userID)
{
var applicationDetailIDParameter = applicationDetailID.HasValue ?
new ObjectParameter("ApplicationDetailID", applicationDetailID) :
new ObjectParameter("ApplicationDetailID", typeof(long));
var receiptDetailIDParameter = receiptDetailID.HasValue ?
new ObjectParameter("ReceiptDetailID", receiptDetailID) :
new ObjectParameter("ReceiptDetailID", typeof(long));
var proofOfPaymentRefNoParameter = proofOfPaymentRefNo != null ?
new ObjectParameter("ProofOfPaymentRefNo", proofOfPaymentRefNo) :
new ObjectParameter("ProofOfPaymentRefNo", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ReceiptApplicationProofOfPaymentRefNoUpdate", applicationDetailIDParameter, receiptDetailIDParameter, proofOfPaymentRefNoParameter, userIDParameter);
}
}
}