/// <inheritdoc />
public int AddReservation(ReservationDTO reservationDTO)
{
try
{
return reservationDAO.Add(reservationDTO);
}
catch (DAOException daoException)
{
throw new ServiceException(daoException.Message);
}
}
public int Add(ReservationDTO reservationDTO)
{
int n = 0;
try
{
connexion.Open();
command.CommandText = ADD_REQUEST;
command.Parameters.Add(new MySqlParameter("@idMembre", reservationDTO.IdMembre));
command.Parameters.Add(new MySqlParameter("@idVoiture", reservationDTO.IdVoiture));
command.Parameters.Add(new MySqlParameter("@idEmploye", reservationDTO.IdEmploye));
command.Parameters.Add(new MySqlParameter("@dateReservation", reservationDTO.DateReservation));
n = command.ExecuteNonQuery();
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return n;
}
/// <inheritdoc />
public int UpdateReservation(ReservationDTO reservationDTO, int id)
{
try
{
return reservationDAO.Update(reservationDTO, id);
}
catch (DAOException daoException)
{
throw new ServiceException(daoException.Message);
}
}
public ReservationDTO Read(int id)
{
ReservationDTO reservationDTO = new ReservationDTO();
try
{
connexion.Open();
command.CommandText = READ_REQUEST;
command.Parameters.Add(new MySqlParameter("@idReservation", id));
MySqlDataReader dr = command.ExecuteReader();
while(dr.Read()){
reservationDTO.IdReservation = dr.GetInt32(0);
reservationDTO.IdMembre = dr.GetInt32(1);
reservationDTO.IdVoiture = dr.GetInt32(2);
reservationDTO.IdEmploye = dr.GetInt32(3);
reservationDTO.DateReservation = dr.GetDateTime(4).ToString();
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return reservationDTO;
}
public List<ReservationDTO> GetAll()
{
List<ReservationDTO> reservations = new List<ReservationDTO>();
try
{
connexion.Open();
command.CommandText = GET_ALL_REQUEST;
MySqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
ReservationDTO reservationDTO = new ReservationDTO();
reservationDTO.IdReservation = dr.GetInt32(0);
reservationDTO.IdMembre = dr.GetInt32(1);
reservationDTO.IdVoiture = dr.GetInt32(2);
reservationDTO.IdEmploye = dr.GetInt32(3);
reservationDTO.DateReservation = dr.GetDateTime(4).ToString();
reservations.Add(reservationDTO);
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return reservations;
}
public List<ReservationDTO> FindByVoiture(int id)
{
List<ReservationDTO> reservations = new List<ReservationDTO>();
try
{
connexion.Open();
command.CommandText = FIND_BY_VOITURE;
command.Parameters.Add(new MySqlParameter("@idVoiture", id));
MySqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
ReservationDTO reservationDTO = new ReservationDTO();
reservationDTO.IdReservation = dr.GetInt32(0);
reservationDTO.IdMembre = dr.GetInt32(1);
reservationDTO.IdVoiture = dr.GetInt32(2);
reservationDTO.IdEmploye = dr.GetInt32(3);
reservationDTO.DateReservation = dr.GetDateTime(4).ToString();
reservations.Add(reservationDTO);
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return reservations;
}
