Exemplo n.º 1
0
 public function ajouterFrais(Frais $frais, NoteFrais $note)
 {
     $sql_frais = "INSERT INTO frais(id,id_categorie,montant,id_devise,commentaire,date_frais) VALUES (:id,:id_categorie,:montant,:id_devise,:commentaire,:date_frais)";
     $donnees = array('id' => $frais->getId(), 'id_categorie' => $frais->getId_categorie(), 'montant' => $frais->getMontant(), 'id_devise' => $frais->getId_devise(), 'commentaire' => $frais->getCommentaire(), 'date_frais' => $frais->getDate_frais());
     try {
         $req_frais = $this->base->prepapre($sql_frais);
         $req_frais->execute($donnees);
     } catch (Exception $ex) {
         echo "Erreur Création Du Frais : {$ex->getMessage}()";
         return false;
     }
     $sql_addFrais = "INSERT into fraisdansnote(id_note,id_frais) VALUES (:id_note,:id_frais)";
     $data = array('id_note' => $note->getIdNote(), 'id_frais' => $frais->getId());
     try {
         $req_addFrais = $this->base->prepare($sql_addFrais);
         $req_addFrais->execute($data);
     } catch (Exception $ex) {
         echo " Erreur : Ajout Frais dans Note de Frais : {$ex->getMessage}()";
         return false;
     }
 }