public async Task <IApplicationResult <DadosPaginadosViewModel <AssuntoViewModel> > > ObterPorFiltroAsync(AssuntoFiltroRequest request) { var result = new ApplicationResult <DadosPaginadosViewModel <AssuntoViewModel> >(); DynamicParameters parameters = new DynamicParameters(); parameters.Add("@valor", request.Valor, DbType.String, ParameterDirection.Input); parameters.Add("@offset", (request.Page - 1) * request.PageSize, DbType.Int32, ParameterDirection.Input); parameters.Add("@pageSize", request.PageSize, DbType.Int32, ParameterDirection.Input); using (var connection = new SqlConnection(Configuration.GetConnectionString("DefaultConnection"))) { connection.Open(); var dadosPaginados = new DadosPaginadosViewModel <AssuntoViewModel>(request); using (var multi = await connection.QueryMultipleAsync(AssuntoRawSqls.ObterPorFiltro, parameters)) { dadosPaginados.Registros = multi.Read <AssuntoViewModel>().ToList(); dadosPaginados.Controle.TotalRegistros = multi.ReadFirst <int>(); result.Result = dadosPaginados; } connection.Close(); } return(result); }
public async Task <IActionResult> GetAll([FromQuery] AssuntoFiltroRequest request) { return(await AssuntoQuery.ObterPorFiltroAsync(request)); }