//------------------------------------------------------------------------------
// <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.LegitimateLicences.NewRouteRequest.Models.Database
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class 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<NewRouteRequestType> NewRouteRequestTypes { get; set; }
        public virtual DbSet<NewRouteRouteNode> NewRouteRouteNodes { get; set; }
        public virtual DbSet<Vw_ApplicationDetails_Light> Vw_ApplicationDetails_Light { get; set; }
        public virtual DbSet<Vw_NewRouteRequestDetail> Vw_NewRouteRequestDetails { get; set; }
    
        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);
        }
    
        public virtual ObjectResult<Pr_NewRouteRequest_ExistingRoutesSearch_Result> Pr_NewRouteRequest_ExistingRoutesSearch(Nullable<long> originPlaceID, Nullable<long> destinationPlaceID, Nullable<long> userID)
        {
            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 userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_NewRouteRequest_ExistingRoutesSearch_Result>("Pr_NewRouteRequest_ExistingRoutesSearch", originPlaceIDParameter, destinationPlaceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_NewRouteRequest_RunningRequestSearch_Result> Pr_NewRouteRequest_RunningRequestSearch(Nullable<long> originPlaceID, Nullable<long> destinationPlaceID, Nullable<long> userID)
        {
            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 userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_NewRouteRequest_RunningRequestSearch_Result>("Pr_NewRouteRequest_RunningRequestSearch", originPlaceIDParameter, destinationPlaceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_NewRouteRequestDetail> Pr_NewRouteRequestCreate(Nullable<long> originPlaceID, Nullable<long> destinationPlaceID, Nullable<long> verifiedRouteID, Nullable<short> routeProvinceID, Nullable<long> userID)
        {
            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 verifiedRouteIDParameter = verifiedRouteID.HasValue ?
                new ObjectParameter("VerifiedRouteID", verifiedRouteID) :
                new ObjectParameter("VerifiedRouteID", typeof(long));
    
            var routeProvinceIDParameter = routeProvinceID.HasValue ?
                new ObjectParameter("RouteProvinceID", routeProvinceID) :
                new ObjectParameter("RouteProvinceID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_NewRouteRequestDetail>("Pr_NewRouteRequestCreate", originPlaceIDParameter, destinationPlaceIDParameter, verifiedRouteIDParameter, routeProvinceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Vw_NewRouteRequestDetail> Pr_NewRouteRequestCreate(Nullable<long> originPlaceID, Nullable<long> destinationPlaceID, Nullable<long> verifiedRouteID, Nullable<short> routeProvinceID, Nullable<long> userID, MergeOption mergeOption)
        {
            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 verifiedRouteIDParameter = verifiedRouteID.HasValue ?
                new ObjectParameter("VerifiedRouteID", verifiedRouteID) :
                new ObjectParameter("VerifiedRouteID", typeof(long));
    
            var routeProvinceIDParameter = routeProvinceID.HasValue ?
                new ObjectParameter("RouteProvinceID", routeProvinceID) :
                new ObjectParameter("RouteProvinceID", typeof(short));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_NewRouteRequestDetail>("Pr_NewRouteRequestCreate", mergeOption, originPlaceIDParameter, destinationPlaceIDParameter, verifiedRouteIDParameter, routeProvinceIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_Dashboard_NewRouteWorkflowStatusGet_Result> Pr_Dashboard_NewRouteWorkflowStatusGet(Nullable<long> newRouteRequestDetailID, Nullable<long> userID)
        {
            var newRouteRequestDetailIDParameter = newRouteRequestDetailID.HasValue ?
                new ObjectParameter("NewRouteRequestDetailID", newRouteRequestDetailID) :
                new ObjectParameter("NewRouteRequestDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_Dashboard_NewRouteWorkflowStatusGet_Result>("Pr_Dashboard_NewRouteWorkflowStatusGet", newRouteRequestDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_NewRouteRequestApplicationsGet_Result> Pr_NewRouteRequestApplicationsGet(Nullable<long> newRouteRequestDetailID, Nullable<long> userID)
        {
            var newRouteRequestDetailIDParameter = newRouteRequestDetailID.HasValue ?
                new ObjectParameter("NewRouteRequestDetailID", newRouteRequestDetailID) :
                new ObjectParameter("NewRouteRequestDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_NewRouteRequestApplicationsGet_Result>("Pr_NewRouteRequestApplicationsGet", newRouteRequestDetailIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<Pr_NewRouteRequestLicencesGet_Result> Pr_NewRouteRequestLicencesGet(Nullable<long> newRouteRequestDetailID, Nullable<long> userID)
        {
            var newRouteRequestDetailIDParameter = newRouteRequestDetailID.HasValue ?
                new ObjectParameter("NewRouteRequestDetailID", newRouteRequestDetailID) :
                new ObjectParameter("NewRouteRequestDetailID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_NewRouteRequestLicencesGet_Result>("Pr_NewRouteRequestLicencesGet", newRouteRequestDetailIDParameter, userIDParameter);
        }
    }
}