public Form1() { InitializeComponent(); using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { listBox1.Items.AddRange(data.Customers.Select(c => c.first_name).ToArray()); } }
public Form3() { InitializeComponent(); using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { var collection = data.Customers.Select(c => new { Id = c.id, Name = c.first_name + " " + c.last_name }).ToArray(); cbPersonen.DataSource = collection; cbPersonen.DisplayMember = "Name"; cbPersonen.ValueMember = "Id"; } }
public Form4() { InitializeComponent(); using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { var collectionPersonen = data.Customers.Select(c => new { Id = c.id, Name = c.first_name + " " + c.last_name }).ToArray(); cbPersonen.DataSource = collectionPersonen; cbPersonen.DisplayMember = "Name"; cbPersonen.ValueMember = "Id"; var collectionBadges = data.Badges.Select(b => new { Id = b.Id, Opschrift = b.Opschrift }).ToArray(); cbBadge.DataSource = collectionBadges; cbBadge.DisplayMember = "Opschrift"; cbBadge.ValueMember = "Id"; } }
private void btnDelete_Click(object sender, EventArgs e) { using (Form3 form3 = new Form3()) { switch (form3.ShowDialog()) { case DialogResult.Yes: using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { data.CustomerBadges.RemoveRange(data.CustomerBadges.Where(c => c.CustomerId == form3.Id)); data.Customers.Remove(data.Customers.FirstOrDefault(c => c.id == form3.Id)); data.SaveChanges(); listBox1.Items.Clear(); listBox1.Items.AddRange(data.Customers.Select(c => c.first_name).ToArray()); } break; case DialogResult.OK: using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { data.Customers.FirstOrDefault(c => c.id == form3.Id).first_name = form3.Voornaam; data.Customers.FirstOrDefault(c => c.id == form3.Id).last_name = form3.Achternaam; data.Customers.FirstOrDefault(c => c.id == form3.Id).age = form3.Leeftijd; data.SaveChanges(); listBox1.Items.Clear(); listBox1.Items.AddRange(data.Customers.Select(c => c.first_name).ToArray()); } break; } } }
private void btnAddBadge_Click(object sender, EventArgs e) { using (Form4 form4 = new Form4()) { switch (form4.ShowDialog()) { case DialogResult.OK: using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { data.CustomerBadges.Add(new CustomerBadge() { BadgeId = form4.BadgeId, CustomerId = form4.PersoonId }); data.SaveChanges(); listBox1.Items.Clear(); listBox1.Items.AddRange(data.Customers.Select(c => c.first_name).ToArray()); } break; } } }
private void btnAddNewBadge_Click(object sender, EventArgs e) { using (Form5 form5 = new Form5()) { switch (form5.ShowDialog()) { case DialogResult.OK: using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { data.Badges.Add(new Badge() { Opschrift = form5.Opschrift }); data.SaveChanges(); listBox1.Items.Clear(); listBox1.Items.AddRange(data.Customers.Select(c => c.first_name).ToArray()); } break; } } }
private void btnAdd_Click(object sender, EventArgs e) { using (Form2 form2 = new Form2()) { switch (form2.ShowDialog()) { case DialogResult.OK: using (DatabaseFirstOefEntitiess data = new DatabaseFirstOefEntitiess()) { data.Customers.Add(new Customer() { first_name = form2.Voornaam, last_name = form2.Achternaam, age = form2.Leeftijd }); data.SaveChanges(); listBox1.Items.Clear(); listBox1.Items.AddRange(data.Customers.Select(c => c.first_name).ToArray()); } break; } } }