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);
}
}
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 SupprimerPlainte(object sender, DataGridViewCellEventArgs e)
{
try
{
//Ouverture connexion
GestConn.Open();
//Requete SQL
String ReqSql = "DELETE 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();
ReaderPlainte.Close();
GestConn.Close();
MessageBox.Show("Cette plainte est maintenant supprimée.");
dataGridViewPlainte.Rows.Clear();
ChargementCollectionPlainte(doSql());
DoRecherche();
}
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);
}
}
