public void OrderedInOrderOfCreation() { var bulk = _seed.GetUsersWithID(); var result = _context.User.ToList(); AssertUser.AreEqual(result, bulk); }
public void OrderedInOrderOfAgeDesc() { var bulk = _seed.GetUsersWithID().OrderByDescending(p => p.Age).ToList(); var result = _context.User.SortQueryByDescending("Age").ToList(); AssertUser.AreEqual(result, bulk); }
public void OrderedInOrderOfNameAsc() { var bulk = _seed.GetUsersWithID().OrderBy(p => p.Name).ToList(); var result = _context.User.SortQueryBy("Name").ToList(); AssertUser.AreEqual(result, bulk); }
public void OrderedInOrderOfAgeFailed() { var bulk = _seed.GetUsersWithID().OrderByDescending(p => p.Age).ToList(); var result = _context.User.SortQueryBy("Age").ToList(); AssertUser.AreNotEqual(result.First(), bulk.First()); AssertUser.AreNotEqual(result.Last(), bulk.Last()); AssertUser.AreEqual(result.First(), bulk.Last()); AssertUser.AreEqual(result.Last(), bulk.First()); }
public void PaginateTestWith3PerPageStartingPage2() { var bulk = _seed.GetUsersWithID(); int totalRow = 0; var result = _context.User.Paginate(new PaginationInfo() { Page = 2, Per_Page = 3, sort_by = "Name", sort_order = EnumSortOrder.Asc }, out totalRow).ToList(); Assert.AreEqual(result.Count, 3); Assert.AreEqual(bulk.Count, totalRow); AssertUser.AreEqual(result, bulk.OrderBy(p => p.Name).Skip(3).Take(3).ToList()); AssertUser.AreNotEqual(result, bulk.OrderByDescending(p => p.Name).Take(4).ToList()); }