private double GetOrderItemPrice(int quantity, int itemID)
{
if (quantity > 0)
{
double orderItemPrice;
// Setting up a variable for the datatable from the database
RestaurantDataSet.MenuItemsDataTable items = new RestaurantDataSet.MenuItemsDataTable();
// Setting up a menu items adaptor and it's to fill in the datatable
RestaurantDataSetTableAdapters.MenuItemsTableAdapter ItemsTableAdap = new RestaurantDataSetTableAdapters.MenuItemsTableAdapter();
// Getting the item data from the database
ItemsTableAdap.GetData();
// Filling the data to the datatable
ItemsTableAdap.Fill(items);
RestaurantDataSet.MenuItemsRow menuItemRow = items.FindBymenuItemId(itemID);
orderItemPrice = quantity * double.Parse(menuItemRow.menuItemPrice);
return(orderItemPrice);
}
else
{
return(0);
}
}
private void btnDeleteItem_Click(object sender, EventArgs e)
{
// Validate that the item number is a integer
if (int.TryParse(txtItemNumber.Text, out itemNumber) == false)
{
MessageBox.Show("Please enter a valid item number.");
}
else
{
// Make sure there is an item with that number
// Setting up a variable for the datatable from the database
RestaurantDataSet.MenuItemsDataTable items = new RestaurantDataSet.MenuItemsDataTable();
// Setting up a employee adaptor and it's to fill in the datatable
RestaurantDataSetTableAdapters.MenuItemsTableAdapter ItemsTableAdap = new RestaurantDataSetTableAdapters.MenuItemsTableAdapter();
// Getting the item data from the database
ItemsTableAdap.GetData();
// Filling the data to the datatable
ItemsTableAdap.Fill(items);
// Going and looking in the datatable for a given item number and returning the row.
RestaurantDataSet.MenuItemsRow itemRow = items.FindBymenuItemId(itemNumber);
// Check if the item row was found (If null, item number does not exist in database)
if (itemRow == null)
{
MessageBox.Show("Could not find item number, please try again.");
itemNumber = 0;
}
else
{
// Get current record data
menuItemId = itemRow.menuItemId;
menuItemName = itemRow.menuItemName;
menuItemPrice = itemRow.menuItemPrice;
menuItemDescription = itemRow.menuItemDescription;
isActive = itemRow.isItemActive;
menuMenuId = itemRow.Menu_MenuId;
// Delete the desired record
ItemsTableAdap.Delete(menuItemId, menuMenuId);
// Close the Add Menu Item form and notify the user
this.Close();
MessageBox.Show("Item has been successfully deleted.");
// Need to update the dataset to show database upadate
}
}
}
private int GetItemId(string itemName)
{
int id = 0;
// Setting up a variable for the datatable from the database
RestaurantDataSet.MenuItemsDataTable items = new RestaurantDataSet.MenuItemsDataTable();
// Setting up a menu items adaptor and it's to fill in the datatable
RestaurantDataSetTableAdapters.MenuItemsTableAdapter ItemsTableAdap = new RestaurantDataSetTableAdapters.MenuItemsTableAdapter();
// Getting the item data from the database
ItemsTableAdap.GetData();
// Filling the data to the datatable
ItemsTableAdap.Fill(items);
// Going and looking in the datatable for a given item name and returning the id.
id = (from DataRow dr in items.Rows
where (string)dr["menuItemName"] == itemName
select(int) dr["menuItemId"]).FirstOrDefault();
return(id);
}
private void btnAddMenuItem_Click(object sender, EventArgs e)
{
// Validate item name
if (txtItemName.Text == "")
{
MessageBox.Show("Please enter a valid item name");
validItemEntry = 0;
}
else
{
itemName = txtItemName.Text;
}
// Validate item price
if (Double.TryParse(txtItemPrice.Text, out itemPrice) == false)
{
MessageBox.Show("Please enter a valid item price.");
validItemEntry = 0;
}
// Validate a description has been chosen
if (rbDesert.Checked)
{
description = "Desert";
}
else if (rbAppetizer.Checked)
{
description = "Appetizer";
}
else if (rbEntree.Checked)
{
description = "Entree";
}
else if (rbBeverage.Checked)
{
description = "Beverage";
}
else
{
MessageBox.Show("Please select a description");
validItemEntry = 0;
}
// Validate active decision
if (rbActive.Checked)
{
isActive = "1";
}
else if (rbDisabled.Checked)
{
isActive = "0";
}
else
{
MessageBox.Show("Please select if this item is active");
validItemEntry = 0;
}
// If all inputs are valid, add the record
if (validItemEntry == 1)
{
// Setting up a variable for the datatable from the database
RestaurantDataSet.MenuItemsDataTable items = new RestaurantDataSet.MenuItemsDataTable();
// Setting up a employee adaptor and it's to fill in the datatable
RestaurantDataSetTableAdapters.MenuItemsTableAdapter ItemsTableAdap = new RestaurantDataSetTableAdapters.MenuItemsTableAdapter();
// Getting the item data from the database
ItemsTableAdap.GetData();
// Filling the data to the datatable
ItemsTableAdap.Fill(items);
// Adding the new record
ItemsTableAdap.Insert(itemName, itemPrice.ToString(), description, isActive, 1);
// Close the Add Menu Item form and notify the user
this.Close();
MessageBox.Show("Item has been successfully added.");
}
// Reset validation checker
validItemEntry = 1;
// Need to update the dataset to show database upadate
}
