public SAFConfigurationParametersMap GetAllParametersFromDB()
{
IDbCommand _cmd = null;
IDataReader _rd = null;
SAFConfigurationParametersMap cacheData = new SAFConfigurationParametersMap();
SAFConfigurationParametersMap result;
try
{
base.ConnectionString = DBConnectionString.ExpandSAFBusinessConfiguration();
_cmd = base.CreateCommand("SAFGetConfiguration", CommandType.StoredProcedure);
base.Connection.Open();
_rd = _cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (_rd.Read())
{
SAFConfigurationParameter par = new SAFConfigurationParameter();
par.section = _rd.GetString(0);
par.name = _rd.GetString(1);
par.value = (_rd.IsDBNull(2) ? null : _rd.GetString(2));
par.lastUTCupdate = _rd.GetDateTime(3);
par.frozen = _rd.GetBoolean(4);
par.hidden = _rd.GetBoolean(5);
cacheData.Add(par.section + "@" + par.name, par);
}
result = cacheData;
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusinessConfig.SAFConfigurationDAO.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = null;
}
finally
{
if (_rd != null)
{
_rd.Dispose();
}
if (_cmd != null)
{
_cmd.Dispose();
}
base.CloseConnection();
}
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;
}
