public function add(Locaux $locaux)
{
$query = $this->_db->prepare('INSERT INTO t_locaux (nom, superficie, facade, prix,
mezzanine, status, idProjet, par, created, createdBy)
VALUES (:nom, :superficie, :facade, :prix, :mezzanine,
:status, :idProjet, :par, :created, :createdBy)') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':nom', $locaux->nom());
$query->bindValue(':superficie', $locaux->superficie());
$query->bindValue(':facade', $locaux->facade());
$query->bindValue(':prix', $locaux->prix());
$query->bindValue(':mezzanine', $locaux->mezzanine());
$query->bindValue(':status', $locaux->status());
$query->bindValue(':idProjet', $locaux->idProjet());
$query->bindValue(':par', $locaux->par());
$query->bindValue(':created', $locaux->created());
$query->bindValue(':createdBy', $locaux->createdBy());
$query->execute();
$query->closeCursor();
}
