| | | 1 | | using Syki.Back.Features.Student.GetStudentFrequency; |
| | | 2 | | using Syki.Back.Features.Student.GetStudentAverageNote; |
| | | 3 | | |
| | | 4 | | namespace Syki.Back.Features.Student.GetStudentInsights; |
| | | 5 | | |
| | 4 | 6 | | public class GetStudentInsightsService(SykiDbContext ctx, GetStudentFrequencyService frequencyService, GetStudentAverage |
| | | 7 | | { |
| | | 8 | | public async Task<StudentInsightsOut> Get(Guid userId, Guid courseCurriculumId) |
| | | 9 | | { |
| | 4 | 10 | | var student = await ctx.Students.FirstAsync(x => x.Id == userId); |
| | | 11 | | |
| | 4 | 12 | | var totalDisciplines = await ctx.CourseCurriculumDisciplines.AsNoTracking() |
| | 4 | 13 | | .Where(g => g.CourseCurriculumId == courseCurriculumId) |
| | 4 | 14 | | .CountAsync(); |
| | 4 | 15 | | var finishedDisciplines = await ctx.ClassesStudents |
| | 4 | 16 | | .Where(x => x.SykiStudentId == userId && x.StudentDisciplineStatus == StudentDisciplineStatus.Aprovado) |
| | 4 | 17 | | .CountAsync(); |
| | | 18 | | |
| | 4 | 19 | | var frequency = await frequencyService.Get(userId); |
| | | 20 | | |
| | 4 | 21 | | var averageNote = await averageNoteService.Get(userId); |
| | | 22 | | |
| | 4 | 23 | | return new() |
| | 4 | 24 | | { |
| | 4 | 25 | | Status = student.Status, |
| | 4 | 26 | | TotalDisciplines = totalDisciplines, |
| | 4 | 27 | | FinishedDisciplines = finishedDisciplines, |
| | 4 | 28 | | Frequency = frequency.Frequency, |
| | 4 | 29 | | Average = averageNote, |
| | 4 | 30 | | }; |
| | 4 | 31 | | } |
| | | 32 | | } |