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