// GET: Audits public ActionResult Index(int?id) { var audits = from s in db.Audits select s; if (id != null) { audits = audits.Where(audit => audit.ProjectId == id); } ViewBag.IsCreateEnable = AccessUtility.IsCreateEnable(db, User.Identity.Name); return(View(audits.Include(a => a.Project).ToList())); }
// GET: Projects public ActionResult Index(string sortOrder, string searchString) { ViewBag.NameSortParm = string.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; var projects = from s in db.Projects select s; if (!string.IsNullOrEmpty(searchString)) { projects = projects.Where(s => s.Name.Contains(searchString)); } var audits = from s in db.Audits select s; var projectView = HelperForProject.CreateProjectView(projects.ToList(), audits.ToList()); switch (sortOrder) { case "name_desc": projectView = projectView.OrderByDescending(s => s.Project.Name); break; //case "Date": // projects = projects.OrderBy(s => s.PlannedDate); // break; //case "date_desc": // projects = projects.OrderByDescending(s => s.PlannedDate); // break; default: projectView = projectView.OrderBy(s => s.Project.Name); break; } ViewBag.IsCreateEnable = AccessUtility.IsCreateEnable(db, User.Identity.Name); return(View(projectView.ToList())); }