public function add(Projet $projet)
{
$query = $this->_db->prepare('INSERT INTO t_projet (name, description, adresse, dateCreation, avancementConstruction, avancementFinition, created, createdBy)
VALUES (:name, :description, :adresse, :dateCreation, :avancementConstruction, :avancementFinition, :created, :createdBy)') or die(print_r($this->_db->errorInfo()));
$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(':created', $projet->created());
$query->bindValue(':createdBy', $projet->createdBy());
$query->execute();
$query->closeCursor();
}
public function add(Projet $projet)
{
$query = $this->_db->prepare('INSERT INTO t_projet (nom, titre, adresse, superficie, description, budget, createdBy, created)
VALUES (:nom, :titre, :adresse, :superficie, :description, :budget, :createdBy, :created)') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':nom', $projet->nom());
$query->bindValue(':titre', $projet->titre());
$query->bindValue(':adresse', $projet->adresse());
$query->bindValue(':superficie', $projet->superficie());
$query->bindValue(':description', $projet->description());
$query->bindValue(':budget', $projet->budget());
$query->bindValue(':created', $projet->created());
$query->bindValue(':createdBy', $projet->createdBy());
$query->execute();
$query->closeCursor();
}
public function update(Projet $projet)
{
$query = $this->_db->prepare(' UPDATE t_projet SET
nom=:nom,numeroTitre=:numeroTitre,emplacement=:emplacement,
superficie=:superficie, description=:description,dateCreation=:dateCreation,
createdBy=:createdBy,created=:created, idSociete=:idSociete
WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $projet->id());
$query->bindValue(':nom', $projet->nom());
$query->bindValue(':numeroTitre', $projet->numeroTitre());
$query->bindValue(':emplacement', $projet->emplacement());
$query->bindValue(':superficie', $projet->superficie());
$query->bindValue(':description', $projet->description());
$query->bindValue(':dateCreation', $projet->dateCreation());
$query->bindValue(':createdBy', $projet->createdBy());
$query->bindValue(':created', $projet->created());
$query->bindValue(':idSociete', $projet->idSociete());
$query->execute();
$query->closeCursor();
}
