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