Filter in Razor Pages

Razor Pages is an alternative to the MVC pattern that makes page-focused coding easier and more productive. This approach consists of a cshtml file and a cshtml.cs file (by design, the two files have the same name).

You can seamlessly integrate the Telerik UI Filter for ASP.NET MVC in Razor Pages applications.

This article describes how to configure the Filter component in a Razor Pages scenario.

For the complete project, refer to the Filter in Razor Pages example.

Getting Started

To bind the Filter DataSource to a data set received from a remote endpoint within a Razor Pages application, follow the next steps:

1. Specify the Read request URL in the DataSource configuration. The URL must refer to the method name in the PageModel.

       @page
       @IndexModel
   
       @(Html.Kendo().DataSource<CustomerViewModel>()
           .Name("dataSource1")
           .Ajax(t =>
           {
               t.Read(r=>r.Url("/Index?handler=Customers").Data("forgeryToken"));
               t.Model(model => model.Id(p => p.CustomerID));
               t.PageSize(20);
           })
       )
   
       @(Html.Kendo().Filter<CustomerViewModel>()
           .Name("filter")
           .ApplyButton(true)
           .ExpressionPreview(true)
           .Fields(f =>
           {
               f.Add(p=>p.CustomerID);
               f.Add(p=>p.Position);
               f.Add(p=>p.CompanyName);
               f.Add(p=>p.Country);
           })
           .FilterExpression(f => {
               f.Add(p => p.Position).IsEqualTo("Sales Representative");
           })
           .DataSource("dataSource1")
       )
   

       @page
       @IndexModel
   
       @{
           var InitialExpression = new CompositeFilterDescriptor();
           InitialExpression.FilterDescriptors.Add(new FilterDescriptor { Member = "Position", Value = "Sales Representative", Operator = FilterOperator.IsEqualTo });
       }
   
       <kendo-datasource name="dataSource1" type="DataSourceTagHelperType.Ajax" page-size="20">
           <transport>
               <read type="post" url="/Index?handler=Customers" data="forgeryToken" />
           </transport>
           <schema>
               <model id="CustomerID"></model>
           </schema>
       </kendo-datasource>
   
       <kendo-filter name="filter" apply-button="true" expression-preview="true" 
           expression="InitialExpression"
           datasource-id="dataSource1">
           <fields>
               <filter-field name="CustomerID"></filter-field>
               <filter-field name="Position"></filter-field>
               <filter-field name="CompanyName"></filter-field>
               <filter-field name="Country"></filter-field>
           </fields>
       </kendo-filter>
   

2. Add an AntiForgeryToken at the top of the page.

       @inject Microsoft.AspNetCore.Antiforgery.IAntiforgery Xsrf
       @Html.AntiForgeryToken()
   

3. Send the AntiForgeryToken with the Read request.

       <script>
           function forgeryToken() {
               return kendo.antiForgeryTokens();
           }
       </script>
   

   Additional parameters can also be supplied.

       <script>
           function forgeryToken() {
               return {
                   __RequestVerificationToken: kendo.antiForgeryTokens().__RequestVerificationToken,
                   additionalParameter: "test"
               }
           }
       </script>
   

4. Within the cshtml.cs file, add a handler method for the Read operation that returns the dataset.

       public static IList<CustomerViewModel> Customers;
       public static IList<string> Countries = new List<string>() {"UK", "Germany", "Italy", "Venezuela", "China", "Bulgaria", "USA" };
       public static IList<string> Positions = new List<string>() { "Sales Agent", "Sales Representative",  "Owner",  "Order Administrator", "Marketing Manager", "Accounting Manager" };
   
       public void OnGet()
       {
           if (Customers == null)
           {
               // Populate the "Customers" collection with data.
               Customers = new List<CustomerViewModel>();
               var rand = new Random();
               for (int i = 1; i < 40; i++)
               {
                   Customers.Add(new CustomerViewModel() { 
                       CustomerID=i,
                       CompanyName="Company " + i,
                       Position = Positions[rand.Next(0,5)],
                       Country = Countries[rand.Next(0, 6)],
                   });
               }
           }
       }
   
       public JsonResult OnPostCustomers([DataSourceRequest]DataSourceRequest request)
       {
           return new JsonResult(Customers.ToDataSourceResult(request));
       }
   

       public class CustomerViewModel
       {
           public int CustomerID { get; set; }
           public string ContactName { get; set; }
           public string Position { get; set; }
           public string CompanyName { get; set; }
           public string Country { get; set; }
       }
   

See Also

• Using Telerik UI for ASP.NET Core in Razor Pages
• Client-Side API of the Filter
• Server-Side HtmlHelper API of the Filter
• Server-Side TagHelper API of the Filter
• Knowledge Base Section