public void limit()
{
var expected = Items.Skip(2).Take(1).ToList();
var request = new TestDataTablesRequest(1, 2, 1, new Search(), Enumerable.Empty <Column>());
var actualObject = request.ApplyTo(Items.AsQueryable());
var actual = ((List <DataTablesItem>)actualObject.Data);
actual.Should().Equal(expected);
}
public void search()
{
var expected = Items.Where(i => i.Boolean == true || i.StringA.Contains("True") || i.StringB.Contains("True")).ToList();
var columns = new List <IColumn>()
{
new Column(nameof(DataTablesItem.Integer), nameof(DataTablesItem.Integer), true, true, null),
new Column(nameof(DataTablesItem.Boolean), nameof(DataTablesItem.Boolean), true, true, null),
new Column(nameof(DataTablesItem.StringA), nameof(DataTablesItem.StringA), true, true, null),
new Column(nameof(DataTablesItem.StringB), nameof(DataTablesItem.StringB), true, true, null),
};
var request = new TestDataTablesRequest(1, 0, 100, new Search("True", false), columns);
var actualObject = request.ApplyTo(Items.AsQueryable());
var actual = ((List <DataTablesItem>)actualObject.Data);
actual.Should().Equal(expected);
}
public void sort()
{
var columns = new List <IColumn>()
{
new Column(nameof(DataTablesItem.Integer), nameof(DataTablesItem.Integer), true, true, null),
new Column(nameof(DataTablesItem.Boolean), nameof(DataTablesItem.Boolean), true, true, null),
new Column(nameof(DataTablesItem.StringA), nameof(DataTablesItem.StringA), true, true, null),
new Column(nameof(DataTablesItem.StringB), nameof(DataTablesItem.StringB), true, true, null),
};
columns[0].SetSort(0, "asc");
columns[1].SetSort(1, "asc");
columns[2].SetSort(2, "desc");
columns[3].SetSort(3, "desc");
var expected = Items.OrderBy(i => i.Integer).ThenBy(i => i.Boolean).ThenByDescending(i => i.StringA).ThenByDescending(i => i.StringB)
.ToList();
var request = new TestDataTablesRequest(1, 0, 100, new Search(), columns);
var actualObject = request.ApplyTo(Items.AsQueryable());
var actual = ((List <DataTablesItem>)actualObject.Data);
actual.Should().Equal(expected);
}
