public bool deleteDashboardItem(int itemID) { try { StoredProcedureDataContext dbmlObject = new StoredProcedureDataContext(); dbmlObject.DeleteDashboardItem(itemID); dbmlObject.SubmitChanges(); } catch (Exception e) { throw e; } return(true); }
public bool deleteDashboard(int dashboardID) { try { StoredProcedureDataContext dbmlobject = new StoredProcedureDataContext(); var result = dbmlobject.RetreiveExistingDashboardItems(dashboardID, "nothing").ToList(); foreach (var item in result) { dbmlobject.DeleteDashboardItem(item.ItemID); } dbmlobject.DeleteDashboard(dashboardID); dbmlobject.SubmitChanges(); } catch (Exception e) { throw e; } return(true); }
public bool AddDashboardItem(DashboardItem Item, int[] Sources, int[] WorkingTeams) { try { StoredProcedureDataContext dbmlObject = new StoredProcedureDataContext(); if (Item.ItemID != 0) //if it is a Edit Option { dbmlObject.DeleteDashboardItem(Item.ItemID); } var resItemID = dbmlObject.AddDataItem(Item.ItemName, Item.StartDate, Item.EndDate, Item.DashboardID, Item.StatusID).ToList(); dbmlObject.SubmitChanges(); int itemID = Convert.ToInt32(resItemID.FirstOrDefault().Column1); AddDashboardItemTeams(WorkingTeams, itemID); AddDashboardItemSource(Sources, itemID); } catch (Exception e) { Console.WriteLine(e); } return(true); }