private void LoadPeriodGraphData(PMIOperation pmiOperation, string operationNumber)
{
//render second graphic
var rawData = _clientPMIDetails
.GetValuePerformance(0, operationNumber, pmiOperation)
.OrderBy(c => c.Year);
var transformed = new
{
Actual = rawData.Select(c => new object[]
{
c.Year, c.Actual == -1 ? null : (decimal?)c.Actual
}),
Planned = rawData.Select(c => new object[]
{
c.Year, c.Planned == -1 ? null : (decimal?)c.Planned
}),
Earned = rawData.Select(c => new object[]
{
c.Year, c.Earned == -1 ? null : (decimal?)c.Earned
}),
AnnualPlanned = rawData.Select(c => new object[]
{
c.Year, c.AnnualPlanned == -1 ? null : (decimal?)c.AnnualPlanned
}),
AnnualEarned = rawData.Select(c => new object[]
{
c.Year, c.AnnualEarned == -1 ? null : (decimal?)c.AnnualEarned
}),
Raw = rawData,
Years = rawData.Select(c => c.Year).Distinct().OrderBy(c => c)
};
ViewBag.PeriodGraphData = transformed;
}
