private void btnSaveOrder_Click(object sender, RoutedEventArgs e)
{
if (cbCustomer.SelectedItem != null)
{
//Combobox ui
customer myCustomer = (customer)cbCustomer.SelectedItem;
producttype myProductType = (producttype)cbProductType.SelectedItem;
product myProduct = (product)cbProduct.SelectedItem;
//Textbox uitlezen en opslaan in variable
string sHoeveelheid = txtHoeveelheid.Text;
int iHoeveelheid = Convert.ToInt32(sHoeveelheid);
//Nieuw product aanmaken
order myOrder = new order();
itemsinorder myItemsInOrder = new itemsinorder();
//Velden met variabele vullen
myOrder.date = DateTime.Now;
customer selCustomer = (customer)cbCustomer.SelectedItem;
myOrder.customerId = selCustomer.id;
db.orders.InsertOnSubmit(myOrder);
db.SubmitChanges();
myItemsInOrder.amount = iHoeveelheid;
myItemsInOrder.orderId = myOrder.id;
myItemsInOrder.productId = myProduct.id;
//Ready changes & changes uitvoeren
db.itemsinorders.InsertOnSubmit(myItemsInOrder);
db.SubmitChanges();
//Refresh database
SetData();
//Confirmation
MessageBox.Show("Opgeslagen");
}
else
{
MessageBox.Show("Selecteer eerst een type");
}
}
partial void Deleteorder(order instance);
partial void Updateorder(order instance);
partial void Insertorder(order instance);
private void detach_orders(order entity)
{
this.SendPropertyChanging();
entity.customer = null;
}
private void attach_orders(order entity)
{
this.SendPropertyChanging();
entity.customer = this;
}
