public void addIngredient(clsIngredient ingr)
{
_strSQL = "INSERT INTO Ingredients (Name, Description, Season) VALUES ('" + ingr.name + "', '" +
ingr.description + "', '" + ingr.season + "')";
executesql();
}
private void getIngredients()
{
foreach (ListViewItem item in lstIngredients.CheckedItems)
{
String query = "Name='" + item.Text + "'";
DataRow[] dr = _ingredients.Select(query);
clsIngredient ingr = new clsIngredient();
ingr.id = Int32.Parse(dr[0]["Ingr_id"].ToString());
ingr.name = dr[0]["Name"].ToString();
ingr.description = dr[0]["Description"].ToString();
ingr.season = dr[0]["Season"].ToString();
_ingredientsUsed.Add(ingr);
}
//for (int i = 0; i < lstIngredients.CheckedItems.Count; ++i)
//{
// string itemname = lstIngredients.Items[i].Text;
// for (int k = 0; k < _ingredients.Rows.Count; ++k)
// {
// DataRow dr = _ingredients.Rows[k];
// if (dr["Name"].ToString().Equals(itemname))
// {
// clsIngredient ingr = new clsIngredient();
// ingr.id = Int32.Parse(dr["Ingr_id"].ToString());
// ingr.name = dr["Name"].ToString();
// ingr.description = dr["Description"].ToString();
// ingr.season = dr["Season"].ToString();
// _ingredientsUsed.Add(ingr);
// }
// }
//}
}
private void getIngredients()
{
foreach (ListViewItem item in lstIngredients.CheckedItems)
{
String query = "Name='" + item.Text + "'";
DataRow[] dr = _ingredients.Select(query);
clsIngredient ingr = new clsIngredient();
ingr.id = Int32.Parse(dr[0]["Ingr_id"].ToString());
ingr.name = dr[0]["Name"].ToString();
ingr.description = dr[0]["Description"].ToString();
ingr.season = dr[0]["Season"].ToString();
_strIngredients.Add(ingr);
}
}
private void getIngredients()
{
for (int i = 0; i < lstIngredients.CheckedItems.Count; ++i)
{
string itemname = lstIngredients.Items[i].Text;
for (int k = 0; k < _ingredients.Rows.Count; ++k)
{
DataRow dr = _ingredients.Rows[k];
if (dr["Name"].ToString().Equals(itemname))
{
clsIngredient ingr = new clsIngredient();
ingr.id = Int32.Parse(dr["Ingr_id"].ToString());
ingr.name = dr["Name"].ToString();
ingr.description = dr["Description"].ToString();
ingr.season = dr["Season"].ToString();
_ingredientsUsed.Add(ingr);
}
}
}
}
public frmAddIngredient(frmAddRecipe frmRec)
{
_frmRec = frmRec;
_ingredient = new clsIngredient();
InitializeComponent();
}