How to I apply filter while paginating in Asp.net MVC and entity Framework?

by

Your form needs to post back to the GET method, and that method needs to include parameters for your filter properties. Your PagedListPager code in the view also need to include those filter properties so they are retained when you navigate to the next/previous page. Note that the Index() POST method is not used and can be deleted.

Having your model contain a complex object to the filter properties and extra complexity when binding, so start by changing your model to

public class Presenter
{
    public IPagedList<Task> Tasks { get; set; }
    public int? Status { get; set; } // note nullable
    ... // add any other properties of TasksFiltersViewModel 
    public int PageNumber { get; set; }
    public IEnumerable<SelectListItem> Statuses { get; set; }
}

Then change the Index() method to

public ActionResult Index(int? id, int? status) // add any other parameters your filtering on
{
    int pageNumber = (id ?? 1);
    var tasks = db.Tasks; // IQueryable<Task>
    if (status.HasValue)
    {
        tasks = tasks.Where(x => x.Status == status.Value)
    }
    if (otherParametersHaveValue)
    {
        tasks = tasks.Where(....);
    }
    Presenter model = new Presenter()
    {
        PageNumber = id ?? 1,
        Status = status,
        .... // set any other filter properties from the parameters
        Statuses = new SelectList(...),
        Tasks = tasks.ToPagedList(pageNumber, 30)
    };
    return View(model );
}

and change the view to

// Make the form a GET
@using (Html.BeginForm("Index", "Tasks", FormMethod.Get, new { @class = "form-horizontal" }))
{
    ....
    // Modify expression based on revised model properties
    @Html.DropDownListFor(m => m.Status, Model.Statuses, ...)
}
....
// Add filter parameters to url so they are retained
@Html.PagedListPager(Model.Tasks, id => Url.Action("Index", new { id, status = Model.Status })) // add other filter properties as required

More Related Contents:

  1. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  2. Pass List of Checkboxes into View and Pull out IEnumerable [duplicate]
  3. ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value
  4. Weird Error Upgrading ASP.NET MVC from 4 to 5
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. Do I need a Global.asax.cs file at all if I’m using an OWIN Startup.cs class and move all configuration there?
  7. How to do a Bulk Insert — Linq to Entities
  8. ASP.Net MVC route to catch all *.aspx requests
  9. How to group by on 2 child entities and get total of both this child entities?
  10. When should I create a new DbContext()
  11. Questions about Entity Framework Context Lifetime
  12. The operation cannot be completed because the DbContext has been disposed using MVC 4
  13. MVC 5 Dynamic Rows with BeginCollectionItem
  14. Entity vs Model vs View Model
  15. Export Model to DataTable
  16. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  17. User in Entity type MVC5 EF6
  18. Method ‘RouteCollection.get_AppendTrailingSlash’ not found when using Razor Url helpers in ASP.NET MVC 5 Mono
  19. Set database timeout in Entity Framework
  20. Using a PagedList with a ViewModel ASP.Net MVC
  21. Only primitive types or enumeration types are supported in this context
  22. Keyword Not Supported: Metadata
  23. Entities VS Domain Models VS View Models
  24. Get UserID of logged-in user in Asp.Net MVC 5
  25. Correct way to use HttpContext.Current.User with async await
  26. Login page on different domain
  27. Repository Pattern, POCO, and Business Entities
  28. .NET Managing Layers Relationships
  29. Entity Framework Many to many through containing object
  30. Getting controller name from razor

Leave a Comment