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