public function add(Operation $operation){
$query = $this->_db->prepare(
'INSERT INTO t_operation (date, dateReglement, compteBancaire, observation, reference,
montant, modePaiement, idContrat, numeroCheque, status, url, created, createdBy)
VALUES (:date, :dateReglement, :compteBancaire, :observation, :reference, :montant,
:modePaiement,:idContrat, :numeroCheque, :status, :url, :created, :createdBy)')
or die(print_r($this->_db->errorInfo()));
$query->bindValue(':date', $operation->date());
$query->bindValue(':dateReglement', $operation->dateReglement());
$query->bindValue(':compteBancaire', $operation->compteBancaire());
$query->bindValue(':observation', $operation->observation());
$query->bindValue(':montant', $operation->montant());
$query->bindValue(':reference', $operation->reference());
$query->bindValue(':modePaiement', $operation->modePaiement());
$query->bindValue(':numeroCheque', $operation->numeroCheque());
$query->bindValue(':status', $operation->status());
$query->bindValue(':idContrat', $operation->idContrat());
$query->bindValue(':url', $operation->url());
$query->bindValue(':created', $operation->created());
$query->bindValue(':createdBy', $operation->createdBy());
$query->execute();
$query->closeCursor();
}
