private void DeleteSupplierDisconnected(Supplier supplier)
{
using (var ctx = new OrderITEntities()) {
ctx.Companies.Attach(supplier);
ctx.DeleteObject(supplier);
ctx.SaveChanges();
MessageBox.Show("Supplier deleted");
}
}
private void btnDeleteCustomer_Click(object sender, EventArgs e)
{
using (var ctx = new OrderITEntities()) {
var id = Convert.ToInt32(CustomerId.Text);
var customer = ctx.Companies.OfType <Customer>().First(c => c.CompanyId == id);
ctx.DeleteObject(customer);
ctx.SaveChanges();
MessageBox.Show("Customer deleted");
}
}
private void btnDeleteCustomerDisconnected_Click(object sender, EventArgs e)
{
using (var ctx = new OrderITEntities())
{
Customer cust = new Customer()
{
CompanyId = Convert.ToInt32(CustomerId.Text), BillingAddress = new AddressInfo(), ShippingAddress = new AddressInfo()
};
ctx.Companies.Attach(cust);
ctx.DeleteObject(cust);
ctx.SaveChanges();
MessageBox.Show("Customer deleted");
}
}
private void Save_Click(object sender, EventArgs e)
{
var datasource = ((BindingList <Order>)orderBindingSource.DataSource);
foreach (var order in datasource.Where(o => o.OrderId == 0))
{
ctx.Orders.AddObject(order);
}
ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified).Select(c => c.Entity).OfType <OrderDetail>().Where(c => c.Order == null).ToList().ForEach(c => ctx.DeleteObject(c));
ctx.SaveChanges();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified).Select(c => c.Entity).OfType <OrderDetail>().Where(c => c.Order == null).ToList().ForEach(c => ctx.DeleteObject(c));
ctx.DetectChanges();
MessageBox.Show(orderDataGrid.Items.Count.ToString() + "-" +
ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Added).Count() + "-" +
ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified).Count() + "-" +
ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Deleted).Count());
//ctx.SaveChanges();
}