private void metroButton_add_bac_save_another_Click(object sender, EventArgs e) { valider(); Program.new_candidat_to_add.son_bac.Add(bac); bac = new Class_bac(); vider_form(); }
public static Class_bac get_bac_by_id(int id) { Class_bac bac = new Class_bac(); try { if (connection_x.State != ConnectionState.Open) { connection_x.Open(); } string query = "select b.Type_,b.annee_obtention from baccalaureat b where b.ID_bac = "; query += id.ToString(); SqlCommand command3 = new SqlCommand(query, connection_x); SqlDataReader reader = command3.ExecuteReader(); while (reader.Read()) { bac.Type = reader[0].ToString(); bac.annee_obtention = (int)reader[1]; } connection_x.Close(); } catch (Exception t) { MessageBox.Show(t.ToString()); } return(bac); }
public void afficher_bac() { if (bac_ids.Count > 0) { foreach (int i in bac_ids) { Class_bac bac = Class_Database_app.get_bac_by_id(i); richTextBox_baccalaureat.Text += bac.Type + "\t" + bac.annee_obtention; richTextBox_baccalaureat.Text += "\n ------------------ \n"; } } else if (niveu_bac_ids.Count > 0) { foreach (int i in niveu_bac_ids) { Class_niveau_bac niveau = Class_Database_app.get_niveau_bac_by_id(i); richTextBox_baccalaureat.Text += "Niveau Bac :" + niveau.type + "\t" + niveau.annee; richTextBox_baccalaureat.Text += "\n --------------------- \n"; } } }