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