public static DashbordSettingInfo GetSettingByKey(DashbordSettingInfo objSetting)
{
try
{
return(DashboardDataProvider.GetSettingByKey(objSetting));
}
catch (Exception)
{
throw;
}
}
public static void AddUpdateDashboardSettings(DashbordSettingInfo objSetting)
{
try
{
DashboardDataProvider.AddUpdateDashboardSettings(objSetting);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and obtain setting key.
/// </summary>
/// <param name="objSetting">DashbordSettingInfo object.</param>
/// <returns>DashbordSettingInfo object.</returns>
public static DashbordSettingInfo GetSettingByKey(DashbordSettingInfo objSetting)
{
string sp = "[dbo].[usp_DashboardGetSettingByKey]";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@SettingKey", objSetting.SettingKey));
ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", objSetting.UserName));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", objSetting.PortalID));
try
{
return(sagesql.ExecuteAsObject <DashbordSettingInfo>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and insert to DashboardSettingsKeyValue.
/// </summary>
/// <param name="objSetting">DashbordSettingInfo object.</param>
public static void AddUpdateDashboardSettings(DashbordSettingInfo objSetting)
{
string sp = "[dbo].[usp_DashboardSettingAddUpdate]";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@SettingKey", objSetting.SettingKey));
ParamCollInput.Add(new KeyValuePair <string, object>("@SettingValue", objSetting.SettingValue));
ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", objSetting.UserName));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", objSetting.PortalID));
try
{
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
public static DashbordSettingInfo GetSettingByKey(DashbordSettingInfo objSetting)
{
string sp = "[dbo].[usp_DashboardGetSettingByKey]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@SettingKey", objSetting.SettingKey));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", objSetting.UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", objSetting.PortalID));
try
{
return(sagesql.ExecuteAsObject<DashbordSettingInfo>(sp, ParamCollInput));
}
catch (Exception)
{
throw;
}
}
public static void AddUpdateDashboardSettings(DashbordSettingInfo objSetting)
{
string sp = "[dbo].[usp_DashboardSettingAddUpdate]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@SettingKey", objSetting.SettingKey));
ParamCollInput.Add(new KeyValuePair<string, object>("@SettingValue", objSetting.SettingValue));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", objSetting.UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", objSetting.PortalID));
try
{
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
public static DashbordSettingInfo GetSettingByKey(DashbordSettingInfo objSetting)
{
try
{
return (DashboardDataProvider.GetSettingByKey(objSetting));
}
catch (Exception)
{
throw;
}
}
public static void AddUpdateDashboardSettings(DashbordSettingInfo objSetting)
{
try
{
DashboardDataProvider.AddUpdateDashboardSettings(objSetting);
}
catch (Exception)
{
throw;
}
}
