void Update(string statusMessage) { // temp stop timer _heartbeatTimer.Change(System.Threading.Timeout.Infinite, System.Threading.Timeout.Infinite); DbTableDmlMgr dmlUpdateMgr = _daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.AppSessions); dmlUpdateMgr.SetWhereCondition((j) => j.Column(Constants.AppCode) == j.Parameter(dmlUpdateMgr.MainTable.SchemaName , dmlUpdateMgr.MainTable.TableName , Constants.AppCode , _daMgr.BuildParamName(Constants.AppCode)) && j.Column(Constants.MultipleSessionCode) == j.Parameter(dmlUpdateMgr.MainTable.SchemaName , dmlUpdateMgr.MainTable.TableName , Constants.MultipleSessionCode , _daMgr.BuildParamName(Constants.MultipleSessionCode))); dmlUpdateMgr.AddColumn(Constants.StatusMessage, _daMgr.BuildParamName(Constants.StatusMessage)); dmlUpdateMgr.AddColumn(Constants.StatusDateTime, Core.EnumDateTimeLocale.UTC); DbCommand dbCmdUpdate = _daMgr.BuildUpdateDbCommand(dmlUpdateMgr); dbCmdUpdate.Parameters[_daMgr.BuildParamName(Constants.AppCode)].Value = _appCode; dbCmdUpdate.Parameters[_daMgr.BuildParamName(Constants.MultipleSessionCode)].Value = _appSessionCode; dbCmdUpdate.Parameters[_daMgr.BuildParamName(Constants.StatusMessage)].Value = statusMessage; DbCommandMgr dbCmdMgr = new DbCommandMgr(_daMgr); dbCmdMgr.AddDbCommand(dbCmdUpdate); // refresh signon control List <string> tableNames = new List <string>(); DbTableDmlMgr dmlSelectMgr = _daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.SignonControl); DbCommand dbCmdSelect = _daMgr.BuildSelectDbCommand(dmlSelectMgr, null); dbCmdMgr.AddDbCommand(dbCmdSelect); tableNames.Add(Constants.SignonControl); // refresh app sessions dmlSelectMgr = _daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.AppSessions); dbCmdSelect = _daMgr.BuildSelectDbCommand(dmlSelectMgr, null); dbCmdMgr.AddDbCommand(dbCmdSelect); tableNames.Add(Constants.AppSessions); DataSet controldata = dbCmdMgr.ExecuteDataSet(tableNames); _signonControl.Refresh(controldata.Tables[Constants.SignonControl]); _appSessions = controldata.Tables[Constants.AppSessions]; // temp start timer _heartbeatTimer.Change(_signonControl.SignonControlData.StatusSeconds * 1000 , _signonControl.SignonControlData.StatusSeconds * 1000); }
/// <summary> /// Adds a record to the session database table /// </summary> /// <param name="daMgr">DataAccessMgr object</param> /// <param name="userId">Unique user identifier</param> /// <param name="userCode">Unique numeric user identifier</param> /// <param name="userEnv">MetaData about the user's environment</param> /// <returns>A unique session code</returns> static Int64 AddSession(DataAccessMgr daMgr, string userId, Int32 userCode, UserEnvironmentStructure userEnv) { Int64 sessionCode = daMgr.GetNextSequenceNumber(Constants.SessionCode); DbTableDmlMgr dmlInsert = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserSessions); dmlInsert.AddColumn(Constants.SessionCode, daMgr.BuildParamName(Constants.SessionCode)); dmlInsert.AddColumn(Constants.UserCode, daMgr.BuildParamName(Constants.UserCode)); dmlInsert.AddColumn(Constants.UserId, daMgr.BuildParamName(Constants.UserId)); dmlInsert.AddColumn(Constants.AppCode, daMgr.BuildParamName(Constants.AppCode)); dmlInsert.AddColumn(Constants.AppId, daMgr.BuildParamName(Constants.AppId)); dmlInsert.AddColumn(Constants.AppMachine, daMgr.BuildParamName(Constants.AppMachine)); dmlInsert.AddColumn(Constants.AppVersion, daMgr.BuildParamName(Constants.AppVersion)); dmlInsert.AddColumn(Constants.RemoteAddress, daMgr.BuildParamName(Constants.RemoteAddress)); DbCommand cmdInsert = daMgr.BuildInsertDbCommand(dmlInsert); cmdInsert.Parameters[daMgr.BuildParamName(Constants.SessionCode)].Value = sessionCode; cmdInsert.Parameters[daMgr.BuildParamName(Constants.UserId)].Value = userId; cmdInsert.Parameters[daMgr.BuildParamName(Constants.UserCode)].Value = userCode; cmdInsert.Parameters[daMgr.BuildParamName(Constants.AppId)].Value = userEnv.AppId; cmdInsert.Parameters[daMgr.BuildParamName(Constants.AppCode)].Value = userEnv.AppCode; cmdInsert.Parameters[daMgr.BuildParamName(Constants.AppVersion)].Value = userEnv.AppVersion; cmdInsert.Parameters[daMgr.BuildParamName(Constants.RemoteAddress)].Value = userEnv.RemoteAddress; cmdInsert.Parameters[daMgr.BuildParamName(Constants.AppMachine)].Value = Environment.MachineName; DbTableDmlMgr dmlUpdate = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserMaster); dmlUpdate.AddColumn(Constants.FailedSignonAttempts , daMgr.BuildParamName(Constants.FailedSignonAttempts)); dmlUpdate.AddColumn(Constants.LastSignonDateTime , EnumDateTimeLocale.Default); dmlUpdate.SetWhereCondition((j) => j.Column(Constants.UserId) == j.Parameter(dmlUpdate.MainTable.SchemaName , dmlUpdate.MainTable.TableName , Constants.UserId , daMgr.BuildParamName(Constants.UserId))); DbCommand cmdUpdate = daMgr.BuildUpdateDbCommand(dmlUpdate); cmdUpdate.Parameters[daMgr.BuildParamName(Constants.UserId)].Value = userId; cmdUpdate.Parameters[daMgr.BuildParamName(Constants.FailedSignonAttempts)].Value = 0; DbCommandMgr cmdMgr = new DbCommandMgr(daMgr); cmdMgr.AddDbCommand(cmdInsert); cmdMgr.AddDbCommand(cmdUpdate); cmdMgr.ExecuteNonQuery(); return(sessionCode); }
/// <summary> /// Changes the given user's password to the new password and resets any account restrictions /// depending on given parameter. /// <para>The method assumes the caller has verified the spelling of the new password.</para> /// <para>The method also assumes the caller has verified the existing password if applicable.</para> /// </summary> /// <param name="daMgr">DataAccessMgr object</param> /// <param name="userId">Unique user identifier</param> /// <param name="newPassword">The new password (unhashed) plain text</param> /// <param name="resetSignonRestrictions">Indicates whether the accounts restrictions will be reset</param> public static void ChangePassword(DataAccessMgr daMgr , string userId , string newPassword , bool resetSignonRestrictions) { string salt = Cryptography.HashOperation.CreateRandomSalt(Cryptography.HashAlgorithmTypeEnum.SHA512HashAlgorithm); string hash = Cryptography.HashOperation.ComputeHash(Cryptography.HashAlgorithmTypeEnum.SHA512HashAlgorithm , newPassword , salt); DbTableDmlMgr dmlUpdate = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserMaster); dmlUpdate.AddColumn(Constants.UserPassword , daMgr.BuildParamName(Constants.UserPassword)); dmlUpdate.AddColumn(Constants.PasswordSalt , daMgr.BuildParamName(Constants.PasswordSalt)); dmlUpdate.AddColumn(Constants.FailedSignonAttempts , daMgr.BuildParamName(Constants.FailedSignonAttempts)); dmlUpdate.AddColumn(Constants.ForcePasswordChange , daMgr.BuildParamName(Constants.ForcePasswordChange)); if (resetSignonRestrictions) { dmlUpdate.AddColumn(Constants.SignonRestricted , daMgr.BuildParamName(Constants.SignonRestricted)); } dmlUpdate.SetWhereCondition((j) => j.Column(Constants.UserId) == j.Parameter(dmlUpdate.MainTable.SchemaName , dmlUpdate.MainTable.TableName , Constants.UserId , daMgr.BuildParamName(Constants.UserId))); DbCommand cmdUpdate = daMgr.BuildUpdateDbCommand(dmlUpdate); cmdUpdate.Parameters[daMgr.BuildParamName(Constants.UserId)].Value = userId; cmdUpdate.Parameters[daMgr.BuildParamName(Constants.UserPassword)].Value = hash; cmdUpdate.Parameters[daMgr.BuildParamName(Constants.PasswordSalt)].Value = salt; if (resetSignonRestrictions) { cmdUpdate.Parameters[daMgr.BuildParamName(Constants.SignonRestricted)].Value = 0; } cmdUpdate.Parameters[daMgr.BuildParamName(Constants.FailedSignonAttempts)].Value = 0; cmdUpdate.Parameters[daMgr.BuildParamName(Constants.ForcePasswordChange)].Value = 0; daMgr.ExecuteNonQuery(cmdUpdate, null, null); }
public ActionResult EditProfile(EditProfileModel editProfile) { if (ModelState.IsValid) { if (!string.IsNullOrEmpty(editProfile.ChangedFields)) { DataAccessMgr daMgr = Global.GetDataAccessMgr(this.HttpContext); DbTableDmlMgr dmlUpdate = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , DataManagement.Constants.Table_UserMaster); foreach (string column in dmlUpdate.MainTable.Columns.Keys) { if (editProfile.ChangedFields.Contains(column)) { dmlUpdate.AddColumn(column); } } dmlUpdate.AddColumn(SessionManagement.Constants.LastModifiedUserCode); dmlUpdate.AddColumn(SessionManagement.Constants.LastModifiedDateTime , Core.EnumDateTimeLocale.Default); dmlUpdate.SetWhereCondition(j => j.Column(DataManagement.Constants.UserId) == j.Parameter(dmlUpdate.MainTable.SchemaName , dmlUpdate.MainTable.TableName , DataManagement.Constants.UserId , daMgr.BuildParamName(DataManagement.Constants.UserId))); DbCommand cmdUpdate = daMgr.BuildUpdateDbCommand(dmlUpdate); UserSession userSessionMgr = (UserSession)Session[SessionManagement.Constants.UserSessionMgr]; cmdUpdate.Parameters[daMgr.BuildParamName(DataManagement.Constants.UserId)].Value = userSessionMgr.UserId; cmdUpdate.Parameters[daMgr.BuildParamName(SessionManagement.Constants.LastModifiedUserCode)].Value = userSessionMgr.UserCode; foreach (DbParameter param in cmdUpdate.Parameters) { if (param.Value == DBNull.Value) { param.Value = GetValueFromModelState(ModelState, param.ParameterName.Substring(1)); } } daMgr.ExecuteNonQuery(cmdUpdate, null, null); } else { ViewBag.NoDataChanged = true; } } return(View(editProfile)); }
static DbCommand BuildCmdGetUpdateUserSession(DataAccessMgr daMgr) { DbTableDmlMgr dmlUpdateMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserSessions); dmlUpdateMgr.AddColumn(Constants.SessionDateTime, EnumDateTimeLocale.UTC); dmlUpdateMgr.SetWhereCondition(j => j.Column(Constants.SessionCode) == j.Parameter(Constants.UserSessions, Constants.SessionCode , daMgr.BuildParamName(Constants.SessionCode))); return(daMgr.BuildUpdateDbCommand(dmlUpdateMgr)); }
/// <summary> /// Increases the signon failure account for the given user identifier and returns the latest count /// </summary> /// <param name="daMgr">DataAccessMgr object</param> /// <param name="userId">Unique user identifier</param> /// <returns>The icremented count of failed attempts</returns> static Int16 IncreaseFailedAttemptCount(DataAccessMgr daMgr, string userId) { DbTableDmlMgr dmlUpdate = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserMaster); DbFunctionStructure addOne = new DbFunctionStructure(); addOne.FunctionBody = string.Format("{0} + 1", Constants.FailedSignonAttempts); dmlUpdate.AddColumn(Constants.FailedSignonAttempts , addOne); dmlUpdate.SetWhereCondition((j) => j.Column(Constants.UserId) == j.Parameter(dmlUpdate.MainTable.SchemaName , dmlUpdate.MainTable.TableName , Constants.UserId , daMgr.BuildParamName(Constants.UserId))); DbCommand cmdUpdate = daMgr.BuildUpdateDbCommand(dmlUpdate); cmdUpdate.Parameters[daMgr.BuildParamName(Constants.UserId)].Value = userId; DbTableDmlMgr dmlSelectMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserMaster , Constants.FailedSignonAttempts); dmlSelectMgr.SetWhereCondition((j) => j.Column(Constants.UserId) == j.Parameter(dmlSelectMgr.MainTable.SchemaName , dmlSelectMgr.MainTable.TableName , Constants.UserId , daMgr.BuildParamName(Constants.UserId))); DbCommand cmdSelectUserMaster = daMgr.BuildSelectDbCommand(dmlSelectMgr, null); cmdSelectUserMaster.Parameters[daMgr.BuildParamName(Constants.UserId)].Value = userId; DbCommandMgr cmdMgr = new DbCommandMgr(daMgr); cmdMgr.AddDbCommand(cmdUpdate); cmdMgr.AddDbCommand(cmdSelectUserMaster); DataTable userMaster = cmdMgr.ExecuteDataTable(); return(Convert.ToInt16(userMaster.Rows[0][Constants.FailedSignonAttempts])); }
/// <summary> /// Constructor accepting the assembly and a usercode performing the registration /// </summary> /// <param name="daMgr">DataAccess manager object</param> /// <param name="assemblyName">Fully qualified assembly name</param> /// <param name="assemblyFileName">Fully qualified assembly path and filename</param> /// <param name="userCode">Usercode of user performing registration</param> /// <returns></returns> public static Int32 RegisterAssemblyTasks(DataAccessMgr daMgr , string assemblyName , string assemblyFileName , Int32?userCode) { // Load the assemlb Assembly asm = Assembly.LoadFrom(assemblyFileName); DbCommandMgr cmdMgr = new DbCommandMgr(daMgr); DbTableDmlMgr dmlMgr = new DbTableDmlMgr(daMgr, DataAccess.Constants.SCHEMA_CORE, Constants.TaskRegistrations); dmlMgr.AddColumn(Constants.TaskId, daMgr.BuildParamName(Constants.TaskId), DbTableColumnType.ForInsertOnly); dmlMgr.AddColumn(Constants.AssemblyName, daMgr.BuildParamName(Constants.AssemblyName)); dmlMgr.AddColumn(Constants.TaskDescription, daMgr.BuildParamName(Constants.TaskDescription)); dmlMgr.AddColumn(Constants.LastRegisteredDate, EnumDateTimeLocale.Default); // if usercode was provided add it to last mod key if (userCode.HasValue) { dmlMgr.AddColumn(Constants.LastModifiedUserCode, daMgr.BuildParamName(Constants.LastModifiedUserCode)); dmlMgr.AddColumn(Constants.LastModifiedDateTime, EnumDateTimeLocale.Default); } dmlMgr.SetWhereCondition((j) => j.Column(Constants.TaskId) == j.Parameter(Constants.TaskRegistrations , Constants.TaskId , daMgr.BuildParamName(Constants.TaskId))); // build a merge statement DbCommand dbCmd = daMgr.BuildMergeDbCommand(dmlMgr); int typesFound = 0; // set the values for the dbCommand foreach (Type t in ObjectFactory.SearchTypes <TaskProcess>(asm)) { // we must create the task object in or to have access to the TaskDesve TaskProcess tp = ObjectFactory.Create <TaskProcess>(assemblyFileName, t.FullName, null, null, null, null, null, null); dbCmd.Parameters[daMgr.BuildParamName(Constants.TaskId)].Value = t.FullName; dbCmd.Parameters[daMgr.BuildParamName(Constants.AssemblyName)].Value = assemblyName; dbCmd.Parameters[daMgr.BuildParamName(Constants.TaskDescription)].Value = tp.TaskDescription(); if (userCode.HasValue) { dbCmd.Parameters[daMgr.BuildParamName(Constants.LastModifiedUserCode)].Value = userCode.Value; } cmdMgr.AddDbCommand(dbCmd); ++typesFound; } // register the task (update it if exists otherwise insert) cmdMgr.ExecuteNonQuery(); return(typesFound); }
/// <summary> /// Sets or resets an account restriction for the given user identifier /// </summary> /// <param name="daMgr">DataAccessMgr object</param> /// <param name="userId">Unique user identifier</param> /// <param name="removeRestriction">Indicates whether to set or reset the restriction</param> static void Restriction(DataAccessMgr daMgr, string userId, bool removeRestriction) { DbTableDmlMgr dmlUpdate = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.UserMaster); dmlUpdate.AddColumn(Constants.SignonRestricted , daMgr.BuildParamName(Constants.SignonRestricted)); dmlUpdate.SetWhereCondition((j) => j.Column(Constants.UserId) == j.Parameter(dmlUpdate.MainTable.SchemaName , dmlUpdate.MainTable.TableName , Constants.UserId , daMgr.BuildParamName(Constants.UserId))); DbCommand cmdUpdate = daMgr.BuildUpdateDbCommand(dmlUpdate); cmdUpdate.Parameters[daMgr.BuildParamName(Constants.UserId)].Value = userId; cmdUpdate.Parameters[daMgr.BuildParamName(Constants.SignonRestricted)].Value = removeRestriction ? 0 : 1; daMgr.ExecuteNonQuery(cmdUpdate, null, null); }
/// <summary> /// Builds the DbCommand to Change the value of the edited columns found in the given dictionary. /// </summary> /// <param name="daMgr">DataAccessMgr object</param> /// <param name="taskQueueItem">The data row containing the values of the parameters</param> /// <param name="editedColumns">The columns that need to be updated</param> /// <param name="userCode">The userCode that updated the data</param> /// <returns>DbCommand Object with DbNull Parameter values</returns> public static DbCommand GetDependencyDmlCmd(DataAccessMgr daMgr , DataRow taskQueueItem , Dictionary <string, object> editedColumns , Int32?userCode = null) { DbCommand dbCmd = null; DbTableDmlMgr dmlMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , TaskProcessing.Constants.TaskDependencies); foreach (string column in editedColumns.Keys) { dmlMgr.AddColumn(column); } if (taskQueueItem == null) // add new item { dmlMgr.AddColumn(TaskProcessing.Constants.LastModifiedUserCode); dmlMgr.AddColumn(TaskProcessing.Constants.LastModifiedDateTime); dbCmd = daMgr.BuildInsertDbCommand(dmlMgr); } else { dbCmd = daMgr.BuildChangeDbCommand(dmlMgr, TaskProcessing.Constants.LastModifiedUserCode , TaskProcessing.Constants.LastModifiedDateTime); } foreach (string column in editedColumns.Keys) { dbCmd.Parameters[daMgr.BuildParamName(column)].Value = editedColumns[column]; } if (taskQueueItem == null) // add new { if (userCode.HasValue) { dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedUserCode)].Value = userCode.Value; dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedDateTime)].Value = daMgr.DbSynchTime; } else { dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedUserCode)].Value = DBNull.Value; dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedDateTime)].Value = DBNull.Value; } } else // change; where condition params { dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedUserCode)].Value = taskQueueItem[TaskProcessing.Constants.LastModifiedUserCode]; dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedDateTime)].Value = taskQueueItem[TaskProcessing.Constants.LastModifiedDateTime]; // set portion of the update if (userCode.HasValue) { dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedUserCode, true)].Value = userCode.Value; dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedDateTime, true)].Value = daMgr.DbSynchTime; } else { dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedUserCode, true)].Value = DBNull.Value; dbCmd.Parameters[daMgr.BuildParamName(TaskProcessing.Constants.LastModifiedDateTime, true)].Value = DBNull.Value; } } return(dbCmd); }
/// <summary> /// Method with change the settings of the SignonControl table to the given new settings only if they have not already been changed. /// <para>If </para> /// </summary> /// <param name="lastModifiedUser">The userCode of the user who last updated the record (or null if not changed)</param> /// <param name="lastModifiedDateTime">The DateTime of when the user last updated the record (or null if not changed)</param> /// <param name="newControlSettings">Signon Control Data Strcutre containing the new values.</param> /// <returns>Boolean indicating if record was changed or not.</returns> internal bool ChangeControl(int?lastModifiedByUserCode , DateTime?lastModifiedDateTime , SignonControlStructure newControlSettings) { DbTableDmlMgr dmlChange = _daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.SignonControl); dmlChange.AddColumn(Constants.TimeoutSeconds); dmlChange.AddColumn(Constants.SignoffWarningMsg); dmlChange.AddColumn(Constants.ForceSignOff); dmlChange.AddColumn(Constants.RestrictSignon); dmlChange.AddColumn(Constants.StatusSeconds); dmlChange.AddColumn(Constants.RestrictSignonMsg); dmlChange.AddColumn(Constants.FailedAttemptLimit); dmlChange.SetWhereCondition((j) => j.Column(Constants.SignonControl) == j.Parameter(Constants.SignonControl)); DbCommandMgr dbCmdMgr = new DbCommandMgr(_daMgr); DbCommand cmdChangeOrig = _daMgr.BuildChangeDbCommand(dmlChange , Constants.LastModifiedUserCode , Constants.LastModifiedDateTime); cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.ControlCode)].Value = newControlSettings.SessionControlCode; cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.TimeoutSeconds)].Value = Convert.ToInt16(newControlSettings.TimeOutSeconds); cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.SignoffWarningMsg)].Value = newControlSettings.SignoffWarningMsg; cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.ForceSignOff)].Value = newControlSettings.ForceSignoff; cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.RestrictSignon)].Value = newControlSettings.RestrictSignon; cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.RestrictSignonMsg)].Value = newControlSettings.RestrictSignonMsg; cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.StatusSeconds)].Value = newControlSettings.StatusSeconds; cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.FailedAttemptLimit)].Value = newControlSettings.FailedAttemptLimit; if (lastModifiedByUserCode.HasValue) { cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.LastModifiedUserCode)].Value = lastModifiedByUserCode.Value; } if (lastModifiedDateTime.HasValue) { cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.LastModifiedDateTime)].Value = lastModifiedDateTime.Value; } if (newControlSettings.LastModifiedByUserCode.HasValue) { cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.LastModifiedUserCode, true)].Value = newControlSettings.LastModifiedByUserCode.Value; } cmdChangeOrig.Parameters[_daMgr.BuildParamName(Constants.LastModifiedDateTime, true)].Value = newControlSettings.LastModifiedByDateTime.Value; int rowsAffected = _daMgr.ExecuteNonQuery(cmdChangeOrig, null, null); if (rowsAffected == 1) { _signonControl.FailedAttemptLimit = newControlSettings.FailedAttemptLimit; _signonControl.ForceSignoff = newControlSettings.ForceSignoff; _signonControl.RestrictSignon = newControlSettings.RestrictSignon; _signonControl.RestrictSignonMsg = newControlSettings.RestrictSignonMsg; _signonControl.SignoffWarningMsg = newControlSettings.SignoffWarningMsg; _signonControl.StatusSeconds = newControlSettings.StatusSeconds; _signonControl.TimeOutSeconds = newControlSettings.TimeOutSeconds; _signonControl.LastModifiedByUserCode = newControlSettings.LastModifiedByUserCode; _signonControl.LastModifiedByDateTime = newControlSettings.LastModifiedByDateTime; return(true); } else { return(false); } }
/// <summary> /// Method to begin session for the application. /// <para>Once started, the application session record will also be updated by the heartbeat process.</para> /// <para>The frequency of the heartbeat process is controlled by the SignonControl.StatusSeconds column.</para> /// <para>If the application is a TaskProcessingEngine, then there can be only a single active instance /// for a given AppId. If there is a violation, a string message will be returned. The caller, can recall /// this method with the overWrite parameter = true. In that case the existing record will be removed.</para> /// </summary> /// <param name="configSettings">A string of configuration settings used by the application</param> /// <param name="statusMsg">A startup status message by the application</param> /// <param name="overwrite">Indicates whether or not to overwrite an existing record for the AppId</param> /// <param name="tpeEndpointAddress">Indentifies the WCF host endpoint address of when app is a TPE</param> /// <returns>Null for success; error message otherwise.</returns> public string Start(string configSettings, string statusMsg, bool overwrite, string tpeEndpointAddress = null) { DbTableDmlMgr dmlSelectMgr = _daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.AppSessions); DbCommand dbCmdSelect = _daMgr.BuildSelectDbCommand(dmlSelectMgr, null); DbTableDmlMgr dmlInsertMgr = _daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , Constants.AppSessions); dmlInsertMgr.AddColumn(Constants.AppId, _daMgr.BuildParamName(Constants.AppId)); dmlInsertMgr.AddColumn(Constants.AppCode, _daMgr.BuildParamName(Constants.AppCode)); dmlInsertMgr.AddColumn(Constants.AppVersion, _daMgr.BuildParamName(Constants.AppVersion)); dmlInsertMgr.AddColumn(Constants.AppName, _daMgr.BuildParamName(Constants.AppName)); dmlInsertMgr.AddColumn(Constants.MultipleSessionCode, _daMgr.BuildParamName(Constants.MultipleSessionCode)); dmlInsertMgr.AddColumn(Constants.ProcessId, _daMgr.BuildParamName(Constants.ProcessId)); dmlInsertMgr.AddColumn(Constants.StatusMessage, _daMgr.BuildParamName(Constants.StatusMessage)); dmlInsertMgr.AddColumn(Constants.ConfigSettings, _daMgr.BuildParamName(Constants.ConfigSettings)); dmlInsertMgr.AddColumn(Constants.EnvironmentSettings, _daMgr.BuildParamName(Constants.EnvironmentSettings)); dmlInsertMgr.AddColumn(Constants.MachineName, _daMgr.BuildParamName(Constants.MachineName)); dmlInsertMgr.AddColumn(Constants.TpeEndpointAddress, _daMgr.BuildParamName(Constants.TpeEndpointAddress)); DbCommand dbCmdInsert = _daMgr.BuildInsertDbCommand(dmlInsertMgr); DbCommandMgr dbCmdMgr = new DbCommandMgr(_daMgr); StringBuilder sb = new StringBuilder(); sb.AppendFormat("AllowMultipleSessions: {0} {1}", _allowMultipleSessions, Environment.NewLine); sb.AppendFormat("OS Version: {0} {1}", Environment.OSVersion, Environment.NewLine); sb.AppendFormat("ProcessName: {0} {1}", Process.GetCurrentProcess().ProcessName, Environment.NewLine); sb.AppendFormat("CLR Version: {0} {1}", Environment.Version, Environment.NewLine); sb.AppendFormat("DbProvider Version: {0} {1}", _daMgr.DbProviderVersion, Environment.NewLine); sb.AppendFormat("DbServer Version: {0} {1}", _daMgr.DbServerVersion, Environment.NewLine); sb.AppendFormat("Is x64bit OS: {0} {1}", Environment.Is64BitOperatingSystem, Environment.NewLine); sb.AppendFormat("Is x64bit process: {0} {1}", Environment.Is64BitProcess, Environment.NewLine); sb.AppendFormat("Processor Count: {0} {1}", Environment.ProcessorCount, Environment.NewLine); dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.AppId)].Value = _appId; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.AppCode)].Value = _appCode; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.MachineName)].Value = Environment.MachineName; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.ProcessId)].Value = System.Diagnostics.Process.GetCurrentProcess().Id; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.AppVersion)].Value = _appVersion; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.AppName)].Value = _appName; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.MultipleSessionCode)].Value = _appSessionCode; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.ConfigSettings)].Value = configSettings; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.EnvironmentSettings)].Value = sb.ToString(); dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.StatusMessage)].Value = statusMsg; dbCmdInsert.Parameters[_daMgr.BuildParamName(Constants.TpeEndpointAddress)].Value = tpeEndpointAddress; if (overwrite) { dbCmdMgr.TransactionBeginBlock(); DbCommand dbCmdDelete = GetDeleteSessionRecordCmd(); dbCmdDelete.Parameters[_daMgr.BuildParamName(Constants.AppCode)].Value = _appCode; dbCmdDelete.Parameters[_daMgr.BuildParamName(Constants.MultipleSessionCode)].Value = _appSessionCode; dbCmdMgr.AddDbCommand(dbCmdDelete); dbCmdMgr.AddDbCommand(dbCmdInsert); dbCmdMgr.TransactionEndBlock(); dbCmdMgr.AddDbCommand(dbCmdSelect); } else { dbCmdMgr.AddDbCommand(dbCmdInsert); dbCmdMgr.AddDbCommand(dbCmdSelect); } try { _appSessions = dbCmdMgr.ExecuteDataTable(); _heartbeatTimer = new System.Threading.Timer(new TimerCallback(Heartbeat), null , _signonControl.SignonControlData.StatusSeconds * 1000 , _signonControl.SignonControlData.StatusSeconds * 1000); if (_daMgr.loggingMgr != null) { _daMgr.loggingMgr.WriteToLog(string.Format("AppId {0}; AppName: {1}; Version: {2}; TaskProcessingEngine: {3}; Session Started." , _appId , _appName , _appVersion , IsTaskProcessingEngine) , EventLogEntryType.Information , enumEventPriority.Critical); } } catch (ExceptionEvent e) { if (_daMgr.loggingMgr != null) { _daMgr.loggingMgr.WriteToLog(e); } if (e.ExceptionEventCode == enumExceptionEventCodes.DbTablePrimaryKeyViolation) { return("AppCode record already exists in AppSession table. If you wish to cleanup record and continue," + " please resubmit."); } throw; } return(null); }