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!"); } } }