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

namespace Neo.Legitimate.NewRouteRequest.Models
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class NewRouteContext : DbContext
    {
        public NewRouteContext()
            : base("name=NewRouteContext")
        {
            this.Configuration.LazyLoadingEnabled = false;
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<NewRouteRequestDetail> NewRouteRequestDetails { get; set; }
        public virtual DbSet<Vw_NewRouteRequestDetails> Vw_NewRouteRequestDetails { get; set; }
        public virtual DbSet<NewRouteRouteNode> NewRouteRouteNodes { get; set; }
        public virtual DbSet<NewRouteRequestType> NewRouteRequestTypes { get; set; }
        public virtual DbSet<Vw_ApplicationRequestDetails> Vw_ApplicationRequestDetails { get; set; }
        public virtual DbSet<ApplicationRouteDetail> ApplicationRouteDetails { get; set; }
        public virtual DbSet<Vw_OperatingLicenceDetails> Vw_OperatingLicenceDetails { get; set; }
    
        public virtual ObjectResult<Vw_NewRouteRequestDetails> Pr_NewRouteRequestDetailsSearch(Nullable<long> newRouteRequestDetailID, Nullable<short> 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<Vw_NewRouteRequestDetails>("Pr_NewRouteRequestDetailsSearch", newRouteRequestDetailIDParameter, workflowInstanceStatusIDParameter, descriptionParameter);
        }
    
        public virtual ObjectResult<Vw_NewRouteRequestDetails> Pr_NewRouteRequestDetailsSearch(Nullable<long> newRouteRequestDetailID, Nullable<short> 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<Vw_NewRouteRequestDetails>("Pr_NewRouteRequestDetailsSearch", mergeOption, newRouteRequestDetailIDParameter, workflowInstanceStatusIDParameter, descriptionParameter);
        }
    
        public virtual int Pr_NewRouteRequestPostSave(Nullable<long> newRouteRequestDetailID)
        {
            var newRouteRequestDetailIDParameter = newRouteRequestDetailID.HasValue ?
                new ObjectParameter("NewRouteRequestDetailID", newRouteRequestDetailID) :
                new ObjectParameter("NewRouteRequestDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_NewRouteRequestPostSave", newRouteRequestDetailIDParameter);
        }
    
        public virtual ObjectResult<Pr_RouteLinkedLicences_Result> Pr_RouteLinkedLicences(Nullable<long> routeID, Nullable<long> userID)
        {
            var routeIDParameter = routeID.HasValue ?
                new ObjectParameter("RouteID", routeID) :
                new ObjectParameter("RouteID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_RouteLinkedLicences_Result>("Pr_RouteLinkedLicences", routeIDParameter, userIDParameter);
        }
    }
}