public TransferBundle GetInScopeTransferBundle(string apbnKey)
{
var region = GetRegion("0");
var result = new TransferBundle
{
Region = region,
};
var scopedRegionIds = db.Regions.Where(r => r.IsInScope).Select(r => r.Id).ToList();
result.TransferRecapitulations = db.TransferRecapitulations
.Where(r => r.ApbnKey == apbnKey && (scopedRegionIds.Contains(r.RegionId)))
.ToList();
var total = new TransferRecapitulation
{
ApbnKey = apbnKey,
RegionId = "0",
RegionName = region.Name
};
foreach (var recap in result.TransferRecapitulations)
{
total.BudgetedDd += recap.BudgetedDd;
total.BudgetedAdd += recap.BudgetedAdd;
total.BudgetedBhpr += recap.BudgetedBhpr;
}
result.TransferRecapitulations.Add(total);
result.TransferProgress = db.TransferProgresses
.Where(r => r.ApbnKey == apbnKey && (scopedRegionIds.Contains(r.RegionId)))
.ToList();
result.TransferRecapitulations.Add(total);
return(result);
}
public TransferBundle GetInScopeTransferBundle(string apbnKey)
{
var region = GetRegion("0");
var result = new TransferBundle
{
Region = region,
};
var scopedRegionIds = db.Regions.Where(r => r.IsInScope).Select(r => r.Id).ToList();
result.TransferRecapitulations = db.TransferRecapitulations
.Where(r => r.ApbnKey == apbnKey && (scopedRegionIds.Contains(r.RegionId)))
.ToList();
var total = new TransferRecapitulation
{
ApbnKey = apbnKey,
RegionId = "0",
RegionName = region.Name
};
foreach(var recap in result.TransferRecapitulations)
{
total.BudgetedDd += recap.BudgetedDd;
total.BudgetedAdd += recap.BudgetedAdd;
total.BudgetedBhpr += recap.BudgetedBhpr;
}
result.TransferRecapitulations.Add(total);
result.TransferProgress = db.TransferProgresses
.Where(r => r.ApbnKey == apbnKey && (scopedRegionIds.Contains(r.fkRegionId)))
.ToList();
result.TransferRecapitulations.Add(total);
return result;
}
