public SettingsList FetchAllSettingsFromDB()
{
try
{
string Source = "sp_FetchAllSettings";
DataSet Output = Commands.ExecuteQuery(Source, CommandType.StoredProcedure, null);
SettingsList SettingsList = new SettingsList();
foreach (DataRow dr in Output.Tables[0].Rows)
{
Settings SettingsObj = new Settings();
SettingsObj.SetSettingsKey(dr["setting_key"].ToString());
SettingsObj.SetSettingsValue(dr["setting_value"].ToString());
SettingsList.AddSettings(SettingsObj);
}
return(SettingsList);
}
catch (Exception ex)
{
LOGGER.Logger.Instance().Log(LOGGER.Fatal.Instance(), ex);
throw ex;
}
}