// 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());
}
}
}
}
