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);
}
// Add category button
private void button3_Click(object sender, EventArgs e)
{
foreach (string cat in Updates.getCatagories())
{
if (cat == comboBox1.Text)
{
MessageBox.Show("This ingredient category is already in the list");
return;
}
}
string theCmd = "INSERT INTO Category (name) VALUES (\'" + comboBox1.Text + "\');";
cmd = new MySqlCommand(theCmd, conn);
cmd.ExecuteNonQuery();
Updates.updateCategory(conn);
MessageBox.Show("This category is added to the list");
}
