public static List <Contenir> readAll() { List <Contenir> res = new List <Contenir>(); Contenir ctnr = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM materiels"; cmd.Connection = Connexion.getInstance(); try { MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Materiel idM = MaterielADO.findById(reader["idM"].ToString()); Commande idCo = CommandeADO.findById(reader["idCo"].ToString()); string nbMateriel = reader["nbMateriel"].ToString(); ctnr = new Contenir(idM, idCo, nbMateriel); res.Add(ctnr); } cmd = null; reader.Close(); reader = null; } catch (Exception ex) { Console.WriteLine("Erreur de dataReader : " + ex.Message); } return(res); }
public static Contenir findById(string id) { Contenir ctnr = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM contenir WHERE idCo = @idCo"; cmd.Parameters.AddWithValue("@idCo", id); //Connexion temporaire ! string chaineDeConnexion = "server=localhost; database=projet dj; username=root; Pooling=true; charset=utf8"; MySqlConnection connexion = null; try { connexion = new MySqlConnection(chaineDeConnexion); connexion.Open(); } catch (Exception ex) { Console.WriteLine("Erreur de connexion : " + ex.Message); } cmd.Connection = connexion; try { MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { Materiel idM = MaterielADO.findById(reader["idM"].ToString()); Commande idCo = CommandeADO.findById(reader["idCo"].ToString()); string nbMateriel = reader["nbMateriel"].ToString(); ctnr = new Contenir(idM, idCo, nbMateriel); } cmd = null; reader.Close(); reader = null; } catch (Exception ex) { Console.WriteLine("Erreur de dataReader : " + ex.Message); } connexion.Close(); connexion = null; return(ctnr); }
// **************************************** RECHERCHE ************************************** public static List <Contenir> findByRecherche(string recherche) { List <Contenir> res = new List <Contenir>(); Contenir ctnr = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM contenir WHERE idCo LIKE '" + recherche + "%'"; //Connexion temporaire ! string chaineDeConnexion = "server=localhost; database=projet dj; username=root; Pooling=true; charset=utf8"; MySqlConnection connexion = null; try { connexion = new MySqlConnection(chaineDeConnexion); connexion.Open(); } catch (Exception ex) { Console.WriteLine("Erreur de connexion : " + ex.Message); } cmd.Connection = connexion; try { MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Materiel idM = MaterielADO.findById(reader["idM"].ToString()); Commande idCo = CommandeADO.findById(reader["idCo"].ToString()); string nbMateriel = reader["nbMateriel"].ToString(); ctnr = new Contenir(idM, idCo, nbMateriel); res.Add(ctnr); } cmd = null; reader.Close(); reader = null; } catch (Exception ex) { Console.WriteLine("Erreur de dataReader : " + ex.Message); } connexion.Close(); connexion = null; return(res); }