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