public function add(Client $client)
 {
     $query = $this->_db->prepare('INSERT INTO t_client (nom, nomArabe, adresse, adresseArabe, telephone1, telephone2, cin, email, code, created, createdBy)
     VALUES (:nom, :nomArabe, :adresse, :adresseArabe, :telephone1, :telephone2, :cin, :email, :code, :created, :createdBy)') or die(print_r($this->_db->errorInfo()));
     $query->bindValue(':nom', $client->nom());
     $query->bindValue(':nomArabe', $client->nomArabe());
     $query->bindValue(':adresse', $client->adresse());
     $query->bindValue(':adresseArabe', $client->adresseArabe());
     $query->bindValue(':telephone1', $client->telephone1());
     $query->bindValue(':telephone2', $client->telephone2());
     $query->bindValue(':cin', $client->cin());
     $query->bindValue(':email', $client->email());
     $query->bindValue(':code', $client->code());
     $query->bindValue(':created', $client->created());
     $query->bindValue(':createdBy', $client->createdBy());
     $query->execute();
     $query->closeCursor();
 }