Example #1
0
 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 { }
 }
Example #2
0
        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();
        }