public int UpdateMembre(MembreDTO membreDTO,int id) { try { return membreDAO.Update(membreDTO,id); } catch (DAOException daoException) { throw new ServiceException(daoException.Message); } }
public int AddMembre(MembreDTO membreDTO) { try { return membreDAO.Add(membreDTO); } catch (DAOException daoException) { throw new ServiceException(daoException.Message); } }
/// <inheritdoc /> public int Add(MembreDTO membreDTO) { try { connexion.Open(); command.CommandText = ADD_REQUEST; command.Parameters.Add(new MySqlParameter("@nom", membreDTO.nom)); command.Parameters.Add(new MySqlParameter("@telephone", membreDTO.telephone)); command.Parameters.Add(new MySqlParameter("@adresse", membreDTO.adresse)); command.Parameters.Add(new MySqlParameter("@email", membreDTO.email)); command.Parameters.Add(new MySqlParameter("@nbLocation", membreDTO.nbLocation)); return command.ExecuteNonQuery(); } catch (MySqlException mySqlException) { throw mySqlException; } finally { connexion.Close(); } }
/// <inheritdoc /> public int Update(MembreDTO membreDTO,int id) { int n = 0; try { connexion.Open(); command.CommandText = UPDATE_REQUEST; command.Parameters.Add(new MySqlParameter("@nom", membreDTO.nom)); command.Parameters.Add(new MySqlParameter("@telephone", membreDTO.telephone)); command.Parameters.Add(new MySqlParameter("@adresse", membreDTO.adresse)); command.Parameters.Add(new MySqlParameter("@email", membreDTO.email)); command.Parameters.Add(new MySqlParameter("@nbLocation", membreDTO.nbLocation)); command.Parameters.Add(new MySqlParameter("@idMembre", id)); n = command.ExecuteNonQuery(); } catch (MySqlException mySqlException) { throw new DAOException(mySqlException); } finally { connexion.Close(); } return n; }
/// <inheritdoc /> public MembreDTO Read(int id) { MembreDTO membreDTO = new MembreDTO(); try { connexion.Open(); command.CommandText = READ_REQUEST; command.Parameters.Add(new MySqlParameter("@idMembre", id)); MySqlDataReader dr = command.ExecuteReader(); if (dr.Read()) { membreDTO.idMembre = dr.GetInt32(0); membreDTO.nom = dr.GetString(1); membreDTO.telephone = dr.GetString(2); membreDTO.adresse = dr.GetString(3); membreDTO.email = dr.GetString(4); membreDTO.nbLocation = dr.GetInt32(5); } } catch (MySqlException mySqlException) { throw new DAOException(mySqlException); } finally { connexion.Close(); } return membreDTO; }
/// <inheritdoc /> public List<MembreDTO> GetAll() { List<MembreDTO> membres = new List<MembreDTO>(); try { connexion.Open(); command.CommandText = GET_ALL_REQUEST; MySqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { MembreDTO membreDTO = new MembreDTO(); membreDTO.idMembre = dr.GetInt32(0); membreDTO.nom = dr.GetString(1); membreDTO.telephone = dr.GetString(2); membreDTO.adresse = dr.GetString(3); membreDTO.email = dr.GetString(4); membreDTO.nbLocation = dr.GetInt32(5); membres.Add(membreDTO); } } catch (MySqlException mySqlException) { throw new DAOException(mySqlException); } finally { connexion.Close(); } return membres; }
/// <inheritdoc /> public List<LocationDTO> GetAll() { List<LocationDTO> locations = new List<LocationDTO>(); LocationDTO locationDTO = new LocationDTO(); try { connexion.Open(); command.CommandText = GET_ALL_REQUEST; MySqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { locationDTO.IdLocation = dr.GetInt32(0); MembreDTO membre = new MembreDTO(); locationDTO.IdMembre = dr.GetInt32(1); VoitureDTO voiture = new VoitureDTO(); locationDTO.IdVoiture = dr.GetInt32(2); locationDTO.DateLocation = dr.GetDateTime(3).ToString(); locationDTO.DateRetour = dr.GetDateTime(4).ToString(); locations.Add(locationDTO); } } catch (MySqlException mySqlException) { throw new DAOException(mySqlException); } finally { connexion.Close(); } return locations; }