private void button2_Click(object sender, EventArgs e)
{
var order = new ModelIA.Order {
OrderId = 11, Customer = new ModelIA.Customer {
CompanyId = 1
}, OrderDate = DateTime.Now.Date
};
var detail = new ModelIA.OrderDetail {
OrderDetailId = 40, Product = new ModelIA.Product {
ProductId = 1
}
};
var cust = new Customer {
CompanyId = 2
};
using (var ctx = new ModelIA.OrderITEntitiesIA()) {
ctx.Orders.Attach(order);
order.OrderDetails.Add(detail);
ctx.DetectChanges();
}
}
private void DeleteOrderConnected_Click(object sender, EventArgs e)
{
using (var transaction = new TransactionScope())
{
using (var ctx = new ModelIA.OrderITEntitiesIA())
{
var order = new ModelIA.Order()
{
OrderId = Convert.ToInt32(OrderId.Text)
};
order.Customer = new ModelIA.Customer()
{
CompanyId = ((Customer)cmbCustomers.SelectedItem).CompanyId
};
ctx.Orders.Attach(order);
ctx.Orders.DeleteObject(order);
ctx.SaveChanges();
ctx.ExecuteStoreCommand("update product set availableitems = availableitems + od.Quantity from product p join [OrderDetail] od on od.ProductId = p.ProductId where od.orderid = {0}", OrderId.Text);
}
transaction.Complete();
}
}
