//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 = "";
}
}
}
}
