public async Task <Pagination <Servico> > ListAsync(int offset, int limit) { this._logger.LogDebug("Starting ListAsync"); this._logger.LogDebug("Validating pagination parameters"); if (limit - offset > 100) { this._validationService.Throw("Limit", "Too much items for pagination", limit, Validation.PaginationExceedsLimits); } this._logger.LogDebug("Retriving paginated list of Servicos"); var list = await _sqlService.ListAsync <Servico>(ServicosQuery.PAGINATE, new { Offset = offset, Limit = limit }); this._logger.LogDebug("Retriving the number of Servicos"); var total = await _sqlService.CountAsync(ServicosQuery.TOTAL, new { CreatedBy = _authenticatedService.Token().Subject }); this._logger.LogDebug("Retriving the number of servicos"); var pagination = new Pagination <Servico>() { Offset = offset, Limit = limit, Items = list, Total = total }; this._logger.LogDebug("Ending ListAsync"); return(pagination); }
public async Task <Pagination <ServicoFuncionario> > ListAsync(int offset, int limit, int servicoId) { this._logger.LogDebug("Starting ListAsync"); this._logger.LogDebug("Validating pagination parameters"); if (limit - offset > 100) { this._validationService.Throw("Limit", "Too much items for pagination", limit, Validation.PaginationExceedsLimits); } this._logger.LogDebug("Retriving paginated list of products"); var list = await _sqlService.ListAsync <ServicoFuncionario>(ServicoFuncionarioQuery.PAGINATE, new { Offset = offset, Limit = limit, SERVICOID = servicoId }); this._logger.LogDebug("Retriving the number of funcionarios registered by the authenticated funcionario"); var total = await _sqlService.CountAsync(ServicoFuncionarioQuery.TOTAL, new { SERVICOID = servicoId }); this._logger.LogDebug("Retriving the number of funcionarios registered by the authenticated funcionario"); var pagination = new Pagination <ServicoFuncionario>() { Offset = offset, Limit = limit, Items = list, Total = total }; this._logger.LogDebug("Ending ListAsync"); return(pagination); }
public async Task <Pagination <EnderecoFuncionario> > ListAsync(int offset, int limit, int funcionarioId) { this._logger.LogDebug("Starting ListAsync"); this._logger.LogDebug("Validating pagination parameters"); if (limit - offset > 100) { this._validationService.Throw("Limit", "Too much items for pagination", limit, Validation.PaginationExceedsLimits); } this._logger.LogDebug("Retriving paginated list of enderecos"); var list = await _sqlService.ListAsync <EnderecoFuncionario>(EnderecosFunQuery.PAGINATE, new { Offset = offset, Limit = limit, FUNCIONARIOID = funcionarioId }); this._logger.LogDebug("Retriving the number of enderecos registered"); var total = await _sqlService.CountAsync(EnderecosFunQuery.TOTAL, new { FUNCIONARIOID = funcionarioId }); this._logger.LogDebug("Retriving the number of enderecos registered"); var pagination = new Pagination <EnderecoFuncionario>() { Offset = offset, Limit = limit, Items = list, Total = total }; this._logger.LogDebug("Ending ListAsync"); return(pagination); }
public async Task <Pagination <ContatoCliente> > ListAsync(int offset, int limit, int clienteId) { this._logger.LogDebug("Starting ListAsync"); this._logger.LogDebug("Validating pagination parameters"); if (limit - offset > 100) { this._validationService.Throw("Limit", "Too much items for pagination", limit, Validation.PaginationExceedsLimits); } this._logger.LogDebug("Retriving paginated list of contatos"); var list = await _sqlService.ListAsync <ContatoCliente>(ContatoClienteQuery.PAGINATE, new { Offset = offset, Limit = limit, ClienteId = clienteId }); this._logger.LogDebug("Retriving the number of contatos registered"); var total = await _sqlService.CountAsync(ContatoClienteQuery.TOTAL, new { }); this._logger.LogDebug("Retriving the number of contatos registered"); var pagination = new Pagination <ContatoCliente>() { Offset = offset, Limit = limit, Items = list, Total = total }; this._logger.LogDebug("Ending ListAsync"); return(pagination); }