public ActionResult EliminarMateria(int id)
{
using (CursoEntities db = new CursoEntities())
{
var emateria = db.MateriasTs.Find(id);
db.MateriasTs.Remove(emateria);
db.SaveChanges();
}
return(Redirect("/Materia"));
}
public ActionResult Eliminar(int id)
{
using (CursoEntities db = new CursoEntities())
{
var vcurso = db.CursoTs.Find(id);
db.CursoTs.Remove(vcurso);
db.SaveChanges();
}
return(Redirect("~/Curso"));
}
public ActionResult EditarMateria(int id)
{
MateriaModel model = new MateriaModel();
using (CursoEntities db = new CursoEntities())
{
var emateria = db.MateriasTs.Find(id);
model.nombre_materia = emateria.nombre_materia;
model.id_materia = emateria.id_materia;
}
return(View(model));
}
public ActionResult EditarCurso(int id)
{
CursoModel model = new CursoModel();
using (CursoEntities db = new CursoEntities())
{
var vcurso = db.CursoTs.Find(id);
model.curso = vcurso.curso;
model.seccion = vcurso.seccion;
model.id_curso = vcurso.id_curso;
}
return(View(model));
}
public ActionResult EditarAlumno(int id)
{
AlumnoModel model = new AlumnoModel();
using (CursoEntities db = new CursoEntities())
{
var emateria = db.AlumnosTs.Find(id);
model.nombre_alumno = emateria.nombre_alumno;
model.apellido_alumno = emateria.apellido_alumno;
model.id_alumno = emateria.id_alumno;
}
return(View(model));
}
// GET: Curso
public ActionResult Curso()
{
List <ListCursoModel> lst;
using (CursoEntities db = new CursoEntities())
{
lst = (from d in db.CursoTs
select new ListCursoModel
{
id_curso = d.id_curso,
curso = d.curso,
seccion = d.seccion
}).ToList();
}
return(View(lst));
}
// GET: Alumno
public ActionResult Alumno()
{
List <ListAlumnoModel> lst;
using (CursoEntities db = new CursoEntities())
{
lst = (from d in db.AlumnosTs
select new ListAlumnoModel
{
id_alumno = d.id_alumno,
nombre_alumno = d.nombre_alumno,
apellido_alumno = d.apellido_alumno
}).ToList();
}
return(View(lst));
}
public ActionResult Materia()
{
List <ListMateriaModel> lst;
using (CursoEntities db = new CursoEntities())
{
lst = (
from d in db.MateriasTs
select new ListMateriaModel
{
id_materia = d.id_materia,
nombre_materia = d.nombre_materia
}
).ToList();
}
return(View(lst));
}
public ActionResult NuevaMateria(MateriaModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var materia = new MateriasT();
materia.nombre_materia = model.nombre_materia;
db.MateriasTs.Add(materia);
db.SaveChanges();
}
return(Redirect("Materia/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult AgregarMateria(MateriaCursoModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var vcurso = new MateriasCursoT();
vcurso.id_curso = model.Id_curso;
vcurso.id_materia = model.Id_materia;
db.MateriasCursoTs.Add(vcurso);
db.SaveChanges();
}
return(Redirect("~/Curso"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult AgregarCurso(AlumnoCursoModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var vcurso = new AlumnosCursoT();
vcurso.id_curso = model.id_curso;
vcurso.id_alumno = model.id_alumno;
db.AlumnosCursoTs.Add(vcurso);
db.SaveChanges();
}
return(Redirect("/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult EditarMateria(MateriaModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var emateria = db.MateriasTs.Find(model.id_materia);
emateria.nombre_materia = model.nombre_materia;
db.Entry(emateria).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult EditarCurso(CursoModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var vcurso = db.CursoTs.Find(model.id_curso);
vcurso.curso = model.curso;
vcurso.seccion = model.seccion;
db.Entry(vcurso).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult NuevoCurso(CursoModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var vcurso = new CursoT();
vcurso.curso = model.curso;
vcurso.seccion = model.seccion;
db.CursoTs.Add(vcurso);
db.SaveChanges();
}
return(Redirect("Curso/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult EditarAlumno(AlumnoModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var ealumnos = db.AlumnosTs.Find(model.id_alumno);
ealumnos.nombre_alumno = model.nombre_alumno;
ealumnos.apellido_alumno = model.apellido_alumno;
db.Entry(ealumnos).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Alumnos/Alumnos"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult NuevoAlumno(AlumnoModel model)
{
try
{
if (ModelState.IsValid)
{
using (CursoEntities db = new CursoEntities())
{
var materia = new AlumnosT();
materia.nombre_alumno = model.nombre_alumno;
materia.apellido_alumno = model.apellido_alumno;
db.AlumnosTs.Add(materia);
db.SaveChanges();
}
return(Redirect("Alumno/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
