public ExpenseEntryCollection FetchAll()
{
ExpenseEntryCollection coll = new ExpenseEntryCollection();
Query qry = new Query(ExpenseEntry.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public ExpenseEntryCollection FetchByTimesheetID(int timesheetid)
{
ExpenseEntryCollection coll = new ExpenseEntryCollection().Where(ExpenseEntry.Columns.Timesheetid, timesheetid).OrderByAsc(ExpenseEntry.Columns.Expensedate).Load();
return coll;
}
public ExpenseEntryCollection FetchByQuery(Query qry)
{
ExpenseEntryCollection coll = new ExpenseEntryCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public ExpenseEntryCollection FetchByID(object Id)
{
ExpenseEntryCollection coll = new ExpenseEntryCollection().Where("id", Id).Load();
return coll;
}
