public List <DashboardItem> RetreiveExistingDashboardItemsByTeamID(string DashboardID, string teamid, string sortby)
{
int DashID = Convert.ToInt32(DashboardID);
StoredProcedureDataContext dbml = new StoredProcedureDataContext();
var result = dbml.RetreiveExistingDashboardItemsSortedAndFilteredDistinctColor(DashID, sortby, teamid).ToList();
List <DashboardItem> list = new List <DashboardItem>();
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, StatusID = i.StatusID, Status = i.Status, StatusColor = i.Color, WorkingTeams = RetreiveTeamsWorkingOnItem(i.ItemID)
});
}
}
catch (Exception e) { return(null); }
return(list);
}
