public static bool update(Materiel mat) { bool res = false; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "UPDATE materiels SET nom = @nom, puissance = @puissance, dimensions = @dimensions, masse = @masse, stock = @stock, prixAchat = @prixAchat, prixLocation = @prixLocation, image = @image WHERE idM = @idM"; cmd.Parameters.AddWithValue("@nom", mat.Nom); cmd.Parameters.AddWithValue("@puissance", mat.Puissance); cmd.Parameters.AddWithValue("@dimensions", mat.Dimensions); cmd.Parameters.AddWithValue("@masse", mat.Masse); cmd.Parameters.AddWithValue("@stock", mat.Stock); cmd.Parameters.AddWithValue("@prixAchat", mat.PrixAchat); cmd.Parameters.AddWithValue("@prixLocation", mat.PrixLocation); cmd.Parameters.AddWithValue("@prixVente", mat.PrixVente); cmd.Parameters.AddWithValue("@image", mat.Image); cmd.Parameters.AddWithValue("@idM", mat.Id); cmd.Connection = Connexion.getInstance(); try { cmd.ExecuteNonQuery(); cmd = null; res = true; } catch (Exception ex) { Console.WriteLine("Erreur de ExecuteNonQuery : " + ex.Message); } return(res); }
private void LblValider_Click(object sender, EventArgs e) { int i = 0; string idM; string nom = txtBoxNom.Text; int puissance = Int32.Parse(txtBoxPuissance.Text); string dimensions = txtBoxDimensions.Text; float masse = float.Parse(txtBoxMasse.Text); int stock = Int32.Parse(txtBoxStock.Text); float prixAchat = float.Parse(txtBoxPA.Text); float prixLocation = float.Parse(txtBoxPL.Text); float prixVente = float.Parse(txtBoxPV.Text); string image = txtBoxImage.Text; foreach (Materiel mat in MaterielADO.readAll()) { idM = i.ToString(); if (mat.Nom != nom && mat.Id != idM) { Materiel mat2 = new Materiel(idM, nom, puissance, dimensions, masse, stock, prixAchat, prixLocation, prixVente, image); MaterielADO.create(mat2); MessageBox.Show("Enregistré"); } i++; } }
public static void create(Materiel mat) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO materiels (nom, puissance, dimensions, masse, stock, prixAchat, prixLocation, prixVente, image) " + "VALUES(@nom, @puissance, @dimensions, @masse, @stock, @prixAchat, @prixLocation, @prixVente, @image)"; cmd.Parameters.AddWithValue("@nom", mat.Nom); cmd.Parameters.AddWithValue("@puissance", mat.Puissance); cmd.Parameters.AddWithValue("@dimensions", mat.Dimensions); cmd.Parameters.AddWithValue("@masse", mat.Masse); cmd.Parameters.AddWithValue("@stock", mat.Stock); cmd.Parameters.AddWithValue("@prixAchat", mat.PrixAchat); cmd.Parameters.AddWithValue("@prixLocation", mat.PrixLocation); cmd.Parameters.AddWithValue("@prixVente", mat.PrixVente); cmd.Parameters.AddWithValue("@image", mat.Image); cmd.Connection = Connexion.getInstance(); try { cmd.ExecuteNonQuery(); cmd = null; } catch (Exception ex) { Console.WriteLine("Erreur de ExecuteNonQuery : " + ex.Message); } }
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 Materiel findById(string id) { Materiel mat = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM materiels WHERE idM = @idM"; cmd.Parameters.AddWithValue("@idM", 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()) { string idM = reader["idM"].ToString(); string nom = reader["nom"].ToString(); int puissance = Int32.Parse(reader["puissance"].ToString()); string dimensions = reader["dimensions"].ToString(); float masse = float.Parse(reader["masse"].ToString()); int stock = Int32.Parse(reader["stock"].ToString()); float prixAchat = float.Parse(reader["prixAchat"].ToString()); float prixLocation = float.Parse(reader["prixLocation"].ToString()); float prixVente = float.Parse(reader["prixVente"].ToString()); string image = reader["image"].ToString(); mat = new Materiel(idM, nom, puissance, dimensions, masse, stock, prixAchat, prixLocation, prixVente, image); } cmd = null; reader.Close(); reader = null; } catch (Exception ex) { Console.WriteLine("Erreur de dataReader : " + ex.Message); } connexion.Close(); connexion = null; return(mat); }
// **************************************** RECHERCHE ************************************** public static List <Materiel> findByRecherche(string recherche) { List <Materiel> res = new List <Materiel>(); Materiel mat = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM materiels WHERE nom 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()) { string nom = reader["nom"].ToString(); int puissance = Int32.Parse(reader["puissance"].ToString()); string dimensions = reader["dimensions"].ToString(); float masse = float.Parse(reader["masse"].ToString()); int stock = Int32.Parse(reader["stock"].ToString()); float prixAchat = float.Parse(reader["prixAchat"].ToString()); float prixLocation = float.Parse(reader["prixLocation"].ToString()); float prixVente = float.Parse(reader["prixVente"].ToString()); string image = reader["image"].ToString(); mat = new Materiel(nom, puissance, dimensions, masse, stock, prixAchat, prixLocation, prixVente, image); res.Add(mat); } cmd = null; reader.Close(); reader = null; } catch (Exception ex) { Console.WriteLine("Erreur de dataReader : " + ex.Message); } connexion.Close(); connexion = null; 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); }
public static bool delete(Materiel mat) { bool res = false; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "DELETE FROM materiels WHERE idM = @idM"; cmd.Parameters.AddWithValue("@idM", mat.Id); cmd.Connection = Connexion.getInstance(); try { cmd.ExecuteNonQuery(); cmd = null; res = true; } catch (Exception ex) { Console.WriteLine("Erreur de ExecuteNonQuery : " + ex.Message); } return(res); }
public static List <Materiel> readAll() { List <Materiel> res = new List <Materiel>(); Materiel mat = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM materiels"; cmd.Connection = Connexion.getInstance(); try { MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string idM = reader["idM"].ToString(); string nom = reader["nom"].ToString(); int puissance = Int32.Parse(reader["puissance"].ToString()); string dimensions = reader["dimensions"].ToString(); float masse = float.Parse(reader["masse"].ToString()); int stock = Int32.Parse(reader["stock"].ToString()); float prixAchat = float.Parse(reader["prixAchat"].ToString()); float prixLocation = float.Parse(reader["prixLocation"].ToString()); float prixVente = float.Parse(reader["prixVente"].ToString()); string image = reader["image"].ToString(); mat = new Materiel(idM, nom, puissance, dimensions, masse, stock, prixAchat, prixLocation, prixVente, image); res.Add(mat); } cmd = null; reader.Close(); reader = null; } catch (Exception ex) { Console.WriteLine("Erreur de dataReader : " + ex.Message); } return(res); }
public Contenir(Materiel idM, Commande idCo, string nbMateriel) { this.idM = idM; this.idCo = idCo; this.nbMateriel = nbMateriel; }