Hi Team
I have logic that does not filter out my search well, i am using dataTable and its using server side processing to retrieve data to my table from the database. I do have few records with data, but they dont filter at all. Please view my logic and help produce results better, thanks.
- // Controller class
- [HttpPost]
- public ActionResult GetList()
- {
- //Server side Parameter.
- int start = Convert.ToInt32(Request["start"]);
- int length = Convert.ToInt32(Request["length"]);
- string searchValue = Request["search[value]"];
- string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
- string sortDirection = Request["order[0][dir]"];
- List
empList = new List (); - using (eNtsaOnlineRegistrationDBContext db = new eNtsaOnlineRegistrationDBContext())
- {
- empList = db.TblEventsManagements.ToList
(); - int totalrows = empList.Count();
- if (!string.IsNullOrEmpty(searchValue))
- {
- empList = empList.Where(x => x.TrainingType.ToLower().Contains(searchValue.ToLower()) || x.TrainingDescription.ToLower().Contains(searchValue.ToLower()) || x.Price.ToString().Contains(searchValue.ToLower())
- || x.Venue.ToLower().Contains(searchValue.ToLower()) || x.Facilitator.ToLower().Contains(searchValue.ToLower()) || x.WhoAttend.ToLower().Contains(searchValue.ToLower()) || x.Rsvp.ToLower().Contains(searchValue.ToLower())).ToList
(); - }
- int totalrowsafterfiltering = empList.Count;
- empList = empList.OrderBy(sortColumnName + " " + sortDirection).ToList
(); - empList = empList.Skip(start).Take(length).ToList
(); - return Json(new { data = empList, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet);
- }
- }
- // View cshtml
- @{
- ViewBag.Title = "EventManagement List";
- }
EventManagement List
- @*Semantic UI*@
- @*
- @*Bootstrap*@
- @*
-
TrainingType TrainingDescription Price Venue Facilitator WhoAttend RSVP -
TrainingType TrainingDescription Price Venue Facilitator WhoAttend RSVP - @section scripts{
-
- }
Laxmidhar SahooPosted Feb 13, 2020, 10:39 PM