private void modificationClient_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 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 recherche_compte__clients_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__comptes_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 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 consultationClients_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();
}
private void consultationComptes_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();
}
