// GET: Alumnos/Create
public ActionResult CreateAlumnoMateria(int cedula)
{
List <Salones> SalonesList = db.Salones.ToList();
var SalonPisoList = SalonesList.Select(
x => new
{
SalonId = x.Id,
Nombre = x.NumeroSalon + " - " + x.Piso
}
);
ViewBag.Salones = new SelectList(SalonPisoList, "SalonId", "Nombre");
List <Materias> MateriasList = db.Materias.ToList();
var MateList = MateriasList.Select(
x => new
{
MateriaId = x.Id,
x.Nombre
}
);
ViewBag.Materias = new SelectList(MateList, "MateriaId", "Nombre");
Alunmos_Materias alumnoMateria = new Alunmos_Materias();
alumnoMateria.Cedula = cedula;
Alumnos alumno = db.Alumnos.Find(cedula);
ViewBag.nombreEstudiante = alumno.Nombre;
return(View(alumnoMateria));
}
public ActionResult EditNota(int id, Alunmos_Materias collection)
{
try
{
int NotaOld = 0;
int NotaNew = 0;
Alunmos_Materias oldValue = db.Alunmos_Materias.AsNoTracking().FirstOrDefault(x => x.Id == id);
int.TryParse(oldValue.Nota.ToString(), out NotaOld);
int.TryParse(collection.Nota.ToString(), out NotaNew);
TrazaNota trazaNota = new TrazaNota();
trazaNota.ProfesorId = oldValue.Materias.ProfesorId;
trazaNota.ValorAnterior = NotaOld;
trazaNota.ValorNuevo = NotaNew;
trazaNota.Alumnos_Materias_Id = collection.Id;
db.TrazaNota.Add(trazaNota);
db.Entry(collection).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult EditAlumnoMateria(int id, Alunmos_Materias collection)
{
try
{
db.Entry(collection).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult CreateAlumnoMateria(Alunmos_Materias alumnomateria)
{
try
{
db.Alunmos_Materias.Add(alumnomateria);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult DeleteAlumnoMateria(int id, Alunmos_Materias collection)
{
try
{
Alunmos_Materias alumnoMateria = db.Alunmos_Materias.Find(id);
List <TrazaNota> trazaNotas = db.TrazaNota.Where(x => x.Alumnos_Materias_Id == id).ToList();
if (trazaNotas != null)
{
db.TrazaNota.RemoveRange(trazaNotas);
}
db.Alunmos_Materias.Remove(alumnoMateria);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View());
}
}
// GET: Alumnos/EditNota/5
public ActionResult EditNota(int id)
{
Alunmos_Materias alunmos_Materria = db.Alunmos_Materias.Find(id);
return(View(alunmos_Materria));
}
