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