System.Linq.Dynamic.ParseException: Expression expected

Guest User

6y3.2k.NET

Hi Mate

I am encountering this issue, below "System.Linq.Dyanmic.ParseException:Expression expected". I am doing server side processing using DataTable. This comes from my Controller object GetList() method.

// using System.Linq.Dynamic;

[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 < TblEventsManagements > empList = new List < TblEventsManagements > ();
using(eNtsaOnlineRegistrationDBContext db = new eNtsaOnlineRegistrationDBContext()) {
empList = db.TblEventsManagements.ToList < TblEventsManagements > ();
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 < TblEventsManagements > ();
}
int totalrowsafterfiltering = empList.Count;
empList = empList.OrderBy(sortColumnName + " " + sortDirection).ToList < TblEventsManagements > (); // This throws at here on this line. System.Linq.Dyanmic.ExpressionParse.ParsePrimaryStart();
empList = empList.Skip(start).Take(length).ToList < TblEventsManagements > ();
return Json(new {
data = empList, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering
}, JsonRequestBehavior.AllowGet);
}
}
$(document).ready(function() {
$("#EventManagementTable").DataTable({
"ajax": {
"url": "/Dashboard/GetList",
"type": "POST",
"datatype": "json"
},
"columns": [{
"data": "TrainingType",
"trainingtype": "TrainingType"
},
{
"data": "TrainingDescription",
"name": "TrainingDescription"
},
{
"data": "Price",
"name": "Price"
},
{
"data": "Venue",
"name": "Venue"
},
{
"data": "Facilitator",
"name": "Facilitator"
},
{
"data": "WhoAttend",
"name": "WhoAttend"
},
{
"data": "RSVP",
"name": "RSVP"
},
],
"serverSide": "true",
"order": [0, "asc"],
"processing": "true",
"language": {
"processing": "processing... please wait"
}
});
});

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
Replace your line 29 (the orderby) with my code.

In the new situation add the skip and take to both the line in the if and the else
Guest User6y ago
Hi Mates
I made the following changes to my code and again i didnt come right, what im trying here is to do sorting of list using server side processing.
[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]"];


     using (eNtsaOnlineRegistrationDBContext db = new eNtsaOnlineRegistrationDBContext())
     {

         IQueryable empList = db.TblEventsManagements;
        int totalrows = empList.Count();
         int totalrowsafterfiltering = totalrows;


         if (!string.IsNullOrEmpty(searchValue))
         {
             empList = empList.Where(x => x.TrainingType.Contains(searchValue) || x.TrainingDescription.Contains(searchValue) || x.Price.ToString().Contains(searchValue.ToLower())
             || x.Venue.Contains(searchValue) || x.Facilitator.Contains(searchValue) || x.WhoAttend.Contains(searchValue) || x.Rsvp.Contains(searchValue));


         }


         empList = empList.OrderBy(sortColumnName + "" + sortDirection).Skip(start).Take(length);



         return Json(new { data = empList, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet);
     }



}
Guest User6y ago
Hi Pritaeas

Am i doing this condition right after i intialized this object?

int totalrowsafterfilering = empList.Count;

How can i declare variable as item?

string item = Request[""[dir]];
Guest User6y ago
Should look like this:

empList = empList.OrderBy(item => item.sortColumnName).ToList();

This will compile, but I doubt it will give the result you need. You probably need something like this:

if (sortDirection == "ASC") // enter what you are using:
{
empList = empList.OrderBy(item => item.sortColumnName).ToList();
}
else
{
empList = empList.OrderByDescending(item => item.sortColumnName).ToList();
}