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