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) }); } }