private static int _updateParameterBusiness(string userName, string parameterName, string parameterValue) { int result = 0; try { string connectionString = SAFConfiguration.readConnectionStringBusiness(); using (IDbConnection dbConnection = new SqlConnection(connectionString)) { dbConnection.Open(); using (IDbCommand dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "SetConfigurationParameter"; dbCommand.Parameters.Add(new SqlParameter("@UserName", userName)); dbCommand.Parameters.Add(new SqlParameter("@ParameterName", parameterName)); dbCommand.Parameters.Add(new SqlParameter("@ParameterValue", parameterValue)); result = (int)dbCommand.ExecuteScalar(); } } } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::_updateParameterBusiness failed. Err:" + ex.Message, ex); } SAFConfiguration._CheckCache(0); return(result); }
public static string ExpandSAFBusinessConfiguration() { string result; try { result = SAFConfiguration.readConnectionStringBusiness(); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[] { "http://sfexpand.SAFBusinessConfig.dbConnectionString.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = null; } return(result); }
private static SAFConfigurationParametersMap GetAllParametersFromDB() { SAFConfigurationParametersMap sAFConfigurationParametersMap = new SAFConfigurationParametersMap(); SAFConfigurationParametersMap result; try { string connectionString = SAFConfiguration.readConnectionStringBusiness(); using (IDbConnection dbConnection = new SqlConnection(connectionString)) { dbConnection.Open(); using (IDbCommand dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "GetAllConfiguration"; IDataReader dataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConnection); while (dataReader.Read()) { SAFConfigurationParameter sAFConfigurationParameter = new SAFConfigurationParameter(); sAFConfigurationParameter.section = dataReader.GetString(0); sAFConfigurationParameter.name = dataReader.GetString(1); sAFConfigurationParameter.value = (dataReader.IsDBNull(2) ? null : dataReader.GetString(2)); sAFConfigurationParameter.lastUTCupdate = dataReader.GetDateTime(3); sAFConfigurationParameter.frozen = dataReader.GetBoolean(4); sAFConfigurationParameter.hidden = dataReader.GetBoolean(5); string key = sAFConfigurationParameter.section + "@" + sAFConfigurationParameter.name; sAFConfigurationParametersMap.Add(key, sAFConfigurationParameter); } } } result = sAFConfigurationParametersMap; } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::GetAllParameters failed. Err:" + ex.Message, ex); result = null; } return(result); }