public ActionResult DoReport() { HardwareVM vm = new HardwareVM(); vm.Employees = GetEmployees(0); //Default Values vm.DateFrom = new DateTime(2019, 1, 1); vm.DateTo = new DateTime(2019, 1, 31); return(View(vm)); }
public ActionResult DoReport(HardwareVM vm) { using (HardwareDBEntities db = new HardwareDBEntities()) { db.Configuration.ProxyCreationEnabled = false; vm.Employees = GetEmployees(vm.SelectedEmployeeID); vm.employee = db.lgemployees.Where(x => x.emp_num == vm.SelectedEmployeeID).FirstOrDefault(); var list = db.lginvoices.Where(r => r.employee_id == vm.employee.emp_num && r.inv_DATETIME >= vm.DateFrom && r.inv_DATETIME <= vm.DateTo).ToList().Select(p => new ReportRecord { //OrderDate = p.inv_DATETIME.ToString("dd-MMM-yyyy"), Total = Convert.ToDouble(p.inv_total), Employee = db.lgemployees.Where(r => r.emp_num == p.employee_id).Select(x => x.emp_fname + "" + x.emp_lname).FirstOrDefault(), }); } //vm.chartData = list.GroupBy(g => g.Employee).ToDictionary(g => g.Key, g => g.Sum(v => v.Total)); TempData["chartData"] = vm.chartData; //TempData["records"] = list.ToList(); TempData["vendor"] = vm.employee; return(View(vm)); }