public function delete($vil_num)
{
$listePerNum = $this->getListeEtudiantInVille($vil_num);
$listeDepNum = $this->getListeDepartementInVille($vil_num);
if (isset($listePerNum) && !is_null($listePerNum)) {
$personneManager = new PersonneManager($this->db);
foreach ($listePerNum as $key => $value) {
$personneManager->deleteByPerNum($value);
}
}
if (isset($listeDepNum) && !is_null($listeDepNum)) {
$departementManager = new DepartementManager($this->db);
foreach ($listeDepNum as $cle => $valeur) {
$departementManager->delete($valeur);
}
}
$sql = "DELETE FROM ville WHERE vil_num=:vil_num";
$requete = $this->db->prepare($sql);
$requete->bindValue("vil_num", $vil_num);
$retour = $requete->execute();
return $retour;
}
