private ApprenticeshipApplicationMetrics GetApprenticeshipApplicationMetrics() { var averageApplicationCountPerApprenticeship = _apprenticeshipMetricsRepository.GetAverageApplicationCountPerApprenticeship(); var apprenticeshipApplicationMetrics = new ApprenticeshipApplicationMetrics { ApprenticeshipsWithApplicationsCount = averageApplicationCountPerApprenticeship["apprenticeshipsWithApplicationsCount"].AsInt32, TotalApplicationsCount = averageApplicationCountPerApprenticeship["count"].AsInt32, AverageApplicationsPerApprenticeship = averageApplicationCountPerApprenticeship["average"].AsDouble }; var applicationCountPerApprenticeship = _apprenticeshipMetricsRepository.GetApplicationCountPerApprenticeship(); foreach (var applicationCount in applicationCountPerApprenticeship) { var vacancyId = applicationCount["_id"]["VacancyId"].AsInt32; var title = applicationCount["_id"]["Title"].AsString; var count = applicationCount["count"].AsInt32; var apprenticeshipMetrics = new ApprenticeshipMetrics { Id = vacancyId, Title = title, ApplicationCount = count }; apprenticeshipApplicationMetrics.ApprenticeshipMetrics[vacancyId] = apprenticeshipMetrics; } return(apprenticeshipApplicationMetrics); }
private static void WriteApprenticeshipApplicationMetricsCsv(ApprenticeshipApplicationMetrics userApplicationMetrics, DateTime fileDateTime) { var fileName = string.Format("ApprenticeshipApplicationMetrics_{0}.csv", fileDateTime.ToString("s").Replace(":", "-")); var textWriter = new StreamWriter(fileName); var csv = new CsvWriter(textWriter); csv.WriteRecords(userApplicationMetrics.ApprenticeshipMetrics.Values); textWriter.Flush(); textWriter.Close(); }