private void btnFood_Click(object sender, EventArgs e)
{
frmFood newForm = new frmFood();
newForm.Show();
this.Hide();
}
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();
}
}
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);
}
}
