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

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

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

            return(coll);
        }