// GET: Profesores/Edit/5 public ActionResult Editar(Subjects model) //me falta esto { List <Subjects> subjects = new List <Subjects>(); List <Teachers> teachers = new List <Teachers>(); using (AlkemyEntities db = new AlkemyEntities()) { subjects = db.Subjects.ToList(); teachers = db.Teachers.ToList(); var subject = subjects.Where(x => x.Id == model.Id).FirstOrDefault(); //var teacher = teachers.Where(x => x.Id == subject.IdTeacher).FirstOrDefault(); subject.Subject_Name = model.Subject_Name; subject.IdTeacher = model.IdTeacher; subject.Quota_Max = model.Quota_Max; subject.Schedule = model.Schedule; List <SelectListItem> item = teachers.ConvertAll(a => { return(new SelectListItem() { Text = a.Name_.ToString(), Value = a.Id.ToString(), }); }); ViewBag.Lista = new SelectList(item, "Value", "Text"); db.SaveChanges(); } return(RedirectToAction("/ListaMaterias")); }
public ActionResult Eliminar(int id) { using (AlkemyEntities db = new AlkemyEntities()) { var delete = db.Subjects.Find(id); db.Subjects.Remove(delete); db.SaveChanges(); } return(Redirect("/Materias/ListaMaterias")); }
public ActionResult Eliminar(int? id) { using (AlkemyEntities db = new AlkemyEntities()) { var delete = db.Teachers.Find(id); db.Teachers.Remove(delete); db.SaveChanges(); } return Redirect("/Profesores/Lista"); }
// GET: Profesores/Edit/5 public ActionResult Editar(Teachers model) { List<Teachers> teachers = new List<Teachers>(); using (AlkemyEntities db = new AlkemyEntities()) { teachers = db.Teachers.ToList(); var teacher = teachers.Where(x => x.Id == model.Id).FirstOrDefault(); teacher.Name_ = model.Name_; teacher.Identification = model.Identification; teacher.Id = model.Id; db.SaveChanges(); return RedirectToAction("Lista"); } }
public ActionResult Agregar(Teachers model) { if (!ModelState.IsValid) return View(); List<Teachers> teachers = new List<Teachers>(); using (AlkemyEntities db = new AlkemyEntities()) { teachers = db.Teachers.ToList(); var oTeacher = new Teachers(); db.Teachers.Add(model); db.SaveChanges(); int nuevo = db.Teachers.Max(x => x.Id) + 1; oTeacher.Id = nuevo; } return Redirect("/Profesores/Lista"); }
public ActionResult Agregar(Subjects model) { List <Teachers> teachers = new List <Teachers>(); if (!ModelState.IsValid) { return(View()); } using (AlkemyEntities db = new AlkemyEntities()) { var oSubject = new Subjects(); oSubject.Subject_Name = model.Subject_Name; oSubject.Quota_Max = model.Quota_Max; oSubject.Schedule = model.Schedule; oSubject.IdTeacher = model.IdTeacher; db.Subjects.Add(model); db.SaveChanges(); List <SelectListItem> item = teachers.ConvertAll(a => { return(new SelectListItem() { Text = a.Name_, Value = a.Id.ToString(), Selected = true }); }); ViewBag.Lista = new SelectList(item, "Value", "Text"); int nuevo = db.Subjects.Max(x => x.Id) + 1; oSubject.Id = nuevo; } return(Redirect("/Materias/ListaMaterias")); }