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