asp.net core docker Part 64 Implement sorting in asp net mvc

C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
http://www.youtube.com/user/kudvenkat...

In this video, we will discuss, implementing sort functionality in an asp.net mvc application. We will be working with the same example that we started in Part 62. So, please watch Parts 62 and 63 before proceeding with this video.

We want to support bi-directional sorting by Name and Gender columns. Here's the requirement
1. Name & Gender columns must be clickable hyperlinks
2. Clicking on the column headers should sort the data. If the data is not already sorted by the column on which you have clicked, the data should be sorted in ascending order. Clicking again on the same column should sort the data in descending order.
3. By default, the data should be sorted by "Name" in ascending order.

By the end of this video, the output should be as shown below. Notice that "Name" and "Gender" columns are rendered as hyperlinks, which the user can click to sort data.

Step 1: Modify the "Index()" action method in HomeController as shown below.
public ActionResult Index(string searchBy, string search, int? page, string sortBy)
{ ViewBag.NameSort = String.IsNullOrEmpty(sortBy) ? "Name desc" : ""; ViewBag.GenderSort = sortBy == "Gender" ? "Gender desc" : "Gender"; var employees = db.Employees.AsQueryable(); if (searchBy == "Gender") { employees = employees.Where(x =] x.Gender == search || search == null); } else { employees = employees.Where(x =] x.Name.StartsWith(search) || search == null); } switch (sortBy) { case "Name desc": employees = employees.OrderByDescending(x =] x.Name); break; case "Gender desc": employees = employees.OrderByDescending(x =] x.Gender); break; case "Gender": employees = employees.OrderBy(x =] x.Gender); break; default: employees = employees.OrderBy(x =] x.Name); break; } return View(employees.ToPagedList(page ?? 1, 3));
}

Step 2: Modify the code in Index.cshtml view as shown below. Please pay attention to the code highlighted with Grey colour.
@using PagedList;
@using PagedList.Mvc;

@model PagedList.IPagedList[MVCDemo.Models.Employee]

@{ ViewBag.Title = "Index";
}
[link href="~/Content/PagedList.css" rel="stylesheet" type="text/css" /]
[div style="font-family:Arial"]
[h2]Employee List[/h2]
[p] @using (@Html.BeginForm("Index", "Home", FormMethod.Get)) { [b]Search By:[/b] @Html.RadioButton("searchBy", "Name", true) [text]Name[/text] @Html.RadioButton("searchBy", "Gender") [text]Gender[/text][br /] @Html.TextBox("search") [input type="submit" value="search" /] }
[/p]
[table border="1"] [tr] [th] @Html.ActionLink("Name", "Index", new { sortBy = ViewBag.NameSort, searchBy = Request["searchBy"], search = Request["search"] }) [/th] [th] @Html.ActionLink("Gender", "Index", new { sortBy = ViewBag.GenderSort, searchBy = Request["searchBy"], search = Request["search"] }) [/th] [th] @Html.DisplayNameFor(model =] model.First().Email) [/th] [th]Action[/th] [/tr]
@if (Model.Count() == 0)
{ [tr] [td colspan="4"] No records match search criteria [/td] [/tr]
}
else
{ foreach (var item in Model) { [tr] [td] @Html.DisplayFor(modelItem =] item.Name) [/td] [td] @Html.DisplayFor(modelItem =] item.Gender) [/td] [td] @Html.DisplayFor(modelItem =] item.Email) [/td] [td] @Html.ActionLink("Edit", "Edit", new { id = item.ID }) | @Html.ActionLink("Details", "Details", new { id = item.ID }) | @Html.ActionLink("Delete", "Delete", new { id = item.ID }) [/td] [/tr] }
}
[/table]
@Html.PagedListPager(Model, page =] Url.Action("Index", new { page, searchBy = Request.QueryString["searchBy"], search = Request.QueryString["search"], sortBy = Request["sortBy"] }), new PagedListRenderOptions() { Display = PagedListDisplayMode.IfNeeded })
[/div]

asp.net core docker Part 64 Implement sorting in asp net mvc
192 Likes	192 Dislikes
68,874 views views	524K followers
Education	Upload TimePublished on 29 Jul 2013

Related keywords

wcf vs web api,ado.net core,sql server management studio,sorteio loteria federal,webkinz,webadvisor,sorteio da mega sena,craigslist nj,wcf one piece,asp.net core 3,sorteador facebook,ajax players,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,services angular,ajax ontario,asp.net mvc tutorial,sorteio facebook,asp.net cos'è,csharp assembly,tutorialspoint python,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,mvc3 クソル,asp.net zero,mvc3 フランク,sorting out,csharp foreach,server memes,sql date format,services online,chase,serverless architecture,server resume,wcf c#,server books,tutorialspoint javascript,sorting hub taguig,mvcc connect,ado.net mysql,services technologies gps,mvc3 エンディング,ajax deadpool,server jobs,sorteio mega sena hoje,cvs,website,sorteio copa do brasil,mvc tutorial,costco hours,mvc3 ダンテ,sorting machine,wcf service application,tutorialspoint spring,serverless,wcf soap,sorteio libertadores 2019,mvc3 キャラランク,mvc3 ドーマムゥ,wcf cat,cool math games,sorteio ao vivo,wcf test client,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,sorting hat quiz,asp.net core logging,mvconnect,cunyfirst,asp.net guida,wcf nba,csharp download,wcfi foundation,csharp online,sorteador instagram,sorteio tri legal,wcf authentication,mvc3 成歩堂,sorteio lotofacil,tutorials near me,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,sorting table,serverminer,ajax cleaner,ado.net visual studio 2019,sorteio no instagram,sorteio da quina de hoje,webassign,ado.net vs entity framework,ado.net visual studio 2017,csharp list,sorteiogram,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,ajax roster,sorting algorithms c++,mvc architecture,sorting in excel,http://ado.net,sorting hub,sorting hat pottermore,asp.net core mvc,ajax soccer,server hosting,sorting algorithms java,wcfi,sorting center,sorteio,ajax dish soap,capital one,server rack,tutorialspoint html,csharp interface,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,tutorialspoint spring boot,mvc map,csharp online compiler,asp.net download,sql between,ado.net c# pdf,mvc3 デッドプール,services tag dell,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,sorteio da quina,csharpstar,wcf tutorial,sorting out meaning,mvc3 サントラ,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,sorting hat,ado.net c#,asp.net core github,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,sorting in java,server error in '/' application,services windows,asp.net core 3.0,sql injection,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,mvc30a,services google play apk,mvc3 バージル,sqlyog,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,webcam,mvc hours,webmd symptom,csharp array,sorteio tele sena,sorting hat song,csharp enum,sorting centre,ajax call,asp.net core 2. guida completa per lo sviluppatore,mvc3 ウェスカー,asp.net core,server pro,mvc3 ps4,server status ffxiv,cheap flights,webcrims,asp.net core hosting,services sas,sorting hub meaning,tutorialspoint java,tutorialspoint java compiler,webmd,csharp to json,college football,ado.net dataset,csharp dictionary,cnn,website builder,tutorialspoint sql,asp.net web api,server side rendering,sorteie me,weber grills,sql server 2017,mvc3 センチネル,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,webster bank,webstaurant,mvc30,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,ajax jersey,csharp operator,asp.net core razor pages,server duties,asp.net core environment variables,mvc32,csharp random,century 21,mvc3 セリフ,sorting centre shopee,services consultores,services consulting,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,sorteador de nomes,sql update,asp.net tutorial,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,chase online,wcf api,costco,server jobs near me,webex,sql meaning,sorting in tagalog,sql tutorial,sql commands,ado.net entity framework,ajax tavern,tutorialsteacher,ajax javascript,services desk,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,mvc3 ジル,sorting meaning,asp.net core middleware,wcf web service,mvc3 フェニックス,mvc301,mvc webadvisor,sorte online,web store,mvcc,webmail,mvci,mvctc,