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