public async Task <IEnumerable <UserOutput> > Handle(GetUsersQuery 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"))
.Select(user => new UserOutput(user.Id, user.LastName, user.FirstName, user.Email, user.IsActive,
new RoleOutput(user.Name, user.Permission))));
}
public async Task <IEnumerable <RfaOutput> > Handle(GetAllRfasQuery request, CancellationToken cancellationToken)
{
return((await _dbQueryHelper.Query <RfaRequest>(@"
select
rfa.PhoneNumber, rfa.Profession,
[User].LastName, [User].FirstName, rfa.Email
from RfaInfo rfa
inner join [User] on [User].Id = rfa.UserId
where [User].isActive = 1;
")).Select(rfa => new RfaOutput(rfa.PhoneNumber, rfa.Profession, new RfaUserOutput(rfa.LastName, rfa.FirstName, rfa.Email))));
}
public async Task <ApplicationInfoOutput> Handle(GetApplicationInfoQuery request, CancellationToken cancellationToken)
{
return((await _dbQueryHelper.Query <ApplicationInfoOutput>(@"
select NameApp, VersionApp, CodeApp from ApplicationInfo;
")).Last());
}