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