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