public List <CourseStudent> Get()
{
using (var dao = new CourseStudentDAO())
{
var query = dao.Query(e => true);
var coursesstudents = query.ToArray();
var cuenta3 = coursesstudents.Length;
using (var courdao = new CourseDAO())
{
var ids = coursesstudents.Select(e => e.IDCURSO).Distinct();
var courses = courdao.Query(e => ids.Contains(e.ID)).ToArray();
var cuenta2 = courses.Length;
using (var studendao = new StudentDAO())
{
var ids2 = coursesstudents.Select(e => e.IDESTUDIANTE).Distinct();
var students = studendao.Query(e => ids2.Contains(e.ID)).ToArray();
var cuenta = students.Length;
return(coursesstudents.Select(e => e.Map(students, courses)).ToList());
}
}
}
}
public void ValidateNoCourseStudentInstan(Course info)
{
using (var dao = new CourseStudentDAO())
{
var query = dao.Query(e => true);
var qCourseStudent = query.Where(e => e.IDCURSO == info.ID).ToList();
if (qCourseStudent.Any())
{
throw new Exception(Common.Constants.Messages.ALUMNO_CON_CURSOS);
}
}
}
public object Delete(CourseStudent info)
{
try
{
var model = info.Map();
using (var dao = new CourseStudentDAO())
{
return(dao.Delete(model));
}
}
catch (Exception)
{
throw;
}
}
public object Modify(CourseStudent info)
{
try
{
ValidateCourse(info);
ValidateStudent(info);
ValidateScore(info);
var model = info.Map();
using (var dao = new CourseStudentDAO())
{
return(dao.Modify(model));
}
}
catch (Exception)
{
throw;
}
}
