public List <MediaSettingInfo> GetallData(MediaSettingInfo objMediaSetting) { try { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >(); param.Add(new KeyValuePair <string, object>("@PortalID", objMediaSetting.PortalID)); param.Add(new KeyValuePair <string, object>("@UserModuleID", objMediaSetting.UserModuleID)); param.Add(new KeyValuePair <string, object>("@Culture", objMediaSetting.Culture)); SQLHandler sagesql = new SQLHandler(); return(sagesql.ExecuteAsList <MediaSettingInfo>("[dbo].[usp_MediaSetting_GetallData]", param)); } catch { throw; } }
public MediaSettingKeys GetMediaSettingKeyValue() { MediaSettingKeys objSettingKey = new MediaSettingKeys(); try { MediaSettingDataProvider objDataProvider = new MediaSettingDataProvider(); MediaSettingInfo settingKeyInfo = objDataProvider.GetByID(1); if (settingKeyInfo != null && settingKeyInfo.SettingKeyValue.Length > 0) { MediaSettingKeyValue objMediaKeys = new MediaSettingKeyValue(); objMediaKeys = new JavaScriptSerializer().Deserialize <MediaSettingKeyValue>(settingKeyInfo.SettingKeyValue); objSettingKey = objMediaKeys.MediaSetting; } } catch { throw; } return(objSettingKey); }
public int AddUpdate(MediaSettingInfo objMediaSetting) { int mediaSettingID = 0; List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >(); param.Add(new KeyValuePair <string, object>("@MediaSettingID", objMediaSetting.MediaSettingID)); param.Add(new KeyValuePair <string, object>("@SettingKeyValue", objMediaSetting.SettingKeyValue)); param.Add(new KeyValuePair <string, object>("@PortalID", objMediaSetting.PortalID)); param.Add(new KeyValuePair <string, object>("@UserModuleID", objMediaSetting.UserModuleID)); param.Add(new KeyValuePair <string, object>("@Culture", objMediaSetting.Culture)); SQLHandler sagesql = new SQLHandler(); try { mediaSettingID = sagesql.ExecuteNonQuery("[dbo].[usp_MediaSetting_InsertUpdate]", param, "@NewMediaSettingID"); } catch { throw; } return(mediaSettingID); }
public int AddUpdate(MediaSettingInfo obj) { MediaSettingDataProvider objDataProvider = new MediaSettingDataProvider(); return(objDataProvider.AddUpdate(obj)); }
public List <MediaSettingInfo> GetallData(MediaSettingInfo objMediaSetting) { MediaSettingDataProvider objDataProvider = new MediaSettingDataProvider(); return(objDataProvider.GetallData(objMediaSetting)); }