private string GetCategories() { var categories = ""; using (var db = new PMToolsContext()) { var projects = db.Projects.Where(x => x.LastActivityDate != null && x.StartDate != null); foreach (var project in projects) { categories += "'" + project.Name + "',"; } categories = categories.Remove(categories.Length - 1, 1); // chop off last comma. } return categories; }
public ActionResult StoryBreakdown() { List<Object> drilldownData = new List<object>(); using (var db = new PMToolsContext()) { var projects = db.Projects.Where(x => x.LastActivityDate != null && x.StartDate != null); foreach (var project in projects) { var stories = db.Stories.Where(s => s.Project.Id == project.Id); var data = new { name = project.Name, y = stories.Count(), drilldown = new { name = project.Name, data = new[] { new { name = "Accepted", y = stories.Where(s => s.AcceptedAtDate.HasValue).Count(), color = "#458B00" }, new { name = "Not Accepted", y = stories.Where(s => !s.AcceptedAtDate.HasValue).Count(), color = "#FCDC3B" } } } }; drilldownData.Add(data); } } var vm = new StoryBreakdownVM(); vm.dataStories = JsonConvert.SerializeObject(drilldownData); return View(vm); }
private string GetData() { var data = ""; using (var db = new PMToolsContext()) { var projects = db.Projects.Where(x => x.LastActivityDate != null && x.StartDate != null); foreach (var project in projects) { string dataPointFormat = "[Date.UTC({0}, {1}, {2}), Date.UTC({3}, {4}, {5})],"; var dataPoint = string.Format( dataPointFormat, project.StartDate.Value.Year, project.StartDate.Value.Month, project.StartDate.Value.Day, project.LastActivityDate.Value.Year, project.LastActivityDate.Value.Month, project.LastActivityDate.Value.Day); data += dataPoint; } data = data.Remove(data.Length - 1, 1); // chop off last comma. } return data; }