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