//------------------------------------------------------------------------------
// <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.Security
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class AfxAdminSecurityContext : DbContext
    {
        public AfxAdminSecurityContext()
            : base("name=AfxAdminSecurityContext")
        {
            this.Configuration.LazyLoadingEnabled = false;
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Application> Applications { get; set; }
        public virtual DbSet<PasswordQuestion> PasswordQuestions { get; set; }
        public virtual DbSet<Role> Roles { get; set; }
        public virtual DbSet<Securable> Securables { get; set; }
        public virtual DbSet<User> Users { get; set; }
        public virtual DbSet<UserSetting> UserSettings { get; set; }
        public virtual DbSet<UserStatus> UserStatus { get; set; }
        public virtual DbSet<UserStatusHistory> UserStatusHistories { get; set; }
        public virtual DbSet<WorkflowBuddy> WorkflowBuddies { get; set; }
        public virtual DbSet<RoleSecurable> RoleSecurables { get; set; }
        public virtual DbSet<Vw_User> Vw_Users { get; set; }
    
        public virtual int Pr_SaveUserPassword(Nullable<long> updatedByID, Nullable<long> userID, string userName, string authMode, string newPassword, Nullable<bool> isPasswordReset)
        {
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var userNameParameter = userName != null ?
                new ObjectParameter("UserName", userName) :
                new ObjectParameter("UserName", typeof(string));
    
            var authModeParameter = authMode != null ?
                new ObjectParameter("AuthMode", authMode) :
                new ObjectParameter("AuthMode", typeof(string));
    
            var newPasswordParameter = newPassword != null ?
                new ObjectParameter("NewPassword", newPassword) :
                new ObjectParameter("NewPassword", typeof(string));
    
            var isPasswordResetParameter = isPasswordReset.HasValue ?
                new ObjectParameter("IsPasswordReset", isPasswordReset) :
                new ObjectParameter("IsPasswordReset", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUserPassword", updatedByIDParameter, userIDParameter, userNameParameter, authModeParameter, newPasswordParameter, isPasswordResetParameter);
        }
    
        public virtual int Pr_UpdateRelatedTable(string primaryID, string primaryColumnName, string relatedIds, string relatedSchema, string relatedTableName, string relatedPrimaryColumnName)
        {
            var primaryIDParameter = primaryID != null ?
                new ObjectParameter("PrimaryID", primaryID) :
                new ObjectParameter("PrimaryID", typeof(string));
    
            var primaryColumnNameParameter = primaryColumnName != null ?
                new ObjectParameter("PrimaryColumnName", primaryColumnName) :
                new ObjectParameter("PrimaryColumnName", typeof(string));
    
            var relatedIdsParameter = relatedIds != null ?
                new ObjectParameter("RelatedIds", relatedIds) :
                new ObjectParameter("RelatedIds", typeof(string));
    
            var relatedSchemaParameter = relatedSchema != null ?
                new ObjectParameter("RelatedSchema", relatedSchema) :
                new ObjectParameter("RelatedSchema", typeof(string));
    
            var relatedTableNameParameter = relatedTableName != null ?
                new ObjectParameter("RelatedTableName", relatedTableName) :
                new ObjectParameter("RelatedTableName", typeof(string));
    
            var relatedPrimaryColumnNameParameter = relatedPrimaryColumnName != null ?
                new ObjectParameter("RelatedPrimaryColumnName", relatedPrimaryColumnName) :
                new ObjectParameter("RelatedPrimaryColumnName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_UpdateRelatedTable", primaryIDParameter, primaryColumnNameParameter, relatedIdsParameter, relatedSchemaParameter, relatedTableNameParameter, relatedPrimaryColumnNameParameter);
        }
    
        public virtual int Pr_ClearUserSettings(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_ClearUserSettings", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_User> Pr_GetActiveUsers(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_User>("Pr_GetActiveUsers", userIDParameter);
        }
    
        public virtual ObjectResult<Vw_User> Pr_GetActiveUsers(Nullable<long> userID, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_User>("Pr_GetActiveUsers", mergeOption, userIDParameter);
        }
    
        public virtual ObjectResult<User> Pr_GetUser(Nullable<long> returnUserID, Nullable<long> userID)
        {
            var returnUserIDParameter = returnUserID.HasValue ?
                new ObjectParameter("ReturnUserID", returnUserID) :
                new ObjectParameter("ReturnUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<User>("Pr_GetUser", returnUserIDParameter, userIDParameter);
        }
    
        public virtual ObjectResult<User> Pr_GetUser(Nullable<long> returnUserID, Nullable<long> userID, MergeOption mergeOption)
        {
            var returnUserIDParameter = returnUserID.HasValue ?
                new ObjectParameter("ReturnUserID", returnUserID) :
                new ObjectParameter("ReturnUserID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<User>("Pr_GetUser", mergeOption, returnUserIDParameter, userIDParameter);
        }
    
        public virtual int Pr_SaveUser(Nullable<long> userID, string knownAs, string lastName, string firstName, string email, string nTAccount, string cell, Nullable<long> officeLocationID, Nullable<long> userProfileDocID, Nullable<long> updatedByID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var knownAsParameter = knownAs != null ?
                new ObjectParameter("KnownAs", knownAs) :
                new ObjectParameter("KnownAs", typeof(string));
    
            var lastNameParameter = lastName != null ?
                new ObjectParameter("LastName", lastName) :
                new ObjectParameter("LastName", typeof(string));
    
            var firstNameParameter = firstName != null ?
                new ObjectParameter("FirstName", firstName) :
                new ObjectParameter("FirstName", typeof(string));
    
            var emailParameter = email != null ?
                new ObjectParameter("Email", email) :
                new ObjectParameter("Email", typeof(string));
    
            var nTAccountParameter = nTAccount != null ?
                new ObjectParameter("NTAccount", nTAccount) :
                new ObjectParameter("NTAccount", typeof(string));
    
            var cellParameter = cell != null ?
                new ObjectParameter("Cell", cell) :
                new ObjectParameter("Cell", typeof(string));
    
            var officeLocationIDParameter = officeLocationID.HasValue ?
                new ObjectParameter("OfficeLocationID", officeLocationID) :
                new ObjectParameter("OfficeLocationID", typeof(long));
    
            var userProfileDocIDParameter = userProfileDocID.HasValue ?
                new ObjectParameter("UserProfileDocID", userProfileDocID) :
                new ObjectParameter("UserProfileDocID", typeof(long));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUser", userIDParameter, knownAsParameter, lastNameParameter, firstNameParameter, emailParameter, nTAccountParameter, cellParameter, officeLocationIDParameter, userProfileDocIDParameter, updatedByIDParameter);
        }
    
        public virtual int Pr_UserStatusUpdate(Nullable<long> updatedByID, string comments, Nullable<long> userID, Nullable<short> userStatusID)
        {
            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 userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var userStatusIDParameter = userStatusID.HasValue ?
                new ObjectParameter("UserStatusID", userStatusID) :
                new ObjectParameter("UserStatusID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_UserStatusUpdate", updatedByIDParameter, commentsParameter, userIDParameter, userStatusIDParameter);
        }
    
        public virtual int Pr_SaveUserRoles(Nullable<long> userID, string rolesCsv, Nullable<long> updatedByID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var rolesCsvParameter = rolesCsv != null ?
                new ObjectParameter("RolesCsv", rolesCsv) :
                new ObjectParameter("RolesCsv", typeof(string));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUserRoles", userIDParameter, rolesCsvParameter, updatedByIDParameter);
        }
    
        public virtual int Pr_SaveUserSettings(Nullable<long> updateUserID, string settingName, string settingValue, Nullable<long> userID)
        {
            var updateUserIDParameter = updateUserID.HasValue ?
                new ObjectParameter("UpdateUserID", updateUserID) :
                new ObjectParameter("UpdateUserID", typeof(long));
    
            var settingNameParameter = settingName != null ?
                new ObjectParameter("SettingName", settingName) :
                new ObjectParameter("SettingName", typeof(string));
    
            var settingValueParameter = settingValue != null ?
                new ObjectParameter("SettingValue", settingValue) :
                new ObjectParameter("SettingValue", typeof(string));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUserSettings", updateUserIDParameter, settingNameParameter, settingValueParameter, userIDParameter);
        }
    
        public virtual int Pr_SaveUserFingerprint(Nullable<long> userID, byte[] fingerprint, Nullable<long> updatedByID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var fingerprintParameter = fingerprint != null ?
                new ObjectParameter("Fingerprint", fingerprint) :
                new ObjectParameter("Fingerprint", typeof(byte[]));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUserFingerprint", userIDParameter, fingerprintParameter, updatedByIDParameter);
        }
    
        public virtual int Pr_DeleteUserWorkflowBuddy(Nullable<long> workflowID, Nullable<long> userID, Nullable<long> buddyUserID, Nullable<long> updatedByID)
        {
            var workflowIDParameter = workflowID.HasValue ?
                new ObjectParameter("WorkflowID", workflowID) :
                new ObjectParameter("WorkflowID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var buddyUserIDParameter = buddyUserID.HasValue ?
                new ObjectParameter("BuddyUserID", buddyUserID) :
                new ObjectParameter("BuddyUserID", typeof(long));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_DeleteUserWorkflowBuddy", workflowIDParameter, userIDParameter, buddyUserIDParameter, updatedByIDParameter);
        }
    
        public virtual ObjectResult<Pr_GetUserWorkflowBuddies_Result> Pr_GetUserWorkflowBuddies(Nullable<long> userID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_GetUserWorkflowBuddies_Result>("Pr_GetUserWorkflowBuddies", userIDParameter);
        }
    
        public virtual int Pr_SaveUserWorkflowBuddy(Nullable<long> workflowID, Nullable<long> userID, Nullable<long> buddyUserID, Nullable<long> updatedByID)
        {
            var workflowIDParameter = workflowID.HasValue ?
                new ObjectParameter("WorkflowID", workflowID) :
                new ObjectParameter("WorkflowID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var buddyUserIDParameter = buddyUserID.HasValue ?
                new ObjectParameter("BuddyUserID", buddyUserID) :
                new ObjectParameter("BuddyUserID", typeof(long));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUserWorkflowBuddy", workflowIDParameter, userIDParameter, buddyUserIDParameter, updatedByIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_GetUsersInRole(string appName, string roleName, string authMode)
        {
            var appNameParameter = appName != null ?
                new ObjectParameter("AppName", appName) :
                new ObjectParameter("AppName", typeof(string));
    
            var roleNameParameter = roleName != null ?
                new ObjectParameter("RoleName", roleName) :
                new ObjectParameter("RoleName", typeof(string));
    
            var authModeParameter = authMode != null ?
                new ObjectParameter("AuthMode", authMode) :
                new ObjectParameter("AuthMode", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_GetUsersInRole", appNameParameter, roleNameParameter, authModeParameter);
        }
    
        public virtual ObjectResult<Vw_User> Pr_GetUsersInRoles(string roleIds)
        {
            var roleIdsParameter = roleIds != null ?
                new ObjectParameter("RoleIds", roleIds) :
                new ObjectParameter("RoleIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_User>("Pr_GetUsersInRoles", roleIdsParameter);
        }
    
        public virtual ObjectResult<Vw_User> Pr_GetUsersInRoles(string roleIds, MergeOption mergeOption)
        {
            var roleIdsParameter = roleIds != null ?
                new ObjectParameter("RoleIds", roleIds) :
                new ObjectParameter("RoleIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_User>("Pr_GetUsersInRoles", mergeOption, roleIdsParameter);
        }
    
        public virtual ObjectResult<RoleSecurable> Pr_GetRoleSecurables(Nullable<short> roleID)
        {
            var roleIDParameter = roleID.HasValue ?
                new ObjectParameter("RoleID", roleID) :
                new ObjectParameter("RoleID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<RoleSecurable>("Pr_GetRoleSecurables", roleIDParameter);
        }
    
        public virtual ObjectResult<RoleSecurable> Pr_GetRoleSecurables(Nullable<short> roleID, MergeOption mergeOption)
        {
            var roleIDParameter = roleID.HasValue ?
                new ObjectParameter("RoleID", roleID) :
                new ObjectParameter("RoleID", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<RoleSecurable>("Pr_GetRoleSecurables", mergeOption, roleIDParameter);
        }
    
        public virtual int Pr_SaveRoleSecurables(Nullable<short> roleID, string securablesCsv, Nullable<long> updatedByID)
        {
            var roleIDParameter = roleID.HasValue ?
                new ObjectParameter("RoleID", roleID) :
                new ObjectParameter("RoleID", typeof(short));
    
            var securablesCsvParameter = securablesCsv != null ?
                new ObjectParameter("SecurablesCsv", securablesCsv) :
                new ObjectParameter("SecurablesCsv", typeof(string));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveRoleSecurables", roleIDParameter, securablesCsvParameter, updatedByIDParameter);
        }
    
        public virtual int Pr_SaveUserFingerPrintRequestToken(Nullable<long> userID, Nullable<bool> createToken, Nullable<long> updatedByID)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var createTokenParameter = createToken.HasValue ?
                new ObjectParameter("CreateToken", createToken) :
                new ObjectParameter("CreateToken", typeof(bool));
    
            var updatedByIDParameter = updatedByID.HasValue ?
                new ObjectParameter("UpdatedByID", updatedByID) :
                new ObjectParameter("UpdatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_SaveUserFingerPrintRequestToken", userIDParameter, createTokenParameter, updatedByIDParameter);
        }
    
        public virtual ObjectResult<string> Pr_ValidateFingerPrintRequestToken(string fingerprintRequestToken)
        {
            var fingerprintRequestTokenParameter = fingerprintRequestToken != null ?
                new ObjectParameter("FingerprintRequestToken", fingerprintRequestToken) :
                new ObjectParameter("FingerprintRequestToken", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_ValidateFingerPrintRequestToken", fingerprintRequestTokenParameter);
        }
    
        public virtual ObjectResult<User> Pr_GetUserByFingerPrintRequestToken(string fingerprintRequestToken)
        {
            var fingerprintRequestTokenParameter = fingerprintRequestToken != null ?
                new ObjectParameter("FingerprintRequestToken", fingerprintRequestToken) :
                new ObjectParameter("FingerprintRequestToken", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<User>("Pr_GetUserByFingerPrintRequestToken", fingerprintRequestTokenParameter);
        }
    
        public virtual ObjectResult<User> Pr_GetUserByFingerPrintRequestToken(string fingerprintRequestToken, MergeOption mergeOption)
        {
            var fingerprintRequestTokenParameter = fingerprintRequestToken != null ?
                new ObjectParameter("FingerprintRequestToken", fingerprintRequestToken) :
                new ObjectParameter("FingerprintRequestToken", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<User>("Pr_GetUserByFingerPrintRequestToken", mergeOption, fingerprintRequestTokenParameter);
        }
    }
}