private void suppressionCompte_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboCompte.DisplayMember = "Num_Compte"; comboCompte.ValueMember = "Num_Compte"; comboCompte.DataSource = Bq.Comptes.Select(c => new { Num_Compte = c.Num_Compte }).ToList(); }
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 suppressionClient_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboClient.DisplayMember = "Num_Client"; comboClient.ValueMember = "Num_Client"; comboClient.DataSource = Bq.Clients.Select(c => new { Num_Client = c.Num_client }).ToList(); }
private void recherche_compte_client_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboCompte.DisplayMember = "Num_Compte"; comboCompte.ValueMember = "Num_Compte"; comboCompte.DataSource = Bq.Comptes.Select(c => new { Num_Compte = c.Num_Compte }).ToList(); comboCompte.Text = "-Faites Votre Choix-"; dataGridView1.DataSource = null; }
private void recherche_client_compte_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboClient.DisplayMember = "Nom"; comboClient.ValueMember = "Num"; comboClient.DataSource = Bq.Clients.Select(c => new { Nom = c.Nom_client + " " + c.Prenom_Client, Num = c.Num_client }).ToList(); comboClient.Text = "-Faites Votre Choix-"; dataGridView1.DataSource = null; }
private void ajoutCompte_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboClient.DisplayMember = "Num_Client"; comboClient.ValueMember = "Num_Client"; comboClient.DataSource = Bq.Clients.Select(c => new { Num_Client = c.Num_client }).ToList(); comboClient.Text = "-Faites votre choix-"; comboTypeC.Text = "-Faites votre choix-"; }
private void mouvementRetrait_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboNuComp.DisplayMember = "Num_Compte"; comboNuComp.ValueMember = "Num_Compte"; comboNuComp.DataSource = Bq.Comptes.Select(c => new { Num_Compte = c.Num_Compte }).ToList(); comboNuComp.Text = "--Faites votre choix--"; dataGridView1.DataSource = Bq.Comptes.Select(cp => new { cp.Num_Compte, cp.Solde }).ToList(); dataGridView2.DataSource = Bq.Mouvements.Select(mvt => new { mvt.Num_Mouvement, mvt.Num_Compte, mvt.Montant }).ToList(); }
private void modificationCompte_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboCompte.DisplayMember = "Num_Compte"; comboCompte.ValueMember = "Num_Compte"; comboCompte.DataSource = Bq.Comptes.Select(c => new { Num_Compte = c.Num_Compte }).ToList(); comboClient.DisplayMember = "Num_Client"; comboClient.ValueMember = "Num_Client"; comboClient.DataSource = Bq.Clients.Select(c => new { Num_Client = c.Num_client }).ToList(); }
private void ajoutVairement_Load(object sender, EventArgs e) { Bq = new banqueEntities(); comboCrediteur.DisplayMember = "Num_Compte"; comboCrediteur.ValueMember = "Num_Compte"; comboCrediteur.DataSource = Bq.Comptes.Select(c => new { Num_Compte = c.Num_Compte }).ToList(); comboCrediteur.Text = "--Faites votre choix--"; comboDebiteur.DisplayMember = "Num_Compte"; comboDebiteur.ValueMember = "Num_Compte"; comboDebiteur.DataSource = Bq.Comptes.Select(c => new { Num_Compte = c.Num_Compte }).ToList(); comboDebiteur.Text = "--Faites votre choix--"; dataGridView1.DataSource = Bq.Comptes.Select(cp => new { cp.Num_Compte, cp.Solde }).ToList(); dataGridView2.DataSource = Bq.Virements.Select(mvt => new { mvt.Num_Virement, mvt.Num_Debiteur, mvt.Num_Crediteur, mvt.Montant_Vr, mvt.Date_Vr }).ToList(); }
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 consultationCompte_Load(object sender, EventArgs e) { banqueEntities bnq = new banqueEntities(); dataGridView1.DataSource = bnq.Comptes.Select(pl => new { pl.Num_Compte, pl.Num_Client, pl.Solde, pl.TypeC }).ToList(); }
private void consultationClient_Load(object sender, EventArgs e) { banqueEntities bnq = new banqueEntities(); dataGridView1.DataSource = bnq.Clients.Select(pl => new { pl.Nom_client, pl.Num_client, pl.Prenom_Client }).ToList(); }