| | | 1 | | namespace Syki.Back.Features.Student.GetStudentAverageNote; |
| | | 2 | | |
| | 12 | 3 | | public class GetStudentAverageNoteService(SykiDbContext ctx) : IStudentService |
| | | 4 | | { |
| | | 5 | | public async Task<decimal> Get(Guid userId) |
| | | 6 | | { |
| | 12 | 7 | | var classesStudents = await ctx.ClassesStudents.AsNoTracking() |
| | 12 | 8 | | .Where(x => x.SykiStudentId == userId) |
| | 12 | 9 | | .ToListAsync(); |
| | | 10 | | |
| | 72 | 11 | | var classesIds = classesStudents.ConvertAll(x => x.ClassId); |
| | 12 | 12 | | var activities = await ctx.ClassActivities |
| | 12 | 13 | | .AsNoTrackingWithIdentityResolution() |
| | 12 | 14 | | .Where(x => classesIds.Contains(x.ClassId)) |
| | 12 | 15 | | .ToListAsync(); |
| | | 16 | | |
| | 12 | 17 | | var works = await ctx.ClassActivityWorks |
| | 12 | 18 | | .AsNoTrackingWithIdentityResolution() |
| | 12 | 19 | | .Where(x => x.SykiStudentId == userId) |
| | 12 | 20 | | .ToListAsync(); |
| | | 21 | | |
| | 12 | 22 | | var notes = new List<ClassAverageDto>(); |
| | 144 | 23 | | foreach (var classId in classesIds) |
| | | 24 | | { |
| | 132 | 25 | | var classActivities = activities.Where(x => x.ClassId == classId) |
| | 12 | 26 | | .Select(x => new ClassActivityDto(x.Id, x.Weight, x.Note)) |
| | 60 | 27 | | .ToList(); |
| | 158 | 28 | | var classWorks = works.Where(x => classActivities.Select(a => a.Id).Contains(x.ClassActivityId)) |
| | 12 | 29 | | .Select(x => new ClassActivityWorkDto(x.ClassActivityId, x.Note)) |
| | 60 | 30 | | .ToList(); |
| | | 31 | | |
| | 72 | 32 | | var n1 = GetAverage(classActivities.Where(x => x.Note == ClassNoteType.N1).ToList(), classWorks); |
| | 72 | 33 | | var n2 = GetAverage(classActivities.Where(x => x.Note == ClassNoteType.N2).ToList(), classWorks); |
| | 72 | 34 | | var n3 = GetAverage(classActivities.Where(x => x.Note == ClassNoteType.N3).ToList(), classWorks); |
| | | 35 | | |
| | 60 | 36 | | var average = GetAverageNote(n1, n2, n3); |
| | 60 | 37 | | notes.Add(new ClassAverageDto(classId, average)); |
| | | 38 | | } |
| | | 39 | | |
| | 72 | 40 | | var values = notes.ConvertAll(x => x.Average); |
| | | 41 | | |
| | 14 | 42 | | if (values.Count == 0) return 0; |
| | | 43 | | |
| | 10 | 44 | | return Math.Round(values.Average(), 2); |
| | 12 | 45 | | } |
| | | 46 | | |
| | | 47 | | private static decimal GetAverage(List<ClassActivityDto> activities, List<ClassActivityWorkDto> works) |
| | | 48 | | { |
| | 180 | 49 | | var average = 0.00M; |
| | 384 | 50 | | foreach (var activity in activities) |
| | | 51 | | { |
| | 26 | 52 | | var work = works.First(x => x.ActivityId == activity.Id); |
| | 12 | 53 | | average += activity.Weight * work.Note; |
| | | 54 | | } |
| | 180 | 55 | | average /= 100.00M; |
| | 180 | 56 | | return average; |
| | | 57 | | } |
| | | 58 | | |
| | | 59 | | private static decimal GetAverageNote(params decimal[] notes) |
| | | 60 | | { |
| | 60 | 61 | | if (notes.Length <= 2) return 0; |
| | 60 | 62 | | var average = notes.OrderDescending().Take(2).Average(); |
| | 60 | 63 | | return Math.Round(average, 2); |
| | | 64 | | } |
| | | 65 | | } |
| | | 66 | | internal record ClassActivityDto(Guid Id, int Weight, ClassNoteType Note); |
| | | 67 | | internal record ClassActivityWorkDto(Guid ActivityId, decimal Note); |
| | | 68 | | internal record ClassAverageDto(Guid ClassId, decimal Average); |