public ActionResult Create([Bind(Include = "StudentId,StudentName")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "CourseId,CourseName,CourseDescription")] Cours course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(course));
}
public ActionResult Create([Bind(Include = "StudentId,StudentName,CourseId,CourseName,CourseDescription,Something")] StudentsCours StudentCourse)
{
if (ModelState.IsValid)
{
db.StudentsCourses.Add(StudentCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(StudentCourse));
}
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 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/"));
}