public DatatableRecords GetSortedRecords(DatatableFilters filters) { // Let's create the actual data to go into the table IList <string[]> dtData = DatatableGenerator.GetDataWithSpecialFormat(); DatatableRecords dtRecords = new DatatableRecords { sEcho = filters.sEcho, iTotalRecords = dtData.Count(), // Total records in table iTotalDisplayRecords = dtData.Count(), // Total records to be displayed in the table aaData = dtData .Sort(filters.iSortCol_0, filters.SortDirection) // The data to be displayed .ToArray() }; return(dtRecords); }
public virtual ActionResult Datatables(DatatablesViewModel viewModel) { string tableHeight = null; // create the basic table again IEnumerable <AOColumn> dtAOColumns = new List <AOColumn> { new AOColumn { sTitle = "First Column", sWidth = "25%" }, new AOColumn { sTitle = "Second Column" } }; DatatableSettings dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), null, "basic records", tableHeight); IEnumerable <string[]> dtData = DatatableGenerator.GetDefaultData(); DatatableRecords dtRecords = new DatatableRecords { iTotalRecords = dtData.Count(), // Total records in table iTotalDisplayRecords = dtData.Count(), // Total records to be displayed in the table aaData = dtData.ToArray() // The data to be displayed }; viewModel.Table = new Datatable("basic-table", dtSettings, dtRecords); // create the postbacks enabled table IEnumerable <PostbackItem> dtPostbacks = PostbackItem.FromObject(viewModel.PostbackFormFields); dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetPostbackData, "searched/filtered records", tableHeight); viewModel.PostbackEnabledTable = new Datatable("postbacks-table", dtSettings, null, dtPostbacks); // update the display mode viewModel.DisplayMode = 6; return(View(MVC.Gumby.Core.Views.Datatables, viewModel)); }
// // GET: /Bootstrap/Core/GetPostbackData public virtual JsonResult GetPostbackData(DatatableFilters filters, PostbackSetupViewModel postbacks) { IEnumerable <string[]> dtData = DatatableGenerator.GetDefaultData(); if (!string.IsNullOrEmpty(postbacks.FirstColumn)) { dtData = dtData.Where(f => f[0].ContainsIgnoreCase(postbacks.FirstColumn)); } if (!string.IsNullOrEmpty(postbacks.SecondColumn)) { dtData = dtData.Where(f => f[1].ContainsIgnoreCase(postbacks.SecondColumn)); } DatatableRecords dtRecords = new DatatableRecords { sEcho = filters.sEcho, iTotalRecords = dtData.Count(), iTotalDisplayRecords = dtData.Count(), aaData = dtData.ToArray() }; return(Json(dtRecords, JsonRequestBehavior.AllowGet)); }
// // GET: /Bootstrap/Core/Datatables public virtual ActionResult Datatables(int?mode) { if (!mode.HasValue) { return(RedirectToAction(Actions.Datatables(0))); } DatatablesViewModel model = new DatatablesViewModel(); string tableId = string.Empty; string tableHeight = null; IEnumerable <AOColumn> dtAOColumns = new List <AOColumn> { new AOColumn { sTitle = "First Column", sWidth = "25%" }, new AOColumn { sTitle = "Second Column" } }; DatatableSettings dtSettings = null; DatatableRecords dtRecords = null; bool enableStatusColumn = false; switch (mode) { case 1: tableId = "ajax-table"; dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetAjaxData, "ajax records", tableHeight); break; case 2: tableId = "paged-table"; dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetPagedData, "paged records", tableHeight); dtRecords = GetPagedRecords(new DatatableFilters { iDisplayStart = 0, iDisplayLength = 5 }); break; case 3: tableId = "paged-and-sorted-table"; dtAOColumns = new List <AOColumn> { new AOColumn { sTitle = "HTML field column", bSortable = true }, new AOColumn { sTitle = "String Column", bSortable = true }, new AOColumn { sTitle = "DateTime Column", bSortable = true }, new AOColumn { sTitle = "Numeric Column", bSortable = true }, new AOColumn { sTitle = "Currency Column", bSortable = true } }; dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetSortedData, "sorted records", tableHeight); dtRecords = GetSortedRecords(new DatatableFilters { iDisplayStart = 0, iDisplayLength = 5 }); break; case 4: tableId = "status-table"; dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), null, "status records", tableHeight); IEnumerable <string[]> statusData = DatatableGenerator.GetDefaultDataWithStatusColumn(); enableStatusColumn = true; dtRecords = new DatatableRecords { iTotalRecords = statusData.Count(), iTotalDisplayRecords = statusData.Count(), aaData = statusData.ToArray() }; break; case 0: case 5: default: tableId = "basic-table"; dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), null, "basic records", tableHeight); IEnumerable <string[]> dtData = DatatableGenerator.GetDefaultData(); dtRecords = new DatatableRecords { iTotalRecords = dtData.Count(), // Total records in table iTotalDisplayRecords = dtData.Count(), // Total records to be displayed in the table aaData = dtData.ToArray() // The data to be displayed }; break; } // Let's create the datatable object with an HTML ID, our settings, columns and records model.DisplayMode = mode.Value; model.Table = new Datatable(tableId, dtSettings, dtRecords, null, enableStatusColumn); return(View(model)); }