public function add(Fournisseur $fournisseur)
{
$query = $this->_db->prepare('INSERT INTO t_fournisseur (nom, adresse, email, telephone1, telephone2, fax, code, created, createdBy)
VALUES (:nom, :adresse, :email, :telephone1, :telephone2, :fax, :code, :created, :createdBy)') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':nom', $fournisseur->nom());
$query->bindValue(':adresse', $fournisseur->adresse());
$query->bindValue(':email', $fournisseur->email());
$query->bindValue(':telephone1', $fournisseur->telephone1());
$query->bindValue(':telephone2', $fournisseur->telephone2());
$query->bindValue(':fax', $fournisseur->fax());
$query->bindValue(':code', $fournisseur->code());
$query->bindValue(':created', $fournisseur->created());
$query->bindValue(':createdBy', $fournisseur->createdBy());
$query->execute();
$query->closeCursor();
}
