public TimeEntryCollection FetchByQuery(Query qry)
        {
            TimeEntryCollection coll = new TimeEntryCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public TimeEntryCollection FetchAll()
        {
            TimeEntryCollection coll = new TimeEntryCollection();
            Query qry = new Query(TimeEntry.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public TimeEntryCollection FetchByTimesheetID(int timesheetid)
        {
            TimeEntryCollection coll = new TimeEntryCollection().Where(TimeEntry.Columns.Timesheetid, timesheetid).OrderByAsc(TimeEntry.Columns.Day).Load();

            return(coll);
        }
        public TimeEntryCollection FetchByID(object Id)
        {
            TimeEntryCollection coll = new TimeEntryCollection().Where("id", Id).Load();

            return(coll);
        }