| | | 1 | | namespace Estud.Back.Features.Disciplines.GetDisciplines; |
| | | 2 | | |
| | 4 | 3 | | public class GetDisciplinesService(EstudDbContext ctx) : IEstudService |
| | | 4 | | { |
| | | 5 | | public async Task<GetDisciplinesOut> Get(GetDisciplinesIn query) |
| | | 6 | | { |
| | 4 | 7 | | var disciplinesQuery = ctx.Disciplines.AsNoTracking() |
| | 4 | 8 | | .Where(d => d.InstitutionId == ctx.RequestUser.InstitutionId); |
| | | 9 | | |
| | 4 | 10 | | var filter = query?.Filter; |
| | 4 | 11 | | if (filter.HasValue()) |
| | 2 | 12 | | disciplinesQuery = disciplinesQuery.Where(d => |
| | 2 | 13 | | d.Name.ToLower().Contains(filter.ToLower()) || |
| | 2 | 14 | | d.Code.ToLower().Contains(filter.ToLower())); |
| | | 15 | | |
| | 4 | 16 | | var disciplines = await disciplinesQuery |
| | 4 | 17 | | .OrderBy(d => d.Name) |
| | 4 | 18 | | .ToListAsync(); |
| | | 19 | | |
| | 10 | 20 | | var ids = disciplines.Select(d => d.Id).ToHashSet(); |
| | | 21 | | |
| | 10 | 22 | | var result = disciplines.ConvertAll(d => d.ToGetDisciplinesItemOut()); |
| | | 23 | | |
| | 4 | 24 | | var courses = await ctx.CoursesDisciplines.AsNoTracking() |
| | 4 | 25 | | .Where(c => ids.Count == 0 || ids.Contains(c.DisciplineId)) |
| | 4 | 26 | | .ToListAsync(); |
| | 10 | 27 | | result.ForEach(x => x.Courses = courses.Count(c => c.DisciplineId == x.Id)); |
| | | 28 | | |
| | 4 | 29 | | var teachers = await ctx.TeachersDisciplines.AsNoTracking() |
| | 4 | 30 | | .Where(d => ids.Count == 0 || ids.Contains(d.DisciplineId)) |
| | 4 | 31 | | .ToListAsync(); |
| | 10 | 32 | | result.ForEach(x => x.Teachers = teachers.Count(t => t.DisciplineId == x.Id)); |
| | | 33 | | |
| | 4 | 34 | | return new GetDisciplinesOut { Total = result.Count, Items = result }; |
| | 4 | 35 | | } |
| | | 36 | | } |