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