public BillingAccountCollection FetchAll() { BillingAccountCollection coll = new BillingAccountCollection(); Query qry = new Query(BillingAccount.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public BillingAccountCollection FetchAccountsNotActive(Int32 periodid) { BillingAccountCollection disabledacocunts = new BillingAccountCollection(); BillingAccountCollection col = new BillingAccountCollection().Load(); disabledacocunts.AddRange(col); foreach (BillingPeriodAccount billingperiodaccount in new BillingPeriodAccountCollection().Where(BillingPeriodAccount.Columns.Periodid, periodid).Load()) foreach (BillingAccount account in col) if (account.Id == billingperiodaccount.Accountid) disabledacocunts.Remove(account); return disabledacocunts; }
public BillingAccountCollection FetchByQuery(Query qry) { BillingAccountCollection coll = new BillingAccountCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public BillingAccountCollection FetchByID(object Id) { BillingAccountCollection coll = new BillingAccountCollection().Where("id", Id).Load(); return coll; }