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 }