/// <inheritdoc />
public int AddFacture(FactureDTO factureDTO)
{
try
{
return factureDAO.Add(factureDTO);
}
catch (DAOException daoException)
{
throw new ServiceException(daoException.Message);
}
}
/// <inheritdoc />
public int Add(FactureDTO factureDTO)
{
int n = 0;
try
{
connexion.Open();
command.CommandText = ADD_REQUEST;
command.Parameters.Add(new MySqlParameter("@idLocation", factureDTO.IdLocation));
command.Parameters.Add(new MySqlParameter("@idEmploye", factureDTO.IdEmploye));
command.Parameters.Add(new MySqlParameter("@dateFacture", factureDTO.DateFacture));
n = command.ExecuteNonQuery();
}
catch (MySqlException mySqlException)
{
throw mySqlException;
}
finally
{
connexion.Close();
}
return n;
}
/// <inheritdoc />
public int UpdateFacture(FactureDTO factureDTO, int id)
{
try
{
return factureDAO.Update(factureDTO,id);
}
catch (DAOException daoException)
{
throw new ServiceException(daoException.Message);
}
}
/// <inheritdoc />
public FactureDTO Read(int id)
{
FactureDTO factureDTO = new FactureDTO();
try
{
connexion.Open();
command.CommandText = READ_REQUEST;
command.Parameters.Add(new MySqlParameter("@idFacture", id));
MySqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
factureDTO.IdFacture = dr.GetInt32(0);
factureDTO.IdLocation = dr.GetInt32(1);
factureDTO.IdEmploye = dr.GetInt32(2);
factureDTO.DateFacture = dr.GetDateTime(3).ToString();
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException);
}
finally
{
connexion.Close();
}
return factureDTO;
}
/// <inheritdoc />
public List<FactureDTO> GetAll()
{
List<FactureDTO> factures = new List<FactureDTO>();
FactureDTO factureDTO = new FactureDTO();
try
{
connexion.Open();
command.CommandText = GET_ALL_REQUEST;
MySqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
factureDTO.IdFacture = dr.GetInt32(0);
factureDTO.IdLocation = dr.GetInt32(1);
factureDTO.IdEmploye = dr.GetInt32(2);
factureDTO.DateFacture = dr.GetDateTime(3).ToString();
factures.Add(factureDTO);
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException);
}
finally
{
connexion.Close();
}
return factures;
}
/// <inheritdoc />
public List<FactureDTO> FindByLocation(int id)
{
List<FactureDTO> factures = new List<FactureDTO>();
FactureDTO factureDTO = new FactureDTO();
try
{
connexion.Open();
command.CommandText = FIND_BY_LOCATION;
command.Parameters.Add(new MySqlParameter("@idLocation", id));
MySqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
factureDTO.IdFacture = dr.GetInt32(0);
factureDTO.IdLocation = dr.GetInt32(1);
factureDTO.IdEmploye = dr.GetInt32(2);
factureDTO.DateFacture = dr.GetDateTime(3).ToString();
factures.Add(factureDTO);
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException);
}
finally
{
connexion.Close();
}
return factures;
}