public ActionResult AdvisorIssueReport(AdvisorReportModel model) { try { employee employee = db.employees.Single(emp => emp.employeeid == User.Identity.Name); IEnumerable<employee> employees = db.employees.Where(emp => emp.role == "Student Advisor"); List<AutoCompletePOCO> EmployeeID = new List<AutoCompletePOCO>(); foreach (employee emp in employees) { AutoCompletePOCO poco = new AutoCompletePOCO() { value = emp.fname + " " + emp.lname + " (" + emp.employeeid + ")", Label = emp.fname + " " + emp.lname + " (" + emp.employeeid + ")", Email = emp.email, Role = emp.role }; EmployeeID.Add(poco); } model.Employee = model.EmpID.Remove(0, model.EmpID.Length - 10); model.Employee = model.Employee.Remove(model.Employee.Length - 1); model.EmployeeID = EmployeeID; model.User = employee.fname + " " + employee.lname + " (" + employee.employeeid + ")"; return View(model); } catch (Exception ex) { return View(model); } }
// // GET: /Reports/StudentIssueReport public ActionResult AdvisorIssueReport() { try { employee employee = db.employees.Single(emp => emp.employeeid == User.Identity.Name); IEnumerable<employee> employees = db.employees.Where(emp => emp.role == "Student Advisor"); List<AutoCompletePOCO> EmployeeID = new List<AutoCompletePOCO>(); foreach (employee emp in employees) { AutoCompletePOCO poco = new AutoCompletePOCO() { value = emp.fname + " " + emp.lname + " (" + emp.employeeid + ")", Label = emp.fname + " " + emp.lname + " (" + emp.employeeid + ")", Email = emp.email, Role = emp.role }; EmployeeID.Add(poco); } AdvisorReportModel model = new AdvisorReportModel() { EmpID = employee.fname + " " + employee.lname + " (" + employee.employeeid + ")", Employee = employee.employeeid, EmployeeID = EmployeeID, startDate = db.issues.OrderBy(i => i.date).First().date, endDate = db.issues.OrderByDescending(i => i.date).First().date, User = employee.fname + " " + employee.lname + " (" + employee.employeeid + ")" }; return View(model); } catch (Exception ex) { return View(); } }