// The method to return partial view to bind search content.
public ActionResult SearchContent(string viewName)
{
FocusAreaLibrary lib = new FocusAreaLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
FocusArea globalSearch = lib.GetByViewName(viewName);
string orderByClause = globalSearch != null?Convert.ToString(globalSearch.OrderBy_Clause) : string.Empty;
DataTable dt = lib.GetAllAsDt(viewName, orderByClause);
//DataTable dt = lib.GetAllWithPagingAsDt(
// viewName,
// out totalRows,
// 1,
// ViewBag.PageSize,
// "",
// "Asc"
// );
//ViewData["total"] = totalRows;
//DataTableViewModel model = new DataTableViewModel();
//model.Data = dt;
//model.Columns = columns(dt);
//model.Total = totalRows;
ViewBag.PageSize = 18;
return(PartialView("~/Views/Search/SearchContent.cshtml", dt));
}
public ActionResult _SearchContent(GridCommand command, string viewName)
{
FocusAreaLibrary lib = new FocusAreaLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
FocusArea globalSearch = lib.GetByViewName(viewName);
string orderByClause = globalSearch != null?Convert.ToString(globalSearch.OrderBy_Clause) : string.Empty;
DataTable dt = lib.GetAllAsDt(viewName, orderByClause);
//DataTable dt = lib.GetAllWithPagingAsDt(viewName,
// out totalRows,
// command.Page,
// command.PageSize,
// command.SortDescriptors.Count == 0 ? "" : command.SortDescriptors[0].Member,
// command.SortDescriptors.Count == 0 ? "" : command.SortDescriptors[0].SortDirection == System.ComponentModel.ListSortDirection.Descending ? "Desc" : "Asc",
// (command.FilterDescriptors.Count == 0 ? null : command.FilterDescriptors)
// );
//DataTableViewModel model = new DataTableViewModel();
//model.Data = dt;
//model.Columns = columns(dt);
//model.Total = totalRows;
//ViewBag.PageSize = 18;
//ViewData["total"] = totalRows;
ViewBag.Total = dt.Rows.Count;
ViewBag.PageSize = 18;
return(View(new GridModel(dt)));
}
