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

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

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

            return(coll);
        }