public Plaintes RecupererPlainteSelectionne() { Plaintes PlainteSelectionne = new Plaintes(); try { //Ouverture connexion GestConn.Open(); //Requete SQL String ReqSql = "SELECT * FROM plainte WHERE ID_PLAINTE=" + dataGridViewPlainte.CurrentRow.Cells[0].Value.ToString(); MySqlCommand MaCommande = new MySqlCommand(ReqSql, GestConn); //Déclaration de Data Reader MySqlDataReader ReaderPlainte; //Exécution de la requête ReaderPlainte = MaCommande.ExecuteReader(); while (ReaderPlainte.Read()) { PlainteSelectionne.id_plaignant = int.Parse(ReaderPlainte["ID_PLAIGNANT"].ToString()); PlainteSelectionne.id_accuse = int.Parse(ReaderPlainte["ID_ACCUSE"].ToString()); } ReaderPlainte.Close(); GestConn.Close(); } catch (Exception ex) { MessageBox.Show("Erreur : " + ex.Message); } return(PlainteSelectionne); }
private void ChargementCollectionPlainte(String requeteSQL) { try { CollPlainte.Clear(); //Ouverture connexion GestConn.Open(); //Requete SQL MySqlCommand MaCommande = new MySqlCommand(requeteSQL, GestConn); //Déclaration de Data Reader MySqlDataReader ReaderPlainte; //Exécution de la requête ReaderPlainte = MaCommande.ExecuteReader(); //Nouveau contact Plaintes NouvellePlainte; while (ReaderPlainte.Read()) { NouvellePlainte.id_plainte = int.Parse(ReaderPlainte["ID_PLAINTE"].ToString()); NouvellePlainte.id_plaignant = int.Parse(ReaderPlainte["ID_PLAIGNANT"].ToString()); NouvellePlainte.id_accuse = int.Parse(ReaderPlainte["ID_ACCUSE"].ToString()); NouvellePlainte.titre = (ReaderPlainte["TITRE_PLAINTE"].ToString()); NouvellePlainte.desc = (ReaderPlainte["DESC_PLAINTE"].ToString()); CollPlainte.Add(NouvellePlainte); } ReaderPlainte.Close(); GestConn.Close(); } catch (Exception ex) { MessageBox.Show("Erreur : " + ex.Message); } }
private void ChangerInformation(object sender, DataGridViewCellEventArgs e) { Plaintes LaPlainte = new Plaintes(); LaPlainte = RecupererPlainteSelectionne(); try { //Ouverture connexion GestConn.Open(); //Requete SQL String ReqSql = "SELECT * FROM membre WHERE ID_MEMBRE=" + LaPlainte.id_plaignant; String ReqSql2 = "SELECT * FROM membre WHERE ID_MEMBRE=" + LaPlainte.id_accuse; MySqlCommand MaCommande = new MySqlCommand(ReqSql, GestConn); MySqlCommand MaCommande2 = new MySqlCommand(ReqSql2, GestConn); //Déclaration de Data Reader MySqlDataReader ReaderPlainte; //Exécution de la requête ReaderPlainte = MaCommande.ExecuteReader(); while (ReaderPlainte.Read()) { TxtNomPlaignant.Text = "Nom Plaignant : " + (ReaderPlainte["NOM_MEMBRE"].ToString()) + " " + (ReaderPlainte["PRENOM_MEMBRE"].ToString()); } ReaderPlainte.Close(); ReaderPlainte = MaCommande2.ExecuteReader(); while (ReaderPlainte.Read()) { TxtNomAccuse.Text = "Nom Accusé : " + (ReaderPlainte["NOM_MEMBRE"].ToString()) + " " + (ReaderPlainte["PRENOM_MEMBRE"].ToString()); } ReaderPlainte.Close(); GestConn.Close(); } catch (Exception ex) { MessageBox.Show("Erreur : " + ex.Message); } }