//------------------------------------------------------------------------------
//
// 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.Legitimate.ApplicationRequest.Models
{
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 ApplicationApplicantDetails { get; set; }
public virtual DbSet ApplicationModeDetails { get; set; }
public virtual DbSet ApplicationProxyDetails { get; set; }
public virtual DbSet ApplicationRequestDetails { get; set; }
public virtual DbSet ApplicationRouteDetails { get; set; }
public virtual DbSet ApplicationServiceDetails { get; set; }
public virtual DbSet ApplicationDocuments { get; set; }
public virtual DbSet ApplicationContractDetails { get; set; }
public virtual DbSet ApplicationRequestTypes { get; set; }
public virtual DbSet ReceiptDetails { get; set; }
public virtual DbSet ApplicationRequestTypeDocuments { get; set; }
public virtual DbSet DocumentTypes { get; set; }
public virtual DbSet PrecheckDetails { get; set; }
public virtual DbSet ApplicationExistingLicenceHolders { get; set; }
public virtual DbSet ApplicationExistingLicences { get; set; }
public virtual DbSet ApplicationRankDetails { get; set; }
public virtual DbSet PaymentTypes { get; set; }
public virtual DbSet AssociationModes { get; set; }
public virtual DbSet AssociationTypes { get; set; }
public virtual DbSet ContractTypes { get; set; }
public virtual DbSet IDTypes { get; set; }
public virtual DbSet Modes { get; set; }
public virtual DbSet PlaceTypes { get; set; }
public virtual DbSet Provinces { get; set; }
public virtual DbSet Regions { get; set; }
public virtual DbSet RouteTypes { get; set; }
public virtual DbSet ServiceTypes { get; set; }
public virtual DbSet SourceApplications { get; set; }
public virtual DbSet VehicleMakes { get; set; }
public virtual DbSet VehicleTypes { get; set; }
public virtual DbSet WaypointTypes { get; set; }
public virtual DbSet Vw_NewRouteRequestDetails { get; set; }
public virtual DbSet BusinessTypes { get; set; }
public virtual DbSet ApplicationRequestObjections { get; set; }
public virtual DbSet Routes { get; set; }
public virtual DbSet ApplicationExistingVehicleDetails { get; set; }
public virtual DbSet ApplicationVehicleDetails { get; set; }
public virtual DbSet Vw_ApplicationRequestDetails { get; set; }
public virtual DbSet ApplicationAllowedExpiredLicences { get; set; }
public virtual DbSet AdjudicationDecisions { get; set; }
public virtual DbSet ApplicationRequestAdjudicationDecisions { get; set; }
public virtual DbSet LicenceDurations { get; set; }
public virtual DbSet GazetteDetails { get; set; }
public virtual DbSet Users { get; set; }
public virtual DbSet ApplicationVehicleDetailsInBulks { get; set; }
public virtual int Pr_LogPrintReceipt(Nullable receiptDetailID, Nullable 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 Pr_NewRouteRequestDetailsSearch(Nullable newRouteRequestDetailID, Nullable workflowInstanceStatusID, string description)
{
var newRouteRequestDetailIDParameter = newRouteRequestDetailID.HasValue ?
new ObjectParameter("NewRouteRequestDetailID", newRouteRequestDetailID) :
new ObjectParameter("NewRouteRequestDetailID", typeof(long));
var workflowInstanceStatusIDParameter = workflowInstanceStatusID.HasValue ?
new ObjectParameter("WorkflowInstanceStatusID", workflowInstanceStatusID) :
new ObjectParameter("WorkflowInstanceStatusID", typeof(short));
var descriptionParameter = description != null ?
new ObjectParameter("Description", description) :
new ObjectParameter("Description", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_NewRouteRequestDetailsSearch", newRouteRequestDetailIDParameter, workflowInstanceStatusIDParameter, descriptionParameter);
}
public virtual ObjectResult Pr_NewRouteRequestDetailsSearch(Nullable newRouteRequestDetailID, Nullable workflowInstanceStatusID, string description, MergeOption mergeOption)
{
var newRouteRequestDetailIDParameter = newRouteRequestDetailID.HasValue ?
new ObjectParameter("NewRouteRequestDetailID", newRouteRequestDetailID) :
new ObjectParameter("NewRouteRequestDetailID", typeof(long));
var workflowInstanceStatusIDParameter = workflowInstanceStatusID.HasValue ?
new ObjectParameter("WorkflowInstanceStatusID", workflowInstanceStatusID) :
new ObjectParameter("WorkflowInstanceStatusID", typeof(short));
var descriptionParameter = description != null ?
new ObjectParameter("Description", description) :
new ObjectParameter("Description", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_NewRouteRequestDetailsSearch", mergeOption, newRouteRequestDetailIDParameter, workflowInstanceStatusIDParameter, descriptionParameter);
}
public virtual ObjectResult Pr_ApplicationRequestDetailsSearch(Nullable applicationRequestDetailID, Nullable workflowInstanceStatusID, string workflowTaskSteps, Nullable includeActiveTasksOnly, Nullable adjudicationDetailID, Nullable hasAdjudicationDecision, Nullable 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", applicationRequestDetailIDParameter, workflowInstanceStatusIDParameter, workflowTaskStepsParameter, includeActiveTasksOnlyParameter, adjudicationDetailIDParameter, hasAdjudicationDecisionParameter, userIDParameter);
}
public virtual int Pr_AssociationMemberAdd(Nullable associationID, Nullable memberID, Nullable userID)
{
var associationIDParameter = associationID.HasValue ?
new ObjectParameter("AssociationID", associationID) :
new ObjectParameter("AssociationID", 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));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_AssociationMemberAdd", associationIDParameter, memberIDParameter, userIDParameter);
}
public virtual ObjectResult> Pr_AssociationUpsert(Nullable associationID, Nullable associationModeID, Nullable associationTypeID, Nullable regionID, string associationName, string associationNameAbbrev, string registrationNumber, string postalAddress, string postalAddressCode, string physicalAddress, string physicalAddressCode, Nullable postalAddressIsDomicilium, string busRegNumber, string taxNumber, string telNumber, string faxNumber, string cellNumber, string emailAddress, Nullable olasID, Nullable ltpsID, Nullable userID, string auditDescription, Nullable forceUpdateIfExists)
{
var associationIDParameter = associationID.HasValue ?
new ObjectParameter("AssociationID", associationID) :
new ObjectParameter("AssociationID", typeof(long));
var associationModeIDParameter = associationModeID.HasValue ?
new ObjectParameter("AssociationModeID", associationModeID) :
new ObjectParameter("AssociationModeID", typeof(int));
var associationTypeIDParameter = associationTypeID.HasValue ?
new ObjectParameter("AssociationTypeID", associationTypeID) :
new ObjectParameter("AssociationTypeID", typeof(short));
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));
var associationNameAbbrevParameter = associationNameAbbrev != null ?
new ObjectParameter("AssociationNameAbbrev", associationNameAbbrev) :
new ObjectParameter("AssociationNameAbbrev", typeof(string));
var registrationNumberParameter = registrationNumber != null ?
new ObjectParameter("RegistrationNumber", registrationNumber) :
new ObjectParameter("RegistrationNumber", 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 postalAddressIsDomiciliumParameter = postalAddressIsDomicilium.HasValue ?
new ObjectParameter("PostalAddressIsDomicilium", postalAddressIsDomicilium) :
new ObjectParameter("PostalAddressIsDomicilium", typeof(bool));
var busRegNumberParameter = busRegNumber != null ?
new ObjectParameter("BusRegNumber", busRegNumber) :
new ObjectParameter("BusRegNumber", typeof(string));
var taxNumberParameter = taxNumber != null ?
new ObjectParameter("TaxNumber", taxNumber) :
new ObjectParameter("TaxNumber", typeof(string));
var telNumberParameter = telNumber != null ?
new ObjectParameter("TelNumber", telNumber) :
new ObjectParameter("TelNumber", typeof(string));
var faxNumberParameter = faxNumber != null ?
new ObjectParameter("FaxNumber", faxNumber) :
new ObjectParameter("FaxNumber", typeof(string));
var cellNumberParameter = cellNumber != null ?
new ObjectParameter("CellNumber", cellNumber) :
new ObjectParameter("CellNumber", typeof(string));
var emailAddressParameter = emailAddress != null ?
new ObjectParameter("EmailAddress", emailAddress) :
new ObjectParameter("EmailAddress", 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>("Pr_AssociationUpsert", associationIDParameter, associationModeIDParameter, associationTypeIDParameter, regionIDParameter, associationNameParameter, associationNameAbbrevParameter, registrationNumberParameter, postalAddressParameter, postalAddressCodeParameter, physicalAddressParameter, physicalAddressCodeParameter, postalAddressIsDomiciliumParameter, busRegNumberParameter, taxNumberParameter, telNumberParameter, faxNumberParameter, cellNumberParameter, emailAddressParameter, olasIDParameter, ltpsIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
}
public virtual ObjectResult> Pr_MemberUpsert(Nullable memberID, Nullable identityDocumentDocID, Nullable taxClearanceCertificateDocID, string surnameOrCompanyName, string firstNames, Nullable iDTypeID, string iDTypeDescription, string iDNumberOrBusinessRegistrationNo, string postalAddress, string postalAddressCode, string physicalAddress, string physicalAddressCode, string telPhone, string telCell, string telFax, string email, string sARSIncomeTaxNumber, string sARSReasonIfNoTaxNumber, string tradeName, Nullable olasID, Nullable ltpsID, Nullable businessTypeID, Nullable userID, string auditDescription, Nullable forceUpdateIfExists)
{
var memberIDParameter = memberID.HasValue ?
new ObjectParameter("MemberID", memberID) :
new ObjectParameter("MemberID", typeof(long));
var identityDocumentDocIDParameter = identityDocumentDocID.HasValue ?
new ObjectParameter("IdentityDocumentDocID", identityDocumentDocID) :
new ObjectParameter("IdentityDocumentDocID", typeof(long));
var taxClearanceCertificateDocIDParameter = taxClearanceCertificateDocID.HasValue ?
new ObjectParameter("TaxClearanceCertificateDocID", taxClearanceCertificateDocID) :
new ObjectParameter("TaxClearanceCertificateDocID", 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 iDTypeIDParameter = iDTypeID.HasValue ?
new ObjectParameter("IDTypeID", iDTypeID) :
new ObjectParameter("IDTypeID", typeof(short));
var iDTypeDescriptionParameter = iDTypeDescription != null ?
new ObjectParameter("IDTypeDescription", iDTypeDescription) :
new ObjectParameter("IDTypeDescription", typeof(string));
var iDNumberOrBusinessRegistrationNoParameter = iDNumberOrBusinessRegistrationNo != null ?
new ObjectParameter("IDNumberOrBusinessRegistrationNo", iDNumberOrBusinessRegistrationNo) :
new ObjectParameter("IDNumberOrBusinessRegistrationNo", 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 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 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));
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>("Pr_MemberUpsert", memberIDParameter, identityDocumentDocIDParameter, taxClearanceCertificateDocIDParameter, surnameOrCompanyNameParameter, firstNamesParameter, iDTypeIDParameter, iDTypeDescriptionParameter, iDNumberOrBusinessRegistrationNoParameter, postalAddressParameter, postalAddressCodeParameter, physicalAddressParameter, physicalAddressCodeParameter, telPhoneParameter, telCellParameter, telFaxParameter, emailParameter, sARSIncomeTaxNumberParameter, sARSReasonIfNoTaxNumberParameter, tradeNameParameter, olasIDParameter, ltpsIDParameter, businessTypeIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
}
public virtual ObjectResult> Pr_PlaceUpsert(Nullable placeID, string description, Nullable placeTypeID, Nullable olasID, Nullable ltpsID, Nullable userID, string auditDescription, Nullable 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>("Pr_PlaceUpsert", placeIDParameter, descriptionParameter, placeTypeIDParameter, olasIDParameter, ltpsIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
}
public virtual int Pr_RouteNodeRemove(Nullable routeID, Nullable placeID, Nullable 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 userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_RouteNodeRemove", routeIDParameter, placeIDParameter, userIDParameter);
}
public virtual ObjectResult> Pr_RouteUpsert(Nullable routeID, Nullable routeTypeID, string routeName, string description, Nullable originPlaceID, Nullable destinationPlaceID, string nationalRouteNumber, string boardRouteNumber, Nullable routeLength, Nullable timeTableDocumentID, Nullable fareScheduleDocumentID, Nullable olasID, Nullable ltpsID, Nullable userID, string auditDescription, Nullable forceUpdateIfExists)
{
var routeIDParameter = routeID.HasValue ?
new ObjectParameter("RouteID", routeID) :
new ObjectParameter("RouteID", typeof(long));
var routeTypeIDParameter = routeTypeID.HasValue ?
new ObjectParameter("RouteTypeID", routeTypeID) :
new ObjectParameter("RouteTypeID", typeof(short));
var routeNameParameter = routeName != null ?
new ObjectParameter("RouteName", routeName) :
new ObjectParameter("RouteName", typeof(string));
var descriptionParameter = description != null ?
new ObjectParameter("Description", description) :
new ObjectParameter("Description", typeof(string));
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 routeLengthParameter = routeLength.HasValue ?
new ObjectParameter("RouteLength", routeLength) :
new ObjectParameter("RouteLength", typeof(double));
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 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>("Pr_RouteUpsert", routeIDParameter, routeTypeIDParameter, routeNameParameter, descriptionParameter, originPlaceIDParameter, destinationPlaceIDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, routeLengthParameter, timeTableDocumentIDParameter, fareScheduleDocumentIDParameter, olasIDParameter, ltpsIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
}
public virtual ObjectResult> Pr_VehicleUpsert(Nullable vehicleID, string registrationNumber, string engineNumber, string vIN, Nullable seatedCapacity, Nullable standingCapacity, Nullable grossMass, Nullable vehicleMakeID, Nullable vehicleTypeID, Nullable carryingCapacityID, string yearOfManufacture, Nullable olasID, Nullable ltpsID, Nullable userID, string auditDescription, Nullable 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>("Pr_VehicleUpsert", vehicleIDParameter, registrationNumberParameter, engineNumberParameter, vINParameter, seatedCapacityParameter, standingCapacityParameter, grossMassParameter, vehicleMakeIDParameter, vehicleTypeIDParameter, carryingCapacityIDParameter, yearOfManufactureParameter, olasIDParameter, ltpsIDParameter, userIDParameter, auditDescriptionParameter, forceUpdateIfExistsParameter);
}
public virtual int Pr_ApplicationRequestPostSaveProcess(Nullable applicationRequestDetailID, Nullable 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_ApplicationRequestPostSaveProcess", applicationRequestDetailIDParameter, userIDParameter);
}
public virtual int Pr_RouteNodeAdd(Nullable routeID, Nullable placeID, Nullable waypointTypeID, Nullable distanceFromOrigin, Nullable sequence, Nullable 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 int Pr_ApplicationRequestObjectionUpsert(Nullable applicationRequestObjectionID, Nullable applicationRequestDetailID, string objector, string objection, Nullable objectionDate, string postalAddress, string postalAddressCode, string telPhone, string telCell, string telFax, string email, Nullable objectionDocumentID, Nullable userID)
{
var applicationRequestObjectionIDParameter = applicationRequestObjectionID.HasValue ?
new ObjectParameter("ApplicationRequestObjectionID", applicationRequestObjectionID) :
new ObjectParameter("ApplicationRequestObjectionID", typeof(long));
var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
new ObjectParameter("ApplicationRequestDetailID", typeof(long));
var objectorParameter = objector != null ?
new ObjectParameter("Objector", objector) :
new ObjectParameter("Objector", typeof(string));
var objectionParameter = objection != null ?
new ObjectParameter("Objection", objection) :
new ObjectParameter("Objection", typeof(string));
var objectionDateParameter = objectionDate.HasValue ?
new ObjectParameter("ObjectionDate", objectionDate) :
new ObjectParameter("ObjectionDate", typeof(System.DateTime));
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 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 objectionDocumentIDParameter = objectionDocumentID.HasValue ?
new ObjectParameter("ObjectionDocumentID", objectionDocumentID) :
new ObjectParameter("ObjectionDocumentID", typeof(long));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationRequestObjectionUpsert", applicationRequestObjectionIDParameter, applicationRequestDetailIDParameter, objectorParameter, objectionParameter, objectionDateParameter, postalAddressParameter, postalAddressCodeParameter, telPhoneParameter, telCellParameter, telFaxParameter, emailParameter, objectionDocumentIDParameter, userIDParameter);
}
public virtual int Pr_ApplicationCheckSecurity(Nullable applicationRequestDetailID, string action, Nullable userID)
{
var applicationRequestDetailIDParameter = applicationRequestDetailID.HasValue ?
new ObjectParameter("ApplicationRequestDetailID", applicationRequestDetailID) :
new ObjectParameter("ApplicationRequestDetailID", typeof(long));
var actionParameter = action != null ?
new ObjectParameter("Action", action) :
new ObjectParameter("Action", typeof(string));
var userIDParameter = userID.HasValue ?
new ObjectParameter("UserID", userID) :
new ObjectParameter("UserID", typeof(long));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ApplicationCheckSecurity", applicationRequestDetailIDParameter, actionParameter, userIDParameter);
}
[DbFunction("ApplicationContext", "Fn_GetSourceApplicationRecordsFromSourceSystem")]
public virtual IQueryable Fn_GetSourceApplicationRecordsFromSourceSystem(string olPermitNumber, Nullable sourceApplicationID, Nullable modeID, Nullable inlcudeActiveOnly, Nullable 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("[ApplicationContext].[Fn_GetSourceApplicationRecordsFromSourceSystem](@OlPermitNumber, @SourceApplicationID, @ModeID, @InlcudeActiveOnly, @IncludeLastExpiredIfNoActiveFound)", olPermitNumberParameter, sourceApplicationIDParameter, modeIDParameter, inlcudeActiveOnlyParameter, includeLastExpiredIfNoActiveFoundParameter);
}
public virtual ObjectResult Pr_RouteSearch(Nullable originPlaceID, Nullable destinationPlaceID, string nationalRouteNumber, string boardRouteNumber, Nullable associationID, string description, Nullable routeStatusID, Nullable routesInVerification, Nullable applicationRequestDetailID, Nullable 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", originPlaceIDParameter, destinationPlaceIDParameter, nationalRouteNumberParameter, boardRouteNumberParameter, associationIDParameter, descriptionParameter, routeStatusIDParameter, routesInVerificationParameter, applicationRequestDetailIDParameter, applicationRequestTypeIDParameter);
}
public virtual ObjectResult> Pr_PrecheckDetailsUpsert(Nullable precheckDetailID, Nullable applicationRequestTypeID, Nullable sourceApplicationID, string applicantName, string olPermitNumber, string iDNumber, string chassisNumber, string vehicleRegistrationNumber, Nullable associationID, Nullable checkData, Nullable precheckDetailIncompleteReasonID, string contactEmail, string contactCell, Nullable numberOfVehiclesRequired, Nullable userID, Nullable modeID, Nullable serviceTypeID, Nullable 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>("Pr_PrecheckDetailsUpsert", precheckDetailIDParameter, applicationRequestTypeIDParameter, sourceApplicationIDParameter, applicantNameParameter, olPermitNumberParameter, iDNumberParameter, chassisNumberParameter, vehicleRegistrationNumberParameter, associationIDParameter, checkDataParameter, precheckDetailIncompleteReasonIDParameter, contactEmailParameter, contactCellParameter, numberOfVehiclesRequiredParameter, userIDParameter, modeIDParameter, serviceTypeIDParameter, calledFromSaveParameter);
}
}
}