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