Doubt with pagination in Asp.net

Question

Does anyone know how to implement a pagination or would have an example using this architecture https://github.com/cleytonferrari/PadraoDeRepositorio/tree/master/TISelvagem I would like to use the Skip() and Take() from Latin:

As was done in this example MVC Asp.net paging

but I’m having a mistake:

public IEnumerable<Cliente> ListarPagina(int paginaAtual, int itensPorPagina)
{
    return contexto.Cliente.Skip((paginaAtual - 1) * itensPorPagina).Take(itensPorPagina).ToList();
}


public class ListaPaginada<T>
{
    public int TotalItens { get; private set; }
    public int ItensPorPagina { get; private set; }
    public int PaginaAtual { get; private set; }

    public int TotalPaginas
    {
        get { return Math.Ceil(TotalItens / ItensPorPagina); }
    }

    public List<T> Itens { get; private set; }

    public ListaPaginada(List<T> itens, int totalItens, int itensPorPagina, int paginaAtual)
    {
        this.Itens = itens;
        this.TotalItens = totalItens;
        this.ItensPorPagina = itensPorPagina;
        this.PaginaAtual = paginaAtual;
    }
}


public ListaPaginada<Cliente> ListarPagina(int paginaAtual, int itensPorPagina)
{
    var clientes = contexto.Cliente;
    var totalClientes = cliente.Count();
    var clientesDaPagina = cliente.Skip((paginaAtual - 1) * itensPorPagina).Take(itensPorPagina).ToList();

    return new ListaPaginada<Cliente> (clientesDaPagina, totalClientes, itensPorPagina, paginaAtual);
}

Answer 1

I can’t tell you why he used Math.Ceil in that response code. I believe what you want is this class (Math) in C# which in turn has the method Ceiling.

Math.Ceil you will find in Javascript.

On the github link you posted it only uses Math.cel in his javascript (I’m putting this in the answer so you can see that it works in Javascritp). Look at that class his.

Answer 2

There’s a library that could help you with that, it’s called X.Pagedlist and on the project page on Github you can find some examples of using. The library is also available through Nuget.

It may be that that question help you with something, in it I asked for a code review about a pagination control that I manually mounted.

Answer 3

After several attempts I decided to use the Pagedlist Plugin, the final answer was this way:

I thank everyone for the contributions, within the architecture I am studying, already able to make practically all the necessary methods, more count on the help of all for evolution.

        //http://localhost:1608/api/ApiGuiaCidade/consulta/paginacao/1/4
        [HttpGet]
        [Route("consulta/paginacao/{pagina:int}/{pagsize:int}")]
        public HttpResponseMessage ClientesPaginacao(int pagina,int pagsize)
        {
            try
            {
                int PageNumero = (pagina * 1);
                var tCliente = new ClienteAplicacao();
                var listarDeClientes = tCliente.ListarTodos();
                return Request.CreateResponse(HttpStatusCode.OK, listarDeClientes.ToPagedList(PageNumero, pagsize));
            }
            catch (Exception ex)
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message);
            }
        }