public void OrderBysWork()
{
Venue venue = new Venue();
venue.Update();
List<Event> events = new List<Event>();
for (int i = 0; i < 10; i++)
{
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
events.Add(ev);
}
Event[] childEvents = venue.ChildEvents().AllItems();
Event[] pagedChildEvents = venue.ChildEvents().Page(1, 10);
for (int i = 0; i < events.Count; i++)
{
Assert.AreEqual(events[i].K, childEvents[i].K);
}
var orderBy = new Pair(Event.Columns.K, OrderBy.OrderDirection.Descending);
childEvents = venue.ChildEvents(orderBy).AllItems();
pagedChildEvents = venue.ChildEvents(orderBy).Page(1, 10);
for (int i = 0; i < events.Count; i++)
{
Assert.AreEqual(events[9 - i].K, childEvents[i].K);
}
}
public void AddingAChildUsingDatabaseAddsToChildren()
{
Venue venue = new Venue();
venue.Update();
Assert.AreEqual(0, venue.ChildEvents().Count);
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
Assert.AreEqual(1, venue.ChildEvents().Count);
}
public void RemovingAChildUsingDatabaseRemovesFromChildren()
{
Venue venue = new Venue();
venue.Update();
Venue venue2 = new Venue();
venue2.Update();
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
Assert.AreEqual(1, venue.ChildEvents().Count);
ev.VenueK = venue2.K;
ev.Update();
Assert.AreEqual(0, venue.ChildEvents().Count);
}
public void PagingWorks()
{
Venue venue = new Venue();
venue.Update();
Random r = new Random();
int pageSize = r.Next(10) + 5;
int numberOfItems = r.Next(50) + 50;
if (numberOfItems % pageSize == 0) { numberOfItems++; }
List<Event> events = new List<Event>();
for (int i = 0; i < numberOfItems; i++)
{
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
events.Add(ev);
}
Assert.AreEqual(numberOfItems, venue.ChildEvents().Count);
Assert.AreEqual(pageSize, venue.ChildEvents().Page(1, pageSize).Length);
int highestPageNumber = (int) Math.Ceiling((float) numberOfItems / (float)pageSize);
Assert.AreEqual(numberOfItems % pageSize, venue.ChildEvents().Page(highestPageNumber, pageSize).Length);
}
public void WheresWork()
{
Venue venue = new Venue();
venue.Update();
List<Event> events = new List<Event>();
for (int i = 0; i < 10; i++)
{
Event ev = new Event();
ev.VenueK = venue.K;
ev.Update();
events.Add(ev);
}
Assert.AreEqual(0, venue.ChildEvents(new Q("1 = 0", null, null)).AllItems().Length);
Assert.AreEqual(0, venue.ChildEvents(new Q("1 = 0", null, null)).Page(1, 10).Length);
}