private void Pa_SelectedIndexChanged(object sender, EventArgs e)
{
Pa.Text = Pa.GetItemText(Pa.SelectedItem).ToString();
}
private void Valider_Click(object sender, EventArgs e)
{
if (Mode == 1)
{
try
{
clscnx.connecter();
date();
clscnx.msql("Insert into Client(cin,Prenom,Nom,Ville,Codepostal,Adresse,Sexe,N_permis,reduction,DateFP,Tel,Pays_origine,Pays_actuelle) values('" + CIN.Text + "','" + Prenom.Text + "','" + Nom.Text + "','" + Ville.Text + "','" + Code_postal.Text + "','" + Adresse.Text + "','" + b + "','" + N_permis.Text + "','" + Réduction.Text + "', '" + DateFP.Value.ToString("yyyy-MM-dd") + "','" + Tel.Text + "','" + Po.GetItemText(Po.SelectedItem) + "','" + Pa.GetItemText(Pa.SelectedItem) + "')", "Client");
Afficher();
afficher2();
menugeneral(true);
}
catch (Exception E)
{
MessageBox.Show(E.Message);
}
}
if (Mode == 2)
{
try
{
//date();
clscnx.connecter();
clscnx.msql(" Update Client set cin = '" + CIN.Text + "' ,Prenom = '" + Prenom.Text + "',Nom = '" + Nom.Text + "',Ville = '" + Ville.Text + "',Codepostal ='" + Code_postal.Text + "',Adresse = '" + Adresse.Text + "',Sexe = '" + b + "',N_permis =' " + N_permis.Text + "',reduction ='" + Réduction.Text + "',Tel = '" + Tel.Text + "',Pays_origine = '" + Po.GetItemText(Po.SelectedItem) + "',Pays_actuelle = '" + Pa.GetItemText(Pa.SelectedItem) + "' where idclt = " + Idclt.Text + " ", "Client");
afficher2();
Afficher();
menugeneral(true);
groupBox1.Enabled = false;
}
catch (Exception E)
{
MessageBox.Show(E.Message);
}
}
if (Mode == 3)
{
try
{
clscnx.connecter();
panelid.Visible = false;
clscnx.msql("Delete from Client where idclt = " + Id.Text + " ", "Client");
Afficher();
afficher2();
menugeneral(true);
groupBox1.Enabled = false;
}
catch (Exception E)
{
MessageBox.Show(E.Message);
}
}
else
{
textBox1.Text = null;
}
}
