public async Task <ActionResult> Download(long fuid)
        {
            var vm = await BuildFullFederationViewModelAsync(fuid, TabType.AllExcludingSchoolPerf, ChartGroupType.All, UnitType.AbsoluteMoney);

            var csv = _csvBuilder.BuildCSVContentHistorically(vm, await _financialDataService.GetLatestDataYearPerEstabTypeAsync(EstablishmentType.Federation));

            return(File(Encoding.UTF8.GetBytes(csv), "text/plain", $"HistoricalData-{fuid}.csv"));
        }
Exemplo n.º 2
0
        public async Task <ActionResult> Download(long urn)
        {
            await _schoolVMBuilder.BuildCoreAsync(urn);

            _schoolVMBuilder.SetTab(TabType.AllIncludingSchoolPerf);
            await _schoolVMBuilder.AddHistoricalChartsAsync(TabType.AllIncludingSchoolPerf, ChartGroupType.All, CentralFinancingType.Include, UnitType.AbsoluteMoney);

            _schoolVMBuilder.SetChartGroups(TabType.AllIncludingSchoolPerf);
            var schoolVM = _schoolVMBuilder.GetResult();

            var csv = _csvBuilder.BuildCSVContentHistorically(schoolVM, await _financialDataService.GetLatestDataYearPerEstabTypeAsync(schoolVM.EstablishmentType));

            return(File(Encoding.UTF8.GetBytes(csv), "text/plain", $"HistoricalData-{urn}.csv"));
        }
        public async Task <ActionResult> Download(int companyNo, string name)
        {
            var latestYear = await _financialDataService.GetLatestDataYearPerEstabTypeAsync(EstablishmentType.MAT);

            var trustVM = await BuildFinancialTrustVMAsync(companyNo, TabType.AllExcludingSchoolPerf, ChartGroupType.All, MatFinancingType.TrustOnly);

            var termsList = await _financialDataService.GetActiveTermsForMatCentralAsync();

            _fcService.PopulateHistoricalChartsWithFinancialData(trustVM.HistoricalCharts, trustVM.HistoricalFinancialDataModels, termsList.First(), TabType.AllExcludingSchoolPerf, UnitType.AbsoluteMoney, EstablishmentType.MAT);

            string csv = _csvBuilder.BuildCSVContentHistorically(trustVM, latestYear);

            return(File(Encoding.UTF8.GetBytes(csv),
                        "text/plain",
                        $"HistoricalData-{name}.csv"));
        }
        public async Task <ActionResult> Download(int urn)
        {
            var schoolDetailsFromEdubase = _contextDataService.GetSchoolByUrn(urn.ToString());

            SchoolViewModel schoolVM = await BuildSchoolVMAsync(RevenueGroupType.AllIncludingSchoolPerf, ChartGroupType.All, CentralFinancingType.Include, schoolDetailsFromEdubase);

            var termsList = BuildTermsList(schoolVM.FinancialType);

            _fcService.PopulateHistoricalChartsWithSchoolData(schoolVM.HistoricalCharts, schoolVM.HistoricalSchoolFinancialDataModels, termsList.First(), RevenueGroupType.AllExcludingSchoolPerf, UnitType.AbsoluteMoney, schoolVM.FinancialType);

            var latestYear = _financialDataService.GetLatestDataYearPerSchoolType(schoolVM.FinancialType);

            var csv = _csvBuilder.BuildCSVContentHistorically(schoolVM, latestYear);

            return(File(Encoding.UTF8.GetBytes(csv),
                        "text/plain",
                        $"HistoricalData-{urn}.csv"));
        }
        public async Task <ActionResult> Download(string matNo, string name)
        {
            var latestYear = _financialDataService.GetLatestDataYearForTrusts();
            var term       = FormatHelpers.FinancialTermFormatAcademies(latestYear);

            var response = _financialDataService.GetAcademiesByMatNumber(term, matNo);

            var sponsorVM = await BuildSponsorVMAsync(matNo, name, response, RevenueGroupType.AllExcludingSchoolPerf, ChartGroupType.All, MatFinancingType.TrustOnly);

            var termsList = _financialDataService.GetActiveTermsForMatCentral();

            _fcService.PopulateHistoricalChartsWithSchoolData(sponsorVM.HistoricalCharts, sponsorVM.HistoricalSchoolFinancialDataModels, termsList.First(), RevenueGroupType.AllExcludingSchoolPerf, UnitType.AbsoluteMoney, SchoolFinancialType.Academies);

            string csv = _csvBuilder.BuildCSVContentHistorically(sponsorVM, latestYear);

            return(File(Encoding.UTF8.GetBytes(csv),
                        "text/plain",
                        $"HistoricalData-{name}.csv"));
        }