private void loadPrintData()
{
SA34_Team9_StationeryStoreInventorySystem.Reports.SSISReports.RequisitionReport RR =
new RequisitionReport();
RR.SetDataSource((DataTable)Session["PrintData"]);
PrintReportViewer.ReportSource = RR;
}
public ActionResult ShowReqReport()
{
RequisitionReport reqReport = Session["reqReport"] as RequisitionReport;
if (reqReport.CategoryList == null)
{
reqReport.CategoryList = db.Categories.Select(c => c.CategoryId).ToList();
}
if (reqReport.DepartmentList == null)
{
reqReport.DepartmentList = db.Departments.Select(d => d.DepartmentID).ToList();
}
ViewBag.report = reqReport;
reportService.GetRequisitionData(reqReport, out string[] categories, out ReportByTimeSeries[] timeDt,
public ActionResult ShowReport()
{
RequisitionReport report = Session["report"] as RequisitionReport;
if (report.CategoryList == null)
{
report.CategoryList = db.Categories.Select(c => c.CategoryId).ToList();
}
List <int> departmentList = new List <int>
{
headService.FindDepID()
};
report.DepartmentList = departmentList;
ViewBag.report = report;
reportService.GetRequisitionData(report, out string[] categories, out ReportByTimeSeries[] timeDt,
public void GetRequisitionData(RequisitionReport reqReport, out string[] categories, out ReportByTimeSeries[] timeDt,
out string[] departments, out ReportByCategory[] catDt)
{
List <int> catId = reqReport.CategoryList;
List <int> depId = reqReport.DepartmentList;
DateTime startDate = Convert.ToDateTime(reqReport.StartDate);
DateTime endDate = Convert.ToDateTime(reqReport.EndDate);
var data = db.RequisitionDetails
.Where(r => r.Requisition.RequisitionDate >= startDate &&
r.Requisition.RequisitionDate < endDate &&
catId.Contains(r.Item.CategoryID) && depId.Contains(r.Requisition.Employee.DepartmentID));
var timeSeriesData = data
.GroupBy(r => new ReportByTimeSeriesKey
{
Month = SqlFunctions.DatePart("month", r.Requisition.RequisitionDate),
Year = SqlFunctions.DateName("year", r.Requisition.RequisitionDate),
Category = r.Item.Category.CategoryName
})
.Select(r => new ReportByTimeSeries {
Key = r.Key, Quantity = r.Sum(b => b.Quantity)
}).ToList();
var catData = data
.GroupBy(r => new ReportByCategoryKey
{
Department = r.Requisition.Employee.Department.DepartmentName,
Category = r.Item.Category.CategoryName
})
.Select(r => new ReportByCategory {
Key = r.Key, Quantity = r.Sum(b => b.Quantity)
}).ToList();
//categories = db.Categories.Where(c => catId.Contains(c.CategoryId)).Select(c => c.CategoryName).Distinct().ToArray();
categories = timeSeriesData.Select(r => r.Key.Category).Distinct().ToArray();
timeDt = timeSeriesData.ToArray();
departments = catData.Select(r => r.Key.Department.ToString()).Distinct().ToArray();
catDt = catData.ToArray();
}
public ActionResult ViewReport(RequisitionReport reqReport)
{
Session["report"] = reqReport;
return(Json(true, JsonRequestBehavior.AllowGet));
}
private void loadPrintData()
{
SA34_Team9_StationeryStoreInventorySystem.Reports.SSISReports.RequisitionReport RR =
new RequisitionReport();
RR.SetDataSource((DataTable)Session["PrintData"]);
PrintReportViewer.ReportSource = RR;
}
