| | | 1 | | namespace Syki.Back.Features.Teacher.GetTeacherClassStudents; |
| | | 2 | | |
| | | 3 | | public class GetTeacherClassStudentsService(SykiDbContext ctx) : ITeacherService |
| | | 4 | | { |
| | | 5 | | public async Task<OneOf<List<TeacherClassStudentOut>, SykiError>> Get(Guid teacherId, Guid classId) |
| | | 6 | | { |
| | | 7 | | var @class = await ctx.Classes.AsNoTracking() |
| | | 8 | | .Include(x => x.Students) |
| | | 9 | | .FirstOrDefaultAsync(x => x.Id == classId && x.TeacherId == teacherId); |
| | | 10 | | if (@class == null) return new ClassNotFound(); |
| | | 11 | | |
| | | 12 | | var students = @class.Students.OrderBy(x => x.Name) |
| | | 13 | | .Select(x => new TeacherClassStudentOut { Id = x.Id, Name = x.Name }) |
| | | 14 | | .ToList(); |
| | | 15 | | var classAttendances = await ctx.Attendances.AsNoTracking().Where(x => x.ClassId == classId).ToListAsync(); |
| | | 16 | | |
| | | 17 | | var classActivities = await ctx.ClassActivities |
| | | 18 | | .AsNoTrackingWithIdentityResolution() |
| | | 19 | | .Where(x => x.ClassId == classId) |
| | | 20 | | .Include(x => x.Works) |
| | | 21 | | .ToListAsync(); |
| | | 22 | | var activities = classActivities |
| | | 23 | | .Select(x => new ClassActivityDto(x.Id, x.Weight, x.Note)) |
| | | 24 | | .ToList(); |
| | | 25 | | |
| | | 26 | | foreach (var student in students) |
| | | 27 | | { |
| | | 28 | | var attendances = classAttendances.Count(x => x.StudentId == student.Id); |
| | | 29 | | var presences = classAttendances.Count(x => x.StudentId == student.Id && x.Present); |
| | | 30 | | student.Frequency = attendances > 0 ? Math.Round(100M*(1M * presences / (1M * attendances)), 2) : 0; |
| | | 31 | | |
| | | 32 | | var works = classActivities.SelectMany(x => x.Works.Where(w => w.SykiStudentId == student.Id)) |
| | | 33 | | .Select(x => new ClassActivityWorkDto(x.ClassActivityId, x.Note)) |
| | | 34 | | .ToList(); |
| | | 35 | | |
| | | 36 | | var n1 = GetAverage(activities.Where(x => x.Note == ClassNoteType.N1).ToList(), works); |
| | | 37 | | var n2 = GetAverage(activities.Where(x => x.Note == ClassNoteType.N2).ToList(), works); |
| | | 38 | | var n3 = GetAverage(activities.Where(x => x.Note == ClassNoteType.N3).ToList(), works); |
| | | 39 | | |
| | | 40 | | student.Notes.Add(new() { Type = ClassNoteType.N1, Note = n1 }); |
| | | 41 | | student.Notes.Add(new() { Type = ClassNoteType.N2, Note = n2 }); |
| | | 42 | | student.Notes.Add(new() { Type = ClassNoteType.N3, Note = n3 }); |
| | | 43 | | student.AverageNote = GetAverageNote(n1, n2, n3); |
| | | 44 | | } |
| | | 45 | | |
| | | 46 | | return students; |
| | | 47 | | } |
| | | 48 | | |
| | | 49 | | private static decimal GetAverage(List<ClassActivityDto> activities, List<ClassActivityWorkDto> works) |
| | | 50 | | { |
| | | 51 | | var average = 0.00M; |
| | | 52 | | foreach (var activity in activities) |
| | | 53 | | { |
| | | 54 | | var work = works.First(x => x.ActivityId == activity.Id); |
| | | 55 | | average += activity.Weight * work.Note; |
| | | 56 | | } |
| | | 57 | | average /= 100.00M; |
| | | 58 | | return average; |
| | | 59 | | } |
| | | 60 | | |
| | | 61 | | private static decimal GetAverageNote(params decimal[] notes) |
| | | 62 | | { |
| | | 63 | | if (notes.Length <= 2) return 0; |
| | | 64 | | var average = notes.OrderDescending().Take(2).Average(); |
| | | 65 | | return Math.Round(average, 2); |
| | | 66 | | } |
| | | 67 | | } |
| | | 68 | | |
| | 42 | 69 | | internal record ClassActivityDto(Guid Id, int Weight, ClassNoteType Note); |
| | | 70 | | internal record ClassActivityWorkDto(Guid ActivityId, decimal Note); |