//code for editing database fields private void ButtonEdit_Click(object sender, RoutedEventArgs e) { if (ButtonEdit.Content.ToString() == "Edit") { ingredient = (Ingredient)ListBoxIngredients.SelectedItem; TextBoxDescription.IsReadOnly = false; TextBoxQuantity.IsReadOnly = false; ButtonEdit.Content = "Save"; TextBoxDescription.Background = Brushes.White; TextBoxQuantity.Background = Brushes.White; } else { using (var db = new Shopping_ListEntities2()) { var ingredientToEdit = db.Ingredients.Find(ingredient.IngredientsId); ingredientToEdit.Ingredient1 = TextBoxDescription.Text; int.TryParse(TextBoxQuantity.Text, out int Quantity); db.SaveChanges(); } } if (ButtonEdit.Content.ToString() == "Edit") { equipment = (Equipment)ListBoxEquipments.SelectedItem; TextBoxDescription.IsReadOnly = false; TextBoxQuantity.IsReadOnly = false; ButtonEdit.Content = "Save"; TextBoxDescription.Background = Brushes.White; TextBoxQuantity.Background = Brushes.White; } else { using (var db = new Shopping_ListEntities2()) { var equipmentToEdit = db.Equipments.Find(equipment.Equipment1); equipmentToEdit.Equipment1 = TextBoxDescription.Text; int.TryParse(TextBoxQuantity.Text, out int Quantity); db.SaveChanges(); } } if (ButtonEdit.Content.ToString() == "Edit") { order = (OrderIngredient)ListBoxOrders.SelectedItem; TextBoxDescription.IsReadOnly = false; TextBoxQuantity.IsReadOnly = false; ButtonEdit.Content = "Save"; TextBoxDescription.Background = Brushes.White; TextBoxQuantity.Background = Brushes.White; } else { using (var db = new Shopping_ListEntities2()) { var orderToEdit = db.OrderIngredients.Find(order.Ingredient); orderToEdit.Ingredient = TextBoxDescription.Text; int.TryParse(TextBoxQuantity.Text, out int Quantity); db.SaveChanges(); } } }
void Intialise() { using (var db = new Shopping_ListEntities2()) { ingredients = db.Ingredients.ToList(); equipments = db.Equipments.ToList(); orders = db.OrderIngredients.ToList(); } ListBoxIngredients.ItemsSource = ingredients; ListBoxIngredients.DisplayMemberPath = "IngredientsId"; ListBoxEquipments.ItemsSource = equipments; ListBoxEquipments.DisplayMemberPath = "Quantity"; ListBoxOrders.ItemsSource = orders; ListBoxOrders.DisplayMemberPath = "Quantity"; }
private void ButtonAdd_Click(object sender, RoutedEventArgs e) { if (ButtonAdd.Content.ToString() == "Add") { ButtonAdd.Content = "Confirm"; TextBoxId.Background = Brushes.White; TextBoxDescription.Background = Brushes.White; TextBoxQuantity.Background = Brushes.White; TextBoxDescription.IsReadOnly = false; TextBoxQuantity.IsReadOnly = false; TextBoxId.IsReadOnly = true; TextBoxDescription.Text = ""; TextBoxQuantity.Text = ""; } else { ButtonAdd.Content = "Add"; ButtonAdd.IsEnabled = true; int.TryParse(TextBoxQuantity.Text, out int Quantity); var ingredientToAdd = new Ingredient() { Ingredient1 = TextBoxDescription.Text, Quantity = Quantity }; using (var db = new Shopping_ListEntities2()) { db.Ingredients.Add(ingredientToAdd); db.SaveChanges(); ListBoxIngredients.ItemsSource = null; ingredients = db.Ingredients.ToList(); ListBoxIngredients.ItemsSource = ingredients; } } if (ButtonAdd.Content.ToString() == "Add") { ButtonAdd.Content = "Confirm"; TextBoxId.Background = Brushes.White; TextBoxDescription.Background = Brushes.White; TextBoxDescription.IsReadOnly = false; TextBoxQuantity.IsReadOnly = false; TextBoxId.IsReadOnly = true; TextBoxDescription.Text = ""; TextBoxQuantity.Text = ""; } else { ButtonAdd.Content = "Add"; ButtonAdd.IsEnabled = true; int.TryParse(TextBoxQuantity.Text, out int Quantity); var equipmentToAdd = new Equipment() { Equipment1 = TextBoxDescription.Text, Quantity = Quantity }; using (var db = new Shopping_ListEntities2()) { db.Equipments.Add(equipmentToAdd); db.SaveChanges(); ListBoxEquipments.ItemsSource = null; equipments = db.Equipments.ToList(); ListBoxEquipments.ItemsSource = equipments; } } if (ButtonAdd.Content.ToString() == "Add") { ButtonAdd.Content = "Confrim"; TextBoxId.Background = Brushes.White; TextBoxDescription.Background = Brushes.White; TextBoxDescription.IsReadOnly = false; TextBoxQuantity.IsReadOnly = false; TextBoxId.IsReadOnly = true; TextBoxDescription.Text = ""; TextBoxQuantity.Text = ""; } else { ButtonAdd.Content = "Add"; ButtonAdd.IsEnabled = true; int.TryParse(TextBoxQuantity.Text, out int Quantity); var orderToAdd = new OrderIngredient() { Ingredient = TextBoxDescription.Text, Quantity = Quantity }; using (var db = new Shopping_ListEntities2()) { db.OrderIngredients.Add(orderToAdd); db.SaveChanges(); ListBoxOrders.ItemsSource = null; orders = db.OrderIngredients.ToList(); ListBoxOrders.ItemsSource = orders; } } }
private void ButtonDelete_Click(object sender, RoutedEventArgs e) { if (ButtonDelete.Content.ToString() == "Delete") { ButtonDelete.Content = "Confirm"; TextBoxId.Background = Brushes.OrangeRed; TextBoxDescription.Background = Brushes.DarkOrange; } else { if (ingredients != null) { using (var db = new Shopping_ListEntities2()) { var ingredientToRemove = db.Ingredients.Find(ingredient.IngredientsId); db.Ingredients.Remove(ingredientToRemove); ListBoxIngredients.ItemsSource = null; ingredients = db.Ingredients.ToList(); ListBoxIngredients.ItemsSource = ingredients; ButtonDelete.Content = "Delete"; TextBoxDescription.IsReadOnly = true; TextBoxId.Text = ""; TextBoxDescription.Text = ""; TextBoxQuantity.Text = ""; } } } if (ButtonDelete.Content.ToString() == "Delete") { ButtonDelete.Content = "Confirm"; TextBoxId.Background = Brushes.OrangeRed; TextBoxDescription.Background = Brushes.DarkOrange; } else { if (equipments != null) { using (var db = new Shopping_ListEntities2()) { var equipmentToRemove = db.Equipments.Find(equipment.EquipmentId); db.Equipments.Remove(equipmentToRemove); ListBoxEquipments.ItemsSource = null; equipments = db.Equipments.ToList(); ListBoxEquipments.ItemsSource = equipments; ButtonDelete.Content = "Delete"; TextBoxId.Text = ""; TextBoxDescription.Text = ""; TextBoxQuantity.Text = ""; } } } if (ButtonDelete.Content.ToString() == "Delete") { ButtonDelete.Content = "Confirm"; TextBoxId.Background = Brushes.OrangeRed; TextBoxDescription.Background = Brushes.DarkOrange; } else { if (orders != null) { using (var db = new Shopping_ListEntities2()) { var orderToRemove = db.OrderIngredients.Find(order.OrderId); db.OrderIngredients.Remove(orderToRemove); ListBoxOrders.ItemsSource = null; orders = db.OrderIngredients.ToList(); ListBoxOrders.ItemsSource = orders; ButtonDelete.Content = "Delete"; TextBoxId.Text = ""; TextBoxDescription.Text = ""; TextBoxQuantity.Text = ""; TextBoxOrdered.Text = ""; } } } }