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