public static DatabaseResponse GetValue(string serviceCode, string connectionString)
{
DataAccessHelper _DataHelper = null;
try
{
SqlParameter[] parameters =
{
new SqlParameter("@ConfigType", SqlDbType.NVarChar)
};
parameters[0].Value = serviceCode;
_DataHelper = new DataAccessHelper("Admin_GetConfigurations", parameters, connectionString);
DataTable dt = new DataTable();
int result = _DataHelper.Run(dt); // 102 /105
DatabaseResponse response = new DatabaseResponse();
if (result == 105)
{
List <Dictionary <string, string> > configDictionary = new List <Dictionary <string, string> >();
if (dt != null && dt.Rows.Count > 0)
{
configDictionary = LinqExtensions.GetDictionary(dt);
}
response = new DatabaseResponse {
ResponseCode = result, Results = configDictionary
};
}
else
{
response = new DatabaseResponse {
ResponseCode = result
};
}
return(response);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
_DataHelper.Dispose();
}
}
public static DatabaseResponse GetValueByKey(string serviceKey, string connectionString)
{
DataAccessHelper _DataHelper = null;
try
{
SqlParameter[] parameters =
{
new SqlParameter("@ConfigKey", SqlDbType.NVarChar)
};
parameters[0].Value = serviceKey;
_DataHelper = new DataAccessHelper("Admin_GetConfigurationByKey", parameters, connectionString);
DataTable dt = new DataTable();
int result = _DataHelper.Run(dt); // 102 /105
DatabaseResponse response = new DatabaseResponse();
if (result == 105)
{
string ConfigValue = "";
if (dt != null && dt.Rows.Count > 0)
{
ConfigValue = dt.Rows[0]["value"].ToString().Trim();
}
response = new DatabaseResponse {
ResponseCode = result, Results = ConfigValue
};
}
else
{
response = new DatabaseResponse {
ResponseCode = result
};
}
return(response);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
_DataHelper.Dispose();
}
}