public ActionResult Contact(integrante integrante)
{
Examen_ParcialEntities3 sd = new Examen_ParcialEntities3();
List <integrante> listaintegrante = sd.integrantes.ToList();
List <Asignatura> listaasignatura = sd.Asignaturas.ToList();
List <cursa> listacursa = sd.cursas.ToList();
List <profesor> listaProfesor = sd.profesors.ToList();
List <imparte> listaImparte = sd.impartes.ToList();
if (integrante.id == 0)
{
return(Redirect("Asignaturas"));
}
else
{
ViewData["AsignaturasCursadas"] = from cur in listacursa
join i in listaintegrante on cur.id_estudiante equals i.id into table1
from i in table1.DefaultIfEmpty()
where i.id == integrante.id
join asign in listaasignatura on cur.id_materia equals asign.id into table2
from asign in table2.DefaultIfEmpty()
join imp in listaImparte on asign.id equals imp.id_materia into table3
from imp in table3.DefaultIfEmpty()
join prof in listaProfesor on imp.id_profesor equals prof.id into table4
from prof in table4.DefaultIfEmpty()
select new AsignaturasCursadas {
listaAsignaturas = asign, listaIntegrantes = i, listaCursa = cur, listaImparte = imp, listaProfesores = prof
};
return(View(ViewData["AsignaturasCursadas"]));
}
}
public ActionResult Asignaturas()
{
Examen_ParcialEntities3 myEntity = new Examen_ParcialEntities3();
var ListaEstudiantes = myEntity.integrantes.ToList();
SelectList list = new SelectList(ListaEstudiantes, "ID", "Nombre");
ViewBag.Integrantes = list;
return(View());
}
