public async Task GetUserReports_DbQuery(DateTime from, DateTime to, int expectedCount)
{
//arrange
var userRepository = Substitute.For <IUserRepository>();
var service = new MyService(userRepository);
var users = new List <UserEntity>
{
new UserEntity {
FirstName = "FirstName1", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012", UsCultureInfo.DateTimeFormat)
},
new UserEntity {
FirstName = "FirstName2", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012", UsCultureInfo.DateTimeFormat)
},
new UserEntity {
FirstName = "FirstName3", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012", UsCultureInfo.DateTimeFormat)
},
new UserEntity {
FirstName = "FirstName3", LastName = "LastName", DateOfBirth = DateTime.Parse("03/20/2012", UsCultureInfo.DateTimeFormat)
},
new UserEntity {
FirstName = "FirstName5", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2018", UsCultureInfo.DateTimeFormat)
},
};
//expect
var mock = users.AsQueryable().BuildMockDbSet();
userRepository.GetQueryable().Returns(mock);
//act
var result = await service.GetUserReports(from, to);
//assert
Assert.AreEqual(expectedCount, result.Count);
}
public async Task GetUserReports(DateTime from, DateTime to, int expectedCount)
{
//arrange
var users = new List <UserEntity>()
{
new UserEntity {
FirstName = "FirstName1", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012")
},
new UserEntity {
FirstName = "FirstName2", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012")
},
new UserEntity {
FirstName = "FirstName3", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012")
},
new UserEntity {
FirstName = "FirstName3", LastName = "LastName", DateOfBirth = DateTime.Parse("03/20/2012")
},
new UserEntity {
FirstName = "FirstName5", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2018")
},
};
//expect
var mock = users.AsQueryable().BuildMock();
_userRepository.Setup(x => x.GetQueryable()).Returns(mock.Object);
//act
var result = await _service.GetUserReports(from, to);
//assert
Assert.AreEqual(expectedCount, result.Count);
}
public async Task DbSetGetUserReports(DateTime from, DateTime to, int expectedCount)
{
//arrange
var users = new List <UserEntity>
{
new UserEntity {
FirstName = "FirstName1", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012")
},
new UserEntity {
FirstName = "FirstName2", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012")
},
new UserEntity {
FirstName = "FirstName3", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2012")
},
new UserEntity {
FirstName = "FirstName3", LastName = "LastName", DateOfBirth = DateTime.Parse("03/20/2012")
},
new UserEntity {
FirstName = "FirstName5", LastName = "LastName", DateOfBirth = DateTime.Parse("01/20/2018")
},
};
var mock = users.AsQueryable().BuildMockDbSet();
var userRepository = new TestDbSetRepository(mock);
var service = new MyService(userRepository);
//act
var result = await service.GetUserReports(from, to);
//assert
Assert.AreEqual(expectedCount, result.Count);
}