public async Task <IEnumerable <MemberDto> > GetMembersOfLibrary(GetMembersOfLibrary request)
{
const string sql = @"
SELECT
mem.id,
usr.id AS user_id,
lib.id AS library_id,
(CASE
WHEN mem.display_name = ''
THEN usr.display_name
ELSE mem.display_name END) AS display_name,
usr.display_name AS full_name,
mem.created_at,
usr.id = lib.created_by AS is_creator
FROM plum.users usr
INNER JOIN plum.memberships mem
ON usr.id = mem.user_id
INNER JOIN plum.libraries lib
ON lib.id = mem.library_id
WHERE mem.library_id = @LibraryId
ORDER BY mem.created_at";
using (var cnn = _sqlConnectionFactory.GetSqlConnection())
{
return(await cnn.QueryAsync <MemberDto>(sql, new { request.LibraryId }));
}
}
public async Task <IEnumerable <Member> > Handle(GetMembersOfLibrary request, CancellationToken cancellationToken)
{
var dtos = await GetMembersOfLibrary(request);
var members = _mapper.Map <IEnumerable <Member> >(dtos).ToArray();
var memberIds = members.Select(m => m.Id).ToList();
var roles = await _mediator.Send(new GetRolesForMembers(memberIds), cancellationToken);
foreach (var member in members)
{
member.Role = roles[member.Id];
}
return(members);
}