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