Exemplo n.º 1
0
        /// <summary>
        /// Fill Summary Report Bridge Data tab.
        /// </summary>
        /// <param name="worksheet"></param>
        /// <param name="simulationModel"></param>
        /// <param name="simulationYears"></param>
        /// <param name="dbContext"></param>
        /// <returns>WorkSummaryModel with simulation and bridge data models</returns>
        internal WorkSummaryModel Fill(ExcelWorksheet worksheet, SimulationModel simulationModel, List <int> simulationYears, BridgeCareContext dbContext)
        {
            var BRKeys = new List <int>();

            var sections                      = bridgeData.GetSectionData(simulationModel, dbContext);
            var treatments                    = bridgeData.GetTreatments(simulationModel.simulationId, dbContext);
            var simulationDataTable           = bridgeData.GetSimulationData(simulationModel, dbContext, simulationYears);
            var projectCostModels             = bridgeData.GetReportData(simulationModel, dbContext, simulationYears);
            var sectionIdsFromSimulationTable = from dt in simulationDataTable.AsEnumerable()
                                                select dt.Field <int>("SECTIONID");

            var sectionsForSummaryReport = sections.Where(sm => sectionIdsFromSimulationTable.Contains(sm.SECTIONID)).ToList();

            BRKeys = sectionsForSummaryReport.Select(sm => Convert.ToInt32(sm.FACILITY)).ToList();
            var bridgeDataModels = bridgeData.GetBridgeData(BRKeys, simulationModel, dbContext, parametersModel);
            var budgetsPerBrKey  = bridgeData.GetBudgetsPerBRKey(simulationModel, dbContext);

            var simulationDataModels    = bridgeDataHelper.GetSimulationDataModels(simulationDataTable, simulationYears, projectCostModels, budgetsPerBrKey);
            var unfundedRecommendations = bridgeData.GetUnfundedRcommendations(simulationModel, dbContext);

            unfundedRecommendations.ForEach(_ => {
                _.TotalProjectCost = Convert.ToDouble(_.Budget_Hash.Split('/')[1]);
            });

            // Add data to excel.
            var headers     = GetHeaders();
            var currentCell = AddHeadersCells(worksheet, headers, simulationYears);

            // Add row next to headers for filters and year numbers for dynamic data. Cover from top, left to right, and bottom set of data.
            using (ExcelRange autoFilterCells = worksheet.Cells[3, 1, currentCell.Row, currentCell.Column - 1])
            {
                autoFilterCells.AutoFilter = true;
            }

            var columnForRiskScore = AddBridgeDataModelsCells(worksheet, bridgeDataModels, currentCell);

            AddDynamicDataCells(worksheet, sectionsForSummaryReport, simulationDataModels, bridgeDataModels, currentCell, columnForRiskScore);
            // TODO The line below currently hangs Postman in testing. It will be required for final production.
            // ExcelHelper.ApplyBorder(worksheet.Cells[1, 1, currentCell.Row, currentCell.Column]);
            worksheet.Cells.AutoFitColumns();
            var spacerBeforeFirstYear = SpacerColumnNumbers[0] - 11;

            worksheet.Column(spacerBeforeFirstYear).Width = 3;
            foreach (var spacerNumber in SpacerColumnNumbers)
            {
                worksheet.Column(spacerNumber).Width = 3;
            }
            var lastColumn = worksheet.Dimension.Columns + 1;

            worksheet.Column(lastColumn).Width = 3;
            var workSummaryModel = new WorkSummaryModel {
                SimulationDataModels = simulationDataModels, BridgeDataModels = bridgeDataModels,
                Treatments           = treatments, BudgetsPerBRKeys = budgetsPerBrKey, UnfundedRecommendations = unfundedRecommendations,
                ParametersModel      = parametersModel
            };

            return(workSummaryModel);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Fill Summary Report Bridge Data tab.
        /// </summary>
        /// <param name="worksheet"></param>
        /// <param name="simulationModel"></param>
        /// <param name="simulationYears"></param>
        /// <param name="dbContext"></param>
        /// <returns>WorkSummaryModel with simulation and bridge data models</returns>
        public WorkSummaryModel Fill(ExcelWorksheet worksheet, SimulationModel simulationModel, List <int> simulationYears, BridgeCareContext dbContext)
        {
            var BRKeys = new List <int>();

            var sections                      = bridgeData.GetSectionData(simulationModel, dbContext);
            var simulationDataTable           = bridgeData.GetSimulationData(simulationModel, dbContext, simulationYears);
            var projectCostModels             = bridgeData.GetReportData(simulationModel, dbContext, simulationYears);
            var sectionIdsFromSimulationTable = from dt in simulationDataTable.AsEnumerable()
                                                select dt.Field <int>("SECTIONID");

            var sectionsForSummaryReport = sections.Where(sm => sectionIdsFromSimulationTable.Contains(sm.SECTIONID)).ToList();

            BRKeys = sectionsForSummaryReport.Select(sm => Convert.ToInt32(sm.FACILITY)).ToList();
            var bridgeDataModels = bridgeData.GetBridgeData(BRKeys, dbContext);

            var simulationDataModels = bridgeDataHelper.GetSimulationDataModels(simulationDataTable, simulationYears, projectCostModels);

            // Add data to excel.
            var headers     = GetHeaders();
            var currentCell = AddHeadersCells(worksheet, headers, simulationYears);

            // Add row next to headers for filters and year numbers for dynamic data. Cover from top, left to right, and bottom set of data.
            using (ExcelRange autoFilterCells = worksheet.Cells[3, 1, currentCell.Row, currentCell.Column - 1])
            {
                autoFilterCells.AutoFilter = true;
            }

            AddBridgeDataModelsCells(worksheet, bridgeDataModels, currentCell);
            AddDynamicDataCells(worksheet, sectionsForSummaryReport, simulationDataModels, bridgeDataModels, currentCell);
            // TODO The line below currently hangs Postman in testing. It will be required for final production.
            // ExcelHelper.ApplyBorder(worksheet.Cells[1, 1, currentCell.Row, currentCell.Column]);
            worksheet.Cells.AutoFitColumns();

            var workSummaryModel = new WorkSummaryModel {
                SimulationDataModels = simulationDataModels, BridgeDataModels = bridgeDataModels
            };

            return(workSummaryModel);
        }