public async Task <RoleOutput> Handle(GetRoleQuery request, CancellationToken cancellationToken)
{
return(await _dbQueryHelper.QuerySingle <RoleOutput>($@"SELECT r.Id as Code, r.Name, r.Permissions as Permission
FROM [User] u
JOIN [Role] r ON u.RoleId = r.Id
WHERE u.Email = @UserEmail and u.isActive = 1", new { request.UserEmail }));
}
public async Task <RfaOutput> Handle(GetRfaQuery request, CancellationToken cancellationToken)
{
var rfa = (await _dbQueryHelper.QuerySingle <RfaRequest>(@"
select
rfa.PhoneNumber, rfa.Profession,
[User].LastName, [User].FirstName, rfa.Email
from RfaInfo rfa
inner join [User] on [User].Id = rfa.UserId
where rfa.email = @Email
", new { @Email = new Email(request.Email).Value }));
if (rfa == null)
{
return(default);