private void IngListPanel_Paint(object sender, PaintEventArgs e)
{
if (user.get_ingredient_name() == "")
{
maltbox.Text = "0";
hopsbox.Text = "0";
yeastsbox.Text = "0";
sugarsbox.Text = "0";
additivesbox.Text = "0";
waterbox.Text = "0";
}
else
{
Ingredients ingredient = new Ingredients();
con.Open();
String str = "SELECT [malt],[hops],[yeasts],[sugars],[additives],[water] FROM [ingredients] WHERE name = '" + user.get_ingredient_name() + "';";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
ingredient.add_malts(reader.GetInt32(0));
ingredient.add_hops(reader.GetInt32(1));
ingredient.add_yeasts(reader.GetInt32(2));
ingredient.add_sugars(reader.GetInt32(3));
ingredient.add_additives(reader.GetInt32(4));
ingredient.add_water(reader.GetInt32(5));
maltbox.Text = ingredient.get_malts().ToString();
hopsbox.Text = ingredient.get_hops().ToString();
yeastsbox.Text = ingredient.get_yeasts().ToString();
sugarsbox.Text = ingredient.get_sugars().ToString();
additivesbox.Text = ingredient.get_additives().ToString();
waterbox.Text = ingredient.get_water().ToString();
}
con.Close();
}
}
public void modify_recipe(Ingredients a)
{
}
