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); } } }