protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                KitchenProjectEntities db = new KitchenProjectEntities();
                // removing all items cart
                List <cart> carts_all = db.carts.ToList();

                foreach (var item in carts_all)
                {
                    db.carts.Remove(item);
                }
                db.SaveChanges();

                List <Food_Items> users = db.Food_Items.ToList();

                grdFoodItem.DataSource = users;
                grdFoodItem.DataBind();

                foreach (var item in users)
                {
                    ddlFoodItems.Items.Add(item.Food_Name);
                }
            }
        }
        protected void btnInsert_Click(object sender, EventArgs e)
        {
            int    Id          = Convert.ToInt32(txtId.Text);
            string Food_name   = txtName.Text;
            string Ingrediants = txtIngrediants.Text;
            string SplNotes    = txtSplNotes.Text;
            string Catagory    = txtCatageory.Text;
            int    Price       = Convert.ToInt32(txtPrice.Text);


            Food_Items foods = new Food_Items()
            {
                id = Id, Food_Name = Food_name, Ingrediants = Ingrediants, Special_Notes = SplNotes, Catageory = Catagory, Price = Price
            };

            KitchenProjectEntities db = new KitchenProjectEntities();

            db.Food_Items.Add(foods);

            db.SaveChanges();

            List <Food_Items> users = db.Food_Items.ToList();

            grdFoodItem.DataSource = users;
            grdFoodItem.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            KitchenProjectEntities db = new KitchenProjectEntities();

            List <Food_Items> users = db.Food_Items.ToList();

            grdFoodItem.DataSource = users;
            grdFoodItem.DataBind();
        }
        protected void btnAdminLogin_Click(object sender, EventArgs e)
        {
            KitchenProjectEntities db1 = new KitchenProjectEntities();

            List <Admin_Credentials> admins = db1.Admin_Credentials.ToList();

            foreach (var item in admins)
            {
                if (item.AdminUsername == txtUsername.Text && item.Admin_password == txtPassword.Text)
                {
                    Response.Redirect("~/AddFoodItems.aspx");
                }
            }
        }
        protected void btnAddCart_Click(object sender, EventArgs e)
        {
            string Food_name           = Convert.ToString(ddlFoodItems.SelectedItem);
            int    quantity            = Convert.ToInt32(ddlQuantity.SelectedValue);
            KitchenProjectEntities db1 = new KitchenProjectEntities();

            List <Food_Items> foodItems = db1.Food_Items.ToList();
            int?price = 0;

            foreach (var item in foodItems)
            {
                if (item.Food_Name == Food_name)
                {
                    price = item.Price * quantity;
                }
            }



            cart cart_items = new cart()
            {
                Food_name = Food_name, quantity = quantity, price = price
            };


            KitchenProjectEntities db = new KitchenProjectEntities();


            db.carts.Add(cart_items);
            db.SaveChanges();

            List <cart> carts_list = db.carts.ToList();

            grdCart.DataSource = carts_list;
            grdCart.DataBind();

            // for tatal Bill
            int?total_Price = 0;

            foreach (var item in carts_list)
            {
                total_Price += item.price;
            }

            lblTotalBill.Text = total_Price.ToString();
        }
        protected void btnUserLogin_Click(object sender, EventArgs e)
        {
            KitchenProjectEntities db = new KitchenProjectEntities();


            List <User_Credentials> users = db.User_Credentials.ToList();



            foreach (var item in users)
            {
                if (item.Username == txtUsername.Text && item.User_password == txtPassword.Text)
                {
                    Response.Redirect("~/Kitchen_Home.aspx");
                }
                else
                {
                    Response.Write("Please Authonticate Correct");
                }
            }
        }