public function add(Commission $commission){
$query = $this->_db->prepare(' INSERT INTO t_commission (
titre, commissionnaire, montant, codeContrat, date, etat, created, createdBy)
VALUES (:titre, :commissionnaire, :montant, :codeContrat, :date, :etat, :created, :createdBy)')
or die (print_r($this->_db->errorInfo()));
$query->bindValue(':titre', $commission->titre());
$query->bindValue(':commissionnaire', $commission->commissionnaire());
$query->bindValue(':montant', $commission->montant());
$query->bindValue(':codeContrat', $commission->codeContrat());
$query->bindValue(':date', $commission->date());
$query->bindValue(':etat', $commission->etat());
$query->bindValue(':created', $commission->created());
$query->bindValue(':createdBy', $commission->createdBy());
$query->execute();
$query->closeCursor();
}
