public BillingPeriodCollection FetchByQuery(Query qry)
        {
            BillingPeriodCollection coll = new BillingPeriodCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public BillingPeriodCollection FetchAll()
        {
            BillingPeriodCollection coll = new BillingPeriodCollection();
            Query qry = new Query(BillingPeriod.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public BillingPeriodCollection FetchByID(object Id)
        {
            BillingPeriodCollection coll = new BillingPeriodCollection().Where("id", Id).Load();

            return(coll);
        }