public void ListAllTest()
{
using (OpenSession())
{
DetachedCriteria dc = DetachedCriteria.For <Foo>();
IPaginable <Foo> pg = new PaginableCriteria <Foo>(LastOpenedSession, dc);
IList <Foo> l = pg.ListAll();
Assert.AreEqual(15, l.Count);
}
}
public void PaginableRowsCount()
{
DetachedCriteria dc = DetachedCriteria.For <Foo>().Add(Restrictions.Like("Name", "N_"));
using (ISession s = OpenSession())
{
PaginableCriteria <Foo> fp = new PaginableCriteria <Foo>(LastOpenedSession, dc);
IList <Foo> l = fp.GetPage(5, 1);
Assert.AreEqual(5, l.Count);
Assert.AreEqual(10, fp.GetRowsCount(s));
}
}
public void PaginableCriteriaImplementsRowsCount()
{
DetachedCriteria dc = DetachedCriteria.For <Foo>().Add(Restrictions.Like("Name", "N_"));
using (ISession session = SessionFactory.OpenSession())
{
var fp = new PaginableCriteria <Foo>(session, dc);
IList <Foo> l = fp.GetPage(5, 1);
Assert.AreEqual(5, l.Count);
Assert.AreEqual(10, fp.GetRowsCount(session));
}
}
public void GetPageTest()
{
// Page count start from 1
using (OpenSession())
{
DetachedCriteria dc = DetachedCriteria.For <Foo>();
IPaginable <Foo> pg = new PaginableCriteria <Foo>(LastOpenedSession, dc);
IList <Foo> l = pg.GetPage(3, 2);
Assert.AreEqual(3, l.Count);
Assert.AreEqual("N3", l[0].Name);
Assert.AreEqual("N4", l[1].Name);
Assert.AreEqual("N5", l[2].Name);
l = pg.GetPage(2, 1);
Assert.AreEqual(2, l.Count);
Assert.AreEqual("N0", l[0].Name);
Assert.AreEqual("N1", l[1].Name);
// If pageSize=10 the page 2 have 5 elements
l = pg.GetPage(10, 2);
Assert.AreEqual(5, l.Count);
}
// Add an element from other session
Foo fAdded;
using (ISession s = OpenSession())
{
fAdded = new Foo("NZ", "DZ");
s.Save(fAdded);
s.Flush();
}
// Reload the same page and have the new element
using (OpenSession())
{
DetachedCriteria dc = DetachedCriteria.For <Foo>();
IPaginable <Foo> pg = new PaginableCriteria <Foo>(LastOpenedSession, dc);
IList <Foo> l = pg.GetPage(10, 2);
// If pageSize=10 the page 2 have 6 elements
Assert.AreEqual(6, l.Count);
}
// clean up
using (ISession s = OpenSession())
{
s.Delete(fAdded);
s.Flush();
}
}
public void GetPageTest()
{
// Page count start from 1
using (OpenSession())
{
DetachedCriteria dc = DetachedCriteria.For<Foo>();
IPaginable<Foo> pg = new PaginableCriteria<Foo>(LastOpenedSession, dc);
IList<Foo> l = pg.GetPage(3, 2);
Assert.AreEqual(3, l.Count);
Assert.AreEqual("N3", l[0].Name);
Assert.AreEqual("N4", l[1].Name);
Assert.AreEqual("N5", l[2].Name);
l = pg.GetPage(2, 1);
Assert.AreEqual(2, l.Count);
Assert.AreEqual("N0", l[0].Name);
Assert.AreEqual("N1", l[1].Name);
// If pageSize=10 the page 2 have 5 elements
l = pg.GetPage(10, 2);
Assert.AreEqual(5, l.Count);
}
// Add an element from other session
Foo fAdded;
using (ISession s = OpenSession())
{
fAdded = new Foo("NZ", "DZ");
s.Save(fAdded);
s.Flush();
}
// Reload the same page and have the new element
using (OpenSession())
{
DetachedCriteria dc = DetachedCriteria.For<Foo>();
IPaginable<Foo> pg = new PaginableCriteria<Foo>(LastOpenedSession, dc);
IList<Foo> l = pg.GetPage(10, 2);
// If pageSize=10 the page 2 have 6 elements
Assert.AreEqual(6, l.Count);
}
// clean up
using (ISession s = OpenSession())
{
s.Delete(fAdded);
s.Flush();
}
}
public void ListAllTest()
{
using (OpenSession())
{
DetachedCriteria dc = DetachedCriteria.For<Foo>();
IPaginable<Foo> pg = new PaginableCriteria<Foo>(LastOpenedSession, dc);
IList<Foo> l = pg.ListAll();
Assert.AreEqual(15, l.Count);
}
}
public void PaginableRowsCount()
{
DetachedCriteria dc = DetachedCriteria.For<Foo>().Add(Restrictions.Like("Name", "N_"));
using (ISession s = OpenSession())
{
PaginableCriteria<Foo> fp = new PaginableCriteria<Foo>(LastOpenedSession, dc);
IList<Foo> l = fp.GetPage(5, 1);
Assert.AreEqual(5, l.Count);
Assert.AreEqual(10, fp.GetRowsCount(s));
}
}
