Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows;
- using System.Windows.Controls;
- using System.Windows.Data;
- using System.Windows.Documents;
- using System.Windows.Input;
- using System.Windows.Media;
- using System.Windows.Media.Imaging;
- using System.Windows.Navigation;
- using System.Windows.Shapes;
- namespace Shopping_List_Application
- {
- /// <summary>
- /// Interaction logic for MainWindow.xaml
- /// </summary>
- public partial class MainWindow : Window
- {
- List<Ingredient> ingredients = new List<Ingredient>();
- List<Equipment> equipments = new List<Equipment>();
- List<OrderIngredient> orders = new List<OrderIngredient>();
- Ingredient ingredient;
- Equipment equipment;
- OrderIngredient order;
- public MainWindow()
- {
- InitializeComponent();
- Intialise();
- }
- 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 ListBoxIngredients_SelectionChanged(object sender, SelectionChangedEventArgs e)
- {
- ingredient = (Ingredient)ListBoxIngredients.SelectedItem;
- if(ingredient != null)
- {
- TextBoxId.Text = ingredient.IngredientsId.ToString();
- TextBoxDescription.Text = ingredient.Ingredient1.ToString();
- TextBoxQuantity.Text = ingredient.Quantity.ToString();
- }
- }
- private void ListBoxEqupments_SelectionChanged(object sender, SelectionChangedEventArgs e)
- {
- equipment = (Equipment)ListBoxEquipments.SelectedItem;
- if(equipment != null)
- {
- TextBoxId.Text = equipment.EquipmentId.ToString();
- TextBoxDescription.Text = equipment.Equipment1.ToString();
- TextBoxQuantity.Text = equipment.Quantity.ToString();
- }
- }
- private void ListBoxOrders_SelectionChanged(object sender, SelectionChangedEventArgs e)
- {
- order = (OrderIngredient)ListBoxOrders.SelectedItem;
- if(order !=null)
- {
- TextBoxId.Text = order.OrderId.ToString();
- TextBoxDescription.Text = order.Ingredient.ToString();
- TextBoxQuantity.Text = order.Quantity.ToString();
- TextBoxOrdered.Text = order.Orderd_On.ToString();
- }
- }
- 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;
- }
- }
- }
- //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();
- }
- }
- }
- 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 = "";
- }
- }
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement