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