public function executeDeleteregion()
 {
     $regionid = $this->getRequestParameter('id');
     $c = new Criteria();
     $c->add(ChapterregionPeer::REGION_ID, $regionid);
     $chcount = ChapterregionPeer::doCount($c);
     $chapterregion = ChapterregionPeer::doSelectOne($c);
     if ($chapterregion) {
         $this->setFlash('notice', 'Region cannot be deleted. <b>' . $chcount . '</b> chapters belong to this region.');
     } else {
         $region = RegionPeer::retrieveByPK($regionid);
         $region->delete();
         $this->setFlash('notice', 'Region deleted Successfully.');
     }
     $this->redirect('admin/regions');
 }
 public function countChapterregions($criteria = null, $distinct = false, $con = null)
 {
     include_once 'lib/model/om/BaseChapterregionPeer.php';
     if ($criteria === null) {
         $criteria = new Criteria();
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     $criteria->add(ChapterregionPeer::CHAPTER_ID, $this->getId());
     return ChapterregionPeer::doCount($criteria, $distinct, $con);
 }