public JsonResult SelectReportItems(DataTableAjaxPostModel model) { string sortBy = "Date"; bool sortDir = true; if (model.order != null) { // in this example we just default sort on the 1st column sortBy = model.columns[model.order[0].column].data; sortDir = model.order[0].dir.ToLower() == "asc"; } int total; var items = _interviewsRepository.GetReportItems(out total, model.start, model.length, sortBy, sortDir); var dataItems = new DatatablesViewModel <InterviewReportRowItemViewModel>() { recordsTotal = total, recordsFiltered = total, data = items }; return(Json(dataItems)); }
public virtual ActionResult Datatables(DatatablesViewModel viewModel) { // 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", "150px"); dtSettings.bJQueryUI = true; IEnumerable <string[]> dtData = new string[][] { new string[] { "first column row 1", "second column row 1" }, new string[] { "first column row 2", "second column row 2" }, new string[] { "first column row 3", "second column row 3" }, new string[] { "first column row 4", "second column row 4" } }; 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", "150px"); dtSettings.bJQueryUI = true; viewModel.PostbackEnabledTable = new Datatable("postbacks-table", dtSettings, null, dtPostbacks); // update the display mode viewModel.DisplayMode = 6; return(View(MVC.JQueryUI.Core.Views.Datatables, viewModel)); }
// // 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)); }