示例#1
0
        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