public List <int> ExtractSalesReports( ) { int year = DateTime.Now.Year; EmployeeDAO employeeDAO = new EmployeeDAO(); RequestDAO requestDAO = new RequestDAO(); DepartmentDAO departmentDAO = new DepartmentDAO(); List <Department> departments = departmentDAO.GetDepartments(); List <int> monthlySales = new List <int>(); //{paper,pen,stapler} foreach (Department d in departments) { List <RequestReport> requestReports = requestDAO.GetRequestsByDepartment(d.Id); if (requestReports != null) { int[] sales = new int[3]; foreach (RequestReport request in requestReports) { if (request.ReqYear == year) //DateTime.Today.year) { if (request.CategoryID == 1) //paper { sales[0] += request.Qty; } else if (request.CategoryID == 2) //pen { sales[1] += request.Qty; } else //stapler { sales[2] += request.Qty; } } } //monthlySales.Add(DateTime.Today.Month); monthlySales.Add(sales[0]); monthlySales.Add(sales[1]); monthlySales.Add(sales[2]); } } System.Diagnostics.Debug.WriteLine(monthlySales); return(monthlySales); }