public Form2(MySqlConnection conn)
{
InitializeComponent();
this.conn = conn;
bl = new BindingList <string>(Updates.getCatagories());
comboBox1.DataSource = bl;
comboBox1.SelectedIndex = -1;
comboBox2.DataSource = Updates.getStores();
comboBox2.SelectedIndex = -1;
}
// Add store button
private void button4_Click(object sender, EventArgs e)
{
foreach (string store in Updates.getStores())
{
if (store == comboBox2.Text)
{
MessageBox.Show("This store is already in the list");
return;
}
}
string theCmd = "INSERT INTO Source (name) VALUES (\'" + comboBox2.Text + "\');";
cmd = new MySqlCommand(theCmd, conn);
cmd.ExecuteNonQuery();
Updates.updateSource(conn);
MessageBox.Show("This store is added to the list");
}
public void setSource(string source)
{
bool check = false;
foreach (string store in Updates.getStores())
{
if (source == store)
{
check = true;
}
}
if (check)
{
this.source = source;
}
else
{
this.source = null;
}
}
// 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();
}