//------------------------------------------------------------------------------
// <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 Common
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class DataModel : DbContext
    {
        public DataModel()
            : base("name=DataModel")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<DriverAction> DriverActions { get; set; }
        public virtual DbSet<DriverLog> DriverLogs { get; set; }
        public virtual DbSet<Setting> Settings { get; set; }
        public virtual DbSet<Dispatch> Dispatches { get; set; }
        public virtual DbSet<Invoice> Invoices { get; set; }
        public virtual DbSet<InvoiceStatu> InvoiceStatus { get; set; }
        public virtual DbSet<Location> Locations { get; set; }
        public virtual DbSet<OperatorLogin> OperatorLogins { get; set; }
        public virtual DbSet<OperatorRole> OperatorRoles { get; set; }
        public virtual DbSet<Package> Packages { get; set; }
        public virtual DbSet<Action> Actions { get; set; }
        public virtual DbSet<BagReference> BagReferences { get; set; }
        public virtual DbSet<BillingProfile> BillingProfiles { get; set; }
        public virtual DbSet<CustomerInventory> CustomerInventories { get; set; }
        public virtual DbSet<CustomerInventoryAudit> CustomerInventoryAudits { get; set; }
        public virtual DbSet<CustomerLoginLog> CustomerLoginLogs { get; set; }
        public virtual DbSet<CustomerLogin> CustomerLogins { get; set; }
        public virtual DbSet<Customer> Customers { get; set; }
        public virtual DbSet<CustomerWorkloadBag> CustomerWorkloadBags { get; set; }
        public virtual DbSet<DispatchPackage> DispatchPackages { get; set; }
        public virtual DbSet<DispatchStatu> DispatchStatus { get; set; }
        public virtual DbSet<InventoryItem> InventoryItems { get; set; }
        public virtual DbSet<InventoryItemTypeCategory> InventoryItemTypeCategories { get; set; }
        public virtual DbSet<InventoryItemType> InventoryItemTypes { get; set; }
        public virtual DbSet<InventoryItemTypeSize> InventoryItemTypeSizes { get; set; }
        public virtual DbSet<InvoiceBag> InvoiceBags { get; set; }
        public virtual DbSet<InvoiceItem> InvoiceItems { get; set; }
        public virtual DbSet<WorkloadItem> WorkloadItems { get; set; }
        public virtual DbSet<WorkloadItemsAudit> WorkloadItemsAudits { get; set; }
        public virtual DbSet<Workload> Workloads { get; set; }
        public virtual DbSet<WorkloadsAudit> WorkloadsAudits { get; set; }
        public virtual DbSet<WorkloadStatus> WorkloadStatuses { get; set; }
        public virtual DbSet<WorkloadType> WorkloadTypes { get; set; }
        public virtual DbSet<vwClosedCustomerWorkload> vwClosedCustomerWorkloads { get; set; }
        public virtual DbSet<vwCustomerBagsWaitingCounting> vwCustomerBagsWaitingCountings { get; set; }
        public virtual DbSet<vwCustomerInventory> vwCustomerInventories { get; set; }
        public virtual DbSet<vwCustomerInventoryForWorkload> vwCustomerInventoryForWorkloads { get; set; }
        public virtual DbSet<vwCustomerInventoryWorkload> vwCustomerInventoryWorkloads { get; set; }
        public virtual DbSet<vwDeliveryNoteCategoriesByBagSeal> vwDeliveryNoteCategoriesByBagSeals { get; set; }
        public virtual DbSet<vwDispatchBagPackageContent> vwDispatchBagPackageContents { get; set; }
        public virtual DbSet<vwExcelDataDump> vwExcelDataDumps { get; set; }
        public virtual DbSet<vwInventoryItem> vwInventoryItems { get; set; }
        public virtual DbSet<vwInventoryItemType> vwInventoryItemTypes { get; set; }
        public virtual DbSet<vwInvoiceBagSealCategory> vwInvoiceBagSealCategories { get; set; }
        public virtual DbSet<vwInvoiceCountsRecon> vwInvoiceCountsRecons { get; set; }
        public virtual DbSet<vwOpenCustomerWorkload> vwOpenCustomerWorkloads { get; set; }
        public virtual DbSet<vwPackageContent> vwPackageContents { get; set; }
        public virtual DbSet<vwPackagesReadyForDispatch> vwPackagesReadyForDispatches { get; set; }
        public virtual DbSet<vwWorkloadCategoryTypeCount> vwWorkloadCategoryTypeCounts { get; set; }
        public virtual DbSet<vwWorkloadStatusReport> vwWorkloadStatusReports { get; set; }
        public virtual DbSet<vwWorkloadStatusReportWithCount> vwWorkloadStatusReportWithCounts { get; set; }
        public virtual DbSet<vwInvoicesReadyToPrint> vwInvoicesReadyToPrints { get; set; }
        public virtual DbSet<vwInvoiceItemCount> vwInvoiceItemCounts { get; set; }
        public virtual DbSet<sysdiagram> sysdiagrams { get; set; }
        public virtual DbSet<vwDispatchesOutForDelivery> vwDispatchesOutForDeliveries { get; set; }
        public virtual DbSet<vwCustomerBagsReadyToDispatch> vwCustomerBagsReadyToDispatches { get; set; }
        public virtual DbSet<vwInvoiceCountsCondemned> vwInvoiceCountsCondemneds { get; set; }
        public virtual DbSet<vwInvoicesReadyToPrint2> vwInvoicesReadyToPrint2 { get; set; }
        public virtual DbSet<vwDeliveryNoteCategoriesByBagSeal2> vwDeliveryNoteCategoriesByBagSeal2 { get; set; }
        public virtual DbSet<vwDispatchesReadyToPrint> vwDispatchesReadyToPrints { get; set; }
        public virtual DbSet<DispatchOperator> DispatchOperators { get; set; }
        public virtual DbSet<VAT> VATs { get; set; }
        public virtual DbSet<Company> Companies { get; set; }
    
        public virtual ObjectResult<AcceptCustomerBag_Result> AcceptCustomerBag(Nullable<int> customerId, string uniqueReference, Nullable<int> operatorLoginId)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            var uniqueReferenceParameter = uniqueReference != null ?
                new ObjectParameter("UniqueReference", uniqueReference) :
                new ObjectParameter("UniqueReference", typeof(string));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<AcceptCustomerBag_Result>("AcceptCustomerBag", customerIdParameter, uniqueReferenceParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<CreateDispatch_Result> CreateDispatch(string packages, string bagSeal, Nullable<int> operatorLoginId)
        {
            var packagesParameter = packages != null ?
                new ObjectParameter("Packages", packages) :
                new ObjectParameter("Packages", typeof(string));
    
            var bagSealParameter = bagSeal != null ?
                new ObjectParameter("BagSeal", bagSeal) :
                new ObjectParameter("BagSeal", typeof(string));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<CreateDispatch_Result>("CreateDispatch", packagesParameter, bagSealParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<CreatePackage_Result> CreatePackage(Nullable<int> invoiceItemId, Nullable<int> itemCount, Nullable<int> itemCountStain, Nullable<int> operatorLoginId)
        {
            var invoiceItemIdParameter = invoiceItemId.HasValue ?
                new ObjectParameter("InvoiceItemId", invoiceItemId) :
                new ObjectParameter("InvoiceItemId", typeof(int));
    
            var itemCountParameter = itemCount.HasValue ?
                new ObjectParameter("ItemCount", itemCount) :
                new ObjectParameter("ItemCount", typeof(int));
    
            var itemCountStainParameter = itemCountStain.HasValue ?
                new ObjectParameter("ItemCountStain", itemCountStain) :
                new ObjectParameter("ItemCountStain", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<CreatePackage_Result>("CreatePackage", invoiceItemIdParameter, itemCountParameter, itemCountStainParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<CreateWorkload_Result> CreateWorkload(Nullable<int> customerLoginId, Nullable<int> workloadTypeId, string workloadItems, string reference, Nullable<int> totalBags)
        {
            var customerLoginIdParameter = customerLoginId.HasValue ?
                new ObjectParameter("CustomerLoginId", customerLoginId) :
                new ObjectParameter("CustomerLoginId", typeof(int));
    
            var workloadTypeIdParameter = workloadTypeId.HasValue ?
                new ObjectParameter("WorkloadTypeId", workloadTypeId) :
                new ObjectParameter("WorkloadTypeId", typeof(int));
    
            var workloadItemsParameter = workloadItems != null ?
                new ObjectParameter("WorkloadItems", workloadItems) :
                new ObjectParameter("WorkloadItems", typeof(string));
    
            var referenceParameter = reference != null ?
                new ObjectParameter("Reference", reference) :
                new ObjectParameter("Reference", typeof(string));
    
            var totalBagsParameter = totalBags.HasValue ?
                new ObjectParameter("TotalBags", totalBags) :
                new ObjectParameter("TotalBags", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<CreateWorkload_Result>("CreateWorkload", customerLoginIdParameter, workloadTypeIdParameter, workloadItemsParameter, referenceParameter, totalBagsParameter);
        }
    
        public virtual ObjectResult<FinishCounting_Result> FinishCounting(Nullable<int> workloadId, Nullable<int> operatorLoginId)
        {
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("WorkloadId", workloadId) :
                new ObjectParameter("WorkloadId", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<FinishCounting_Result>("FinishCounting", workloadIdParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<GenerateInvoiceFromWorkloadCounts_Result> GenerateInvoiceFromWorkloadCounts(Nullable<int> workloadId, Nullable<int> operatorLoginId)
        {
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("WorkloadId", workloadId) :
                new ObjectParameter("WorkloadId", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GenerateInvoiceFromWorkloadCounts_Result>("GenerateInvoiceFromWorkloadCounts", workloadIdParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<GetCustomerInventory_Result> GetCustomerInventory(Nullable<int> customerId)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerInventory_Result>("GetCustomerInventory", customerIdParameter);
        }
    
        public virtual ObjectResult<GetCustomerInventoryByCustomerIdWorkloadId_Result> GetCustomerInventoryByCustomerIdWorkloadId(Nullable<int> customerId, Nullable<int> workloadId)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("WorkloadId", workloadId) :
                new ObjectParameter("WorkloadId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerInventoryByCustomerIdWorkloadId_Result>("GetCustomerInventoryByCustomerIdWorkloadId", customerIdParameter, workloadIdParameter);
        }
    
        public virtual ObjectResult<GetCustomerInventoryForWorkload_Result> GetCustomerInventoryForWorkload(Nullable<int> customerId)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerInventoryForWorkload_Result>("GetCustomerInventoryForWorkload", customerIdParameter);
        }
    
        public virtual ObjectResult<GetCustomerLoginFromGuid_Result> GetCustomerLoginFromGuid(string guid)
        {
            var guidParameter = guid != null ?
                new ObjectParameter("Guid", guid) :
                new ObjectParameter("Guid", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerLoginFromGuid_Result>("GetCustomerLoginFromGuid", guidParameter);
        }
    
        public virtual ObjectResult<GetInvoiceForPrinter_Result> GetInvoiceForPrinter(Nullable<int> invoiceId)
        {
            var invoiceIdParameter = invoiceId.HasValue ?
                new ObjectParameter("InvoiceId", invoiceId) :
                new ObjectParameter("InvoiceId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetInvoiceForPrinter_Result>("GetInvoiceForPrinter", invoiceIdParameter);
        }
    
        public virtual ObjectResult<GetWorkloadInventory_Result> GetWorkloadInventory(Nullable<int> workloadId)
        {
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("WorkloadId", workloadId) :
                new ObjectParameter("WorkloadId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetWorkloadInventory_Result>("GetWorkloadInventory", workloadIdParameter);
        }
    
        public virtual ObjectResult<WorkloadInventory_Result> GetWorkloadInventoryForInvoice(Nullable<int> invoiceId)
        {
            var invoiceIdParameter = invoiceId.HasValue ?
                new ObjectParameter("InvoiceId", invoiceId) :
                new ObjectParameter("InvoiceId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<WorkloadInventory_Result>("GetWorkloadInventoryForInvoice", invoiceIdParameter);
        }
    
        public virtual ObjectResult<LoginCustomer_Result> LoginCustomer(string emailAddress, string password, string iPAddress)
        {
            var emailAddressParameter = emailAddress != null ?
                new ObjectParameter("EmailAddress", emailAddress) :
                new ObjectParameter("EmailAddress", typeof(string));
    
            var passwordParameter = password != null ?
                new ObjectParameter("Password", password) :
                new ObjectParameter("Password", typeof(string));
    
            var iPAddressParameter = iPAddress != null ?
                new ObjectParameter("IPAddress", iPAddress) :
                new ObjectParameter("IPAddress", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<LoginCustomer_Result>("LoginCustomer", emailAddressParameter, passwordParameter, iPAddressParameter);
        }
    
        public virtual ObjectResult<LoginOperator_Result> LoginOperator(string username, string password)
        {
            var usernameParameter = username != null ?
                new ObjectParameter("Username", username) :
                new ObjectParameter("Username", typeof(string));
    
            var passwordParameter = password != null ?
                new ObjectParameter("Password", password) :
                new ObjectParameter("Password", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<LoginOperator_Result>("LoginOperator", usernameParameter, passwordParameter);
        }
    
        public virtual int PLSendMail(string server, string from, string recipients, string subject, string body)
        {
            var serverParameter = server != null ?
                new ObjectParameter("server", server) :
                new ObjectParameter("server", typeof(string));
    
            var fromParameter = from != null ?
                new ObjectParameter("from", from) :
                new ObjectParameter("from", typeof(string));
    
            var recipientsParameter = recipients != null ?
                new ObjectParameter("recipients", recipients) :
                new ObjectParameter("recipients", typeof(string));
    
            var subjectParameter = subject != null ?
                new ObjectParameter("subject", subject) :
                new ObjectParameter("subject", typeof(string));
    
            var bodyParameter = body != null ?
                new ObjectParameter("body", body) :
                new ObjectParameter("body", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("PLSendMail", serverParameter, fromParameter, recipientsParameter, subjectParameter, bodyParameter);
        }
    
        public virtual ObjectResult<SaveFingerprint_Result> SaveFingerprint(Nullable<int> operatorLoginId, byte[] fingerprint)
        {
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            var fingerprintParameter = fingerprint != null ?
                new ObjectParameter("Fingerprint", fingerprint) :
                new ObjectParameter("Fingerprint", typeof(byte[]));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SaveFingerprint_Result>("SaveFingerprint", operatorLoginIdParameter, fingerprintParameter);
        }
    
        [DbFunction("DataModel", "Split")]
        public virtual IQueryable<string> Split(string s, string delimiter)
        {
            var sParameter = s != null ?
                new ObjectParameter("S", s) :
                new ObjectParameter("S", typeof(string));
    
            var delimiterParameter = delimiter != null ?
                new ObjectParameter("Delimiter", delimiter) :
                new ObjectParameter("Delimiter", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<string>("[DataModel].[Split](@S, @Delimiter)", sParameter, delimiterParameter);
        }
    
        public virtual ObjectResult<UpdateCustomerInventory_Result> UpdateCustomerInventory(Nullable<int> customerId, Nullable<int> inventoryItemTypeId, Nullable<int> costGeneralWash, Nullable<int> costRepeatWash, Nullable<int> costStainWash, Nullable<int> costRewashWash, Nullable<int> operatorLoginId)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            var inventoryItemTypeIdParameter = inventoryItemTypeId.HasValue ?
                new ObjectParameter("InventoryItemTypeId", inventoryItemTypeId) :
                new ObjectParameter("InventoryItemTypeId", typeof(int));
    
            var costGeneralWashParameter = costGeneralWash.HasValue ?
                new ObjectParameter("CostGeneralWash", costGeneralWash) :
                new ObjectParameter("CostGeneralWash", typeof(int));
    
            var costRepeatWashParameter = costRepeatWash.HasValue ?
                new ObjectParameter("CostRepeatWash", costRepeatWash) :
                new ObjectParameter("CostRepeatWash", typeof(int));
    
            var costStainWashParameter = costStainWash.HasValue ?
                new ObjectParameter("CostStainWash", costStainWash) :
                new ObjectParameter("CostStainWash", typeof(int));
    
            var costRewashWashParameter = costRewashWash.HasValue ?
                new ObjectParameter("CostRewashWash", costRewashWash) :
                new ObjectParameter("CostRewashWash", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateCustomerInventory_Result>("UpdateCustomerInventory", customerIdParameter, inventoryItemTypeIdParameter, costGeneralWashParameter, costRepeatWashParameter, costStainWashParameter, costRewashWashParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<UpdateCustomerLogin_Result> UpdateCustomerLogin(Nullable<int> customerId, string emailAddress, string password, Nullable<bool> isActive, Nullable<bool> isLockedOut)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            var emailAddressParameter = emailAddress != null ?
                new ObjectParameter("EmailAddress", emailAddress) :
                new ObjectParameter("EmailAddress", typeof(string));
    
            var passwordParameter = password != null ?
                new ObjectParameter("Password", password) :
                new ObjectParameter("Password", typeof(string));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            var isLockedOutParameter = isLockedOut.HasValue ?
                new ObjectParameter("IsLockedOut", isLockedOut) :
                new ObjectParameter("IsLockedOut", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateCustomerLogin_Result>("UpdateCustomerLogin", customerIdParameter, emailAddressParameter, passwordParameter, isActiveParameter, isLockedOutParameter);
        }
    
        public virtual ObjectResult<UpdateCustomerWorkloadBag_Result> UpdateCustomerWorkloadBag(Nullable<int> customerLoginId, Nullable<int> workloadId, string uniqueReference)
        {
            var customerLoginIdParameter = customerLoginId.HasValue ?
                new ObjectParameter("CustomerLoginId", customerLoginId) :
                new ObjectParameter("CustomerLoginId", typeof(int));
    
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("WorkloadId", workloadId) :
                new ObjectParameter("WorkloadId", typeof(int));
    
            var uniqueReferenceParameter = uniqueReference != null ?
                new ObjectParameter("UniqueReference", uniqueReference) :
                new ObjectParameter("UniqueReference", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateCustomerWorkloadBag_Result>("UpdateCustomerWorkloadBag", customerLoginIdParameter, workloadIdParameter, uniqueReferenceParameter);
        }
    
        public virtual int UpdateInventoryItemType(string category, string itemType, string size, Nullable<int> inventoryItemTypeId)
        {
            var categoryParameter = category != null ?
                new ObjectParameter("Category", category) :
                new ObjectParameter("Category", typeof(string));
    
            var itemTypeParameter = itemType != null ?
                new ObjectParameter("ItemType", itemType) :
                new ObjectParameter("ItemType", typeof(string));
    
            var sizeParameter = size != null ?
                new ObjectParameter("Size", size) :
                new ObjectParameter("Size", typeof(string));
    
            var inventoryItemTypeIdParameter = inventoryItemTypeId.HasValue ?
                new ObjectParameter("InventoryItemTypeId", inventoryItemTypeId) :
                new ObjectParameter("InventoryItemTypeId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateInventoryItemType", categoryParameter, itemTypeParameter, sizeParameter, inventoryItemTypeIdParameter);
        }
    
        public virtual ObjectResult<UpdateInvoiceItemCount_Result> UpdateInvoiceItemCount(Nullable<int> invoiceId, Nullable<int> inventoryItemTypeId, Nullable<int> count, Nullable<int> operatorLoginId)
        {
            var invoiceIdParameter = invoiceId.HasValue ?
                new ObjectParameter("InvoiceId", invoiceId) :
                new ObjectParameter("InvoiceId", typeof(int));
    
            var inventoryItemTypeIdParameter = inventoryItemTypeId.HasValue ?
                new ObjectParameter("InventoryItemTypeId", inventoryItemTypeId) :
                new ObjectParameter("InventoryItemTypeId", typeof(int));
    
            var countParameter = count.HasValue ?
                new ObjectParameter("Count", count) :
                new ObjectParameter("Count", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateInvoiceItemCount_Result>("UpdateInvoiceItemCount", invoiceIdParameter, inventoryItemTypeIdParameter, countParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<UpdateOperatorLogin_Result> UpdateOperatorLogin(string username, string password, Nullable<int> operatorRoleId, string operatorShift)
        {
            var usernameParameter = username != null ?
                new ObjectParameter("Username", username) :
                new ObjectParameter("Username", typeof(string));
    
            var passwordParameter = password != null ?
                new ObjectParameter("Password", password) :
                new ObjectParameter("Password", typeof(string));
    
            var operatorRoleIdParameter = operatorRoleId.HasValue ?
                new ObjectParameter("OperatorRoleId", operatorRoleId) :
                new ObjectParameter("OperatorRoleId", typeof(int));
    
            var operatorShiftParameter = operatorShift != null ?
                new ObjectParameter("OperatorShift", operatorShift) :
                new ObjectParameter("OperatorShift", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateOperatorLogin_Result>("UpdateOperatorLogin", usernameParameter, passwordParameter, operatorRoleIdParameter, operatorShiftParameter);
        }
    
        public virtual ObjectResult<UpdateWorkloadItem_Result> UpdateWorkloadItem(Nullable<int> workloadId, Nullable<int> customerInventoryId, Nullable<int> itemCount, Nullable<int> customerLoginId, Nullable<int> operatorLoginId)
        {
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("WorkloadId", workloadId) :
                new ObjectParameter("WorkloadId", typeof(int));
    
            var customerInventoryIdParameter = customerInventoryId.HasValue ?
                new ObjectParameter("CustomerInventoryId", customerInventoryId) :
                new ObjectParameter("CustomerInventoryId", typeof(int));
    
            var itemCountParameter = itemCount.HasValue ?
                new ObjectParameter("ItemCount", itemCount) :
                new ObjectParameter("ItemCount", typeof(int));
    
            var customerLoginIdParameter = customerLoginId.HasValue ?
                new ObjectParameter("CustomerLoginId", customerLoginId) :
                new ObjectParameter("CustomerLoginId", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateWorkloadItem_Result>("UpdateWorkloadItem", workloadIdParameter, customerInventoryIdParameter, itemCountParameter, customerLoginIdParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<WorkloadInventory_Result> GetWorkloadInventoryForDispatch(Nullable<int> dispatchId)
        {
            var dispatchIdParameter = dispatchId.HasValue ?
                new ObjectParameter("DispatchId", dispatchId) :
                new ObjectParameter("DispatchId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<WorkloadInventory_Result>("GetWorkloadInventoryForDispatch", dispatchIdParameter);
        }
    
        public virtual ObjectResult<GetCustomerInvoiceById_Result> GetCustomerInvoiceById(Nullable<int> customerId)
        {
            var customerIdParameter = customerId.HasValue ?
                new ObjectParameter("CustomerId", customerId) :
                new ObjectParameter("CustomerId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerInvoiceById_Result>("GetCustomerInvoiceById", customerIdParameter);
        }
    
        public virtual ObjectResult<UpdateInvoiceItemBadCount_Result> UpdateInvoiceItemBadCount(Nullable<int> invoiceId, Nullable<int> inventoryItemTypeId, Nullable<int> count, Nullable<int> operatorLoginId)
        {
            var invoiceIdParameter = invoiceId.HasValue ?
                new ObjectParameter("InvoiceId", invoiceId) :
                new ObjectParameter("InvoiceId", typeof(int));
    
            var inventoryItemTypeIdParameter = inventoryItemTypeId.HasValue ?
                new ObjectParameter("InventoryItemTypeId", inventoryItemTypeId) :
                new ObjectParameter("InventoryItemTypeId", typeof(int));
    
            var countParameter = count.HasValue ?
                new ObjectParameter("Count", count) :
                new ObjectParameter("Count", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateInvoiceItemBadCount_Result>("UpdateInvoiceItemBadCount", invoiceIdParameter, inventoryItemTypeIdParameter, countParameter, operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<GetWorkloadInventoryForInvoice_backup_20140820_Result> GetWorkloadInventoryForInvoice_backup_20140820(Nullable<int> invoiceId)
        {
            var invoiceIdParameter = invoiceId.HasValue ?
                new ObjectParameter("InvoiceId", invoiceId) :
                new ObjectParameter("InvoiceId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetWorkloadInventoryForInvoice_backup_20140820_Result>("GetWorkloadInventoryForInvoice_backup_20140820", invoiceIdParameter);
        }
    
        public virtual int sp_alterdiagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            var versionParameter = version.HasValue ?
                new ObjectParameter("version", version) :
                new ObjectParameter("version", typeof(int));
    
            var definitionParameter = definition != null ?
                new ObjectParameter("definition", definition) :
                new ObjectParameter("definition", typeof(byte[]));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_alterdiagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
        }
    
        public virtual int sp_creatediagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            var versionParameter = version.HasValue ?
                new ObjectParameter("version", version) :
                new ObjectParameter("version", typeof(int));
    
            var definitionParameter = definition != null ?
                new ObjectParameter("definition", definition) :
                new ObjectParameter("definition", typeof(byte[]));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_creatediagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
        }
    
        public virtual int sp_dropdiagram(string diagramname, Nullable<int> owner_id)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_dropdiagram", diagramnameParameter, owner_idParameter);
        }
    
        public virtual int sp_helpdiagramdefinition(string diagramname, Nullable<int> owner_id)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_helpdiagramdefinition", diagramnameParameter, owner_idParameter);
        }
    
        public virtual int sp_helpdiagrams(string diagramname, Nullable<int> owner_id)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_helpdiagrams", diagramnameParameter, owner_idParameter);
        }
    
        public virtual int sp_renamediagram(string diagramname, Nullable<int> owner_id, string new_diagramname)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            var new_diagramnameParameter = new_diagramname != null ?
                new ObjectParameter("new_diagramname", new_diagramname) :
                new ObjectParameter("new_diagramname", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_renamediagram", diagramnameParameter, owner_idParameter, new_diagramnameParameter);
        }
    
        public virtual int sp_upgraddiagrams()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_upgraddiagrams");
        }
    
        public virtual int SendMail(string p_strSubject, string p_strRecipients, string p_from_address, string p_strBody, string p_cc)
        {
            var p_strSubjectParameter = p_strSubject != null ?
                new ObjectParameter("p_strSubject", p_strSubject) :
                new ObjectParameter("p_strSubject", typeof(string));
    
            var p_strRecipientsParameter = p_strRecipients != null ?
                new ObjectParameter("p_strRecipients", p_strRecipients) :
                new ObjectParameter("p_strRecipients", typeof(string));
    
            var p_from_addressParameter = p_from_address != null ?
                new ObjectParameter("p_from_address", p_from_address) :
                new ObjectParameter("p_from_address", typeof(string));
    
            var p_strBodyParameter = p_strBody != null ?
                new ObjectParameter("p_strBody", p_strBody) :
                new ObjectParameter("p_strBody", typeof(string));
    
            var p_ccParameter = p_cc != null ?
                new ObjectParameter("p_cc", p_cc) :
                new ObjectParameter("p_cc", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SendMail", p_strSubjectParameter, p_strRecipientsParameter, p_from_addressParameter, p_strBodyParameter, p_ccParameter);
        }
    
        public virtual ObjectResult<GetCustomerPricingPercentages_Result> GetCustomerPricingPercentages()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerPricingPercentages_Result>("GetCustomerPricingPercentages");
        }
    
        public virtual int UpdateCustomerInventoryByPercentages(Nullable<int> operatorLoginId)
        {
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateCustomerInventoryByPercentages", operatorLoginIdParameter);
        }
    
        public virtual ObjectResult<GetWorkloadInventoryForDispatches_Result> GetWorkloadInventoryForDispatches(Nullable<int> deliveryId)
        {
            var deliveryIdParameter = deliveryId.HasValue ?
                new ObjectParameter("DeliveryId", deliveryId) :
                new ObjectParameter("DeliveryId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetWorkloadInventoryForDispatches_Result>("GetWorkloadInventoryForDispatches", deliveryIdParameter);
        }
    
        public virtual int UpdateDispatchDeliveryId(string dispatchIds)
        {
            var dispatchIdsParameter = dispatchIds != null ?
                new ObjectParameter("DispatchIds", dispatchIds) :
                new ObjectParameter("DispatchIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateDispatchDeliveryId", dispatchIdsParameter);
        }
    
        public virtual ObjectResult<UpdateDeliveryId_Result> UpdateDeliveryId(string dispatchIds)
        {
            var dispatchIdsParameter = dispatchIds != null ?
                new ObjectParameter("DispatchIds", dispatchIds) :
                new ObjectParameter("DispatchIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateDeliveryId_Result>("UpdateDeliveryId", dispatchIdsParameter);
        }
    
        public virtual ObjectResult<UpdateDispatchDelivery_Result> UpdateDispatchDelivery(string dispatchIds)
        {
            var dispatchIdsParameter = dispatchIds != null ?
                new ObjectParameter("DispatchIds", dispatchIds) :
                new ObjectParameter("DispatchIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateDispatchDelivery_Result>("UpdateDispatchDelivery", dispatchIdsParameter);
        }
    
        public virtual ObjectResult<UpdateDispatchDelivery_Result> UpdateDispatchDelivery1(string dispatchIds)
        {
            var dispatchIdsParameter = dispatchIds != null ?
                new ObjectParameter("DispatchIds", dispatchIds) :
                new ObjectParameter("DispatchIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateDispatchDelivery_Result>("UpdateDispatchDelivery1", dispatchIdsParameter);
        }
    
        public virtual ObjectResult<UpdateDispatchDelivery_Result> UpdateDispatchDelivery2(string dispatchIds)
        {
            var dispatchIdsParameter = dispatchIds != null ?
                new ObjectParameter("DispatchIds", dispatchIds) :
                new ObjectParameter("DispatchIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<UpdateDispatchDelivery_Result>("UpdateDispatchDelivery2", dispatchIdsParameter);
        }
    
        public virtual ObjectResult<GetWorkloadInventoryForDispatches2016_Result> GetWorkloadInventoryForDispatches2016(string dispatchId)
        {
            var dispatchIdParameter = dispatchId != null ?
                new ObjectParameter("DispatchId", dispatchId) :
                new ObjectParameter("DispatchId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetWorkloadInventoryForDispatches2016_Result>("GetWorkloadInventoryForDispatches2016", dispatchIdParameter);
        }
    
        public virtual int UpdateCondemnedPrintedForDispatches(string dispatchId)
        {
            var dispatchIdParameter = dispatchId != null ?
                new ObjectParameter("DispatchId", dispatchId) :
                new ObjectParameter("DispatchId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateCondemnedPrintedForDispatches", dispatchIdParameter);
        }
    
        public virtual ObjectResult<GetDeliveryNoteCategoriesByBagSeal_Result> GetDeliveryNoteCategoriesByBagSeal(string bagIds)
        {
            var bagIdsParameter = bagIds != null ?
                new ObjectParameter("BagIds", bagIds) :
                new ObjectParameter("BagIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDeliveryNoteCategoriesByBagSeal_Result>("GetDeliveryNoteCategoriesByBagSeal", bagIdsParameter);
        }
    
        public virtual ObjectResult<GetWorkloadInventoryForDelivery_Result> GetWorkloadInventoryForDelivery(Nullable<int> deliveryId)
        {
            var deliveryIdParameter = deliveryId.HasValue ?
                new ObjectParameter("DeliveryId", deliveryId) :
                new ObjectParameter("DeliveryId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetWorkloadInventoryForDelivery_Result>("GetWorkloadInventoryForDelivery", deliveryIdParameter);
        }
    
        public virtual ObjectResult<GetDispatchesReadyToPrint_Result> GetDispatchesReadyToPrint(Nullable<int> customerid)
        {
            var customeridParameter = customerid.HasValue ?
                new ObjectParameter("Customerid", customerid) :
                new ObjectParameter("Customerid", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDispatchesReadyToPrint_Result>("GetDispatchesReadyToPrint", customeridParameter);
        }
    
        public virtual ObjectResult<GetDispatchesReadyToExport_Result> GetDispatchesReadyToExport(string startDate, string endDate, Nullable<int> companyID)
        {
            var startDateParameter = startDate != null ?
                new ObjectParameter("startDate", startDate) :
                new ObjectParameter("startDate", typeof(string));
    
            var endDateParameter = endDate != null ?
                new ObjectParameter("endDate", endDate) :
                new ObjectParameter("endDate", typeof(string));
    
            var companyIDParameter = companyID.HasValue ?
                new ObjectParameter("companyID", companyID) :
                new ObjectParameter("companyID", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDispatchesReadyToExport_Result>("GetDispatchesReadyToExport", startDateParameter, endDateParameter, companyIDParameter);
        }
    
        public virtual ObjectResult<string> GetCustomerEmail(Nullable<int> workloadId)
        {
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("workloadId", workloadId) :
                new ObjectParameter("workloadId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("GetCustomerEmail", workloadIdParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> CheckCustomerInventoryCost(string itemType, Nullable<int> workloadid)
        {
            var itemTypeParameter = itemType != null ?
                new ObjectParameter("itemType", itemType) :
                new ObjectParameter("itemType", typeof(string));
    
            var workloadidParameter = workloadid.HasValue ?
                new ObjectParameter("workloadid", workloadid) :
                new ObjectParameter("workloadid", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("CheckCustomerInventoryCost", itemTypeParameter, workloadidParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> CheckCustomerInventoryItemCost(string itemType, string itemTypeCategory, Nullable<int> workloadid)
        {
            var itemTypeParameter = itemType != null ?
                new ObjectParameter("itemType", itemType) :
                new ObjectParameter("itemType", typeof(string));
    
            var itemTypeCategoryParameter = itemTypeCategory != null ?
                new ObjectParameter("itemTypeCategory", itemTypeCategory) :
                new ObjectParameter("itemTypeCategory", typeof(string));
    
            var workloadidParameter = workloadid.HasValue ?
                new ObjectParameter("workloadid", workloadid) :
                new ObjectParameter("workloadid", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("CheckCustomerInventoryItemCost", itemTypeParameter, itemTypeCategoryParameter, workloadidParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> CheckCustomerInventoryItemSizeCost(Nullable<int> itemTypeId, Nullable<int> workloadid)
        {
            var itemTypeIdParameter = itemTypeId.HasValue ?
                new ObjectParameter("itemTypeId", itemTypeId) :
                new ObjectParameter("itemTypeId", typeof(int));
    
            var workloadidParameter = workloadid.HasValue ?
                new ObjectParameter("workloadid", workloadid) :
                new ObjectParameter("workloadid", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("CheckCustomerInventoryItemSizeCost", itemTypeIdParameter, workloadidParameter);
        }
    
        public virtual ObjectResult<string> GetCustomerCCEmail(Nullable<int> workloadId)
        {
            var workloadIdParameter = workloadId.HasValue ?
                new ObjectParameter("workloadId", workloadId) :
                new ObjectParameter("workloadId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("GetCustomerCCEmail", workloadIdParameter);
        }
    
        public virtual int UpdateCondemnedPrintedForDelivery(Nullable<int> deliveryId, string dispatchId)
        {
            var deliveryIdParameter = deliveryId.HasValue ?
                new ObjectParameter("DeliveryId", deliveryId) :
                new ObjectParameter("DeliveryId", typeof(int));
    
            var dispatchIdParameter = dispatchId != null ?
                new ObjectParameter("DispatchId", dispatchId) :
                new ObjectParameter("DispatchId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateCondemnedPrintedForDelivery", deliveryIdParameter, dispatchIdParameter);
        }
    
        public virtual ObjectResult<GetDuplicatePrelists_Result> GetDuplicatePrelists(string startDate, string endDate)
        {
            var startDateParameter = startDate != null ?
                new ObjectParameter("startDate", startDate) :
                new ObjectParameter("startDate", typeof(string));
    
            var endDateParameter = endDate != null ?
                new ObjectParameter("endDate", endDate) :
                new ObjectParameter("endDate", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDuplicatePrelists_Result>("GetDuplicatePrelists", startDateParameter, endDateParameter);
        }
    
        public virtual int CreateDeliveryOperator(Nullable<int> deliveryId, Nullable<int> operatorLoginId, string deviceName, string posPrinter)
        {
            var deliveryIdParameter = deliveryId.HasValue ?
                new ObjectParameter("DeliveryId", deliveryId) :
                new ObjectParameter("DeliveryId", typeof(int));
    
            var operatorLoginIdParameter = operatorLoginId.HasValue ?
                new ObjectParameter("OperatorLoginId", operatorLoginId) :
                new ObjectParameter("OperatorLoginId", typeof(int));
    
            var deviceNameParameter = deviceName != null ?
                new ObjectParameter("DeviceName", deviceName) :
                new ObjectParameter("DeviceName", typeof(string));
    
            var posPrinterParameter = posPrinter != null ?
                new ObjectParameter("PosPrinter", posPrinter) :
                new ObjectParameter("PosPrinter", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("CreateDeliveryOperator", deliveryIdParameter, operatorLoginIdParameter, deviceNameParameter, posPrinterParameter);
        }
    
        public virtual ObjectResult<string> rptOutstandingOrders(Nullable<int> p_CustomerID)
        {
            var p_CustomerIDParameter = p_CustomerID.HasValue ?
                new ObjectParameter("p_CustomerID", p_CustomerID) :
                new ObjectParameter("p_CustomerID", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("rptOutstandingOrders", p_CustomerIDParameter);
        }
    
        public virtual ObjectResult<rptOutstandingOrders_Items_Result> rptOutstandingOrders_Items(Nullable<int> p_CustomerID, string p_StartDate, string p_EndDate)
        {
            var p_CustomerIDParameter = p_CustomerID.HasValue ?
                new ObjectParameter("p_CustomerID", p_CustomerID) :
                new ObjectParameter("p_CustomerID", typeof(int));
    
            var p_StartDateParameter = p_StartDate != null ?
                new ObjectParameter("p_StartDate", p_StartDate) :
                new ObjectParameter("p_StartDate", typeof(string));
    
            var p_EndDateParameter = p_EndDate != null ?
                new ObjectParameter("p_EndDate", p_EndDate) :
                new ObjectParameter("p_EndDate", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<rptOutstandingOrders_Items_Result>("rptOutstandingOrders_Items", p_CustomerIDParameter, p_StartDateParameter, p_EndDateParameter);
        }
    
        public virtual ObjectResult<rptBagReconDeliveries_Result> rptBagReconDeliveries(Nullable<int> p_CustomerID, string p_StartDate, string p_EndDate)
        {
            var p_CustomerIDParameter = p_CustomerID.HasValue ?
                new ObjectParameter("p_CustomerID", p_CustomerID) :
                new ObjectParameter("p_CustomerID", typeof(int));
    
            var p_StartDateParameter = p_StartDate != null ?
                new ObjectParameter("p_StartDate", p_StartDate) :
                new ObjectParameter("p_StartDate", typeof(string));
    
            var p_EndDateParameter = p_EndDate != null ?
                new ObjectParameter("p_EndDate", p_EndDate) :
                new ObjectParameter("p_EndDate", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<rptBagReconDeliveries_Result>("rptBagReconDeliveries", p_CustomerIDParameter, p_StartDateParameter, p_EndDateParameter);
        }
    
        public virtual ObjectResult<rptBagReconPickups_Result> rptBagReconPickups(Nullable<int> p_CustomerID, string p_StartDate, string p_EndDate)
        {
            var p_CustomerIDParameter = p_CustomerID.HasValue ?
                new ObjectParameter("p_CustomerID", p_CustomerID) :
                new ObjectParameter("p_CustomerID", typeof(int));
    
            var p_StartDateParameter = p_StartDate != null ?
                new ObjectParameter("p_StartDate", p_StartDate) :
                new ObjectParameter("p_StartDate", typeof(string));
    
            var p_EndDateParameter = p_EndDate != null ?
                new ObjectParameter("p_EndDate", p_EndDate) :
                new ObjectParameter("p_EndDate", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<rptBagReconPickups_Result>("rptBagReconPickups", p_CustomerIDParameter, p_StartDateParameter, p_EndDateParameter);
        }
    
        public virtual int sp_ArchiveData(string fromDate, string toDate, Nullable<int> companyID)
        {
            var fromDateParameter = fromDate != null ?
                new ObjectParameter("FromDate", fromDate) :
                new ObjectParameter("FromDate", typeof(string));
    
            var toDateParameter = toDate != null ?
                new ObjectParameter("ToDate", toDate) :
                new ObjectParameter("ToDate", typeof(string));
    
            var companyIDParameter = companyID.HasValue ?
                new ObjectParameter("CompanyID", companyID) :
                new ObjectParameter("CompanyID", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_ArchiveData", fromDateParameter, toDateParameter, companyIDParameter);
        }
    
        public virtual int sp_BackupDatabase(ObjectParameter resultMessage)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_BackupDatabase", resultMessage);
        }
    }
}