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

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

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

            return(coll);
        }