How to do data sorting and filtering at the same time?

Question

I have a code like this

public async Task Index(string[] searchString, string sortOrder)
    {
        
        ViewBag.CurrentFilter = searchString;
        ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc" : "";
        ViewBag.PriceSortParm = sortOrder == "Price" ? "Price desc" : "Price";

        var cosmetics = from s in db.Cosmetics
                       select s;
        //Sorting logic
        switch (sortOrder)
        {
            case "Name desc":
                cosmetics = cosmetics.OrderByDescending(s => s.Name);
                break;
            case "Price":
                cosmetics = cosmetics.OrderBy(s => s.Price);
                break;
            case "Price desc":
                cosmetics = cosmetics.OrderByDescending(s => s.Price);
                break;
            default:
                cosmetics = cosmetics.OrderBy(s => s.Name);
                break;
        }
        //Filter data logic
        if (searchString.Length != 0)
        {
            var li = new List();

            foreach (string ss in searchString)
            {
                List ll = cosmetics.Where(c => c.Name.Contains(ss)).ToList();
               
                li.AddRange(ll);

            }
            return View(li);
        }

        return View(await cosmetics.ToListAsync());
    }

I want data filtering and sorting to work together. I tried to connect them, but the result was such that all products were displayed regardless of what I passed to "string [] searchString"

Update

Filter data:

Sorting:

Name

Price

mj1313 · Accepted Answer

The searchString is a string array, which can not be regonized in asp-route-searchString. I suggest you could receive the two searchString separately.

Filter:

Sorting:

Name

Price

Controller:

public IActionResult Index(string searchString1, string searchString2, string sortOrder)
{
    ViewBag.CurrentFilter1 = searchString1;
    ViewBag.CurrentFilter2 = searchString2;
    ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc" : "";
    ViewBag.PriceSortParm = sortOrder == "Price" ? "Price desc" : "Price";

    //filter and sort 

}

Update:

If you have different filter conditions, I think javasript can meet it. You could get the filter and sort condition in js then append them as querstring to url manually.

I have made an example based on this, you can refer to below codes:

Model:

public class Car
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Color { get; set; }
    public string Manufacturer { get; set; }
    public string Price { get; set; }
}

View:

@model IEnumerable

@{
    ViewData["Title"] = "Home Page";
}



    Color:
    Black
    White
    

    Manufacturer:
    A
    B
    C
    D

    



        @foreach (var item in Model)
        {
            
        }
    
    
        
            
                @Html.DisplayNameFor(model => model.Name)
            
            
                @Html.DisplayNameFor(model => model.Color)
            
            
                @Html.DisplayNameFor(model => model.Manufacturer)
            
            
                @Html.DisplayNameFor(model => model.Price)
            
        
    
    
                
                    @Html.DisplayFor(modelItem => item.Name)
                
                
                    @Html.DisplayFor(modelItem => item.Color)
                
                
                    @Html.DisplayFor(modelItem => item.Manufacturer)
                
                
                    @Html.DisplayFor(modelItem => item.Price)
                
            


@section scripts{ 
    
}

Controller:

public IActionResult Index(string[] color, string[] manufacturer, string sortOrder)
{
    ViewBag.color = color;
    ViewBag.manufacturer = manufacturer;
    ViewBag.NameSortParm = string.IsNullOrEmpty(sortOrder) ? "Name_desc" : "";
    ViewBag.PriceSortParm = sortOrder == "Price" ? "Price_desc" : "Price";

    var cars = _context.Car.ToList();
    var co_cars = new List();
    var ma_cars = new List();

    if (color.Length != 0)
    {
        foreach (string co in color)
        {
            var colorfiltercars = _context.Car.Where(c => c.Color.Contains(co)).ToList();
            co_cars.AddRange(colorfiltercars);
        }
    }
    else
    {
        co_cars = cars;
    }

    if (manufacturer.Length != 0)
    {
        foreach (string ma in manufacturer)
        {
            var manufacturerfiltercars = _context.Car.Where(c => c.Manufacturer.Contains(ma)).ToList();
            ma_cars.AddRange(manufacturerfiltercars);
        }
    }
    else
    {
        ma_cars = cars;
    }

    var filtercars = co_cars.Intersect(ma_cars);

    switch (sortOrder)
    {
        case "Name_desc":
            filtercars = filtercars.OrderByDescending(s => s.Name);
            break;
        case "Price":
            filtercars = filtercars.OrderBy(s => int.Parse(s.Price));
            break;
        case "Price_desc":
            filtercars = filtercars.OrderByDescending(s => int.Parse(s.Price));
            break;
        default:
            filtercars = filtercars.OrderBy(s => s.Name);
            break;
    }
       
    return View(filtercars.ToList());
}

And the Datasource:

Result:

How to do data sorting and filtering at the same time?

Answers (2)

Related Questions