public DefaultBillingRateCollection FetchByQuery(Query qry)
{
DefaultBillingRateCollection coll = new DefaultBillingRateCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public DefaultBillingRateCollection FetchAll()
{
DefaultBillingRateCollection coll = new DefaultBillingRateCollection();
Query qry = new Query(DefaultBillingRate.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public Double FetchRate(Int32 AccountID, Int32 RateGroupID)
{
DefaultBillingRateCollection col = FetchByAccountAndGroup(AccountID, RateGroupID);
if (col.Count == 0)
{
return(0);
}
return(col[0].Rate);
}
public DefaultBillingRateCollection FetchByID(object Id)
{
DefaultBillingRateCollection coll = new DefaultBillingRateCollection().Where("id", Id).Load();
return(coll);
}