public TblPaymentDetailCollection FetchByQuery(Query qry)
        {
            var coll = new TblPaymentDetailCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public TblPaymentDetailCollection FetchAll()
        {
            var coll = new TblPaymentDetailCollection();
            var qry  = new Query(TblPaymentDetail.Schema);

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

            return(coll);
        }