public function update(Projet $projet)
{
$query = $this->_db->prepare('UPDATE t_projet SET
name=:name, description=:description, adresse=:adresse,
dateCreation=:dateCreation, avancementConstruction=:avancementConstruction,
avancementFinition=:avancementFinition, updated=:updated, updatedBy=:updatedBy
WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $projet->id());
$query->bindValue(':name', $projet->name());
$query->bindValue(':description', $projet->description());
$query->bindValue(':adresse', $projet->adresse());
$query->bindValue(':dateCreation', $projet->dateCreation());
$query->bindValue(':avancementConstruction', $projet->avancementConstruction());
$query->bindValue(':avancementFinition', $projet->avancementFinition());
$query->bindValue(':updated', $projet->updated());
$query->bindValue(':updatedBy', $projet->updatedBy());
$query->execute();
$query->closeCursor();
}