Пример #1
0
        private void btnFood_Click(object sender, EventArgs e)
        {
            frmFood newForm = new frmFood();

            newForm.Show();
            this.Hide();
        }
Пример #2
0
        private void btnCancel_Click(object sender, EventArgs e)
        {
            DialogResult dialogResult = MessageBox.Show("Are you sure you want to cancel? No changes will be saved.", "Confirmation", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                frmFood newForm = new frmFood();
                //newForm.clearDataGridView();
                //newForm.loadDataGridView();
                newForm.Show();
                this.Hide();
            }
        }
Пример #3
0
        private void confirmButton(int choice)
        {
            double price        = 0.0;
            bool   convertPrice = double.TryParse(txtFoodPrice.Text, out price);

            if (convertPrice == false || price < 0)
            {
                MessageBox.Show("Please enter positive numbers in the Price field!", "Error");
                return;
            }
            else if (String.IsNullOrWhiteSpace(txtFoodName.Text))
            {
                MessageBox.Show("Please enter data in the Food Name field!", "Error");
                return;
            }

            price = Math.Round(price, 2);
            try
            {
                connect.Open();
                string p = "SELECT Max(foodID) FROM Food";

                int          maxId   = 1;
                OleDbCommand command = new OleDbCommand();
                using (OleDbCommand command1 = new OleDbCommand(p, connect))
                {
                    if (command1.ExecuteScalar() != DBNull.Value)
                    {
                        maxId = Convert.ToInt32(command1.ExecuteScalar());
                        maxId = maxId + 1;
                    }
                }

                command.Connection = connect;
                if (choice == 1)
                {
                    command.CommandText = "insert into Food (foodID, foodName, price) values  ('" + maxId + "','" + txtFoodName.Text + "'," + price + ")";
                }
                else if (choice == 2)
                {
                    command.CommandText = "UPDATE Food SET foodName='" + txtFoodName.Text + "', price=" + price + " WHERE foodID = " + food + ";";
                }

                command.ExecuteNonQuery();
                if (choice == 1)
                {
                    MessageBox.Show("Food record successfully added! Returning to previous screen!", "Successful");
                }
                else if (choice == 2)
                {
                    MessageBox.Show("Food record successfully edited! Returning to previous screen!", "Successful");
                }

                connect.Close();
                frmFood f1 = new frmFood();
                f1.Show();
                this.Hide();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error" + ex);
            }
        }