private void deleteBtn_Click(object sender, RoutedEventArgs e) { MessageBoxResult msgBoxResult = MessageBox.Show("Do you want to delete order?", "Order has been deleted", MessageBoxButton.YesNo, MessageBoxImage.Warning, MessageBoxResult.No); if (msgBoxResult == MessageBoxResult.Yes) { ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities(); var r = from o in _db.Orders where o.Id == this.updateOrderId select o; Order order = r.SingleOrDefault(); if (order != null) { _db.Orders.Remove(order); _db.SaveChanges(); } } }
private void insertOrdBtn_Click(object sender, RoutedEventArgs e) { ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities(); Order newOrder = new Order() { CustomerName = txtName.Text, CustomerSurname = txtSurname.Text, Product = txtProduct.Text }; _db.Orders.Add(newOrder); _db.SaveChanges(); }
private void updateBtn_Click(object sender, RoutedEventArgs e) { ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities(); var r = from o in _db.Orders where o.Id == this.updateOrderId select o; Order order = r.SingleOrDefault(); if (order != null) { order.CustomerName = this.txtNameUpdate.Text; order.CustomerSurname = this.txtSurnameUpdate.Text; order.Product = this.txtProductUpdate.Text; } _db.SaveChanges(); }