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 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);
}
}
