internal ImageFlowSettingInfo GetSetting(int userModuleID, int portalID)
{
try
{
string Sp = "[dbo].[usp_ImageFlowSetting_Get]";
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@UserModuleID", userModuleID));
param.Add(new KeyValuePair <string, object>("@PortalID", portalID));
SQLHandler objSql = new SQLHandler();
ImageFlowSettingInfo objInfo = objSql.ExecuteAsObject <ImageFlowSettingInfo>(Sp, param);
return(objInfo);
}
catch (Exception ex)
{
throw ex;
}
}
internal void AddUpdateSetting(ImageFlowSettingInfo objInfo)
{
try
{
string Sp = "[dbo].[usp_ImageFlowSetting_AddUpdate]";
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@Style", objInfo.Style));
param.Add(new KeyValuePair <string, object>("@Spacing", objInfo.Spacing));
param.Add(new KeyValuePair <string, object>("@Arrow", objInfo.Arrow));
param.Add(new KeyValuePair <string, object>("@AutoPlay", objInfo.AutoPlay));
param.Add(new KeyValuePair <string, object>("@Looping", objInfo.Looping));
param.Add(new KeyValuePair <string, object>("@Clickable", objInfo.Clickable));
param.Add(new KeyValuePair <string, object>("@ScrollWheel", objInfo.ScrollWheel));
param.Add(new KeyValuePair <string, object>("@UserModuleID", objInfo.UserModuleID));
param.Add(new KeyValuePair <string, object>("@PortalID", objInfo.PortalID));
SQLHandler objSql = new SQLHandler();
objSql.ExecuteNonQuery(Sp, param);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddUpdateSetting(ImageFlowSettingInfo objInfo)
{
ImageFlowDataProvider ObjProv = new ImageFlowDataProvider();
ObjProv.AddUpdateSetting(objInfo);
}
