public ActionResult Test(string sortOrder, string StudentCode, string FullName, int?DepartmentID, int?PageCurrent) { TaviStudentDemoDb db = new TaviStudentDemoDb(); var students = db.Students.AsQueryable(); int pageNumber = PageCurrent ?? 1; if (string.IsNullOrEmpty(sortOrder) || sortOrder.Equals("name_desc")) { ViewBag.NameSortParm = "name_asc"; } else { ViewBag.NameSortParm = "name_desc"; } switch (sortOrder) { case "name_asc": students = students.OrderBy(s => s.StudentID); break; case "name_desc": students = students.OrderByDescending(s => s.StudentID); break; default: students = students.OrderByDescending(s => s.StudentID); break; } return(View(students.ToList())); }
public ActionResult Index() { TaviStudentDemoDb db = new TaviStudentDemoDb(); var StudentCount = db.Students.Where(x => x.IsDelete == false).Count(); var ClassRoomCount = db.ClassRooms.Where(x => x.IsDelete == false).Count(); var DepartmentCount = db.Departments.Where(x => x.IsDelete == false).Count(); ViewBag.StudentCount = StudentCount.ToString(); ViewBag.ClassRoomCount = ClassRoomCount.ToString(); ViewBag.DepartmentCount = DepartmentCount.ToString(); return(View()); }