public async Task <IEnumerable <PermissaoViewModel> > Handle(BuscarTodos <PermissaoViewModel> request, CancellationToken cancellationToken)
{
using (var connection = _context.Database.GetDbConnection())
{
var sql = @"SELECT [Id]
,[Atribuicao_Valor] as Valor
,[Atribuicao_Tipo] as Tipo
FROM [permissoes] WHERE [DeletadoEm] IS NULL";
var result = await connection.QueryAsync <PermissaoViewModel>(sql);
return(result);
}
}
public async Task <IEnumerable <PerfilViewModel> > Handle(BuscarTodos <PerfilViewModel> request, CancellationToken cancellationToken)
{
using (var connection = _context.Database.GetDbConnection())
{
var sql = @"SELECT [Id]
,[Nome]
,[Descricao]
,[DeletadoEm]
FROM [perfis] WHERE [DeletadoEm] IS NULL";
var perfis = await connection.QueryAsync <PerfilViewModel>(sql);
return(perfis);
}
}
public async Task <IEnumerable <UsuarioViewModel> > Handle(BuscarTodos <UsuarioViewModel> request, CancellationToken cancellationToken)
{
using (var connection = _context.Database.GetDbConnection())
{
var sql = @"SELECT
[Id]
,[PrimeiroNome] AS Nome
,[Sobrenome]
,[Email]
FROM [usuarios] WHERE [DeletadoEm] IS NULL";
var query = await connection.QueryAsync <UsuarioViewModel>(sql);
return(query);
}
}