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