public ICollection <GetStudentListResponseDto> Handle(GetStudentListQuery query) { var sql = @" SELECT Id, Name, Surname FROM Students s "; using (var sqlConnection = new SqlConnection(_connectionString)) { var students = sqlConnection.Query <GetStudentListResponseDto>(sql).ToList(); return(students); } }
public async Task ShouldGetStudentList() { var createStudentItemCommand = new CreateStudentItemCommand() { FirstName = "first", LastName = "last" }; var createStudentDto = await SendAsync(createStudentItemCommand); var created = await ExecuteDbContextAsync(db => db.Students.Where(c => c.Id.Equals(createStudentDto.Id)).SingleOrDefaultAsync()); GetStudentListQuery query = new GetStudentListQuery(); GetObjectListVm <GetStudentItemDto> dto = await SendAsync(query); dto.ShouldNotBeNull(); dto.Count.ShouldBeGreaterThanOrEqualTo(1); dto.Data.ShouldContain(d => d.Id.Equals(created.Id)); }
public async Task <GetObjectListVm <GetStudentItemDto> > Handle(GetStudentListQuery request, CancellationToken cancellationToken) { var students = await context.Students .AsNoTracking() .ToListAsync(cancellationToken); var list = students .Select(x => new GetStudentItemDto { Id = x.Id, Name = $"{x.FirstName} {x.LastName}", }).ToList(); var dto = new GetObjectListVm <GetStudentItemDto> { Count = list.Count, Data = list }; return(dto); }
public List <StudentDto> Handle(GetStudentListQuery query) { return(_studentService.GetList(query.EnrolledIn, query.NumberOfCourses) .Select(StudentDto.ConvertToDto).ToList()); }