// ====================================== end of insertion in database ============================================

        // ====================================== search in database ============================================

        public void searchCatRecord(PCategoryDTO DTO)
        {
            pCategoryDAL = new ProductCategoryDAL();
            pCategoryDAL.searchCatInDatabase(DTO);
        }