public TimesheetCollection FetchAll()
{
TimesheetCollection coll = new TimesheetCollection();
Query qry = new Query(Timesheet.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public TimesheetCollection FetchAllByPeriodAccountId(int periodAccountId)
{
TimesheetCollection coll = new TimesheetCollection();
Query qry = new Query(Timesheet.Schema);
qry.WHERE(Timesheet.Columns.Periodaccountid, periodAccountId);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public TimesheetCollection FetchByQuery(Query qry)
{
TimesheetCollection coll = new TimesheetCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public TimesheetCollection FetchByID(object Id)
{
TimesheetCollection coll = new TimesheetCollection().Where("id", Id).Load();
return coll;
}