//------------------------------------------------------------------------------
// <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.LicenceIssueRequest.Models
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class LicenceIssueContext : DbContext
    {
        public LicenceIssueContext()
            : base("name=LicenceIssueContext")
        {
            this.Configuration.LazyLoadingEnabled = false;
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<LicenceIssueDetail> LicenceIssueDetails { get; set; }
        public virtual DbSet<Licence> Licences { get; set; }
        public virtual DbSet<Vehicle> Vehicles { get; set; }
        public virtual DbSet<LicenceIssueDocument> LicenceIssueDocuments { get; set; }
        public virtual DbSet<DocumentType> DocumentTypes { get; set; }
        public virtual DbSet<Route> Routes { get; set; }
        public virtual DbSet<RouteType> RouteTypes { get; set; }
        public virtual DbSet<Member> Members { get; set; }
        public virtual DbSet<Place> Places { get; set; }
        public virtual DbSet<LicenceIssueInspectionDetail> LicenceIssueInspectionDetails { get; set; }
        public virtual DbSet<ApplicationRequestDetail> ApplicationRequestDetails { get; set; }
        public virtual DbSet<ApplicationVehicleDetail> ApplicationVehicleDetails { get; set; }
        public virtual DbSet<LicenceException> LicenceExceptions { get; set; }
    
        public virtual int Pr_LicenceIssueRequestDetailsSearch(Nullable<long> licenceIssueRequestDetailID, Nullable<short> workflowInstanceStatusID)
        {
            var licenceIssueRequestDetailIDParameter = licenceIssueRequestDetailID.HasValue ?
                new ObjectParameter("LicenceIssueRequestDetailID", licenceIssueRequestDetailID) :
                new ObjectParameter("LicenceIssueRequestDetailID", typeof(long));
    
            var workflowInstanceStatusIDParameter = workflowInstanceStatusID.HasValue ?
                new ObjectParameter("WorkflowInstanceStatusID", workflowInstanceStatusID) :
                new ObjectParameter("WorkflowInstanceStatusID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceIssueRequestDetailsSearch", licenceIssueRequestDetailIDParameter, workflowInstanceStatusIDParameter);
        }
    
        public virtual int Pr_LicenceIssuePostSaveProcess(Nullable<long> licenceIssueDetailID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceIssuePostSaveProcess", licenceIssueDetailIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_VehicleGetLinkedByVIN(string vIN)
        {
            var vINParameter = vIN != null ?
                new ObjectParameter("VIN", vIN) :
                new ObjectParameter("VIN", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_VehicleGetLinkedByVIN", vINParameter);
        }
    
        public virtual int Pr_LicenceExceptionsUpdate(Nullable<long> licenceID)
        {
            var licenceIDParameter = licenceID.HasValue ?
                new ObjectParameter("LicenceID", licenceID) :
                new ObjectParameter("LicenceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_LicenceExceptionsUpdate", licenceIDParameter);
        }
    
        public virtual int Pr_LicenceIssueCheckSecurity(Nullable<long> licenceIssueDetailID, string action, Nullable<long> userID)
        {
            var licenceIssueDetailIDParameter = licenceIssueDetailID.HasValue ?
                new ObjectParameter("LicenceIssueDetailID", licenceIssueDetailID) :
                new ObjectParameter("LicenceIssueDetailID", 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_LicenceIssueCheckSecurity", licenceIssueDetailIDParameter, actionParameter, userIDParameter);
        }
    
        public virtual int Pr_CleanseUnusedVehicleData()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_CleanseUnusedVehicleData");
        }
    }
}