//------------------------------------------------------------------------------
// <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.Afx.Admin.Delegation
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class AfxAdminDelegationContext : DbContext
    {
        public AfxAdminDelegationContext()
            : base("name=AfxAdminDelegationContext")
        {
            this.Configuration.LazyLoadingEnabled = false;
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Vw_DelegationDetails> Vw_DelegationDetails { get; set; }
    
        public virtual int Pr_DelegationDetailStatusCalculate(Nullable<long> workflowInstanceID)
        {
            var workflowInstanceIDParameter = workflowInstanceID.HasValue ?
                new ObjectParameter("WorkflowInstanceID", workflowInstanceID) :
                new ObjectParameter("WorkflowInstanceID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DelegationDetailStatusCalculate", workflowInstanceIDParameter);
        }
    
        public virtual int Pr_DelegationDetailStatusUpdate(Nullable<long> updatedByID, string comments, Nullable<long> delegationDetailID, Nullable<short> delegationDetailStatusID, Nullable<bool> isTransactionRequired)
        {
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            var commentsParameter = comments != null ?
                new ObjectParameter("Comments", comments) :
                new ObjectParameter("Comments", typeof(string));
    
            var delegationDetailIDParameter = delegationDetailID.HasValue ?
                new ObjectParameter("DelegationDetailID", delegationDetailID) :
                new ObjectParameter("DelegationDetailID", typeof(long));
    
            var delegationDetailStatusIDParameter = delegationDetailStatusID.HasValue ?
                new ObjectParameter("DelegationDetailStatusID", delegationDetailStatusID) :
                new ObjectParameter("DelegationDetailStatusID", typeof(short));
    
            var isTransactionRequiredParameter = isTransactionRequired.HasValue ?
                new ObjectParameter("IsTransactionRequired", isTransactionRequired) :
                new ObjectParameter("IsTransactionRequired", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DelegationDetailStatusUpdate", updatedByIDParameter, commentsParameter, delegationDetailIDParameter, delegationDetailStatusIDParameter, isTransactionRequiredParameter);
        }
    }
}