public PdPucoCollection FetchByQuery(Query qry)
{
PdPucoCollection coll = new PdPucoCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PdPucoCollection FetchAll()
{
PdPucoCollection coll = new PdPucoCollection();
Query qry = new Query(PdPuco.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PdPucoCollection FetchAllPaged(int start, int pageLength)
{
int startIndex;
if (start == 0)
{
startIndex = 1;
}
else
{
startIndex = start / pageLength;
}
PdPucoCollection coll = new PdPucoCollection();
Query qry = new Query(PdPuco.Schema);
qry.PageSize = pageLength;
qry.PageIndex = startIndex;
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PdPucoCollection FetchByID(object Id)
{
PdPucoCollection coll = new PdPucoCollection().Where("id", Id).Load();
return(coll);
}
