public SageBannerSettingInfo GetSageBannerSettingList(int PortalID, int UserModuleID, string CultureCode) { try { SageBannerSettingInfo Getsettin = new SageBannerSettingInfo(); List<KeyValuePair<string, object>> paramCol = new List<KeyValuePair<string, object>>(); paramCol.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); paramCol.Add(new KeyValuePair<string, object>("@UserModuleID", UserModuleID)); paramCol.Add(new KeyValuePair<string, object>("@CultureCode", CultureCode)); SQLHandler sageSQL = new SQLHandler(); Getsettin = sageSQL.ExecuteAsObject<SageBannerSettingInfo>("[dbo].[usp_SageBannerGetBannerSetting]", paramCol); return Getsettin; } catch (Exception ex) { throw ex; } }
/// <summary> /// Obtain sagebanner setting list. /// </summary> /// <param name="PortalID">PortalID</param> /// <param name="UserModuleID">UserModuleID</param> /// <param name="CultureCode">CultureCode</param> /// <returns>SageBannerSettingInfo object.</returns> public SageBannerSettingInfo GetSageBannerSettingList(int PortalID, int UserModuleID, string CultureCode) { try { SageBannerSettingInfo objSageBannerSettingInfo = new SageBannerSettingInfo(); if (HttpRuntime.Cache["BannerSetting_" + CultureCode + "_" + UserModuleID.ToString()] != null) { objSageBannerSettingInfo = HttpRuntime.Cache["BannerSetting_" + CultureCode + "_" + UserModuleID.ToString()] as SageBannerSettingInfo; } else { SageBannerProvider objp = new SageBannerProvider(); objSageBannerSettingInfo = objp.GetSageBannerSettingList(PortalID, UserModuleID, CultureCode); HttpRuntime.Cache["BannerSetting_" + CultureCode + "_" + UserModuleID.ToString()] = objSageBannerSettingInfo; } return objSageBannerSettingInfo; } catch (Exception ex) { throw ex; } }