public string AddOrUpdateIngredientInFood(Food newFood)
{
FoodManager foodManager = new FoodManager();
int foodID = foodManager.GetFoodIDByName(newFood.Name);
string res = DeleteIngredientInFood(foodID);
if (res != "")
return res;
if (newFood.GetIngredients() == null)
return "";
foreach (Ingredient igr in newFood.GetIngredients())
{
res = AddOrUpdateIngredientDetails(igr.GetIngredientDetails());
if (res != "")
return res;
try
{
int ingredientDetailsID = GetIngredientDetailsID(igr.Name);
DAL.Ingredient newIgredient = new DAL.Ingredient();
newIgredient.ingredientDetailsID = ingredientDetailsID;
newIgredient.quantity = igr.Quantity;
Table<DAL.Ingredient> igrTable = GetIngredientsTable();
igrTable.InsertOnSubmit(newIgredient);
igrTable.Context.SubmitChanges();
DAL.IngredientsInFood newIgrInFood = new DAL.IngredientsInFood();
newIgrInFood.foodID = foodID;
newIgrInFood.ingredientID = newIgredient.ingredientID;
Table<DAL.IngredientsInFood> igrInFoodTable = GetIngredientsInFoodTable();
igrInFoodTable.InsertOnSubmit(newIgrInFood);
igrInFoodTable.Context.SubmitChanges();
}
catch (Exception ex)
{
return ex.Message;
}
}
return "";
}
