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