public void SaveRecipe(Recipe recipe)
{
var recipeId = Guid.NewGuid().ToString();
var recipeDbo = new RecipeDbo(recipeId, recipe.Name, recipe.Category);
_appDb.SaveToRecipeTable(recipeDbo);
_appDb.SaveToIngredientsTable(recipeId, recipe.Ingredients);
_appDb.SaveToDirectionsTable(recipeId, recipe.Directions);
}
public void SaveToRecipeTable(RecipeDbo recipe)
{
String query = "INSERT INTO recipes (name, id, category) VALUES (@name,@id, @category)";
using (MySqlCommand command = new MySqlCommand(query, Connection))
{
command.Parameters.AddWithValue("@name", recipe.Name);
command.Parameters.AddWithValue("@id", recipe.RecipeId);
command.Parameters.AddWithValue("@category", recipe.Category);
Connection.Open();
int result = command.ExecuteNonQuery();
Connection.Close();
// Check Error
if (result < 0)
{
Console.WriteLine("Error inserting data into Database!");
}
}
}
