private void OrderProductGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
{
if (CurrentOrderProduct != null)
{
try
{
if (CurrentOrderProduct.ID != 0)
{
using (var con = new naukaEntities()) //update
{
ReceiptOrder_Product curr = (from item in con.ReceiptOrder_Product
where item.ID == CurrentOrderProduct.ID
select item).First();
curr.OrderNum = CurrentOrderProduct.OrderNum;
curr.ProductNumber = CurrentOrderProduct.ProductNumber;
curr.Quantity = CurrentOrderProduct.Quantity;
curr.WarehouseID = CurrentOrderProduct.WarehouseID;
con.SaveChanges();
}
}
else
{
using (var con = new naukaEntities()) //create
{
con.ReceiptOrder_Product.Add(new ReceiptOrder_Product
{
OrderNum = CurrentOrderProduct.OrderNum,
ProductNumber = CurrentOrderProduct.ProductNumber,
Quantity = CurrentOrderProduct.Quantity,
WarehouseID = CurrentOrderProduct.WarehouseID
});
con.SaveChanges();
}
}
CurrentOrderProduct = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void ButtonRemove_Click(object sender, RoutedEventArgs e)
{
if (OrderGrid.SelectedItem != null)
{
try
{
ReceiptOrder row = (ReceiptOrder)OrderGrid.SelectedItem;
using (var con = new naukaEntities())
{
ReceiptOrder curr = (from item in con.ReceiptOrder
where item.OrderNum == row.OrderNum
select item).First();
con.ReceiptOrder.Remove(curr);
con.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
RefreshDB();
}
if (OrderProductGrid.SelectedItem != null)
{
try
{
ReceiptOrder_Product row = (ReceiptOrder_Product)OrderProductGrid.SelectedItem;
using (var con = new naukaEntities())
{
ReceiptOrder_Product curr = (from item in con.ReceiptOrder_Product
where item.ID == row.ID
select item).First();
con.ReceiptOrder_Product.Remove(curr);
con.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
RefreshDB();
}
}
private void OrderProductGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
CurrentOrderProduct = (ReceiptOrder_Product)e.Row.Item;
}
