public ActionResult CreateOrEdit(ALUMNO a) { a.SEXO = null; if (!ModelState.IsValid) { return(View()); } try { using (var db = new ALUMNOS_DBContext()) { db.ALUMNO.Add(a);//crea el usuario db.SaveChanges(); return(RedirectToAction("Index")); } } catch (DbEntityValidationException ex) { var sb = new StringBuilder(); foreach (var failure in ex.EntityValidationErrors) { sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType()); foreach (var error in failure.ValidationErrors) { sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage); sb.AppendLine(); } } ModelState.AddModelError("", sb.ToString()); return(View()); } }
public ActionResult Borrar(int id) { //caso que lo mismo que editar using (var db = new ALUMNOS_DBContext()) { var al1 = db.ALUMNO.Where(a => a.ID == id).FirstOrDefault(); db.ALUMNO.Remove(al1); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Editar(ALUMNO alumno) { if (!ModelState.IsValid) { return(View()); } using (var db = new ALUMNOS_DBContext()) { ALUMNO al = db.ALUMNO.Where(a => a.ID == alumno.ID).FirstOrDefault(); al.NOMBRES = alumno.NOMBRES; al.APELLIDOS = alumno.APELLIDOS; al.EDAD = alumno.EDAD; al.SEXO = alumno.SEXO; db.SaveChanges(); return(RedirectToAction("Index", "Alumno")); } }