예제 #1
0
        private void label1_Click(object sender, EventArgs e)
        {
            Create_order ord = new Create_order();

            ord.Show();
            this.Hide();
        }
예제 #2
0
        private void agree_Click(object sender, EventArgs e)
        {
            DB db = new DB();

            Table.TableGuest = guestBox.Text;

            if (Table.TableWaiter == "Александр Алексеев")
            {
                Table.TableWaiter = "1";
            }

            string tableident = Table.TableTable + " " + Table.TableTimer;

            try
            {
                MySqlCommand cmd = new MySqlCommand("call create_order('" + DB.Name_user + "', '" + tableident + "', " + Table.TableTable + ", " + Table.TableGuest + " , '" + Table.TableTimer + "', 0, 0)", db.getConn());

                db.openConn();

                if (cmd.ExecuteNonQuery() == 1)
                {
                    MessageBox.Show("Заказ создан");
                }
                else
                {
                    MessageBox.Show("Ошибка при создании заказа");
                }

                db.closeConn();

                Create_order ord = new Create_order();
                ord.Show();
                this.Hide();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }