Summarize this content to 400 words in Persian Lang \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0639\u0645\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u0627\u0645\u067e\u0648\u0646\u0646\u062a jQuery DataTables.net \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 Asp.Net 8 MVC.<\/p>\n
\u0686\u06a9\u06cc\u062f\u0647: \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0639\u0645\u0644\u06cc \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Asp.Net 8 MVC \u06a9\u0647 \u0627\u0632 \u0645\u0648\u0644\u0641\u0647 jQuery DataTables.net \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0627\u062f\u0627\u0645\u0647 \u0645\u0642\u0627\u0644\u0647 Part8 \u0627\u0633\u062a.<\/p>\n
1 ASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 jQuery DataTables.net<\/p>\n
\u0645\u0646 \u0645\u0648\u0644\u0641\u0647 jQuery DataTables.net \u0631\u0627 \u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0631\u062f\u0645 [1] \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631 \u067e\u0631\u0648\u0698\u0647 \u0647\u0627\u06cc ASP.NET8 \u0648 \u0627\u06cc\u062c\u0627\u062f \u0686\u0646\u062f\u06cc\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0646\u0645\u0648\u0646\u0647 \u0627\u0648\u0644\u06cc\u0647 (\u0627\u062b\u0628\u0627\u062a \u0645\u0641\u0647\u0648\u0645). \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0627\u062a \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n
1.1 \u0645\u0642\u0627\u0644\u0627\u062a \u0627\u06cc\u0646 \u0645\u062c\u0645\u0648\u0639\u0647<\/p>\n
\u0645\u0642\u0627\u0644\u0627\u062a \u0627\u06cc\u0646 \u0645\u062c\u0645\u0648\u0639\u0647 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n
ASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part1 \u2013 Foundation
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06a9\u0645\u0647 \u0647\u0627\u06cc DataTables.net \u2013 Part2 \u2013 Action
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part3 \u2013 \u062d\u0627\u0644\u062a \u0630\u062e\u06cc\u0631\u0647
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part4 \u2013 Multilingual
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part5 \u2013 \u0627\u0631\u0633\u0627\u0644 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u062f\u0631 AJAX
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part6 \u2013 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u062f\u0631 AJAX
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part7 \u2013 \u062f\u06a9\u0645\u0647 \u0647\u0627\u06cc \u0645\u0646\u0638\u0645
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part8 \u2013 \u0633\u0637\u0631\u0647\u0627 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f
\nASP.NET8 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DataTables.net \u2013 Part9 \u2013 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647<\/p>\n
2 \u0646\u062a\u06cc\u062c\u0647 \u0646\u0647\u0627\u06cc\u06cc<\/p>\n
\u0647\u062f\u0641 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u062b\u0628\u0627\u062a \u0645\u0641\u0647\u0648\u0645 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0624\u0644\u0641\u0647 DataTables.net \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u0641\u06cc\u0644\u062a\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0633\u0641\u0627\u0631\u0634\u06cc. \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n
\u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644\u060c \u0641\u06cc\u0644\u062a\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0645\u0624\u0644\u0641\u0647 DataTables.net \u0631\u0627 \u062f\u0631 \u06af\u0648\u0634\u0647 \u0628\u0627\u0644\u0627 \u0633\u0645\u062a \u0631\u0627\u0633\u062a \u063a\u06cc\u0631\u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u06cc\u0645 \u0648 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u0645. \u0641\u0631\u0645 \u0633\u0641\u0627\u0631\u0634\u06cc \u0641\u06cc\u0644\u062a\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647. \u06a9\u0627\u062f\u0631 \u0641\u06cc\u0644\u062a\u0631 (\u062c\u0633\u062a\u062c\u0648) \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0633\u0627\u062f\u0647 \u0628\u0648\u062f \u0648 \u0645\u0642\u062f\u0627\u0631 \u06cc\u06a9\u0633\u0627\u0646\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0645\u0647 \u0633\u062a\u0648\u0646 \u0647\u0627 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0631\u062f. \u0627\u063a\u0644\u0628 \u062f\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0647\u0627\u06cc \u062d\u0631\u0641\u0647 \u0627\u06cc\u060c \u0641\u0631\u062f \u0628\u0647 \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc \u0641\u06cc\u0644\u062a\u0631\u06cc\u0646\u06af \u062f\u0642\u06cc\u0642 \u062a\u0631\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f.<\/p>\n
\u0645\u0646 \u0628\u0627 \u062f\u0642\u062a \u0628\u0647 \u0633\u0627\u06cc\u062a \u0646\u06af\u0627\u0647 \u06a9\u0631\u062f\u0645 [1] \u062f\u0631 \u062a\u0645\u0627\u0645 \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627 \u0648 \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0624\u0644\u0641\u0647 DataTables.net \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u0645\u0627 \u0645\u0646 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u06a9\u0647 \u0622\u0646\u062c\u0627 \u0628\u0648\u062f \u062f\u0648\u0633\u062a \u0646\u062f\u0627\u0634\u062a\u0645\u060c \u0647\u06cc\u0686 \u0686\u06cc\u0632 \u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 \u06a9\u0627\u0641\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646\u0645 \u062d\u0631\u0641\u0647 \u0627\u06cc \u0646\u0628\u0648\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u062a\u0635\u0645\u06cc\u0645 \u06af\u0631\u0641\u062a\u0645 \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u062f\u0631 ASP.NET \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0645 \u0648 \u0641\u06cc\u0644\u062a\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0633\u0641\u0627\u0631\u0634\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u0645 \u0648 \u062c\u0632\u0621 DataTables.net \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0631\u0627\u0626\u0647 \u062c\u062f\u0648\u0644 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u06a9\u0646\u0645. \u0631\u0627\u0647 \u062d\u0644 \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0647\u0645\u0627\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u0646 \u0628\u0647 \u0622\u0646 \u0631\u0633\u06cc\u062f\u0645.<\/p>\n
3 \u0641\u0631\u0645 \u0641\u06cc\u0644\u062a\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647<\/p>\n
\u0641\u06cc\u0644\u062a\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0633\u0641\u0627\u0631\u0634\u06cc \u0641\u0642\u0637 \u06cc\u06a9 \u0641\u0631\u0645 \u062f\u06cc\u06af\u0631 ASP.NET \u0627\u0633\u062a \u0648 \u0645\u0646 \u062a\u0635\u0645\u06cc\u0645 \u06af\u0631\u0641\u062a\u0645 \u062d\u0627\u0644\u062a \u0641\u06cc\u0644\u062a\u0631 \u0631\u0627 \u062f\u0631 \u0634\u06cc\u0621 ASP.NET Session \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 \u0637\u0648\u0644 \u0647\u0631 \u062a\u0645\u0627\u0633 AJAX \u0628\u0631\u0627\u06cc \u0645\u0624\u0644\u0641\u0647 DataTables \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0628\u0627\u0634\u062f. \u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 “\u0648\u0636\u0639\u06cc\u062a \u0641\u06cc\u0644\u062a\u0631” \u0628\u06cc\u0646 \u0627\u0642\u062f\u0627\u0645\u0627\u062a \/ \u0641\u0631\u0645 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0647 \u0627\u0634\u062a\u0631\u0627\u06a9 \u06af\u0630\u0627\u0634\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0627\u06cc\u0646\u0645 \u06a9\u062f \u0645\u0631\u0628\u0648\u0637\u0647<\/p>\n
\/\/HomeController.cs ======================================<\/p>\n
public class HomeController : Controller
\n{
\npublic const string EMPLOYEES_ADVANCED_FILTER_STATE = “EMPLOYEES_ADVANCED_FILTER_STATE”;<\/p>\n
public IActionResult EmployeesAdvancedFilter(EmployeesAdvancedFilterVM model)
\n{
\n try
\n {
\n ISession ? CurrentSession=this.HttpContext?.Session;<\/p>\n
if (model.IsSubmit)
\n {
\n \/\/we have submit
\n \/\/we save the advanced-filter state to session
\n if (CurrentSession != null && model != null)
\n {
\n model.FirstName=model.FirstName?.Trim();
\n model.LastName = model.LastName?.Trim();
\n model.City = model.City?.Trim();
\n model.Country = model.Country?.Trim();
\n string jsonUserEmployeesAdvancedFilterState = JsonSerializer.Serialize(model);
\n CurrentSession.SetString(EMPLOYEES_ADVANCED_FILTER_STATE, jsonUserEmployeesAdvancedFilterState);
\n }<\/p>\n
return RedirectToAction(“Employees”, “Home”);
\n }
\n else if (model.IsReset)
\n {
\n \/\/we have reset
\n \/\/we clear advanced-filter state in session
\n CurrentSession?.Remove(EMPLOYEES_ADVANCED_FILTER_STATE);
\n }<\/p>\n
\/\/go for presentation
\n {
\n \/\/we get advanced-filter state from session if there is one
\n string? jsonUserEmployeesAdvancedFilterState = CurrentSession?.GetString(EMPLOYEES_ADVANCED_FILTER_STATE);<\/p>\n
if (!string.IsNullOrEmpty(jsonUserEmployeesAdvancedFilterState))
\n {
\n model = JsonSerializer.Deserialize<EmployeesAdvancedFilterVM>(jsonUserEmployeesAdvancedFilterState)
\n ?? new EmployeesAdvancedFilterVM();
\n }
\n }
\n }
\n catch (Exception ex)
\n {
\n Console.WriteLine(ex.ToString());
\n }<\/p>\n
return View(model);
\n}<\/p>\n
\/\/EmployeesAdvancedFilterVM.cs
\nnamespace Example09.Models.Home
\n{
\n public class EmployeesAdvancedFilterVM
\n {
\n \/\/model
\n public string? FirstName { get; set; } = null;
\n public string? LastName { get; set; } = null;
\n public string? City { get; set; } = null;
\n public string? Country { get; set; } = null;
\n public bool IsSubmit { get; set; } = false;
\n public bool IsReset { get; set; } = false;<\/p>\n
\/\/view model
\n }
\n}<\/p>\n
<!– EmployeesAdvancedFilter.cshtml –>
\n@using Example09.Models.Home;<\/p>\n
@model EmployeesAdvancedFilterVM<\/p>\n
@{
\n <div class=”text-center”>
\n <h3 class=”display-4″>Employees Advanced Filter<\/h3>
\n <\/div><\/p>\n
<fieldset class=”border rounded-3 p-3″ style=”width:600px”>
\n <legend class=”float-none w-auto px-3″>Choose filter parameters<\/legend><\/p>\n
<p class=”bg-light m-1 border p-1″>
\n * = whildchar, zero or more characters <br\/>
\n ? = whildchar, one character
\n <\/p><\/p>\n
<form id=”form1″ method=”post”> <\/p>\n
<div class=”form-group”>
\n <label asp-for=FirstName>Given Name<\/label>
\n <input class=”form-control” asp-for=”FirstName” \/>
\n <\/div><\/p>\n
<div class=”form-group”>
\n <label asp-for=LastName>Family Name<\/label>
\n <input class=”form-control” asp-for=”LastName” \/>
\n <\/div><\/p>\n
<div class=”form-group”>
\n <label asp-for=City>Town<\/label>
\n <input class=”form-control” asp-for=”City” \/>
\n <\/div><\/p>\n
<div class=”form-group”>
\n <label asp-for=Country><\/label>
\n <input class=”form-control” asp-for=”Country” \/>
\n <\/div><\/p>\n
<button type=”submit” form=”form1″ class=”btn btn-primary mt-3 ms-3 float-end” asp-area=””
\n asp-controller=”Home” asp-action=”EmployeesAdvancedFilter” asp-route-IsSubmit=”true”>
\n Submit
\n <\/button><\/p>\n
<a class=”btn btn-primary mt-3 float-end” asp-area=””
\n asp-controller=”Home” asp-action=”EmployeesAdvancedFilter” asp-route-IsReset=”true”>
\n Reset
\n <\/a>
\n <\/form>
\n <\/fieldset>
\n}<\/p>\n
4 \u062c\u0632\u0621 DataTables.net \u0633\u0645\u062a \u06a9\u0644\u0627\u06cc\u0646\u062a<\/p>\n
\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0646 \u0641\u0642\u0637 \u0646\u0634\u0627\u0646 \u062e\u0648\u0627\u0647\u0645 \u062f\u0627\u062f \u06a9\u0647 \u0646\u0645\u0627\u06cc ASP.NET \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0624\u0644\u0641\u0647 DataTables \u0686\u06af\u0648\u0646\u0647 \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f.<\/p>\n
<!– Employees.cshtml –>
\n@using Example09.Models.Home;<\/p>\n
@model EmployeesVM<\/p>\n
<partial name=”_LoadingDatatablesJsAndCss” \/><\/p>\n
@{
\n <div class=”text-center”>
\n <h3 class=”display-4″>Employees table – Advanced Filter<\/h3>
\n <\/div><\/p>\n
<h4 class=”bg-info m-4 border p-3″>
\n @{
\n string text1 = “Filter= ” + Model?.AdvancedFilterState;
\n @text1
\n }
\n <\/h4><\/p>\n
<!– Here is our table HTML element defined. JavaScript library Datatables
\n will do all the magic to turn it into interactive component –>
\n <table id=”EmployeesTable01″ class=”table table-striped table-bordered “>
\n <\/table>
\n}<\/p>\n
<script type=”text\/javascript”>
\n \/\/ Datatables script initialization =========================================
\n \/\/ we used defer attribute on jQuery so it might not be available at this point
\n \/\/ so we go for vanilla JS event<\/p>\n
document.addEventListener(“DOMContentLoaded”, InitializeDatatable);<\/p>\n
function InitializeDatatable() {
\n $(“#EmployeesTable01”).dataTable(
\n \/\/providing initialization parameters as JavaScript object
\n {
\n \/\/processing-Feature control the processing indicator.
\n processing: true,
\n \/\/paging-Enable or disable table pagination.
\n paging: true,
\n \/\/info-Feature control table information display field
\n info: true,
\n \/\/ordering-Feature control ordering (sorting) abilities in DataTables.
\n ordering: true,
\n \/\/searching-Feature control search (filtering) abilities
\n searching: false,<\/p>\n
\/\/autoWidth-Feature control DataTables’ smart column width handling.
\n autoWidth: true,
\n \/\/lengthMenu-Change the options in the page length select list.
\n lengthMenu: [10, 15, 25, 50, 100],
\n \/\/pageLength-Change the initial page length (number of rows per page)
\n pageLength: 10,<\/p>\n
\/\/order-Initial order (sort) to apply to the table.
\n order: [[1, ‘asc’]],<\/p>\n
\/\/serverSide-Feature control DataTables’ server-side processing mode.
\n serverSide: true,<\/p>\n
\/\/Load data for the table’s content from an Ajax source.
\n ajax: {
\n “url”: “@Url.Action(“EmployeesDT”, “Home”)”,
\n “type”: “POST”,
\n “datatype”: “json”
\n },<\/p>\n
\/\/Set column specific initialisation properties.
\n columns: [
\n \/\/name-Set a descriptive name for a column
\n \/\/data-Set the data source for the column from the rows data object \/ array
\n \/\/title-Set the column title
\n \/\/orderable-Enable or disable ordering on this column
\n \/\/searchable-Enable or disable search on the data in this column
\n \/\/type-Set the column type – used for filtering and sorting string processing
\n \/\/visible-Enable or disable the display of this column.
\n \/\/width-Column width assignment.
\n \/\/render-Render (process) the data for use in the table.
\n \/\/className-Class to assign to each cell in the column.<\/p>\n
{ \/\/0
\n name: ‘id’,
\n data: ‘id’,
\n title: “Employee Id”,
\n orderable: true,
\n searchable: false,
\n type: ‘num’,
\n visible: false
\n },
\n {
\n \/\/1
\n name: ‘givenName’,
\n data: “givenName”,
\n title: “Given Name”,
\n orderable: true,
\n searchable: true,
\n type: ‘string’,
\n visible: true
\n },
\n {
\n \/\/2
\n name: ‘familyName’,
\n data: “familyName”,
\n title: “Family Name”,
\n orderable: true,
\n searchable: true,
\n type: ‘string’,
\n visible: true
\n },
\n {
\n \/\/3
\n name: ‘town’,
\n data: “town”,
\n title: “Town”,
\n orderable: true,
\n searchable: true,
\n type: ‘string’,
\n visible: true
\n },
\n {
\n \/\/4
\n name: ‘country’,
\n data: “country”,
\n title: “Country”,
\n orderable: true,
\n searchable: true,
\n type: ‘string’,
\n visible: true,
\n width: “150px”,
\n className: ‘text-center ‘
\n },
\n {
\n \/\/5
\n name: ’email’,
\n data: “email”,
\n title: “Email”,
\n orderable: true,
\n searchable: true,
\n type: ‘string’,
\n visible: true
\n },
\n {
\n \/\/6
\n name: ‘phoneNo’,
\n data: “phoneNo”,
\n title: “Phone Number”,
\n orderable: false,
\n searchable: true,
\n type: ‘string’,
\n visible: true
\n }
\n ],<\/p>\n
layout: {
\n top1Start: {
\n buttons:
\n [
\n {
\n text: ‘Filter’,
\n action: AdvancedFilter
\n }
\n ]\n }
\n }
\n } \/\/ end of initialization object
\n );<\/p>\n
function AdvancedFilter(e, dt, node, config) {
\n let EmployeesAdvancedFilter = “@Url.Action(“EmployeesAdvancedFilter”, “Home”)”;
\n \/\/redirect to another page
\n window.location.replace(EmployeesAdvancedFilter);
\n };
\n }
\n<\/script><\/p>\n
\u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u062c\u0627\u0648\u0627 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0631 \u062f\u0641\u062a\u0631\u0686\u0647 \u0631\u0627\u0647\u0646\u0645\u0627 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f [1]. \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0641\u0642\u0637 \u06cc\u06a9 \u0627\u062b\u0628\u0627\u062a \u0645\u0641\u0647\u0648\u0645 \u0628\u0631\u0627\u06cc \u0645\u062d\u06cc\u0637 ASP.NET \u0627\u0633\u062a.<\/p>\n
5 \u067e\u0631\u062f\u0627\u0632\u0634 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 ASP.NET<\/p>\n
\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0645\u0627 \u0627\u06a9\u0646\u0648\u0646 \u062f\u0631 \u0642\u0633\u0645\u062a C#\/.NET \u0647\u0633\u062a\u06cc\u0645 \u0648 \u06a9\u062f ASP.NET \u062e\u0648\u062f \u0631\u0627 \u0645\u06cc \u0646\u0648\u06cc\u0633\u06cc\u0645. \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06a9\u0634\u0646 Employees() \u0648 \u062f\u0631 \u0645\u062a\u062f FilterRowsPerSavedAdvancedFilterState() \u0648\u0636\u0639\u06cc\u062a \u0641\u06cc\u0644\u062a\u0631 \u0631\u0627 \u0627\u0632 \u0634\u06cc ASP.NET Session \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f. \u062a\u0631\u0641\u0646\u062f \u0627\u0635\u0644\u06cc \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0637\u0648\u0644 \u0647\u0631 \u062a\u0645\u0627\u0633 AJAX\u060c \u0645\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648\u0636\u0639\u06cc\u062a \u0641\u06cc\u0644\u062a\u0631 \u0627\u0632 \u0634\u06cc ASP.NET Session \u0648 \u0645\u062d\u062a\u0648\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 back-end \u062c\u062f\u0648\u0644 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n
\/\/\/\/EmployeesVM.cs
\nnamespace Example09.Models.Home
\n{
\n public class EmployeesVM
\n {
\n \/\/view model
\n public String? AdvancedFilterState { get; set; } = null;
\n }
\n}<\/p>\n
\/\/HomeController.cs ======================================
\nnamespace Example09.Controllers
\n{
\n public class HomeController : Controller
\n {
\n public const string EMPLOYEES_ADVANCED_FILTER_STATE = “EMPLOYEES_ADVANCED_FILTER_STATE”;<\/p>\n
public IActionResult Employees(EmployeesVM model)
\n{
\n try
\n {
\n ISession? CurrentSession = this.HttpContext?.Session;<\/p>\n
{
\n \/\/we get advanced-filter state from session if there is one
\n string? jsonUserEmployeesAdvancedFilterState = CurrentSession?.GetString(EMPLOYEES_ADVANCED_FILTER_STATE);<\/p>\n
if (!string.IsNullOrEmpty(jsonUserEmployeesAdvancedFilterState))
\n {
\n EmployeesAdvancedFilterVM? AdvancedFilterState =
\n JsonSerializer.Deserialize<EmployeesAdvancedFilterVM>(jsonUserEmployeesAdvancedFilterState);<\/p>\n
if (AdvancedFilterState != null)
\n {
\n string filterState =
\n “Given Name: ” + AdvancedFilterState.FirstName +
\n “; Family Name: ” + AdvancedFilterState.LastName +
\n “; Town: ” + AdvancedFilterState.City+
\n “; Country: ” + AdvancedFilterState.Country ;
\n model.AdvancedFilterState = filterState;
\n }
\n }
\n }
\n }
\n catch (Exception ex)
\n {
\n Console.WriteLine(ex.ToString());
\n }
\n return View(model);
\n}<\/p>\n
\/\/this is target of AJAX call and provides data for
\n\/\/the table, based on selected input parameters
\npublic IActionResult EmployeesDT(DataTables.AspNet.Core.IDataTablesRequest request)
\n{
\n \/\/ There is dependency in this method on names of fields
\n \/\/ and implied mapping. I see it almost impossible to avoid.
\n \/\/ At least, in this method, we avoided dependency on the order
\n \/\/ of table fields, in case order needs to be changed
\n \/\/Here are our mapped table columns:
\n \/\/Column0 id -> Employee.Id
\n \/\/Column1 givenName -> Employee.FirstName
\n \/\/Column2 familyName -> Employee.LastName
\n \/\/Column3 town -> Employee.City
\n \/\/Column4 country -> Employee.Country
\n \/\/Column5 email -> Employee.Email
\n \/\/Column6 phoneNo -> Employee.Phone<\/p>\n
try
\n {
\n IQueryable<Employee> employees = MockDatabase.MockDatabase.Instance.EmployeesTable.AsQueryable();<\/p>\n
\/\/here we get the count that needs to be presented by the UI
\n int totalRecordsCount = employees.Count();<\/p>\n
employees = FilterRowsPerSavedAdvancedFilterState(employees);<\/p>\n
var iQueryableOfAnonymous = employees.Select(p => new
\n {
\n id = p.Id,
\n givenName = p.FirstName,
\n familyName = p.LastName,
\n town = p.City,
\n country = p.Country,
\n email = p.Email,
\n phoneNo = p.Phone,
\n });<\/p>\n
\/\/here we get the count that needs to be presented by the UI
\n int filteredRecordsCount = iQueryableOfAnonymous.Count();<\/p>\n
iQueryableOfAnonymous = SortRowsPerRequestParamters(iQueryableOfAnonymous, request);<\/p>\n
iQueryableOfAnonymous = iQueryableOfAnonymous.Skip(request.Start).Take(request.Length);<\/p>\n
\/\/here we materialize the query
\n var dataPage = iQueryableOfAnonymous.ToList();<\/p>\n
var response = DataTablesResponse.Create(request, totalRecordsCount, filteredRecordsCount, dataPage);<\/p>\n
return new DataTablesJsonResult(response, false);
\n }
\n catch (Exception ex)
\n {
\n Console.WriteLine(ex.ToString());
\n var response = DataTablesResponse.Create(request, “Error processing AJAX call on server side”);
\n return new DataTablesJsonResult(response, false);
\n }
\n}<\/p>\n
private IQueryable<Example09.MockDatabase.Employee> FilterRowsPerSavedAdvancedFilterState(
\n IQueryable<Example09.MockDatabase.Employee> iQueryableOfEmployee)
\n{
\n try
\n {
\n ISession? CurrentSession = this.HttpContext?.Session;<\/p>\n
{
\n \/\/we get advanced-filter state from session if there is one
\n string? jsonUserEmployeesAdvancedFilterState = CurrentSession?.GetString(EMPLOYEES_ADVANCED_FILTER_STATE);<\/p>\n
if (!string.IsNullOrEmpty(jsonUserEmployeesAdvancedFilterState))
\n {
\n EmployeesAdvancedFilterVM? advancedFilter =
\n JsonSerializer.Deserialize<EmployeesAdvancedFilterVM>(jsonUserEmployeesAdvancedFilterState);<\/p>\n
if (advancedFilter != null)
\n {
\n \/\/FirstName
\n advancedFilter.FirstName = advancedFilter.FirstName?.Trim();
\n if (!string.IsNullOrEmpty(advancedFilter.FirstName))
\n {
\n \/*
\n * In EF we would go for DbFunctions.Like
\n if (advancedFilter.FirstName.Contains(‘*’) || advancedFilter.FirstName.Contains(‘?’))
\n {
\n string pattern = advancedFilter.FirstName.Replace(‘*’, ‘%’).Replace(‘?’, ‘_’);
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(vk => DbFunctions.Like(vk.FirstName, pattern));
\n }
\n else
\n {
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.FirstName != null && vk.FirstName.Equals(advancedFilter.FirstName));
\n }
\n *\/<\/p>\n
\/\/in pure Linq going for Regex
\n if (advancedFilter.FirstName.Contains(‘*’) || advancedFilter.FirstName.Contains(‘?’))
\n {
\n string pattern = advancedFilter.FirstName.Replace(“*”, “.*”).Replace(“?”, “.{1}”);
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.FirstName != null && Regex.IsMatch(vk.FirstName, pattern));
\n }
\n else
\n {
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.FirstName != null && vk.FirstName.Equals(advancedFilter.FirstName));
\n }
\n }<\/p>\n
\/\/LastName
\n advancedFilter.LastName = advancedFilter.LastName?.Trim();
\n if (!string.IsNullOrEmpty(advancedFilter.LastName))
\n {
\n \/\/in pure Linq going for Regex
\n if (advancedFilter.LastName.Contains(‘*’) || advancedFilter.LastName.Contains(‘?’))
\n {
\n string pattern = advancedFilter.LastName.Replace(“*”, “.*”).Replace(“?”, “.{1}”);
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.LastName != null && Regex.IsMatch(vk.LastName, pattern));
\n }
\n else
\n {
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.LastName != null && vk.LastName.Equals(advancedFilter.LastName));
\n }
\n }<\/p>\n
\/\/City
\n advancedFilter.City = advancedFilter.City?.Trim();
\n if (!string.IsNullOrEmpty(advancedFilter.City))
\n {
\n \/\/in pure Linq going for Regex
\n if (advancedFilter.City.Contains(‘*’) || advancedFilter.City.Contains(‘?’))
\n {
\n string pattern = advancedFilter.City.Replace(“*”, “.*”).Replace(“?”, “.{1}”);
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.City != null && Regex.IsMatch(vk.City, pattern));
\n }
\n else
\n {
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.City != null && vk.City.Equals(advancedFilter.City));
\n }
\n }<\/p>\n
\/\/Country
\n advancedFilter.Country = advancedFilter.Country?.Trim();
\n if (!string.IsNullOrEmpty(advancedFilter.Country))
\n {
\n \/\/in pure Linq going for Regex
\n if (advancedFilter.Country.Contains(‘*’) || advancedFilter.Country.Contains(‘?’))
\n {
\n string pattern = advancedFilter.Country.Replace(“*”, “.*”).Replace(“?”, “.{1}”);
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.Country != null && Regex.IsMatch(vk.Country, pattern));
\n }
\n else
\n {
\n iQueryableOfEmployee = iQueryableOfEmployee.Where(
\n vk => vk.Country != null && vk.Country.Equals(advancedFilter.Country));
\n }
\n }
\n }
\n }
\n }
\n }
\n catch (Exception ex)
\n {
\n Console.WriteLine(ex.ToString());
\n }<\/p>\n
return iQueryableOfEmployee;
\n} <\/p>\n
6 \u0646\u062a\u06cc\u062c\u0647 \u06af\u06cc\u0631\u06cc<\/p>\n
\u0646\u0645\u0648\u0646\u0647 \u06a9\u0627\u0645\u0644 \u067e\u0631\u0648\u0698\u0647 \u06a9\u062f \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u0631 GitHub \u062f\u0627\u0646\u0644\u0648\u062f \u06a9\u0631\u062f [99].<\/p>\n
7 \u0645\u0631\u0627\u062c\u0639<\/p>\n[1] https:\/\/datatables.net\/<\/p>\n[99] https:\/\/github.com\/MarkPelf\/ASPNET8UsingDataTablesNet <\/p>\n
\u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0639\u0645\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u0627\u0645\u067e\u0648\u0646\u0646\u062a jQuery DataTables.net \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 Asp.Net 8 MVC.<\/p>\n
\u0686\u06a9\u06cc\u062f\u0647: \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0639\u0645\u0644\u06cc \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Asp.Net 8 MVC \u06a9\u0647 \u0627\u0632 \u0645\u0648\u0644\u0641\u0647 jQuery DataTables.net \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0627\u062f\u0627\u0645\u0647 \u0645\u0642\u0627\u0644\u0647 Part8 \u0627\u0633\u062a.<\/em><\/strong><\/p>\n