// ====================================== end of insertion in database ============================================
// ====================================== search in database ============================================
public void searchCatRecord(PCategoryDTO DTO)
{
pCategoryDAL = new ProductCategoryDAL();
pCategoryDAL.searchCatInDatabase(DTO);
}