// Reading from the Drink text file and displaying each line in the listbox public void ReadFromDrink() { MenuWorker.drinkList.Clear(); try { SqlConnection cnn = new SqlConnection(Properties.Settings.Default.MenuConnString); cnn.Open(); string sqlQuery = "Select * from Drink_Item WHERE Username ='******'"; SqlCommand command = new SqlCommand(sqlQuery, cnn); SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { DrinkItem temp = new DrinkItem(dataReader.GetInt32(0), dataReader.GetValue(1).ToString(), dataReader.GetValue(2).ToString(), dataReader.GetDouble(3), dataReader.GetDouble(4), dataReader.GetValue(5).ToString(), dataReader.GetValue(6).ToString(), dataReader.GetValue(7).ToString()); MenuWorker.drinkList.Add(temp); } dataReader.Close(); command.Dispose(); cnn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } lbDrinks.Items.Clear(); foreach (DrinkItem drink in MenuWorker.drinkList) { lbDrinks.Items.Add(drink.ItemName + " | " + drink.Description + " |" + " ............................................. R" + drink.Price); } }
//Adding public void addDrrink() { DrinkItem newDrink = new DrinkItem(0, txtName.Text, txtDescrip.Text, Convert.ToDouble(txtSell.Text), Convert.ToDouble(txtCost.Text), txtContType.Text, txtDrinkType.Text, username); try { SqlConnection cnn = new SqlConnection(Properties.Settings.Default.MenuConnString); cnn.Open(); string sqlQuery = "Insert into Drink_Item(ItemName,Description,Price,CostPrice,Container,DrinkType,Username)VALUES ('" + newDrink.ItemName + "','" + newDrink.Description + "','" + newDrink.Price + "','" + newDrink.CostPrice + "','" + newDrink.Container + "','" + newDrink.DrinkType + "','" + newDrink.UserName + "');SELECT SCOPE_IDENTITY();"; SqlCommand command = new SqlCommand(sqlQuery, cnn); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.InsertCommand = command; int id = Convert.ToInt32(adapter.InsertCommand.ExecuteScalar()); newDrink.Id = id; newDrink.UserName = username; MenuWorker.drinkList.Add(newDrink); adapter.Dispose(); command.Dispose(); cnn.Close(); MessageBox.Show("Drink Added Successfully"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
//Editing public void UpdateDrink() { DrinkItem newDrink = new DrinkItem(MenuWorker.selectedDrink.Id, txtName.Text, txtDescrip.Text, Convert.ToDouble(txtSell.Text), Convert.ToDouble(txtCost.Text), txtContType.Text, txtDrinkType.Text, username); try { SqlConnection cnn = new SqlConnection(Properties.Settings.Default.MenuConnString); cnn.Open(); string sqlQuery = "Update Drink_Item set ItemName='" + newDrink.ItemName + "',Description='" + newDrink.Description + "',Price='" + newDrink.Price + "',CostPrice='" + newDrink.CostPrice + "',Container='" + newDrink.Container + "',DrinkType='" + newDrink.DrinkType + "'WHERE ID=" + newDrink.Id; SqlCommand command = new SqlCommand(sqlQuery, cnn); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.UpdateCommand = command; adapter.UpdateCommand.ExecuteNonQuery(); MessageBox.Show("Drink Updated Successfully"); MenuWorker.drinkList.Remove(MenuWorker.selectedDrink); MenuWorker.drinkList.Add(newDrink); adapter.Dispose(); command.Dispose(); cnn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public AddDrink(DrinkItem pass, int selectedIndex, string username) { InitializeComponent(); MenuWorker.selectedDrink.Id = pass.Id; txtName.Text = pass.ItemName.ToString(); txtDescrip.Text = pass.Description; txtCost.Text = pass.CostPrice.ToString(); txtSell.Text = pass.Price.ToString(); txtContType.Text = pass.Container.ToString(); txtDrinkType.Text = pass.DrinkType.ToString(); SelectedIndex = selectedIndex; this.username = username; }
// Passing the line to be updated to the respective form private void btnUpdate_Click(object sender, EventArgs e) { if (lbMeals.SelectedItem != null || lbDrinks.SelectedItem != null) { try { for (int i = 0; i < MenuWorker.foodList.Count; i++) { if (lbMeals.SelectedIndex == i) { FoodItem foodItem = new FoodItem(MenuWorker.foodList[i].Id, MenuWorker.foodList[i].ItemName, MenuWorker.foodList[i].Description, MenuWorker.foodList[i].Price, MenuWorker.foodList[i].CostPrice, MenuWorker.foodList[i].FoodType, MenuWorker.foodList[i].Cuisine, MenuWorker.foodList[i].UserName); this.Hide(); AddFood add = new AddFood(foodItem, lbMeals.SelectedIndex, username); add.ShowDialog(); } } for (int i = 0; i < MenuWorker.drinkList.Count; i++) { if (lbDrinks.SelectedIndex == i) { DrinkItem drinkItem = new DrinkItem(MenuWorker.drinkList[i].Id, MenuWorker.drinkList[i].ItemName, MenuWorker.drinkList[i].Description, MenuWorker.drinkList[i].Price, MenuWorker.drinkList[i].CostPrice, MenuWorker.drinkList[i].Container, MenuWorker.drinkList[i].DrinkType, MenuWorker.drinkList[i].UserName); this.Hide(); AddDrink add = new AddDrink(drinkItem, lbDrinks.SelectedIndex, username); add.ShowDialog(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { MessageBox.Show("Please Select an item you Wish to Update from the List"); } }
public void deleteDrink() { for (int i = 0; i < MenuWorker.drinkList.Count; i++) { if (lbDrinks.SelectedIndex == i) { DrinkItem drinkItem = new DrinkItem(MenuWorker.drinkList[i].Id, MenuWorker.drinkList[i].ItemName, MenuWorker.drinkList[i].Description, MenuWorker.drinkList[i].Price, MenuWorker.drinkList[i].CostPrice, MenuWorker.drinkList[i].Container, MenuWorker.drinkList[i].DrinkType, MenuWorker.drinkList[i].UserName); try { SqlConnection cnn = new SqlConnection(Properties.Settings.Default.MenuConnString); cnn.Open(); string sqlQuery = "Delete from Drink_Item WHERE ID= " + drinkItem.Id; SqlCommand command = new SqlCommand(sqlQuery, cnn); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.DeleteCommand = command; adapter.DeleteCommand.ExecuteNonQuery(); MessageBox.Show("Drink Deleted Successfully"); MenuWorker.drinkList.Remove(drinkItem); lbDrinks.Items.Remove(lbDrinks.SelectedItem); adapter.Dispose(); command.Dispose(); cnn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }