public List <PCurrentMatterView> GetCurrentMattersTeacher(int idCurrentUser, ref string error)
{
List <PCurrentMatterView> pCurrentMatterViewList = new List <PCurrentMatterView>();
PCurrentMatterView pCurrentMatterView;
try
{
using (NotasAcademicasEntities context = new NotasAcademicasEntities())
{
var currentMatter = (from mt in context.Matricula
join dm in context.DetalleMatricula on mt.IdMatricula equals dm.Id_Fr_Matricula
join de in context.DetalleEstudiantes on dm.Id_Fr_Matricula equals de.Id_Fr_Matricula_E
join Materia m in context.Materia on dm.IdMateria equals m.IdMateria
join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
where dm.IdProfesor == idCurrentUser
select new { dm.Id_Fr_Matricula, m.IdMateria, m.Nombre, m.Codigo, m.NumeroCredito, p.IdProfesor }).ToList();
foreach (var item in currentMatter)
{
pCurrentMatterView = new PCurrentMatterView();
pCurrentMatterView.IdRegistration = item.Id_Fr_Matricula;
pCurrentMatterView.IdMatter = item.IdMateria.ToString();
pCurrentMatterView.NameMatter = item.Nombre;
pCurrentMatterView.NamberCredits = (int)item.NumeroCredito;
pCurrentMatterView.Code = item.Codigo;
pCurrentMatterView.IdTeacher = item.IdProfesor.ToString();
pCurrentMatterViewList.Add(pCurrentMatterView);
}
}
return(pCurrentMatterViewList);
}
catch (System.Exception ex)
{
error = ex.ToString();
return(null);
throw;
}
}
public List <PCurrentMatterView> GetCurrentMattersByUser(int idCurrentUser, string typeUser, ref string error)
{
List <PCurrentMatterView> pCurrentMatterViewList = new List <PCurrentMatterView>();
PCurrentMatterView pCurrentMatterView;
try
{
using (NotasAcademicasEntities context = new NotasAcademicasEntities())
{
if (typeUser.Equals("student"))
{
var currentMatter = (from mt in context.Matricula
join dm in context.DetalleMatricula on mt.IdMatricula equals dm.Id_Fr_Matricula
join de in context.DetalleEstudiantes on dm.Id_Fr_Matricula equals de.Id_Fr_Matricula_E
join Materia m in context.Materia on dm.IdMateria equals m.IdMateria
join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
where de.Id_Fr_Estudiantes_E == idCurrentUser & de.Estado == true && mt.Estado == true
select new { dm.Id_Fr_Matricula, dm.Grupo, m.IdMateria, m.Nombre, m.Codigo, m.NumeroCredito, p.IdProfesor, p.Nombres, p.Apellidos }).ToList();
foreach (var item in currentMatter)
{
pCurrentMatterView = new PCurrentMatterView();
pCurrentMatterView.IdRegistration = item.Id_Fr_Matricula;
pCurrentMatterView.IdMatter = item.IdMateria.ToString();
pCurrentMatterView.NameMatter = item.Nombre;
pCurrentMatterView.NamberCredits = (int)item.NumeroCredito;
pCurrentMatterView.Code = item.Codigo;
pCurrentMatterView.IdTeacher = item.IdProfesor.ToString();
pCurrentMatterView.NameTeacher = item.Nombres + " " + item.Apellidos;
pCurrentMatterView.Group = item.Grupo.ToString();
pCurrentMatterViewList.Add(pCurrentMatterView);
}
}
else
{
var currentMatter = (from dm in context.DetalleMatricula
join p in context.Profesor on dm.IdProfesor equals p.IdProfesor
join m in context.Materia on dm.IdMateria equals m.IdMateria
join mt in context.Matricula on dm.Id_Fr_Matricula equals mt.IdMatricula
where dm.IdProfesor == idCurrentUser && mt.Estado == true
select new { dm.Grupo, dm.Id_Fr_Matricula, m.IdMateria, m.Nombre, m.Codigo, m.NumeroCredito, p.IdProfesor }).ToList();
foreach (var item in currentMatter)
{
pCurrentMatterView = new PCurrentMatterView();
pCurrentMatterView.IdRegistration = item.Id_Fr_Matricula;
pCurrentMatterView.IdMatter = item.IdMateria.ToString();
pCurrentMatterView.NameMatter = item.Nombre + "(" + item.Grupo + ")";
pCurrentMatterView.NamberCredits = (int)item.NumeroCredito;
pCurrentMatterView.Code = item.Codigo;
pCurrentMatterView.IdTeacher = item.IdProfesor.ToString();
pCurrentMatterView.Group = item.Grupo.ToString();
pCurrentMatterViewList.Add(pCurrentMatterView);
}
}
}
return(pCurrentMatterViewList);
}
catch (System.Exception ex)
{
error = ex.ToString();
return(null);
throw;
}
}