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;
}