public FindFood()
{
InitializeComponent();
DbHandler dbh = new DbHandler();
dbh.addItemsToComboBox(comboBox3, 0, 1, "HowPrepare", 2);
dbh.addItemsToComboBox(comboBox1, 0, 1, "MeasurementUnits", -1);
}
public AddPartOfFood()
{
InitializeComponent();
DbHandler dbh = new DbHandler();
dbh.addItemsToComboBox(comboBox2, 0, 1, "HowPrepare", 2, false);
dbh.addItemsToComboBox(comboBox1, 0, 1, "MeasurementUnits", -1);
}
public AddFood()
{
InitializeComponent();
label6.Visible = false;
DbHandler dbh = new DbHandler();
dbh.addItemsToComboBox(comboBox3, 0, 1, "HowPrepare", 2);
dbh.addItemsToComboBox(comboBox1, 0, 1, "MeasurementUnits", -1);
dbh.addItemsToComboBox(comboBox2, 0, 1, "PartsOfFood", -1);
}
public DeleteFood()
{
InitializeComponent();
label6.Visible = false;
DbHandler dbh = new DbHandler();
dbh.addItemsToComboBox(comboBox3, 0, 1, "HowPrepare", 2);
dbh.addItemsToComboBox(comboBox1, 0, 1, "MeasurementUnits", -1);
dbh.addItemsToComboBox(comboBox4, 0, 2, "Food", -1);
dbh.refreshListBox(listBox1, "foodChange", (int)comboBox4.SelectedValue);
}
private void button1_Click(object sender, EventArgs e)
{
DbHandler dbh = new DbHandler();
dbh.delete("delete from PartsOfFood where id=" + ((KeyValuePair <int, string>)comboBox3.SelectedItem).Key);
dbh.showHideLabel(label6);
dbh.addItemsToComboBox(comboBox3, 0, 1, "PartsOfFood", -1);
}
