private void GetMonthlyReportData(int year, IList <MonthlyReportData> onlineList, IList <MonthlyReportData> inHouseList)
{
var monthlyRunsCount = _dataSheetService.GetMonthlyRunsCount(year);
var monthlyConsultations = _dataSheetService.GetMonthlyConsultationReport(year);
var monthlyNewUsers = _dataSheetService.GetMonthlyNewUserReport(year);
foreach (var month in MonthYearHelper.GetMonths())
{
//inhouse
inHouseList.Add(new MonthlyReportData
{
Month = month.Item1,
MonthName = month.Item2,
Inhouse = Common.Constants.Constants.INHOUSE,
NoOfRuns = GetMonthlyRunsCount(monthlyRunsCount, month.Item1, Common.Constants.Constants.INHOUSE),
ConsultationACT = GetMonthlyConsultationACTCount(monthlyConsultations, month.Item1, Common.Constants.Constants.INHOUSE),
NUACT = GetMonthlyNewUserCount(monthlyNewUsers, month.Item1, Common.Constants.Constants.INHOUSE)
});
//online
onlineList.Add(new MonthlyReportData
{
Month = month.Item1,
MonthName = month.Item2,
Inhouse = Common.Constants.Constants.INHOUSE,
NoOfRuns = GetMonthlyRunsCount(monthlyRunsCount, month.Item1, Common.Constants.Constants.ONLINE),
ConsultationACT = GetMonthlyConsultationACTCount(monthlyConsultations, month.Item1, Common.Constants.Constants.ONLINE),
NUACT = GetMonthlyNewUserCount(monthlyNewUsers, month.Item1, Common.Constants.Constants.ONLINE)
});
}
}