public void GetAllWithPredicates_Customer_Succeed() { //Arrange using (var context = new ManagementContext()) { var executor = new SqlExecutor(context.Database.Connection.ConnectionString); executor.ExecuteScript(Path.Combine(Environment.CurrentDirectory, "Scripts", "2 - Customers.sql")); var unitOfWork = new DatabaseUnitOfWork(context); var customerRepository = new CustomerRepository(unitOfWork); //Act var predicates = CustomerRepository.Predicates(p => p.Id > 2, p => p.Code.StartsWith("A")); var total = customerRepository.GetAll <Customer>(predicates, null, null).Count(); //Assert Assert.AreEqual(3, total); } }
public void GetPaginated_Customer_Succeed(PaginatedData paginatedData) { //Arrange using (var context = new ManagementContext()) { var executor = new SqlExecutor(context.Database.Connection.ConnectionString); executor.ExecuteScript(Path.Combine(Environment.CurrentDirectory, "Scripts", "2 - Customers.sql")); var unitOfWork = new DatabaseUnitOfWork(context); var customerRepository = new CustomerRepository(unitOfWork); //Act PaginatedResult <Customer> result = customerRepository.GetPaginated(null, null, p => p.Id, paginatedData.PageIndex, paginatedData.PageSize); //Assert Assert.AreEqual(paginatedData.ResultCount, result.Result.Count()); Assert.AreEqual(paginatedData.PageIndex, result.PageIndex); Assert.AreEqual(paginatedData.PageSize, result.PageSize); Assert.AreEqual(paginatedData.TotalCount, result.TotalCount); Assert.AreEqual(paginatedData.TotalPageCount, result.TotalPageCount); Assert.AreEqual(paginatedData.HasPreviousPage, result.HasPreviousPage); Assert.AreEqual(paginatedData.HasNextPage, result.HasNextPage); } }
public void GetPaginated_Customer_Succeed(PaginatedData paginatedData) { //Arrange using (var context = new ManagementContext()) { var executor = new SqlExecutor(context.Database.Connection.ConnectionString); executor.ExecuteScript(Path.Combine(Environment.CurrentDirectory, "Scripts", "2 - Customers.sql")); var unitOfWork = new DatabaseUnitOfWork(context); var customerRepository = new CustomerRepository(unitOfWork); //Act PaginatedResult<Customer> result = customerRepository.GetPaginated(null, null, p => p.Id, paginatedData.PageIndex, paginatedData.PageSize); //Assert Assert.AreEqual(paginatedData.ResultCount, result.Result.Count()); Assert.AreEqual(paginatedData.PageIndex, result.PageIndex); Assert.AreEqual(paginatedData.PageSize, result.PageSize); Assert.AreEqual(paginatedData.TotalCount, result.TotalCount); Assert.AreEqual(paginatedData.TotalPageCount, result.TotalPageCount); Assert.AreEqual(paginatedData.HasPreviousPage, result.HasPreviousPage); Assert.AreEqual(paginatedData.HasNextPage, result.HasNextPage); } }
public void GetAllWithPredicates_Customer_Succeed() { //Arrange using (var context = new ManagementContext()) { var executor = new SqlExecutor(context.Database.Connection.ConnectionString); executor.ExecuteScript(Path.Combine(Environment.CurrentDirectory, "Scripts", "2 - Customers.sql")); var unitOfWork = new DatabaseUnitOfWork(context); var customerRepository = new CustomerRepository(unitOfWork); //Act var predicates = CustomerRepository.Predicates(p => p.Id > 2, p => p.Code.StartsWith("A")); var total = customerRepository.GetAll<Customer>(predicates, null, null).Count(); //Assert Assert.AreEqual(3, total); } }