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);
}
private static string _readParameterBusiness(string parameterFullName, int cacheSecs)
{
string result;
try
{
SAFConfigurationParametersMap cacheData = SAFConfiguration._CheckCache(cacheSecs);
if (cacheData == null || !cacheData.ContainsKey(parameterFullName))
{
result = null;
}
else
{
result = cacheData[parameterFullName].value;
}
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.WARNING, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusinessConfig.SAFConfiguration.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
"failed::[" + parameterFullName + "]",
ex.ToString()
});
result = null;
}
return(result);
}
private static string _readParameterBusiness(string parameterFullName, int cacheSecs)
{
SAFConfigurationParametersMap sAFConfigurationParametersMap = SAFConfiguration._CheckCache(cacheSecs);
if (sAFConfigurationParametersMap == null)
{
return(null);
}
string result;
try
{
result = sAFConfigurationParametersMap[parameterFullName].value;
}
catch (Exception ex)
{
LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Configuration.SAFConfiguration::readParameterBusinessChangeable error getting parameter[" + parameterFullName + "]. Err:" + ex.Message, ex);
result = null;
}
return(result);
}
public static SAFConfigurationParametersMap readParameters(int cacheSecs)
{
return(SAFConfiguration._CheckCache(cacheSecs));
}
public static SAFConfigurationParametersMap readParameters()
{
return(SAFConfiguration._CheckCache(0));
}