public static Class_diplome get_diploma_by_id(int id_diploma) { Class_diplome diplome = new Class_diplome(); try { if (connection_x.State != ConnectionState.Open) { connection_x.Open(); } string query = "select d.Niveau,d.date_obtention,d.specialite,d.Etablissement from diplome d where d.ID_diplome = " + id_diploma; SqlCommand command3 = new SqlCommand(query, connection_x); SqlDataReader reader = command3.ExecuteReader(); while (reader.Read()) { diplome.niveau = reader[0].ToString(); diplome.date_obtention = (int)reader[1]; diplome.specialite = reader[2].ToString(); diplome.etablissement = reader[3].ToString(); } connection_x.Close(); } catch (Exception t) { MessageBox.Show(t.ToString()); } return(diplome); }
private void metroButton_add_new_Click(object sender, EventArgs e) { if (metroButton_add_new.Text == "Ajouter Nouveau") { enable_false_nav_buttons(); metroButton_update.Enabled = false; vider_form(); metroButton_add_new.Text = "Save"; } else if (metroButton_add_new.Text == "Save") { DialogResult x = MessageBox.Show("do you wanna save", "save", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (x == DialogResult.OK) { string query = ""; if (!metroCheckBox_add_diploma_En_cours.Checked) { query = "insert into diplome(ID_candidat,Niveau,specialite,Etablissement,date_obtention) values(" + my_id + ",'" + metroComboBox_add_diploma_niveau.SelectedItem.ToString() + "'," + "'" + metroTextBox_add_diploma_specialite.Text + "','" + metroTextBox_etablissement.Text + "','" + metroTextBox_date_obtention.Text + "')"; } else { query = "insert into diplome(ID_candidat,Niveau,specialite,Etablissement,date_obtention) values(" + my_id + ",'" + metroComboBox_add_diploma_niveau.SelectedItem.ToString() + "'," + "'" + metroTextBox_add_diploma_specialite.Text + "','" + metroTextBox_etablissement.Text + "','0')"; } Class_Database_app.add_data(query); } position = 0; Class_diplome diplome = Class_Database_app.get_diploma_by_id((int)my_list_diploma[position]); afficher(diplome); enable_true_nav_buttons(); metroButton_update.Enabled = true; } }
private void metroButton_modifier_search_first_Click(object sender, EventArgs e) { position = 0; Class_diplome diplome = Class_Database_app.get_diploma_by_id((int)my_list_diploma[position]); afficher(diplome); }
private void metroButton_update_Click(object sender, EventArgs e) { if (metroButton_update.Text == "Save") { DialogResult c = MessageBox.Show("Do you wanna to save", "save", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (c == DialogResult.OK) { string query = "update diplome set Niveau = '" + metroComboBox_add_diploma_niveau.SelectedItem.ToString() + "',"; query += "specialite='" + metroTextBox_add_diploma_specialite.Text + "',Etablissement='" + metroTextBox_etablissement.Text + "',date_obtention='" + metroTextBox_date_obtention.Text + "' "; query += "where ID_diplome = " + (int)my_list_diploma[position]; Boolean is_updated = Class_Database_app.update_diplome_infos(query); if (is_updated) { MessageBox.Show("it is updated"); } //---------------------- } position = 0; Class_diplome diplome = Class_Database_app.get_diploma_by_id((int)my_list_diploma[position]); afficher(diplome); metroButton_update.Text = "Modifier"; disable_false_all(); enable_true_nav_buttons(); metroButton_add_new.Enabled = true; } else if (metroButton_update.Text == "Modifier") { metroButton_update.Text = "Save"; disable_true_all(); enable_false_nav_buttons(); metroButton_add_new.Enabled = false; } }
public void afficher_diplomas() { foreach (int id_diploma in diploma_ids) { Class_diplome diploma = Class_Database_app.get_diploma_by_id(id_diploma); richTextBox_formation.Text += diploma.specialite + "\t" + diploma.etablissement + "\n"; richTextBox_formation.Text += diploma.niveau + "\t" + diploma.date_obtention; richTextBox_formation.Text += "\n -------------------------- \n"; } }
private void metroButton_modifier_search_precedant_Click(object sender, EventArgs e) { position--; if (position < 0) { position = my_list_diploma.Count - 1; } Class_diplome diplome = Class_Database_app.get_diploma_by_id((int)my_list_diploma[position]); afficher(diplome); }
private void metrobuutton_modifier_search_next_Click(object sender, EventArgs e) { position++; if (position > my_list_diploma.Count - 1) { position = 0; } Class_diplome diplome = Class_Database_app.get_diploma_by_id((int)my_list_diploma[position]); afficher(diplome); }
public void afficher(Class_diplome dp) { metroComboBox_add_diploma_niveau.SelectedItem = dp.niveau; metroTextBox_add_diploma_specialite.Text = dp.specialite; if (dp.date_obtention != 0) { metroTextBox_date_obtention.Text = dp.date_obtention.ToString(); metroCheckBox_add_diploma_En_cours.Checked = false; } else { metroTextBox_etablissement.Text = ""; metroCheckBox_add_diploma_En_cours.Checked = true; } metroTextBox_etablissement.Text = dp.etablissement; }
private void metroButton1_Click(object sender, EventArgs e) { DialogResult x = MessageBox.Show("Etes Vous Sur", "Vouliez vous vraiment enregistrer", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (x == DialogResult.OK) { valider_fomulaire(); Program.new_candidat_to_add.son_diplomes.Add(diploma); diploma = new Class_diplome(); vider_formulaire(); } else { MessageBox.Show("Le procedure à ete annuler", "Annuler", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void Form_update_diploma_Load(object sender, EventArgs e) { Class_Candidat candidat = Class_Database_app.get_candidate_by_id(my_id); metroTextBox_update_diploma_nom.Text = candidat.Nom; metroTextBox_update_diploma_prenom.Text = candidat.Prenom; string query_diploma = "select ID_diplome from diplome where ID_candidat = " + my_id; my_list_diploma = Class_Database_app.get_ids_diploma_update(query_diploma); if (my_list_diploma.Count > 0) { Class_diplome diplome = Class_Database_app.get_diploma_by_id((int)my_list_diploma[position]); afficher(diplome); } else { MessageBox.Show("aucune diplome à afficher"); } }