public GetAsignaturasModel GetAsignaturas()
{
var model = new GetAsignaturasModel();
using (SchoolDataContext ctx = new SchoolDataContext())
{
var asignaturas = (from x in ctx.Asignaturas
orderby x.Id, x.MateriaCod
select new Model.Asignatura
{
ID = x.Id,
CodigoMateria = x.MateriaCod,
Materia = x.Materia.Titulo,
AlumnoCedula = x.AlumnoDni,
Alumno = x.Alumno.Nombres,
ProfesorCedula = x.ProfesorDni,
Profesor = x.Profesor.Nombres,
NotaTareas = x.Tareas,
NotaExamen = x.Examen
}).ToList();
model.Asignaturas = asignaturas;
model.Alumnos = this.GetAlumnos();
model.Profesores = this.GetProfesores();
model.PromedioGeneral = (from x in asignaturas
select x.Promedio).Average();
}
return(model);
}
public GetAsignaturasModel GetAsignaturas(string filtro)
{
var model = new GetAsignaturasModel();
using (SchoolDataContext ctx = new SchoolDataContext())
{
var rows = (from x in ctx.Asignaturas
orderby x.Id, x.MateriaCod
select new Model.Asignatura
{
ID = x.Id,
CodigoMateria = x.MateriaCod,
Materia = x.Materia.Titulo,
AlumnoCedula = x.AlumnoDni,
Alumno = x.Alumno.Nombres,
ProfesorCedula = x.ProfesorDni,
Profesor = x.Profesor.Nombres,
NotaTareas = x.Tareas,
NotaExamen = x.Examen
}).ToList();
//if (string.IsNullOrWhiteSpace(filtro) == false)
//{
// rows = from x in rows
// where filtro.Contains(x.AlumnoCedula) ||
// filtro.Contains(x.Alumno) ||
// filtro.Contains(x.Materia) ||
// filtro.Contains(x.Profesor)
// select x;
//}
if (string.IsNullOrWhiteSpace(filtro) == false && filtro.ToUpper().Equals("APROBADO"))
{
rows = (from x in rows
where x.Aprobo == true
select x).ToList();
}
if (string.IsNullOrWhiteSpace(filtro) == false && filtro.ToUpper().Equals("REPROBADO"))
{
rows = (from x in rows
where x.Aprobo == false
select x).ToList();
}
var rowsFiltered = (from x in rows
orderby x.ID, x.CodigoMateria
select x).ToList();
model.Asignaturas = rowsFiltered;
model.Alumnos = this.GetAlumnos();
model.Profesores = this.GetProfesores();
model.PromedioGeneral = (from x in rowsFiltered
select x.Promedio).Average();
return(model);
}
}
public GetAsignaturasModel GetAsignaturasPorFiltro(GetAsignaturasPorFiltro filtro)
{
var model = new GetAsignaturasModel();
using (SchoolDataContext ctx = new SchoolDataContext())
{
var rows = from x in ctx.Asignaturas
orderby x.Id, x.MateriaCod
select new Model.Asignatura
{
ID = x.Id,
CodigoMateria = x.MateriaCod,
Materia = x.Materia.Titulo,
AlumnoCedula = x.AlumnoDni,
Alumno = x.Alumno.Nombres,
ProfesorCedula = x.ProfesorDni,
Profesor = x.Profesor.Nombres,
NotaTareas = x.Tareas,
NotaExamen = x.Examen
};
if (filtro != null)
{
if (string.IsNullOrWhiteSpace(filtro.SelectedProfesorCod) == false)
{
rows = from x in rows
where filtro.SelectedProfesorCod.Equals(x.ProfesorCedula)
select x;
}
if (string.IsNullOrWhiteSpace(filtro.SelectedAlumnoCod) == false)
{
rows = from x in rows
where filtro.SelectedAlumnoCod.Equals(x.AlumnoCedula)
select x;
}
}
var rowsFiltered = (from x in rows
orderby x.ID, x.CodigoMateria
select x).ToList();
model.Asignaturas = rowsFiltered;
model.Alumnos = this.GetAlumnos();
model.Profesores = this.GetProfesores();
model.PromedioGeneral = (from x in rowsFiltered
select x.Promedio).Average();
return(model);
}
}
