public ContentResult TreatmentSiteTable()
{
var waterQualityManagementPlanNodes = NereidUtilities.GetWaterQualityManagementPlanNodes(HttpRequestStorage.DatabaseEntities);
var list = HttpRequestStorage.DatabaseEntities.WaterQualityManagementPlans
.SelectMany(x => x.QuickBMPs.Where(y => y.TreatmentBMPType.IsAnalyzedInModelingModule)).Join(
waterQualityManagementPlanNodes, x => x.WaterQualityManagementPlanID,
x => x.WaterQualityManagementPlanID, (bmp, node) => new { bmp, node }).ToList();
var treatmentSites = list.Select(x =>
new TreatmentSite
{
NodeID = NereidUtilities.WaterQualityManagementPlanTreatmentNodeID(x.node.WaterQualityManagementPlanID,
x.node.RegionalSubbasinID),
AreaPercentage = x.bmp.PercentOfSiteTreated,
CapturedPercentage = x.bmp.PercentCaptured,
RetainedPercentage = x.bmp.PercentRetained,
FacilityType = x.bmp.TreatmentBMPType.TreatmentBMPModelingType.TreatmentBMPModelingTypeName
}).ToList();
var treatmentSiteTable = new TreatmentSiteTable()
{
TreatmentSites = treatmentSites
};
return(Content(JsonConvert.SerializeObject(treatmentSiteTable), "application/json"));
}