internal void Fill(ExcelWorksheet worksheet, SimulationModel simulationModel, int simulationYearsCount, ParametersModel parametersModel) { var simulationId = simulationModel.simulationId; var investmentPeriod = analysisData.GetAnySimulationAnalysis(simulationId, db); var inflationAndInvestments = getInflationRate.GetAnySimulationInvestmentLibrary(simulationId, db); var priorities = getPriorities.GetAnySimulationPriorityLibrary(simulationId, db).Priorities; var criterias = budgetCriteria.GetAnyCriteriaDrivenBudgets(simulationId, db); // Simulation Name format excelHelper.MergeCells(worksheet, 1, 1, 1, 2); excelHelper.MergeCells(worksheet, 1, 3, 1, 10); excelHelper.ApplyColor(worksheet.Cells[1, 1, 1, 2], Color.Gray); worksheet.Cells["A1:B1"].Value = "Simulation Name"; worksheet.Cells["C1:J1"].Value = simulationModel.simulationName; excelHelper.ApplyColor(worksheet.Cells[1, 3, 1, 10], Color.FromArgb(142, 169, 219)); excelHelper.ApplyBorder(worksheet.Cells[1, 1, 1, 10]); // End of Simulation Name format FillData(worksheet, parametersModel); FillSimulationDetails(worksheet, investmentPeriod, inflationAndInvestments.InflationRate, simulationYearsCount); FillAnalysisDetails(worksheet, investmentPeriod); FillJurisdictionCriteria(worksheet, investmentPeriod.Criteria); FillPriorities(worksheet, priorities); FillInvestmentAndBudgetCriteria(worksheet, inflationAndInvestments, criterias); worksheet.Cells.AutoFitColumns(50); }
/// <summary> /// Creates a mapping from user roles to the appropriate methods for getting priority libraries /// </summary> private Dictionary <string, PriorityLibraryGetMethod> CreateGetMethods() { PriorityLibraryModel GetAnyLibrary(int id, UserInformationModel userInformation) => repo.GetAnySimulationPriorityLibrary(id, db); PriorityLibraryModel GetPermittedLibrary(int id, UserInformationModel userInformation) => repo.GetPermittedSimulationPriorityLibrary(id, db, userInformation.Name); return(new Dictionary <string, PriorityLibraryGetMethod> { [Role.ADMINISTRATOR] = GetAnyLibrary, [Role.DISTRICT_ENGINEER] = GetPermittedLibrary, [Role.CWOPA] = GetAnyLibrary, [Role.PLANNING_PARTNER] = GetPermittedLibrary }); }