MVC Filter Data in Table based on Tab-CodePudding

I'm trying to filter the data in the table by clicking on a tab, but I have no idea how to bind data in views.

The view code(Tab):

<ul  role="tablist">
     <li  role="presentation">
          <a  data-bs-toggle="tab" role="tab" aasp-action="">North</a>
     </li>
     <li  role="presentation">
          <a  data-bs-toggle="tab" role="tab" tabindex="-1">South</a>
     </li>
</ul>

The view code(Data Table):

<table >
    <thead>
        <tr>
            <th>Region Name</th>
            <th>Country Name</th>
        </tr>
    </thead>
    <tbody>
        @foreach(var data in @Model.Where(data => data.Region_Name.Trim() == REGION_NAME_BASED_ON_TAB).ToList())
        {
        <tr>
            <td>@data.Region_Name</td>
            <td>@data.Country_Name</td>
        </tr>
        }                     
    </tbody>
</table>

as I know maybe this could be solved by using Controller, What would the syntax for this look like?

any suggestions would be helpful.

Thanks!

CodePudding user response：

Assuming you are using Entity Framwework

public IActionResult Index(string? REGION_NAME_BASED_ON_TAB)
    {
        var model = from s in db.<YourTableName>
                    select s;

        if (!String.IsNullOrEmpty(REGION_NAME_BASED_ON_TAB))
        {
            model = model.Where(a => a.Region_Name.ToLower().Contains(REGION_NAME_BASED_ON_TAB.ToLower()));
        }


        return View(model.ToList());
    }

Add this before your lising begin

  <li  role="presentation">
          <a  data-bs-toggle="tab" role="tab"  href="@Url.Action("Index","YoutController",new{REGION_NAME_BASED_ON_TAB= "North"})>North</a>
     </li>