public ActionResult agregarMateria(MateriaViewModel model)
{
List <ListMateriaViewModel> lst;
try
{
if (ModelState.IsValid)
{
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = new Materias();
oTabla.ID_curso = model.IdCurso;
oTabla.Profesor = model.Profesor;
oTabla.Materia = model.Materia;
oTabla.Horario = model.Horario;
oTabla.Duracion = model.Duracion;
db.Materias.Add(oTabla);
db.SaveChanges();
}
return(Redirect("~/Materia/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult EditarMateria(MateriaViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = db.Materias.Find(model.IdMaterias);
oTabla.ID_curso = model.IdCurso;
oTabla.Profesor = model.Profesor;
oTabla.Materia = model.Materia;
oTabla.Horario = model.Horario;
oTabla.Duracion = model.Duracion;
db.Entry(oTabla).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Materia/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult agregarMateria()
{
List <ListCursoViewModel> lst;
using (SchoolAppEntities db = new SchoolAppEntities())
{
lst = (from d in db.Curso
select new ListCursoViewModel
{
IdCurso = d.ID_curso,
Grado = d.Grado,
Seccion = d.Seccion
}).ToList();
}
List <SelectListItem> items = lst.ConvertAll(d =>
{
return(new SelectListItem()
{
Text = d.Grado.ToString() + d.Seccion.ToString(),
Value = d.IdCurso.ToString(),
Selected = false
});
});
ViewBag.listaID = items;
return(View());
}
public ActionResult agregarEstudiante(EstudianteViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = new Estudiantes();
oTabla.ID_curso = model.IdCurso;
oTabla.Nombre = model.Nombre;
oTabla.Apellido = model.Apellido;
oTabla.Sexo = model.Sexo;
oTabla.Edad = model.Edad;
oTabla.Codigo = model.Codigo;
oTabla.Telefono = model.Telefono;
oTabla.Direccion = model.Direccion;
db.Estudiantes.Add(oTabla);
db.SaveChanges();
}
return(Redirect("~/Estudiante/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Editar(CursoViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = db.Curso.Find(model.IdCurso);
oTabla.Grado = model.Grado;
oTabla.Seccion = model.Seccion;
oTabla.Cant_de_Estudiantes = model.CantDeEstudiantes;
oTabla.Profesor_encargado = model.ProfesorEncargado;
db.Entry(oTabla).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Curso/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Nuevo(CursoViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = new Curso();
oTabla.Grado = model.Grado;
oTabla.Seccion = model.Seccion;
oTabla.Cant_de_Estudiantes = model.CantDeEstudiantes;
oTabla.Profesor_encargado = model.ProfesorEncargado;
db.Curso.Add(oTabla);
db.SaveChanges();
}
return(Redirect("~/Curso/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Eliminar(int id)
{
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = db.Materias.Find(id);
db.Materias.Remove(oTabla);
db.SaveChanges();
}
return(Redirect("~/Materia/"));
}
public ActionResult Editar(int id)
{
CursoViewModel model = new CursoViewModel();
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = db.Curso.Find(id);
model.Grado = oTabla.Grado;
model.Seccion = oTabla.Seccion;
model.CantDeEstudiantes = oTabla.Cant_de_Estudiantes;
model.ProfesorEncargado = oTabla.Profesor_encargado;
model.IdCurso = oTabla.ID_curso;
}
return(View(model));
}
public ActionResult EditarMateria(int id)
{
MateriaViewModel model = new MateriaViewModel();
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = db.Materias.Find(id);
model.IdCurso = oTabla.ID_curso;
model.Profesor = oTabla.Profesor;
model.Materia = oTabla.Materia;
model.Horario = oTabla.Horario;
model.Duracion = oTabla.Duracion;
model.IdMaterias = oTabla.ID_materias;
}
return(View(model));
}
// GET: Curso
public ActionResult Index()
{
List <ListCursoViewModel> lst;
using (SchoolAppEntities db = new SchoolAppEntities())
{
lst = (from d in db.Curso
select new ListCursoViewModel
{
IdCurso = d.ID_curso,
Grado = d.Grado,
Seccion = d.Seccion,
CantDeEstudiantes = d.Cant_de_Estudiantes,
ProfesorEncargado = d.Profesor_encargado
}).ToList();
}
return(View(lst));
}
public ActionResult EditarEstudiante(int id)
{
EstudianteViewModel model = new EstudianteViewModel();
using (SchoolAppEntities db = new SchoolAppEntities())
{
var oTabla = db.Estudiantes.Find(id);
model.IdCurso = oTabla.ID_curso;
model.Nombre = oTabla.Nombre;
model.Apellido = oTabla.Apellido;
model.Sexo = oTabla.Sexo;
model.Edad = oTabla.Edad;
model.Codigo = oTabla.Codigo;
model.Telefono = oTabla.Telefono;
model.Direccion = oTabla.Direccion;
model.IdEstudiantes = oTabla.ID_estudiantes;
}
return(View(model));
}
// GET: Curso
public ActionResult Index()
{
List <ListMateriaViewModel> lst;
using (SchoolAppEntities db = new SchoolAppEntities())
{
lst = (from d in db.Materias
select new ListMateriaViewModel
{
IdMaterias = d.ID_materias,
IdCurso = d.ID_curso,
Profesor = d.Profesor,
Materia = d.Materia,
Horario = d.Horario,
Duracion = d.Duracion
}).ToList();
}
return(View(lst));
}
// GET: Curso
public ActionResult Index()
{
List <ListEstudianteViewModel> lst;
using (SchoolAppEntities db = new SchoolAppEntities())
{
lst = (from d in db.Estudiantes
select new ListEstudianteViewModel
{
IdEstudiantes = d.ID_estudiantes,
IdCurso = d.ID_curso,
Nombre = d.Nombre,
Apellido = d.Apellido,
Sexo = d.Sexo,
Edad = d.Edad,
Codigo = d.Codigo,
Telefono = d.Telefono,
Direccion = d.Direccion
}).ToList();
}
return(View(lst));
}
