public TimesheetBillingCityRateCollection FetchByQuery(Query qry)
{
TimesheetBillingCityRateCollection coll = new TimesheetBillingCityRateCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public TimesheetBillingCityRateCollection FetchAll()
{
TimesheetBillingCityRateCollection coll = new TimesheetBillingCityRateCollection();
Query qry = new Query(TimesheetBillingCityRate.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public TimesheetBillingCityRateCollection FetchAllActive()
{
TimesheetBillingCityRateCollection coll = new TimesheetBillingCityRateCollection();
Query qry = new Query(TimesheetBillingCityRate.Schema);
qry.WHERE(TimesheetBillingCityRate.Columns.IsDeleted, false);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}