public JsonResult GetSearchResults(string sidx, string sord, int page, int rows, bool _search, string filters)
{
//Placements tbl = new Placements();
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int currentPage = pageIndex * pageSize == 0 ? 1 : pageIndex * pageSize;
int totalRecords = tbl.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
jgridFilter searchRules = jgridFilter.Create(filters ?? "");
bool IsSearch = _search;
string where_string = "";
if (IsSearch)
{
string groupOp = searchRules.groupOp;
int i = 0;
foreach (Rule myrule in searchRules.rules)
{
string line = BuildLine(myrule.op, myrule.field, myrule.data);
if (i == 0)
{
where_string = line;
}
else
{
where_string += " " + groupOp + " " + line;
}
i++;
}
}//
IEnumerable <dynamic> results;
if (IsSearch)
{
results = tbl.Paged(where : where_string, orderBy: sidx + " " + sord, currentPage: currentPage, pageSize: pageSize).Items;
}
else
{
results = tbl.Paged(orderBy: sidx + " " + sord, currentPage: currentPage, pageSize: pageSize).Items;
}
JsonResult myJasonResults = GetJson(results, totalPages, page, totalRecords);
return(myJasonResults);
}
public JsonResult DynamicGridData(string sidx, string sord, int page, int rows, bool _search, string filters)
{
//note: a view is used here. This is because the we want to display the PUBLICATION_NETWORK field from the PUBLICATION_NETWORKS table
//OID_PUBLISHER_ID field of the MEDIA_CAT_DIGITAL_PLCMNT table is hooked up to a combo box: ref method PublishersCombo() which feeds the combo box
//if just the data from the MEDIA_CAT_DIGITAL_PLCMNT table was to be dispayed you could simply pass in the Placements class like so:
//SearchHelper sh = new SearchHelper(new Placements(), ShapeGridRow);
//display a view
DynamicModel myview = new View_Placements_Publications();
jgridDisplayHelper sh = new jgridDisplayHelper(myview, ShapeGridRow);
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
int totalRecords = tbl.Count(); //repository.TimeCards.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
JsonResult mydata = sh.GetSearchResults(sidx, sord, page, rows, _search, filters);
return(mydata);
}