private void button1_Click(object sender, EventArgs e) { try { DbHandler dbh = new DbHandler(); dbh.write("insert into PartsOfFood (nname, price, energyOnGram, measurementUnitsId, howPrepareId) values ('" + textBox1.Text + "','" + textBox4.Text + "','" + textBox3.Text + "','" + comboBox1.SelectedValue + "','" + ((KeyValuePair <int, string>)comboBox2.SelectedItem).Key + "')"); textBox1.Text = ""; textBox3.Text = ""; textBox4.Text = ""; dbh.showHideLabel(label6); } catch { } }
private void button1_Click(object sender, EventArgs e) { string ingr = ""; foreach (KeyValuePair <int, int> item in ingredients) { ingr += item.Key + "x" + item.Value + ";"; } ingr.Remove(ingr.Length - 1); DbHandler dbh = new DbHandler(); dbh.write("insert into Food (measurementUnitsId, nname, howPrepareId, partsOfFood) values ('" + comboBox1.SelectedValue + "','" + textBox1.Text + "','" + comboBox3.SelectedValue + "','" + ingr + "')"); textBox1.Text = ""; listBox1.Items.Clear(); label6.Visible = true; timer = new Timer(); timer.Interval = 3000; timer.Tick += hideLabel; timer.Start(); }