// // GET: /Home/ public ActionResult Index() { try { DateTime date = DateTime.Today.AddDays(7); DateTime date2 = DateTime.Now.AddMonths(-1); IEnumerable<appointment> appointments = db.appointments.Where(i => i.employeeid == User.Identity.Name && i.starttime >= DateTime.Today && i.starttime <= date); IEnumerable<issue> issues = db.issues.Where(i => i.date <= date2 && i.status != "Complete"); List<Events> Events = new List<Events>(); foreach (appointment appointment in appointments) { Events Event = new Events(); Event.id = appointment.appointmentid; Event.title = appointment.subject; Event.allDay = appointment.allday; Event.start = ConvertToUnixTimestamp(appointment.starttime).ToString(); Event.end = ConvertToUnixTimestamp(appointment.endtime).ToString(); Event.url = Url.Action("Details/" + appointment.appointmentid.ToString()); switch (appointment.appointmenttype.Trim()) { case "Personal": Event.color = "#009B00"; break; case "Advisement": Event.color = "#36C"; break; case "Office": Event.color = "#800080"; break; } Events.Add(Event); } List<IssuesPOCO> _issues = new List<IssuesPOCO>(); foreach (issue i in issues.OrderByDescending(e => e.date)) { IssuesPOCO temp = new IssuesPOCO(); temp.IssueID = i.issueid; temp.Name = i.issuename; temp.Date = ConvertToUnixTimestamp(i.date).ToString(); temp.Status = i.status; temp.Urgency = i.urgency; _issues.Add(temp); } IndexHomeModel model = new IndexHomeModel() { _Events = Events, _Issues = _issues }; return View(model); } catch (Exception ex) { return View(); } }
// // GET: /Student/Details/5 /// <summary> /// Grabs the object by ID and pushes the required objects in the Model (These are the worse comments I know but Im to tired) /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Details(string id) { try { if (id != null) { IEnumerable<issue> _issue = db.issues.Include("student").Where(i => i.studentid == id); student student = db.students.Include("program").Single(s => s.studentid == id); List<IssuesPOCO> issue = new List<IssuesPOCO>(); foreach (issue i in _issue.OrderByDescending(e => e.date)) { IssuesPOCO temp = new IssuesPOCO(); temp.IssueID = i.issueid; temp.Name = i.issuename; temp.Date = ConvertToUnixTimestamp(i.date).ToString(); temp.Status = i.status; temp.Urgency = i.urgency; issue.Add(temp); } DetailsStudentRequestModel details = new DetailsStudentRequestModel() { _student = student, _issue = issue.OrderByDescending(i => i.Status) }; return View(details); } else { return RedirectToAction("Index", "Student"); } } catch (InvalidOperationException) { return RedirectToAction("Index", "Student"); } }
public ActionResult Index(IndexIssueRequestModel Model) { try { if (ModelState.IsValid) { var issues = db.issues.Include("student"); var program = db.programs; var employee = db.employees; List<String> employees = new List<String>(); employees.Add("Any"); foreach (employee emp in employee) { employees.Add(emp.employeeid.Trim() + " - " + emp.fname.Trim() + " " + emp.lname.Trim()); } List<catagory> catagories = new List<catagory>(); catagory cat = new catagory() { catagory1 = "Any" }; catagories.Add(cat); catagories.AddRange(db.catagories); List<String> collection = new List<String>(); collection.Add("Any"); foreach (program prog in program) { collection.Add(prog.programcode.ToString().Trim() + " - " + prog.programname.ToString().Trim()); } IEnumerable<issue> _issues = issues; if (Model._name != null) _issues = _issues.Where(i => i.issuename.Trim().ToUpper().Contains(Model._name.Trim().ToUpper())); if (Model._employeeid != "Any") { StringBuilder sb = new StringBuilder(Model._employeeid.Trim().ToUpper()); sb.Remove(9, sb.Length - 9); _issues = _issues.Where(i => i.employeeid.Trim().ToUpper().Contains(sb.ToString())); } if (Model._status != "Any") _issues = _issues.Where(i => i.status.Trim().ToUpper().Contains(Model._status.Trim().ToUpper())); if (Model._urgency != "Any") _issues = _issues.Where(i => i.urgency.Trim().ToUpper().Contains(Model._urgency.Trim().ToUpper())); if (Model._category != "Any") _issues = _issues.Where(i => i.catagory.Trim().ToUpper().Contains(Model._category.Trim().ToUpper())); if (Model._selectedpcode != "Any") { StringBuilder sb = new StringBuilder(Model._selectedpcode.Trim().ToUpper()); sb.Remove(5, sb.Length - 5); _issues = _issues.Where(i => i.student.programcode.Trim().ToUpper().Contains(sb.ToString())); } if ((Model._date1 != null) && (Model._date2 != null)) { if (Model._date1 > Model._date2) { _issues = _issues.Where(i => i.date >= Model._date2 && i.date <= Model._date1); } else if (Model._date2 > Model._date1) { _issues = _issues.Where(i => i.date <= Model._date2 && i.date >= Model._date1); } else { _issues = _issues.Where(i => i.date == Model._date1); } } List<IssuesPOCO> _issue = new List<IssuesPOCO>(); foreach (issue i in _issues.OrderByDescending(e => e.date)) { IssuesPOCO temp = new IssuesPOCO(); temp.IssueID = i.issueid; temp.Name = i.issuename; temp.Date = ConvertToUnixTimestamp(i.date).ToString(); temp.Status = i.status; temp.Urgency = i.urgency; _issue.Add(temp); } Model._issue = _issue; Model._employee = employees; Model._catagories = catagories; Model._programcode = collection; return View(Model); } return View(Model); } catch (Exception ex) { return View(Model); } }
// // GET: /Issue/ /// <summary> /// Ensures tha field have the proper information /// </summary> /// <returns></returns> public ViewResult Index() { try { var issues = db.issues.Include("student"); List<IssuesPOCO> _issues = new List<IssuesPOCO>(); foreach (issue i in issues.OrderByDescending(e => e.date)) { IssuesPOCO temp = new IssuesPOCO(); temp.IssueID = i.issueid; temp.Name = i.issuename; temp.Date = ConvertToUnixTimestamp(i.date).ToString(); temp.Status = i.status; temp.Urgency = i.urgency; _issues.Add(temp); } var program = db.programs; var employee = db.employees; List<String> employees = new List<String>(); employees.Add("Any"); foreach (employee emp in employee) { employees.Add(emp.employeeid.Trim() + " - " + emp.fname.Trim() + " " + emp.lname.Trim()); } List<catagory> catagories = new List<catagory>(); catagory cat = new catagory() { catagory1 = "Any" }; catagories.Add(cat); catagories.AddRange(db.catagories); List<String> collection = new List<String>(); collection.Add("Any"); foreach (program prog in program) { collection.Add(prog.programcode.ToString().Trim() + " - " + prog.programname.ToString().Trim()); } IndexIssueRequestModel Model = new IndexIssueRequestModel() { _issue = _issues.OrderByDescending(i => i.Status), _employee = employees, _catagories = catagories, _date1 = issues.OrderByDescending(i => i.date).First().date, _date2 = issues.OrderBy(i => i.date).First().date, _programcode = collection }; return View(Model); } catch (Exception ex) { return View(); } }