private void btnAjouter_Click(object sender, EventArgs e)
{
if (textNomCl.Text != "" && textNumClient.Text != "" && textPrenomCl.Text != "")
{
try
{
banqueEntities Bq = new banqueEntities();
Client cl = new Client();
cl.Nom_client = textNomCl.Text;
cl.Num_client = int.Parse(textNumClient.Text);
cl.Prenom_Client = textPrenomCl.Text;
Bq.Clients.Add(cl);
Bq.SaveChanges();
MessageBox.Show("Ajout effectué");
textPrenomCl.Text = "";
textNomCl.Text = "";
textNumClient.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Remplir les champs SVP!");
}
}
private void btnSupprimer_Click(object sender, EventArgs e)
{
int N = int.Parse(comboCompte.Text.ToString());
Compte cl = Bq.Comptes.Where(C => C.Num_Compte == N).First();
Bq.Comptes.Remove(cl);
Bq.SaveChanges();
MessageBox.Show("Suppression effectué");
this.Close();
}
private void btnSupprimer_Click(object sender, EventArgs e)
{
try
{
int N = int.Parse(comboClient.Text.ToString());
Client cl = Bq.Clients.Where(C => C.Num_client == N).First();
Bq.Clients.Remove(cl);
Bq.SaveChanges();
MessageBox.Show("Suppression effectué");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnModifier_Click(object sender, EventArgs e)
{
try
{
int N = int.Parse(comboClient.Text.ToString());
Client cl = Bq.Clients.Where(C => C.Num_client == N).First();
cl.Nom_client = textNomCl.Text;
cl.Prenom_Client = textPrenomCl.Text;
Bq.SaveChanges();
MessageBox.Show("Modification réussie");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAjouter_Click(object sender, EventArgs e)
{
Bq = new banqueEntities();
Compte cp = new Compte();
cp.Num_Compte = int.Parse(textNumCmp.Text);
cp.Num_Client = int.Parse(comboClient.Text);
cp.Solde = Convert.ToDecimal(textSolde.Text);
cp.TypeC = comboTypeC.Text;
Bq.Comptes.Add(cp);
Bq.SaveChanges();
MessageBox.Show("Ajout effectué");
textSolde.Text = "";
textNumCmp.Text = "";
comboClient.Text = "-Faites votre choix-";
comboTypeC.Text = "-Faites votre choix-";
}
private void btnModifier_Click(object sender, EventArgs e)
{
try
{
int N = int.Parse(comboCompte.Text.ToString());
Compte cl = Bq.Comptes.Where(C => C.Num_Compte == N).First();
cl.Num_Client = int.Parse(comboClient.Text);
cl.Solde = Convert.ToDecimal(textSolde.Text);
cl.TypeC = textTypeC.Text;
Bq.SaveChanges();
MessageBox.Show("Modification réussie");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
