public static void UpdateWeakPasswordSettings(WeakPasswordSetting weakPasswordSettings, string connectionString) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); WeakPasswordSetting.UpdateWeakPasswordSettings(weakPasswordSettings, connection); } } catch (Exception ex) { logX.loggerX.Error("ERROR - exception raised when connecting to update weak password lists, ", ex.ToString()); } }
public static List <WeakPasswordSetting> GetWeakPasswordSettings(string connectionString) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); return(WeakPasswordSetting.GetWeakPasswordSettings(connection)); } } catch (Exception ex) { logX.loggerX.Error("ERROR - exception raised when connecting to read weak password lists, ", ex.ToString()); return(new List <WeakPasswordSetting>()); } }
public static List <WeakPasswordSetting> GetWeakPasswordSettings(SqlConnection connection) { List <WeakPasswordSetting> settings = new List <WeakPasswordSetting>(); try { using (SqlCommand cmd = new SqlCommand(QueryGetPasswordList, connection)) { cmd.CommandType = CommandType.StoredProcedure; //pass null to get all the entire list SqlParameter passwordListId = new SqlParameter(ParamPasswordListId, DBNull.Value); cmd.Parameters.Add(passwordListId); // Read info from the repository. using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { int listId = WeakPasswordSetting.GetId(rdr.GetSqlInt32((int)WeakPasswordColumns.Id)); List <string> customList = WeakPasswordSetting.GetPasswordList(rdr.GetSqlString((int)WeakPasswordColumns.CustomList)); DateTime customUpdated = WeakPasswordSetting.GetDateTime(rdr.GetSqlDateTime((int)WeakPasswordColumns.CustonListUpdated)); List <string> additionalList = WeakPasswordSetting.GetPasswordList(rdr.GetSqlString((int)WeakPasswordColumns.AdditionalList)); DateTime additionalUpdate = WeakPasswordSetting.GetDateTime(rdr.GetSqlDateTime((int)WeakPasswordColumns.AdditionListUpdated)); bool enabled = WeakPasswordSetting.GetBoolean(rdr.GetSqlString((int)WeakPasswordColumns.PasswordCheckingEnabled)); WeakPasswordSetting setting = new WeakPasswordSetting(listId, customList, customUpdated, additionalList, additionalUpdate, enabled); settings.Add(setting); } } } } catch (Exception ex) { logX.loggerX.Error("ERROR - exception raised when reading weak password lists, ", ex.ToString()); } if (settings.Count == 0) { //since there is nothing in the repository, create an empy object. WeakPasswordSetting passwordSettings = new WeakPasswordSetting(-1, new List <string>(), DateTime.MinValue, new List <string>(), DateTime.MinValue, true); settings.Add(passwordSettings); } return(settings); }
public static List <WeakPasswordSetting> UpdateWeakPasswordSettings(WeakPasswordSetting weakPasswordSettings, SqlConnection connection) { List <WeakPasswordSetting> settings = new List <WeakPasswordSetting>(); try { using (SqlCommand cmd = new SqlCommand(QueryUpdatePasswordList, connection)) { cmd.CommandType = CommandType.StoredProcedure; SqlParameter passwordListId = new SqlParameter(ParamPasswordListId, weakPasswordSettings.PasswordListId); SqlParameter customPasswordList; SqlParameter customListUpdated; SqlParameter additionalPasswordList; SqlParameter additionalListUpdated; string passwordList; //only set the custom list if it has been changed if (weakPasswordSettings.CustomListUpdated != DateTime.MinValue) { passwordList = WeakPasswordSetting.ConvertListToString(weakPasswordSettings.CustomPasswordList); //an empty list shoud be set to null since empty means blank if (String.IsNullOrEmpty(passwordList)) { customPasswordList = new SqlParameter(ParamCustomPasswordList, DBNull.Value); } else { customPasswordList = new SqlParameter(ParamCustomPasswordList, passwordList); } customListUpdated = new SqlParameter(ParamCustomListUpdated, weakPasswordSettings.CustomListUpdated); } else { customPasswordList = new SqlParameter(ParamCustomPasswordList, DBNull.Value); customListUpdated = new SqlParameter(ParamCustomListUpdated, DBNull.Value); } //only set the additional list if it has been changed if (weakPasswordSettings.AdditionalListUpdated != DateTime.MinValue) { passwordList = WeakPasswordSetting.ConvertListToString(weakPasswordSettings.AdditionalPasswordList); //an empty list shoud be set to null since empty means blank if (String.IsNullOrEmpty(passwordList)) { additionalPasswordList = new SqlParameter(ParamAdditionalPasswordList, DBNull.Value); } else { additionalPasswordList = new SqlParameter(ParamAdditionalPasswordList, passwordList); } additionalListUpdated = new SqlParameter(ParamAdditionListUpdated, weakPasswordSettings.AdditionalListUpdated); } else { additionalPasswordList = new SqlParameter(ParamAdditionalPasswordList, DBNull.Value); additionalListUpdated = new SqlParameter(ParamAdditionListUpdated, DBNull.Value); } SqlParameter passwordCheckingEnabled = new SqlParameter(ParamPasswordCheckingEnabled, (weakPasswordSettings.PasswordCheckingEnabled ? 'Y' : 'N')); cmd.Parameters.Add(passwordListId); cmd.Parameters.Add(customPasswordList); cmd.Parameters.Add(customListUpdated); cmd.Parameters.Add(additionalPasswordList); cmd.Parameters.Add(additionalListUpdated); cmd.Parameters.Add(passwordCheckingEnabled); cmd.ExecuteNonQuery(); } } catch (Exception ex) { logX.loggerX.Error("ERROR - exception raised when updating weak password lists, ", ex.ToString()); } return(settings); }