private void SaveMenuItem_Click(object sender, EventArgs e) { try { // Buffer to store text string MenuItemName = MenuItemName_Textbox.Text.ToString(); string MenuItemCategory = ((BoxFormat)MenuItemCategory_comboBox.SelectedItem).databaseID; string MenuItemPrice = MenuItemPrice_Textbox.Text.ToString(); string isspecial = null; string MenuItemID = null; int DayMask = 0; object Components = MenuItemsComponent_CheckedListbox.SelectedItems; // Checks if Special has been checked if (MenuItemSpecial_Checkbox.Checked) { isspecial = "1"; // Test Checkboxes for Day Mask if (SpecialDayMonday_Checkbox.Checked) { DayMask += 1; } if (SpecialDayTuesday_Checkbox.Checked) { DayMask += 2; } if (SpecialDayWednesday_Checkbox.Checked) { DayMask += 4; } if (SpecialDayThursday_Checkbox.Checked) { DayMask += 8; } if (SpecialDayFriday_Checkbox.Checked) { DayMask += 16; } if (SpecialDaySaturday_Checkbox.Checked) { DayMask += 32; } if (SpecialDaySunday_Checkbox.Checked) { DayMask += 64; } } else { isspecial = "0"; } // Checks if all Text Boxes filled if (String.IsNullOrWhiteSpace(MenuItemName) || String.IsNullOrWhiteSpace(MenuItemCategory) || String.IsNullOrWhiteSpace(MenuItemPrice)) { MessageBox.Show("Not All Fields Filled In!", "Save Menu Item", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } // Checks if Menu Item has atleast 1 component if (MenuItemsComponent_CheckedListbox.CheckedItems.Count == 0) { MessageBox.Show("No Components Selected!", "Save Menu Item", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } // connect to DB if it is not connected if (!nsadb.Connected()) { nsadb.OpenConnection(); } // Create the Menu Item in the Database MenuItemID = nsadb.ManagerCreateMenuItem(MenuItemName, MenuItemCategory, MenuItemPrice, isspecial); foreach (object itemChecked in MenuItemsComponent_CheckedListbox.CheckedItems) { // Create the Menu Item Component in the Database nsadb.ManagerCreateMenuItemComponent(MenuItemID, ((BoxFormat)itemChecked).databaseID); } // Checks if Special has been checked if (MenuItemSpecial_Checkbox.Checked) { // Create the Special in the Database nsadb.ManagerCreateSpecial(MenuItemID, DateBegin_Calender.SelectionRange.Start.ToString("d", CultureInfo.CreateSpecificCulture("ja-jp")), DateEnd_Calender.SelectionRange.Start.ToString("d", CultureInfo.CreateSpecificCulture("ja-jp")), DayMask); } // Refresh List LoadManagerMenuItemList(); // Inform user that Menu Item was successfully created. MessageBox.Show("Menu Item - " + MenuItemName + " Created.", "Save Menu Item", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Save Menu Item", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } // ManagerSaveMenuItem