// 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))); }