public function add(Terrain $terrain)
{
$query = $this->_db->prepare('INSERT INTO t_terrain (prix, vendeur, fraisAchat, superficie, emplacement, idProjet, created, createdBy)
VALUES (:prix, :vendeur, :fraisAchat, :superficie, :emplacement, :idProjet, :created, :createdBy)') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':prix', $terrain->prix());
$query->bindValue(':vendeur', $terrain->vendeur());
$query->bindValue(':fraisAchat', $terrain->fraisAchat());
$query->bindValue(':superficie', $terrain->superficie());
$query->bindValue(':emplacement', $terrain->emplacement());
$query->bindValue(':idProjet', $terrain->idProjet());
$query->bindValue(':created', $terrain->created());
$query->bindValue(':createdBy', $terrain->createdBy());
$query->execute();
$query->closeCursor();
}
public function add(Terrain $terrain)
{
$query = $this->_db->prepare(' INSERT INTO t_terrain (
numeroTitre,nom,superficie,surplan,emplacement,prix, status, idProjet,created,createdBy)
VALUES (:numeroTitre,:nom,:superficie,:surplan,:emplacement,:prix, :status,:idProjet,:created,:createdBy)') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':numeroTitre', $terrain->numeroTitre());
$query->bindValue(':nom', $terrain->nom());
$query->bindValue(':superficie', $terrain->superficie());
$query->bindValue(':surplan', $terrain->surplan());
$query->bindValue(':emplacement', $terrain->emplacement());
$query->bindValue(':prix', $terrain->prix());
$query->bindValue(':status', $terrain->status());
$query->bindValue(':idProjet', $terrain->idProjet());
$query->bindValue(':created', $terrain->created());
$query->bindValue(':createdBy', $terrain->createdBy());
$query->execute();
$query->closeCursor();
}
