public TimesheetCollection FetchByQuery(Query qry)
{
TimesheetCollection coll = new TimesheetCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
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);
}