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;
 }