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