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); }
// Adds ingredient private void button1_Click(object sender, EventArgs e) { foreach (Ingredient ing in Updates.getIngredients()) { if (ing.name == textBox1.Text) { MessageBox.Show("This ingredient is already in the list"); textBox1.Text = null; radioButton1.Checked = false; button1.Enabled = false; numericUpDown1.Value = 0; comboBox1.Text = ""; comboBox2.Text = ""; textBox1.Select(); return; } } if (comboBox1.Text != String.Empty) { bool inList = false; foreach (string s in Updates.getCatagories()) { if (s == comboBox1.Text) { inList = true; break; } } if (!inList) { category = null; MessageBox.Show("You must select a category from the list or add it."); comboBox1.Select(); return; } if (inList) { category = comboBox1.Text; } } else { category = null; } if (comboBox2.Text != String.Empty) { bool inList = false; foreach (string s in Updates.getStores()) { if (s == comboBox2.Text) { inList = true; break; } } if (!inList) { source = null; MessageBox.Show("You must select a store from the list or add it."); comboBox2.Select(); return; } if (inList) { source = comboBox2.Text; } } else { source = null; } if (radioButton1.Checked) { staple = "true"; } else { staple = "false"; } string cmdText = "SET TRANSACTION READ WRITE;"; cmd = new MySqlCommand(cmdText, conn); cmd.ExecuteNonQuery(); cmdText = "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;"; cmd = new MySqlCommand(cmdText, conn); cmd.ExecuteNonQuery(); cmdText = "START TRANSACTION;"; cmd = new MySqlCommand(cmdText, conn); cmd.ExecuteNonQuery(); string theCmd = "CALL addIngredient(\'" + textBox1.Text + "\', \'" + category + "\', \'" + source + "\', " + staple + ", " + numericUpDown1.Value.ToString() + ");"; cmd = new MySqlCommand(theCmd, conn); cmd.ExecuteNonQuery(); cmdText = "COMMIT;"; cmd = new MySqlCommand(cmdText, conn); cmd.ExecuteNonQuery(); Updates.updateIngredients(conn); MessageBox.Show("This ingredient is added to the list"); textBox1.Text = null; button1.Enabled = false; numericUpDown1.Value = 0; comboBox1.Text = ""; comboBox2.Text = ""; radioButton1.Checked = false; textBox1.Select(); }