private void btnSave0_Click(object sender, RoutedEventArgs e)
{
Order order = null;
if (action == ActionState.New)
{
try
{
Customer customer = (Customer)cmbCustomers.SelectedItem;
Iventory iventory = (Iventory)cmbInventory.SelectedItem;
//instantiem Order entity
order = new Order()
{
CustId = customer.CustId,
CardId = iventory.CardId
};
//adaugam entitatea nou creata in context
ctx.Orders.Add(order);
customerOrdersViewSource.View.Refresh();
//salvam modificarile
ctx.SaveChanges();
}
catch (DataException ex)
{
MessageBox.Show(ex.Message);
}
if (action == ActionState.Edit)
{
dynamic selectedOrder = ordersDataGrid.SelectedItem;
try
{
int curr_id = selectedOrder.OrderId;
var editedOrder = ctx.Orders.FirstOrDefault(s => s.OrderId == curr_id);
if (editedOrder != null)
{
editedOrder.CustId = Int32.Parse(cmbCustomers.SelectedValue.ToString());
editedOrder.CardId = Convert.ToInt32(cmbInventory.SelectedValue.ToString());
//salvam modificarile
ctx.SaveChanges();
}
}
catch (DataException ex)
{
MessageBox.Show(ex.Message);
}
BindDataGrid();
// pozitionarea pe item-ul curent
customerViewSource.View.MoveCurrentTo(selectedOrder);
}
else if (action == ActionState.Delete)
{
try
{
dynamic selectedOrder = ordersDataGrid.SelectedItem;
int curr_id = selectedOrder.OrderId;
var deletedOrder = ctx.Orders.FirstOrDefault(s => s.OrderId == curr_id);
if (deletedOrder != null)
{
ctx.Orders.Remove(deletedOrder);
ctx.SaveChanges();
MessageBox.Show("Order Deleted Successfully", "Message");
BindDataGrid();
}
}
catch (DataException ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave1_Click(object sender, RoutedEventArgs e)
{
Iventory inventory = null;
if (action == ActionState.New)
{
try
{
inventory = new Iventory()
{
Make = makeTextBox.Text.Trim(),
Color = colorTextBox.Text.Trim()
};
ctx.Iventories.Add(inventory);
iventoryViewSource.View.Refresh();
ctx.SaveChanges();
}
//using System.Data;
catch (DataException ex)
{
MessageBox.Show(ex.Message);
}
btnNew1.IsEnabled = true;
btnEdit1.IsEnabled = true;
btnSave1.IsEnabled = false;
btnCancel1.IsEnabled = false;
btnPrevious1.IsEnabled = true;
btnNext1.IsEnabled = true;
colorTextBox.IsEnabled = false;
makeTextBox.IsEnabled = false;
}
else
{
if (action == ActionState.Edit)
{
try
{
inventory = (Iventory)iventoryDataGrid.SelectedItem;
inventory.Make = makeTextBox.Text.Trim();
inventory.Color = colorTextBox.Text.Trim();
ctx.SaveChanges();
}
catch (DataException ex)
{
MessageBox.Show(ex.Message);
}
iventoryViewSource.View.Refresh();
iventoryViewSource.View.MoveCurrentTo(inventory);
btnNew1.IsEnabled = true;
btnEdit1.IsEnabled = true;
btnDelete1.IsEnabled = true;
btnSave1.IsEnabled = false;
btnCancel1.IsEnabled = false;
btnPrevious1.IsEnabled = true;
btnNext1.IsEnabled = true;
makeTextBox.IsEnabled = false;
colorTextBox.IsEnabled = false;
makeTextBox.SetBinding(TextBox.TextProperty, txtMakeBinding);
colorTextBox.SetBinding(TextBox.TextProperty, txtColorBinding);
}
else
{
if (action == ActionState.Delete)
{
try
{
inventory = (Iventory)iventoryDataGrid.SelectedItem;
ctx.Iventories.Remove(inventory);
ctx.SaveChanges();
}
catch (DataException ex)
{
MessageBox.Show(ex.Message);
}
customerViewSource.View.Refresh();
btnNew1.IsEnabled = true;
btnEdit1.IsEnabled = true;
btnDelete1.IsEnabled = true;
btnSave1.IsEnabled = false;
btnCancel1.IsEnabled = false;
btnPrevious1.IsEnabled = true;
btnNext1.IsEnabled = true;
makeTextBox.IsEnabled = false;
colorTextBox.IsEnabled = false;
makeTextBox.SetBinding(TextBox.TextProperty, txtMakeBinding);
colorTextBox.SetBinding(TextBox.TextProperty, txtColorBinding);
}
}
}
}
