public function update(ContratEmploye $contratEmploye)
{
$query = $this->_db->prepare(' UPDATE t_contratEmploye SET
dateContrat=:dateContrat, nombreUnites=:nombreUnites, prixUnitaire=:prixUnitaire,
total=:total, employe=:employe, idProjet=:idProjet WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $contratEmploye->id());
$query->bindValue(':dateContrat', $contratEmploye->dateContrat());
$query->bindValue(':prixUnitaire', $contratEmploye->prixUnitaire());
$query->bindValue(':nombreUnites', $contratEmploye->nombreUnites());
$query->bindValue(':total', $contratEmploye->total());
$query->bindValue(':employe', $contratEmploye->employe());
$query->bindValue(':idProjet', $contratEmploye->idProjet());
$query->execute();
$query->closeCursor();
}
public function update(ContratEmploye $contratEmploye){
$query = $this->_db->prepare(
'UPDATE t_contratemploye SET dateContrat=:dateContrat, dateFinContrat=:dateFinContrat,
nombreUnites=:nombreUnites, prixUnitaire=:prixUnitaire, unite=:unite, nomUnite=:nomUnite, nomUniteArabe=:nomUniteArabe,
nombreUnites2=:nombreUnites2, prixUnitaire2=:prixUnitaire2, unite2=:unite2, nomUnite2=:nomUnite2, nomUniteArabe2=:nomUniteArabe2,
traveaux=:traveaux, traveauxArabe=:traveauxArabe, articlesArabes=:articlesArabes, total=:total, employe=:employe, idSociete=:idSociete, idProjet=:idProjet
WHERE id=:id')
or die (print_r($this->_db->errorInfo()));
$query->bindValue(':id', $contratEmploye->id());
$query->bindValue(':dateContrat', $contratEmploye->dateContrat());
$query->bindValue(':dateFinContrat', $contratEmploye->dateFinContrat());
$query->bindValue(':prixUnitaire', $contratEmploye->prixUnitaire());
$query->bindValue(':unite', $contratEmploye->unite());
$query->bindValue(':nomUnite', $contratEmploye->nomUnite());
$query->bindValue(':nomUniteArabe', $contratEmploye->nomUniteArabe());
$query->bindValue(':nombreUnites', $contratEmploye->nombreUnites());
$query->bindValue(':prixUnitaire2', $contratEmploye->prixUnitaire2());
$query->bindValue(':unite2', $contratEmploye->unite2());
$query->bindValue(':nomUnite2', $contratEmploye->nomUnite2());
$query->bindValue(':nomUniteArabe2', $contratEmploye->nomUniteArabe2());
$query->bindValue(':nombreUnites2', $contratEmploye->nombreUnites2());
$query->bindValue(':traveaux', $contratEmploye->traveaux());
$query->bindValue(':traveauxArabe', $contratEmploye->traveauxArabe());
$query->bindValue(':articlesArabes', $contratEmploye->articlesArabes());
$query->bindValue(':total', $contratEmploye->total());
$query->bindValue(':employe', $contratEmploye->employe());
$query->bindValue(':idSociete', $contratEmploye->idSociete());
$query->bindValue(':idProjet', $contratEmploye->idProjet());
$query->execute();
$query->closeCursor();
}
