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

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

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

            return(coll);
        }