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) { }