List <IngredientsQuantity> GetRecipeIngredientsFromDB(int RecipeId)
{
List <IngredientsQuantity> ingredientsList = new List <IngredientsQuantity>();
SqlDataReader reader;
query = "SELECT * FROM RecipesIngredientsTable WHERE RecipeId = " + RecipeId.ToString();
command = new SqlCommand(query, conn);
try
{
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
IngredientsQuantity ingredient = new IngredientsQuantity();
ingredient.ingredient = reader["Ingredient"].ToString();
ingredient.Quantity = (int)reader["Quantity"];
ingredient.unit = reader["Unit"].ToString();
ingredientsList.Add(ingredient);
}
}
finally
{
conn.Close();
}
return(ingredientsList);
}
Recipe GetRecipeFromForm()
{
string name = txtRecipeName.Text;
string sPeopleServed = txtPeopleServed.Text;
string sCookingTime = txtCookingTime.Text;
Int16 peopleServed = 0;
Int16.TryParse(sPeopleServed, out peopleServed);
Int16 cookingTime = 0;
Int16.TryParse(sCookingTime, out cookingTime);
//ingredientsList
List <IngredientsQuantity> ingredientsList = new List <IngredientsQuantity>();
IngredientsQuantity ingredientQuantity = new IngredientsQuantity();
if (!(comboBox1.Text == "" || comboBox1.Text == "none" || comboBox1.Text == "None" || txtQty1.Text == ""))
{
ingredientQuantity.ingredient = comboBox1.Text;
ingredientQuantity.Quantity = int.Parse(txtQty1.Text);
ingredientQuantity.unit = lblUnit1.Text;
ingredientsList.Add(ingredientQuantity);
}
if (!(comboBox2.Text == "" || comboBox2.Text == "none" || comboBox2.Text == "None" || txtQty2.Text == ""))
{
ingredientQuantity = new IngredientsQuantity();
ingredientQuantity.ingredient = comboBox2.Text;
ingredientQuantity.Quantity = int.Parse(txtQty2.Text);
ingredientQuantity.unit = lblUnit2.Text;
ingredientsList.Add(ingredientQuantity);
}
if (!(comboBox3.Text == "" || comboBox3.Text == "none" || comboBox3.Text == "None" || txtQty3.Text == ""))
{
ingredientQuantity = new IngredientsQuantity();
ingredientQuantity.ingredient = comboBox3.Text;
ingredientQuantity.Quantity = int.Parse(txtQty3.Text);
ingredientQuantity.unit = lblUnit3.Text;
ingredientsList.Add(ingredientQuantity);
}
if (!(comboBox4.Text == "" || comboBox4.Text == "none" || comboBox4.Text == "None" || txtQty4.Text == ""))
{
ingredientQuantity = new IngredientsQuantity();
ingredientQuantity.ingredient = comboBox4.Text;
ingredientQuantity.Quantity = int.Parse(txtQty4.Text);
ingredientQuantity.unit = lblUnit4.Text;
ingredientsList.Add(ingredientQuantity);
}
if (!(comboBox5.Text == "" || comboBox5.Text == "none" || comboBox5.Text == "None" || txtQty5.Text == ""))
{
ingredientQuantity = new IngredientsQuantity();
ingredientQuantity.ingredient = comboBox5.Text;
ingredientQuantity.Quantity = int.Parse(txtQty5.Text);
ingredientQuantity.unit = lblUnit5.Text;
ingredientsList.Add(ingredientQuantity);
}
//int Id = GetNextRecipeId();
Recipe recipe = new Recipe(ingredientsList, peopleServed, cookingTime, name);
return(recipe);
}
