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 CreateNewDashboardByExistingDashboard(int dashboardID, int userID, string dashboardName, string description)
{
StoredProcedureDataContext dbmlObject = new StoredProcedureDataContext();
var result = dbmlObject.GetDashboardByID(dashboardID).ToList();
var dashboardDetails = result.FirstOrDefault();
var resNewDashboardID = dbmlObject.CreateDashboard(dashboardName, dashboardDetails.StartMonth, dashboardDetails.StartYear, dashboardDetails.EndMonth, dashboardDetails.EndYear, userID, "ADMIN", description).ToList();
int newDashboardID = Convert.ToInt32(resNewDashboardID.FirstOrDefault().Column1);
//Dashboard Source
var resDashboardSources = dbmlObject.RetreiveSource(dashboardID).ToList();
foreach (var i in resDashboardSources)
{
dbmlObject.AddDashboardSources(i.Source, newDashboardID);
}
//dashboard Status
var resStatus = dbmlObject.RetreiveStatus(dashboardID);
foreach (var i in resStatus)
{
dbmlObject.AddDashboardStatus(i.Status, i.Color, newDashboardID);
}
var resultItems = dbmlObject.RetreiveExistingDashboardItems(dashboardID, "StartDate").ToList();
foreach (var i in resultItems)
{
var resItemID = dbmlObject.AddDataItem(i.ItemName, i.StartDate, i.EndDate, newDashboardID, i.StatusID).ToList();
int itemID = Convert.ToInt32(resItemID.FirstOrDefault().Column1);
var resTeams = dbmlObject.RetreiveTeamsWorkingOnItem(i.ItemID).ToArray();
for (var j = 0; j < resTeams.Length; j++)
{
dbmlObject.AddTeamToDashboardItem(itemID, resTeams[j].TeamID);
}
var resSources = dbmlObject.GetSourcesByItemID(i.ItemID).ToArray();
for (var j = 0; j < resSources.Length; j++)
{
dbmlObject.AddDataItemSource(itemID, resSources[j].SourceID);
}
}
dbmlObject.SubmitChanges();
return(true);
}
public List <DashboardItem> RetreiveExistingDashboardItems(string DashboardID, string sortBy)
{
List <DashboardItem> list = new List <DashboardItem>();
int DashID = Convert.ToInt32(DashboardID);
StoredProcedureDataContext dbml = new StoredProcedureDataContext();
var result = dbml.RetreiveExistingDashboardItems(DashID, sortBy).ToList();
try
{
foreach (var i in result)
{
DateTime startdatestring = i.StartDate;
DateTime endDatestring = i.EndDate;
list.Add(new DashboardItem {
ItemID = i.ItemID, DashboardID = DashID, ItemName = i.ItemName, EndDate = endDatestring, StartDate = startdatestring, WorkingTeams = RetreiveTeamsWorkingOnItem(i.ItemID)
});
}
}
catch (Exception ex) { Console.WriteLine(ex); }
return(list);
}
