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