In the previous post,Paging data, NOT client side. | Universidad Net, I described how to use OFFSET-FETCH pair to paginate data in the server side. In this one, I will describe an example of how to use it in a Web Assembly App.
Note: To test this code, you must create a new Blazor app in Visual Studio.
The Model.
The data model will be a class with two properties, one for the list of items and other with the page’s information.
This classes will be added in the Shared project of the Application.
The first class vary depending on the data you want to display, but the second one will be always the same, enhanced by some code.
Since the pager class will be a standardized and enhanced version of the data retrieved by using the stored procedure, and could be used in different projects, let’s define an interface for it.
IPagesInfo interface.
This is the code for the Interface.
public interface IPagesInfo { #region Properties /// <summary> /// Gets or sets the current page..... /// </summary> System.Int32 CurrentPage { get; set; } /// <summary> /// Gets the current first page number.. /// </summary> Int32 FirstPageNumber { get; } /// <summary> /// Gets the HasNextGroup /// Gets a value indicating whether this instance has next page.. /// </summary> Boolean HasNextGroup { get; } /// <summary> /// Gets the HasPreviousGroup /// Gets a value indicating whether this instance has previous page.. /// </summary> Boolean HasPreviousGroup { get; } /// <summary> /// Gets the last page number.. /// </summary> Int32 LastPageNumber { get; } /// <summary> /// Gets or sets the number of links to show.. /// </summary> Int32 NumberOfLinks { get; set; } /// <summary> /// Gets or sets the size of the page..... /// </summary> System.Int32 PageSize { get; set; } /// <summary> /// Gets or sets the Qty of rows skipped from the top of the select..... /// </summary> System.Int32 Skip { get; set; } /// <summary> /// Gets or sets the Qty of rows taken..... /// </summary> System.Int32 Take { get; set; } /// <summary> /// Gets or sets the amount of items to display. /// </summary> System.Int32 TotalItems { get; set; } /// <summary> /// Gets the total pages available to display.. /// </summary> Int32 TotalPages { get; } /// <summary> /// Gets the page number for the previous group start. /// </summary> /// <value> /// The page number. /// </value> Int32 PreviousGroupStart { get; } /// <summary> /// Gets the page number for the next group start. /// </summary> /// <value> /// The page number. /// </value> Int32 NextGroupStart { get; } #endregion }
PagerInfo class.
Here, you have the code for the class implementing the IPagesInfo interface.
Notice the class is responsible of the calculations about page numbers displayed, if there are next or previous groups of pages, etc.
public class PagerInfo : IPagesInfo { #region Fields /// <summary> /// Defines the lastPageNumber. /// </summary> internal Int32 lastPageNumber = 0; #endregion #region Properties public Int32 TotalPages { get => (Int32)Math.Ceiling(TotalItems / (Double)PageSize); } /// <summary> /// Gets the page number for the previous group start. /// </summary> /// <value> /// The page number. /// </value> public Int32 PreviousGroupStart => LastPageNumber - NumberOfLinks; /// <summary> /// Gets the page number for the next group start. /// </summary> /// <value> /// The page number. /// </value> public Int32 NextGroupStart => LastPageNumber + 1; /// <summary> /// Gets or sets the current page. /// </summary> public System.Int32 CurrentPage { get; set; } /// <summary> /// Gets the current first page number.. /// </summary> public Int32 FirstPageNumber { get => LastPageNumber - (NumberOfLinks - 1); } /// <summary> /// Gets a value indicating whether this instance has next page. /// </summary> public Boolean HasNextGroup { get => CurrentPage + NumberOfLinks < TotalPages; } /// <summary> /// Gets a value indicating whether this instance has previous page. /// </summary> public Boolean HasPreviousGroup { get => CurrentPage > NumberOfLinks; } /// <summary> /// Gets the last page number.. /// </summary> public Int32 LastPageNumber { get { lastPageNumber = (Int32)Math.Ceiling((Double)CurrentPage / NumberOfLinks) * NumberOfLinks; if (lastPageNumber > TotalPages) { lastPageNumber = TotalPages; } return lastPageNumber; } } /// <summary> /// Gets or sets the number of links to show.. /// </summary> public Int32 NumberOfLinks { get; set; } = 10; /// <summary> /// Gets or sets the size of the page..... /// </summary> public System.Int32 PageSize { get; set; } /// <summary> /// Gets or sets the Qty of rows skipped from the top of the select..... /// </summary> public System.Int32 Skip { get; set; } /// <summary> /// Gets or sets the Qty of rows taken..... /// </summary> public System.Int32 Take { get; set; } /// <summary> /// Gets or sets the amount of items to display. /// </summary> public System.Int32 TotalItems { get; set; } /// <summary> /// Gets the total pages available to display.. /// </summary> #endregion }
The Data Class.
This class will contain your data and the IPagesInfo properties. In this sample, it will be called PersonsPager.
Note: You can easily create it by executing the stored procedure, copying the result and in a new code window (for example, an empty one created for PersonsPager), paste it by the Edit – Paste Special-Past JSON as Classes.
Then replace the names autogenerated by your own and change the type for the second one for the PagesInfo class.
The pasted code names the main class as Rootobject, which has been renamed to PersonsPager.
The Pager class will be changed by PagesInfo, and the Pager class defined could be removed.
This is the final code for the PersonsPager class.
public class PersonsPager { public List[] List { get; set; } public PagerInfo Pager { get; set; } }
public class List { public int BusinessEntityID { get; set; } public string FirstName { get; set; } public string MiddleName { get; set; } public string LastName { get; set; } }
The Pager Component.
You must add a Razor Component. In this sample, it is called Pager.razor.
In the UI code, I use an UL tag, adding a button for previous group of pages (when the user moves beyond the first set of page numbers), buttons for the different page numbers, and a button for the next group as well.
For the buttons, the pagination, page-item, and page-link classes are used.
<nav class="text-center"> <ul class="pagination"> @{//Previous page group button. string className = "page-item " + (!PagesInfo.HasPreviousGroup ? " disabled" : ""); //If there is in previous group, the button will be disabled <li class="@className"> <button class="page-link " @onclick="@(()=> { if (PagesInfo.HasPreviousGroup) ChangePage(PagesInfo.PreviousGroupStart); } )"> ⏪ </button> </li> } @*Buttons for page numbers*@ @for (Int32 i = PagesInfo.FirstPageNumber; i <= PagesInfo.LastPageNumber; i++) { int pageSelector = i; className = "page-item " + (i == PagesInfo.CurrentPage ? " active" : ""); <li class="@className"> <button class="page-link" @onclick="@(()=>ChangePage(pageSelector))">@string.Format("{0:00}", pageSelector)</button> </li> } @{//Next page group button. className = "page-item " + (!PagesInfo.HasNextGroup ? " disabled" : ""); <li class="@className"> <button class="page-link " @onclick="@(()=> { if (PagesInfo.HasNextGroup) ChangePage(PagesInfo.NextGroupStart); } )"> ⏩ </button> </li> } </ul> </nav>
In the code section, parameters are defined for:
- an instance of a class implementing the IPagerInfo
- a value to persist the selected page
- an EventCallback to notify the client page about the changes in the selection by the user.
Finally, the ChangePage function called every time the user clicks ant of the buttons is defined to change the selected page and notify the client page.
@code { [Parameter] public IPagesInfo PagesInfo { get; set; } [Parameter] public int SelectedPage { get => PagesInfo.CurrentPage; set => PagesInfo.CurrentPage = value; } [Parameter] public EventCallback OnPageChange { get; set; } void ChangePage(int newPage) { PagesInfo.CurrentPage = newPage; SelectedPage = newPage; OnPageChange.InvokeAsync(SelectedPage); } }
The controller.
To get the information from the database, you will need an API REST controller which returns the JSON string from the stored procedure.
The method must be decorated with the HttpGet attribute to react when the client page code calls it.
[Route("/[controller]")] [ApiController] public class PersonDataController : ControllerBase { public PersonDataController(IConfiguration configuration) { Configuration = configuration; } public IConfiguration Configuration { get; } [HttpGet] public async Task<string> GetPersons(int selectedPage, int pageSize = 10) { using SqlConnection con = new SqlConnection(Configuration.GetConnectionString("aw")); try { SqlCommand com = new SqlCommand("[Person].[Person_GetforPager]", con); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.AddWithValue("@skip", (selectedPage == 0 ? 0 : selectedPage - 1) * pageSize); com.Parameters.AddWithValue("@take", pageSize); con.Open(); string values = (await com.ExecuteScalarAsync()).ToString(); return values; } catch (System.Exception ex) { throw; } } }
The client page.
A new component will be defined to display the data.
It will contain any type of display for your data (in the sample, it is just a UL list), and an instance of the Pager component.
As usual in a Web assembly app, you must check if you have data to display before performing the UI generation.
Moreover, you can decide if you need display the pager component in case of no more than one page is needed to display the information.
@inject HttpClient httpClient <h3>Persons</h3> @if (result != null) { <div>@result.StatusCode</div> <div>@result.Content.ReadAsStringAsync().Result</div> <div>@httpClient.BaseAddress</div> } @if (personsPager != null && personsPager.List.Count() > 0) { <ul> @foreach (var item in personsPager.List) { <li>@item.LastName</li> } </ul> @if (personsPager.Pager != null && personsPager.Pager.TotalPages > 1) { <Pager PagesInfo="PagesInfo" OnPageChange="ChangePage" /> @**@ } } else SelectedPage = 1;
The code of this page will call the controller get method to retrieve the information.
@code { PersonsPager personsPager; int SelectedPage; public IPagesInfo PagesInfo { get => personsPager.Pager; } HttpResponseMessage result; protected async override Task OnInitializedAsync() { await GetDataAsync(); } async void ChangePage() { SelectedPage = personsPager.Pager.CurrentPage; //SelectedPage = PagesInfo.CurrentPage; await GetDataAsync(); this.StateHasChanged(); } async Task GetDataAsync() { //result = await httpClient.GetAsync($"PersonData?Selectedpage={SelectedPage}"); personsPager = await httpClient.GetFromJsonAsync<PersonsPager>($"PersonData?Selectedpage={SelectedPage}"); } }
And this is the result:
Note: The “aw” connection string points to the AdventureWorks2017 database where the stored procedure from the previous post has been created.
BTW here is the sample
