| | | 1 | | namespace Syki.Back.Features.Students.GetStudents; |
| | | 2 | | |
| | 2 | 3 | | public class GetStudentsService(SykiDbContext ctx) : ISykiService |
| | | 4 | | { |
| | | 5 | | public async Task<GetStudentsOut> Get() |
| | | 6 | | { |
| | 2 | 7 | | var institutionId = ctx.RequestUser.InstitutionId; |
| | | 8 | | |
| | 2 | 9 | | var students = await ctx.Students.AsNoTracking() |
| | 2 | 10 | | .Include(s => s.User) |
| | 2 | 11 | | .Where(s => s.InstitutionId == institutionId) |
| | 2 | 12 | | .OrderBy(s => s.Name) |
| | 2 | 13 | | .ToListAsync(); |
| | 6 | 14 | | var studentIds = students.Select(s => s.Id).ToHashSet(); |
| | | 15 | | |
| | 2 | 16 | | var studentEnrollments = await ctx.StudentCourseEnrollments.AsNoTracking() |
| | 2 | 17 | | .Where(e => studentIds.Contains(e.StudentId) && e.LeftAt == null) |
| | 2 | 18 | | .ToListAsync(); |
| | 2 | 19 | | var courseOfferingIds = studentEnrollments.Select(e => e.CourseOfferingId).ToHashSet(); |
| | | 20 | | |
| | 2 | 21 | | var courseOfferings = await ctx.CourseOfferings.AsNoTracking() |
| | 2 | 22 | | .Where(co => courseOfferingIds.Contains(co.Id)) |
| | 2 | 23 | | .Select(g => new { g.Id, g.CourseId }) |
| | 2 | 24 | | .ToListAsync(); |
| | 2 | 25 | | var coursesIds = courseOfferings.Select(co => co.CourseId).ToHashSet(); |
| | 2 | 26 | | var courses = await ctx.Courses.AsNoTracking() |
| | 2 | 27 | | .Where(c => coursesIds.Contains(c.Id)) |
| | 2 | 28 | | .Select(c => new { c.Id, c.Name }) |
| | 2 | 29 | | .ToListAsync(); |
| | | 30 | | |
| | | 31 | | |
| | 6 | 32 | | var result = students.ConvertAll(s => s.ToGetStudentsItemOut()); |
| | 12 | 33 | | foreach (var item in result) |
| | | 34 | | { |
| | 4 | 35 | | var enrollment = studentEnrollments.FirstOrDefault(e => e.StudentId == item.Id); |
| | 4 | 36 | | if (enrollment == null) continue; |
| | | 37 | | |
| | 0 | 38 | | var courseOffering = courseOfferings.FirstOrDefault(co => co.Id == enrollment.CourseOfferingId); |
| | 0 | 39 | | if (courseOffering == null) continue; |
| | | 40 | | |
| | 0 | 41 | | var course = courses.FirstOrDefault(c => c.Id == courseOffering.CourseId); |
| | 0 | 42 | | item.Course = course?.Name ?? "-"; |
| | | 43 | | } |
| | | 44 | | |
| | 2 | 45 | | return new GetStudentsOut { Total = result.Count, Items = result }; |
| | 2 | 46 | | } |
| | | 47 | | } |