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