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