public async Task <PageedList <Order> > GetPagedListAsync(int PageNumber, int PageSize, bool Shipped)
        {
            PageedList <Order> pageed = new PageedList <Order>();
            var result = await GetListAsync(false);

            pageed.ListItem             = result.OrderBy(c => c.ID).Skip((PageNumber - 1) * PageSize).Take(PageSize).ToList();
            pageed.pageData.TotalItem   = result.Count;
            pageed.pageData.ItemPerPage = PageSize;
            return(pageed);
        }
        public async Task <PageedList <Product> > GetPagedProductAsync(string Category, int PageSize, int PageNumber)
        {
            var query = _context.Products.Where(c => string.IsNullOrWhiteSpace(Category) || c.Category.Equals(Category));
            PageedList <Product> Result = new PageedList <Product>();

            Result.pageData.TotalItem   = query.Count();
            Result.pageData.ItemPerPage = PageSize;
            Result.pageData.CurentItem  = PageNumber;
            Result.ListItem             = await query.OrderBy(c => c.ID).Skip((PageNumber - 1) * PageSize).Take(PageSize).ToListAsync();

            return(Result);
        }