public void Get_WhenPageNumberIs4AndPageSizeIs3_ReturnsLastEntity() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); Add10Managers(); //Act var getParameters = new GetOperationParameters() { QueryParameters = new QueryParameters() { PagingParameters = new QueryPagingParameters() { PageNumber = 3, PageSize = 3, } } }; var entities = repository.Get(getParameters); //Assert Assert.AreEqual(1, entities.Length); Assert.AreEqual(10, getParameters.QueryParameters.PagingParameters.TotalCount); Assert.AreEqual(3, entities[0].CreatedById); }
public void Get_WhenPageNumberIs0AndPageSizeIs3_ReturnsFirstThreeEntities() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); Add10Managers(); //Act var getParameters = new GetOperationParameters() { QueryParameters = new QueryParameters() { PagingParameters = new QueryPagingParameters() { PageNumber = 0, PageSize = 3, } } }; var entities = repository.Get(getParameters); //Assert Assert.AreEqual(3, entities.Length); Assert.AreEqual(10, getParameters.QueryParameters.PagingParameters.TotalCount); for (int i = 0; i < 3; i++) { Assert.AreEqual(0, entities[i].CreatedById); } }
public void Get_WhenFilteredAndSortedAndPaged_ReturnsEntities() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); Add10Managers(); //Act var getParameters = new GetOperationParameters() { QueryParameters = new QueryParameters() { Filter = new OrOperator() { LeftOperand = new EqualsCondition() { Property = ReflectionHelper.GetPropertyName <Manager, long>(e => e.CreatedById), Value = 2L }, RightOperand = new EqualsCondition() { Property = ReflectionHelper.GetPropertyName <Manager, long>(e => e.CreatedById), Value = 3L } }, SortingParameters = new QuerySortingParameters() { SortBy = ReflectionHelper.GetPropertyName <Manager, long>(e => e.CreatedById), SortingType = SortingType.Descending }, PagingParameters = new QueryPagingParameters() { PageNumber = 0, PageSize = 3, } } }; var entities = repository.Get(getParameters); //Assert Assert.AreEqual(3, entities.Length); Assert.AreEqual(4, getParameters.QueryParameters.PagingParameters.TotalCount); Assert.AreEqual(3, entities[0].CreatedById); Assert.AreEqual(2, entities[1].CreatedById); Assert.AreEqual(2, entities[2].CreatedById); }
public void Get_WhenPageNumberIs4AndPageSizeIs3_ReturnsLastEntity() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); Add10Managers(); //Act var getParameters = new GetOperationParameters() { QueryParameters = new QueryParameters() { PagingParameters = new QueryPagingParameters() { PageNumber = 3, PageSize = 3, } } }; var entities = repository.Get(getParameters); //Assert Assert.AreEqual(1, entities.Length); Assert.AreEqual(10, getParameters.QueryParameters.PagingParameters.TotalCount); Assert.AreEqual("data9", entities[0].Data); }
public void Get_WhenPageNumberIs0AndPageSizeIs3_ReturnsFirstThreeEntities() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); Add10Managers(); //Act var getParameters = new GetOperationParameters() { QueryParameters = new QueryParameters() { PagingParameters = new QueryPagingParameters() { PageNumber = 0, PageSize = 3, } } }; var entities = repository.Get(getParameters); //Assert Assert.AreEqual(3, entities.Length); Assert.AreEqual(10, getParameters.QueryParameters.PagingParameters.TotalCount); for (int i = 0; i < 3; i++) { Assert.IsTrue(entities[i].Data == "data0" || entities[i].Data == "data1" || entities[i].Data == "data2"); } }
public void Get_WhenFilteredAndSortedAndPaged_ReturnsEntities() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); Add10Managers(); //Act var getParameters = new GetOperationParameters() { QueryParameters = new QueryParameters() { Filter = new OrOperator() { LeftOperand = new OrOperator() { LeftOperand = new EqualsCondition() { Property = ReflectionHelper.GetPropertyName<Manager, string>(e => e.Data), Value = "data1" }, RightOperand = new EqualsCondition() { Property = ReflectionHelper.GetPropertyName<Manager, string>(e => e.Data), Value = "data2" } }, RightOperand = new OrOperator() { LeftOperand = new EqualsCondition() { Property = ReflectionHelper.GetPropertyName<Manager, string>(e => e.Data), Value = "data3" }, RightOperand = new EqualsCondition() { Property = ReflectionHelper.GetPropertyName<Manager, string>(e => e.Data), Value = "data4" } }, }, SortingParameters = new QuerySortingParameters() { SortBy = ReflectionHelper.GetPropertyName<Manager, string>(e => e.Data), SortingType = SortingType.Descending }, PagingParameters = new QueryPagingParameters() { PageNumber = 0, PageSize = 3, } } }; var entities = repository.Get(getParameters); //Assert Assert.AreEqual(3, entities.Length); Assert.AreEqual(4, getParameters.QueryParameters.PagingParameters.TotalCount); Assert.AreEqual("data4", entities[0].Data); Assert.AreEqual("data3", entities[1].Data); Assert.AreEqual("data2", entities[2].Data); }
public new EFEntity[] Get(GetOperationParameters parameters) { return(base.Get(parameters)); }
public new Manager[] Get(GetOperationParameters parameters) { return(base.Get(parameters)); }