CRUD filtering/sorting doesnt work in asp.net

Question

I have this database that I need to sort/filter. My current code shows no errors, but it does nothing as well.

ApplicationUsersController.cs

// GET: ApplicationUsers
        public ActionResult Index(string sortOrder, string searchString)
        {
            ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewBag.EmailSortParm = sortOrder == "Email" ? "email_desc" : "Email";
            var users = from c in db.Users
                           select c;
            if (!String.IsNullOrEmpty(searchString))
            {
                users = users.Where(c => c.Name.ToUpper().Contains(searchString.ToUpper())
                                       || c.Email.ToUpper().Contains(searchString.ToUpper()));
            }
            switch (sortOrder)
            {
                case "name_desc":
                    users = users.OrderByDescending(c => c.Name);
                    break;
                case "Email":
                    users = users.OrderBy(c => c.Email);
                    break;
                case "email_desc":
                    users = users.OrderByDescending(c => c.Email);
                    break;
                default:
                    users = users.OrderBy(c => c.Name);
                    break;
            }




            return View(db.Users.ToList());
        }

Index.cshtml

@using (Html.BeginForm())
{
    <p>
        Find by name: @Html.TextBox("SearchString")
        <input type="submit" value="Search" />
    </p>
}



<table class="table">
    <tr>
        <th>
            @Html.ActionLink("Email", "Index", new { sortOrder = ViewBag.EmailSortParm })
        </th>
        <th>
            @Html.ActionLink("Name", "Index", new { sortOrder = ViewBag.NameSortParm })
        </th>

Neither sorting, nor filtering seems to work. When sorting, address bar changes to

/ApplicationUsers?sortOrder=name_desc

but the order doesn't change at all. Maybe someone can see where is the problem?

EDIT:

Can it be 'var users = from c in db.Users select c; ' that the letter 'c' is wrong? How can I know for sure?

codeape · Accepted Answer · 2017-04-02 20:43:32Z

2

Change:

return View(db.Users.ToList());

To:

return View(users);

:-)

answered Apr 2, 2017 at 20:43

codeape

102k26 gold badges180 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

odinas1212 Over a year ago

I can't believe how simple that was. Thank you.

Mustapha Larhrouch · Accepted Answer · 2017-04-02 18:54:13Z

1

you need to pass two params to the action Index:

@Html.ActionLink("Email", "Index", new { sortOrder = ViewBag.EmailSortParm, searchString = null })

answered Apr 2, 2017 at 18:54

Mustapha Larhrouch

3,4053 gold badges16 silver badges29 bronze badges

2 Comments

odinas1212 Over a year ago

Thanks for the help, but after putting this line I'm getting Cannot assign <null> to anonymous type property After putting "" instead of "null", sorting still doesn't work.

odinas1212 Over a year ago

Can it be 'var users = from c in db.Users select c; ' that the letter 'c' is wrong? How can I know for sure?

Collectives™ on Stack Overflow

CRUD filtering/sorting doesnt work in asp.net

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related