/* internal static string updateIngredientQuery(RecipeToIngredient recipeToIngredient) * { * return $"update ingredients set IngredientName values ('{recipeToIngredient.IngredientName}')"; * }*/ internal static string updateRecipeComponent(FullRecipe fullRecipe, RecipeToIngredient recipeToIngredient) { return($"update recipeComponents (" + $" set RecipeId = (select recipeid from recipes where recipes.recipename='{fullRecipe.recipe.RecipeName}'), " + $" set IngredientId = (select ingredientId from Ingredients where ingredients.ingredientName='{recipeToIngredient.IngredientName}'), " + $" set Quantity = {recipeToIngredient.Quantity}" + $" set Unit = '{recipeToIngredient.Unit}') ) " + $" where recipes.recipeId = {fullRecipe.recipe.RecipeId};"); }
public static string insertRecipeComponent(FullRecipe fullRecipe, RecipeToIngredient recipeToIngredient) => $"insert into recipeComponents(" + $"RecipeId, " + $"IngredientId, " + $"Quantity, " + $"Unit) " + $"values" + $"((select recipeid from recipes where recipes.recipename='{fullRecipe.recipe.RecipeName}')," + $"(select ingredientId from Ingredients where ingredients.ingredientName='{recipeToIngredient.IngredientName}'), " + $"{recipeToIngredient.Quantity}, " + $"'{recipeToIngredient.Unit}')";
public static string insertIngredientQuery(RecipeToIngredient recipeToIngredient) => $"insert into ingredients(IngredientName) values ('{recipeToIngredient.IngredientName}')";