private void FillNonNHSBridgeCountPercentSection(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, int dataStartRow, ChartRowsModel chartRowsModel) { bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Non-NHS Bridge Count Percentage", true); chartRowsModel.NonNHSBridgeCountPercentSectionYearsRow = currentCell.Row; AddDetailsForNonNHSPercentSection(worksheet, currentCell, simulationYears, dataStartRow); }
/// <summary> /// Fill work summary bridge poor on off rate and deck area sections /// </summary> /// <param name="worksheet"></param> /// <param name="currentCell"></param> /// <param name="simulationYears"></param> /// <param name="simulationDataModels"></param> /// <returns>ChartRowsModel object for usage in other tab reports.</returns> public ChartRowsModel FillBridgeRateDeckAreaWorkSummarySections(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels) { var chartRowsModel = new ChartRowsModel(); FillPoorBridgeOnOffRateSection(worksheet, currentCell, simulationYears, simulationDataModels); chartRowsModel.TotalPoorBridgesCountSectionYearsRow = FillTotalPoorBridgesCountSection(worksheet, currentCell, simulationYears, simulationDataModels); chartRowsModel.TotalPoorBridgesDeckAreaSectionYearsRow = FillTotalPoorBridgesDeckAreaSection(worksheet, currentCell, simulationYears, simulationDataModels); chartRowsModel.TotalBridgeCountSectionYearsRow = FillTotalBridgeCountSection(worksheet, currentCell, simulationYears, simulationDataModels); chartRowsModel.TotalDeckAreaSectionYearsRow = FillTotalDeckAreaSection(worksheet, currentCell, simulationYears, simulationDataModels); return(chartRowsModel); }
internal ChartRowsModel FillPoorDeckArea(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels, List <BridgeDataModel> bridgeDataModels, ChartRowsModel chartRowsModel) { //excelHelper.ApplyColor(worksheet.Cells[currentCell.Row, 1, currentCell.Row, worksheet.Dimension.Columns], Color.LightGray); bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Poor Deck Area", true); chartRowsModel.TotalPoorDeckAreaByBPNSectionYearsRow = currentCell.Row; AddDetailsForPoorDeckArea(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels); return(chartRowsModel); }
internal ChartRowsModel FillMoneyNeededByBPN(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels, List <BridgeDataModel> bridgeDataModels, ChartRowsModel chartRowsModel) { //excelHelper.ApplyColor(worksheet.Cells[currentCell.Row, 1, currentCell.Row, worksheet.Dimension.Columns], Color.LightGray); bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Dollar Needs By BPN", false); chartRowsModel.TotalCashNeededByBPNYearsRow = currentCell.Row; AddDetailsForMoneyNeededByBPN(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels); return(chartRowsModel); }
/// <summary> /// Fill NHS sections. /// </summary> /// <param name="worksheet"></param> /// <param name="currentCell"></param> /// <param name="simulationYears"></param> /// <param name="simulationDataModels"></param> /// <param name="bridgeDataModels"></param> /// <param name="chartRowsModel"></param> public void FillNHSBridgeDeckAreaWorkSummarySections(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels, List <BridgeDataModel> bridgeDataModels, ChartRowsModel chartRowsModel) { var dataStartRow = FillNHSBridgeCountSection(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels); FillNHSBridgeCountPercentSection(worksheet, currentCell, simulationYears, dataStartRow, chartRowsModel); dataStartRow = FillNHSBridgeDeckAreaSection(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels); FillNHSBridgeDeckAreaPercentSection(worksheet, currentCell, simulationYears, dataStartRow, chartRowsModel); }
private int FillNonNHSBridgeCountSection(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, int totalBridgeCountSectionStartRow, int nHSBridgeCountSectionStartRow, ChartRowsModel chartRowsModel) { bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Non-NHS Bridge Count", true); var dataStartRow = currentCell.Row + 1; AddDetailsForNonNHSCountAndArea(worksheet, currentCell, simulationYears, totalBridgeCountSectionStartRow, nHSBridgeCountSectionStartRow, false); return(dataStartRow); }