public static Etudiant RechercheE(string code) { using (MySqlConnection cnx = gestionConnection.getConnection()) { Console.WriteLine("wssalt l hna 1 "); Etudiant E = new Etudiant(); // the state of my connection was closed sometimes so i added this line if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "select * from eleves where codeElev='" + code + "';"; cmd.Connection = cnx; Console.WriteLine(cnx.State); if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlDataReader rd = cmd.ExecuteReader(); E.Code = code; while (rd.Read()) { E.Nom = rd[1].ToString(); E.Prenom = rd[2].ToString(); E.Niveau = rd[3].ToString(); E.Code_Fil = rd[4].ToString(); } Console.WriteLine("wssalt l hna 2 "); return(E); } }
private void button3_Click(object sender, EventArgs e) { //I need to check if all textboxes are full foreach (Control x in this.Controls) { if (x is TextBox) { if (((TextBox)x).Text == String.Empty) { MessageBox.Show("Tous les champs doivent être remplies"); return; } } if (x is ComboBox) { if (((ComboBox)x).Text == String.Empty) { MessageBox.Show("Tous les champs doivent être remplies"); return; } } } // Now i need to update Etudiant et1 = new Etudiant(); et1.Code = this.codeE; et1.Nom = textBox1.Text; et1.Prenom = textBox2.Text; et1.Code_Fil = comboBox1.Text; et1.Niveau = textBox3.Text; GererEtudiant.UpdateE(et1); MessageBox.Show("Etudiant Modifié"); this.Close(); }
public ComboBoxModif(Etudiant e) { InitializeComponent(); this.codeE = label2.Text = e.Code; textBox1.Text = e.Nom; textBox2.Text = e.Prenom; comboBox1.Text = e.Code_Fil; textBox3.Text = e.Niveau; }
private void button3_Click(object sender, EventArgs e) // Modifier { DataGridViewCell d = dataGridView1.SelectedCells[0]; string code = d.Value.ToString(); if (code == "") { MessageBox.Show("Sélectionnez un étudiant pour le modifier"); return; } Etudiant et = GererEtudiant.RechercheE(code); ComboBoxModif frm = new ComboBoxModif(et); frm.Show(); }
public Form2(Etudiant E) { InitializeComponent(); this.E = E; label4.Text = E.Code; MySqlDataAdapter sqlDa = GererMatieres.RechercheMs(E); DataTable Matières = new DataTable("Matières"); sqlDa.Fill(Matières); foreach (DataRow dr in Matières.Rows) { comboBox1.Items.Add(dr[0].ToString()); } InitialiserGrid(); }
private void button6_Click(object sender, EventArgs e) // gestion des notes { DataGridViewCell d0 = dataGridView1.SelectedCells[0]; string code = d0.Value.ToString(); if (code == "") { MessageBox.Show("Sélectionnez un étudiant pour le modifier"); return; } Etudiant E = GererEtudiant.RechercheE(code);// we need etudiant with that code Form2 frm2 = new Form2(E); frm2.Show(); }
private void button5_Click(object sender, EventArgs e) // Rechercher { MySqlDataAdapter sqlDa = null; string code = ""; string nom = ""; string prenom = ""; string fili = ""; string niveau = ""; if (!checkBox5.Checked && !checkBox4.Checked && !checkBox3.Checked && !checkBox2.Checked && !checkBox1.Checked) { MessageBox.Show("Choisissez un critère de recherche et entrez sa valeur !"); return; } if (checkBox1.Checked) { code = textBox1.Text; } if (checkBox2.Checked) { nom = textBox2.Text; } if (checkBox3.Checked) { prenom = textBox3.Text; } if (checkBox4.Checked) { fili = comboBox1.Text; } if (checkBox5.Checked) { niveau = comboBox2.Text; } Etudiant E = new Etudiant(code, nom, prenom, niveau, fili); sqlDa = GererEtudiant.RechercheE(E); DataTable tbl = new DataTable(); sqlDa.Fill(tbl); dataGridView1.DataSource = tbl; }
public static void AjouterEtudiant(Etudiant e) { using (MySqlConnection cnx = gestionConnection.getConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "insert into eleves values('" + e.Code + "','" + e.Nom + "','" + e.Prenom + "','" + e.Niveau + "','" + e.Code_Fil + "');"; cmd.Connection = cnx; Console.WriteLine(cnx.State); if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } cmd.ExecuteNonQuery(); } }
public static void UpdateE(Etudiant e) { using (MySqlConnection cnx = gestionConnection.getConnection()) { // the state of my connection was closed sometimes so i added this line if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "update eleves set nom='" + e.Nom + "',prenom='" + e.Prenom + "',niveau='" + e.Niveau + "'" + ",code_Fil='" + e.Code_Fil + "' where codeElev='" + e.Code + "';"; cmd.Connection = cnx; Console.WriteLine(cnx.State); if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } cmd.ExecuteNonQuery(); } }
public static MySqlDataAdapter RechercheE(Etudiant Etu) { using (MySqlConnection cnx = gestionConnection.getConnection()) { string codE = Etu.Code; string NomE = Etu.Nom; // Etudiant E = new Etudiant(); // the state of my connection was closed sometimes so i added this line if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "select * from eleves where codeElev like '%" + Etu.Code + "%'" + " and nom like '%" + Etu.Nom + "%' and prenom like '%" + Etu.Prenom + "%' and code_Fil like '%" + Etu.Code_Fil + "%' and niveau like '%" + Etu.Niveau + "%'; "; cmd.Connection = cnx; Console.WriteLine(cnx.State); if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlDataAdapter dtadapter = new MySqlDataAdapter(cmd.CommandText, cnx); //E.Code = code; //while (rd.Read()) //{ // E.Nom = rd[1].ToString(); // E.Prenom = rd[2].ToString(); // E.Niveau = rd[3].ToString(); // E.Code_Fil = rd[4].ToString(); //} return(dtadapter); } }
public static MySqlDataAdapter RechercheMs(Etudiant Etu) { using (MySqlConnection cnx = gestionConnection.getConnection()) { // the state of my connection was closed sometimes so i added this line if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "select * from matieres where niveau like '%" + Etu.Niveau + "%'" + " and code_Fil like '%" + Etu.Code_Fil + "%' ; "; cmd.Connection = cnx; Console.WriteLine(cnx.State); if (cnx.State == System.Data.ConnectionState.Closed) { cnx.Open(); } MySqlDataAdapter dtadapter = new MySqlDataAdapter(cmd.CommandText, cnx); return(dtadapter); } }