public async Task <UserOutput> Handle(GetUsersByEmailQuery request, CancellationToken cancellationToken)
{
return((await _dbQueryHelper.Query <UserRequest>($@"
SELECT u.id, u.firstName, u.lastName, u.email, r.name, r.id as code, r.permissions as permission, u.isActive
FROM [User] u
INNER JOIN [Role] r ON u.RoleId = r.Id
where u.email = @Email" , new { Email = request.UserEmail }))
.Select(user => new UserOutput(user.Id, user.LastName, user.FirstName, user.Email, user.IsActive,
new RoleOutput(user.Name, user.Permission)))
.First());
}
public async Task <IEnumerable <FormattedUserDto> > Handle(GetUsersByEmailQuery request, CancellationToken cancellationToken)
{
var data = await _userBusinessLogic.GetAsync(request.EmailAddress);
return(data);
}
public async Task <IActionResult> Get(string emailAddress)
{
var query = new GetUsersByEmailQuery(emailAddress);
return(await base.Get <GetUsersByEmailQuery, FormattedUserDto>(query));
}
