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);
}
