コード例 #1
0
        /// <summary>
        /// The item new item is added to the menu item table or the drink table based on 
        /// the selected category.  The fields are then hidden.
        /// </summary>
        protected void btnAddSubmit_Click(object sender, EventArgs e)
        {
            //the item to be added is a drink
            //gets the nonalcohol or alcohol tage from the drop down list
            if (ddlChooseItem.SelectedIndex == 0)
            {
                TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
                TreasureLand.DBM.MenuItem d = new DBM.MenuItem();
                d.MenuItemName = txtAddMenuItemName.Text;
                d.MenuItemPrice = Convert.ToDecimal(txtAddPrice.Text);
                d.IsCurrentItem = true;
                d.FoodDrinkCategoryID = Convert.ToByte(ddlAddCategory.SelectedIndex + 1);

                db.MenuItems.InsertOnSubmit(d);
                db.SubmitChanges();
            }
            //the item to be added is a discount
            else if (ddlChooseItem.SelectedItem.Text=="Discounts")
            {
                try
                {
                    TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
                    TreasureLand.DBM.MenuItem d = new DBM.MenuItem();
                    d.MenuItemName = txtAddMenuItemName.Text;
                    d.MenuItemPrice = Convert.ToDecimal(txtAddPrice.Text);
                    d.IsCurrentItem = true;
                    d.FoodDrinkCategoryID = Convert.ToByte(3);
                    db.MenuItems.InsertOnSubmit(d);
                    db.SubmitChanges();
                }
                catch (Exception)
                {

                    throw;
                }
            }
            else
            {
                //The item to be added is a menu item
                //gets the value from the category drop down list and adds 4 to that value
                //2 for drink categories, 1 for dicount category, and 1 since the first location is 0
                TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
                TreasureLand.DBM.MenuItem mi = new TreasureLand.DBM.MenuItem();
                mi.FoodDrinkCategoryID = Convert.ToSByte(ddlAddCategory.SelectedIndex + 4);
                mi.MenuItemName = txtAddMenuItemName.Text;
                mi.MenuItemPrice = Convert.ToDecimal(txtAddPrice.Text);
                mi.IsCurrentItem = true;
                db.MenuItems.InsertOnSubmit(mi);
                db.SubmitChanges();
            }

            disableButtons(true);
            gvMenuItems.DataBind();
            ddlMenuItemIngredients.DataBind();
        }
		private void detach_MenuItems(MenuItem entity)
		{
			this.SendPropertyChanging();
			entity.FoodDrinkCategory = null;
		}
 partial void UpdateMenuItem(MenuItem instance);
 partial void DeleteMenuItem(MenuItem instance);
 partial void InsertMenuItem(MenuItem instance);