public ActionResult Students() { using (BS2DBDataContext dbCtx = new BS2DBDataContext()) { List <StudentModel> studentModels = new List <StudentModel>(); foreach (Student student in dbCtx.Students) { studentModels.Add(new StudentModel { Id = student.Id, Name = student.Name }); } return(View(studentModels)); } }
public ActionResult DeleteStudent(int id) { using (BS2DBDataContext dbCtx = new BS2DBDataContext()) { Student student = dbCtx.Students.Where(x => x.Id == id).FirstOrDefault(); if (student == null) { return(RedirectToAction("Error", "Error")); } dbCtx.Students.DeleteOnSubmit(student); dbCtx.SubmitChanges(); return(RedirectToAction("Students")); } }
public ActionResult EditStudent(StudentModel model) { try { if (ModelState.IsValid) { using (BS2DBDataContext dbCtx = new BS2DBDataContext()) { if (model.Id == 0) { Student dbStudent = new Student { Name = model.Name }; dbCtx.Students.InsertOnSubmit(dbStudent); dbCtx.SubmitChanges(); return(RedirectToAction("Students")); } Student student = dbCtx.Students.Where(x => x.Id == model.Id).FirstOrDefault(); if (student == null) { RedirectToAction("Error", "Error"); } student.Name = model.Name; dbCtx.SubmitChanges(); return(RedirectToAction("Students")); } } return(View(model)); } catch { return(RedirectToAction("Error", "Error")); } }
public ActionResult EditStudent(int Id) { if (Id == 0) { return(View(new StudentModel())); } using (BS2DBDataContext dbCtx = new BS2DBDataContext()) { Student student = dbCtx.Students.Where(x => x.Id == Id).FirstOrDefault(); if (student == null) { return(View(new StudentModel())); } StudentModel student1 = new StudentModel { Id = student.Id, Name = student.Name }; return(View(student1)); } }