public function add(Commande $commande){
$query = $this->_db->prepare(' INSERT INTO t_commande (
idFournisseur, idProjet, dateCommande, numeroCommande, designation, status, codeLivraison, created, createdBy)
VALUES (:idFournisseur, :idProjet, :dateCommande, :numeroCommande, :designation, :status, :codeLivraison, :created, :createdBy)')
or die (print_r($this->_db->errorInfo()));
$query->bindValue(':idFournisseur', $commande->idFournisseur());
$query->bindValue(':idProjet', $commande->idProjet());
$query->bindValue(':dateCommande', $commande->dateCommande());
$query->bindValue(':numeroCommande', $commande->numeroCommande());
$query->bindValue(':designation', $commande->designation());
$query->bindValue(':status', $commande->status());
$query->bindValue(':codeLivraison', $commande->codeLivraison());
$query->bindValue(':created', $commande->created());
$query->bindValue(':createdBy', $commande->createdBy());
$query->execute();
$query->closeCursor();
}
