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;
}