/// <summary> /// This function adds the widgets for a user /// </summary> /// <param name="widgets"></param> /// <returns></returns> public bool SetUserWidgets(List<DashboardWidget> widgets) { if (widgets != null && widgets.Count > 0) { var context = new dbDataContext(); var userId = widgets[0].UserId; //delete all the widgets for the user var foundWidgets = context.tbl_UserWidgets.Where(t => t.UserId == userId).Select(t => t).ToList(); context.tbl_UserWidgets.DeleteAllOnSubmit(foundWidgets); context.SubmitChanges(); //add widgets foreach (var wi in widgets) { if (string.IsNullOrEmpty(wi.WidgetName)) { continue; } var widget = new tbl_UserWidget { Ordering = wi.Ordering, UserId = wi.UserId, WidgetName = wi.WidgetName, WidgetTitle = wi.WidgetTitle, Width = wi.Width }; context.tbl_UserWidgets.InsertOnSubmit(widget); } context.SubmitChanges(); } return true; }
partial void Updatetbl_UserWidget(tbl_UserWidget instance);
partial void Deletetbl_UserWidget(tbl_UserWidget instance);
partial void Inserttbl_UserWidget(tbl_UserWidget instance);