public Form1()
{
InitializeComponent();
listView1.View = View.Details;
listView1.Columns.Add("Name");
listView1.Columns.Add("Meal");
listView1.Columns.Add("Category");
listView1.Columns.Add("Day");
listView1.Columns.Add("Day Num");
try
{
conn.Open();
}
catch (Exception ex)
{
MessageBox.Show("We cannot connect to the database", ex.Message);
return;
}
Updates.updateSource(conn);
Updates.updateDays(conn);
Updates.updateCuisine(conn);
Updates.updateMeal(conn);
Updates.updateCategory(conn);
Updates.updateSeason(conn);
Updates.updateUnits(conn);
Updates.updateIngredients(conn);
}
private void button1_Click(object sender, EventArgs e)
{
foreach (string cuisine in Updates.getCuisines())
{
if (cuisine == textBox1.Text)
{
MessageBox.Show("This cuisine is already in the list");
button1.Enabled = false;
textBox1.Text = null;
textBox1.Select();
return;
}
}
string theCmd = "INSERT INTO Cuisine (name) VALUES (\'" + textBox1.Text + "\');";
cmd = new MySqlCommand(theCmd, conn);
cmd.ExecuteNonQuery();
Updates.updateCuisine(conn);
MessageBox.Show("This cuisine is added to the list");
textBox1.Text = null;
button1.Enabled = false;
textBox1.Select();
}
