public BillingCityRateCollection FetchByQuery(Query qry)
{
BillingCityRateCollection coll = new BillingCityRateCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public BillingCityRateCollection FetchAll()
{
BillingCityRateCollection coll = new BillingCityRateCollection();
Query qry = new Query(BillingCityRate.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public BillingCityRateCollection FetchAllActive()
{
BillingCityRateCollection coll = new BillingCityRateCollection();
Query qry = new Query(BillingCityRate.Schema);
qry.WHERE(BillingCityRate.Columns.IsDeleted, false);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public BillingCityRateCollection FetchByID(object Id)
{
BillingCityRateCollection coll = new BillingCityRateCollection().Where("id", Id).Load();
return(coll);
}