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());
}
