// 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 Editar(int id)
{
//Subjects model = new Subjects();
List <Teachers> teachers = new List <Teachers>();
List <Subjects> subjects = new List <Subjects>();
using (AlkemyEntities db = new AlkemyEntities())
{
subjects = db.Subjects.ToList();
teachers = db.Teachers.ToList();
var viewModel = new Subjects();
var subject = subjects.Where(x => x.Id == id).FirstOrDefault();
//var teacher = teachers.Where(x => x.Id == subject.IdTeacher).FirstOrDefault();
viewModel.Subject_Name = subject.Subject_Name;
viewModel.IdTeacher = subject.IdTeacher;
viewModel.Quota_Max = subject.Quota_Max;
viewModel.Schedule = subject.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");
return(View(subject));
}
}
// GET: Profesores/Lista
public ActionResult Lista()
{
List<Teachers> teachers = new List<Teachers>();
using (AlkemyEntities db = new AlkemyEntities())
{
var lst = db.Teachers.ToList();
return View(lst);
}
}
public ActionResult ListaMaterias()
{
List <Subjects> subjects = new List <Subjects>();
using (AlkemyEntities db = new AlkemyEntities())
{
var lst = db.Subjects.ToList();
return(View(lst));
}
}
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 Editar(int Id)
{
List<Teachers> teachers = new List<Teachers>();
using (AlkemyEntities db = new AlkemyEntities())
{
teachers = db.Teachers.ToList();
var teacher = teachers.Where(x => x.Id == Id).FirstOrDefault();
return View(teacher);
}
}
// GET: Profesores/Create
public ActionResult Agregar()
{
List<Teachers> teachers = new List<Teachers>();
using (AlkemyEntities db = new AlkemyEntities())
{
teachers = db.Teachers.ToList();
}
return View();
}
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()
{
List <Teachers> teachers = new List <Teachers>();
using (AlkemyEntities db = new AlkemyEntities())
{
teachers = db.Teachers.ToList();
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");
return(View());
}
}
// GET: Materias/Details/5
public ActionResult Detalle(int?id)
{
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 viewModel = new MateriaDetalleViewModel();
var subject = subjects.Where(x => x.Id == id).FirstOrDefault();
var teacher = teachers.Where(x => x.Id == subject.IdTeacher).FirstOrDefault();
viewModel.Materia = subject.Subject_Name;
viewModel.Profesor = teacher.Name_;
viewModel.CupMax = subject.Quota_Max;
viewModel.Horario = subject.Schedule;
return(View(viewModel));
}
}
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"));
}
