// GET: Students public ActionResult Index(string search) { using (var db = new AspNetMvcDbContext()) { var students = from s in db.Students select s; // Filter by the keyword 'search' if (!string.IsNullOrEmpty(search)) { students = students.Where(n => n.Name.Contains(search)); } return(View(students.ToList())); } }
public ActionResult DeleteConfirmed(int id) { //var student = _db.Students.Find(id); //_db.Students.Remove(student); using (var db = new AspNetMvcDbContext()) { // Reduce call to DB var student = new Student { Id = id }; db.Entry(student).State = EntityState.Deleted; db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult EditPost(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (var db = new AspNetMvcDbContext()) { var student = db.Students.Find(id); // Use TryUpdateModel to update fields from user input in the posted form data // Bind resets fields if (!TryUpdateModel(student, "", new[] { "MatricNumber", "Name", "IcNumber", "DateOfBirth" })) { return(View(student)); } db.SaveChanges(); return(RedirectToAction("Index")); } }