public DrinkViewModels PostDrinkId([FromBody]int id) { using (var db = new DrinkAppContext()) { var dri = new DrinkRecipeViewModels(); var drink = db.Drinks.Select(a => a).Where(b => b.DrinkID == id).FirstOrDefault(); var drinkVM = new List<DrinkViewModels>(); var x = (from dr in db.DrinkRecipes join i in db.Ingredients on dr.IngredientID equals i.IngredientID where dr.DrinkID == id select new DrinkRecipeViewModels { DrinkRecipeID = dr.DrinkRecipeID, Amount = dr.Amount, Order = dr.Order, IngredientID = dr.IngredientID, DrinkID = dr.DrinkID, Name = i.Name }).ToList(); var drinkVMs = new DrinkViewModels(); drinkVMs.DrinkID = drink.DrinkID; drinkVMs.Name = drink.Name; drinkVMs.DrinkTaste = drink.DrinkTaste; drinkVMs.DrinkType = drink.DrinkType; drinkVMs.Complexity = drink.Complexity; drinkVMs.DRI = x; return drinkVMs; } }
public IEnumerable<DrinkViewModels> Get() { using (var db = new DrinkAppContext()) { var dri = new DrinkRecipeViewModels(); var drinkVM = new List<DrinkViewModels>(); var drinklist = db.Drinks.ToList(); foreach (var item in drinklist) { var x = (from dr in db.DrinkRecipes join i in db.Ingredients on dr.IngredientID equals i.IngredientID where dr.DrinkID == item.DrinkID select new DrinkRecipeViewModels { DrinkRecipeID = dr.DrinkRecipeID, Amount = dr.Amount, Order = dr.Order, IngredientID = dr.IngredientID, DrinkID = dr.DrinkID, Name = i.Name }).ToList(); var drinkVMs = new DrinkViewModels(); drinkVMs.DrinkID = item.DrinkID; drinkVMs.Name = item.Name; drinkVMs.DrinkTaste = item.DrinkTaste; drinkVMs.DrinkType = item.DrinkType; drinkVMs.Complexity = item.Complexity; drinkVMs.DRI = x; drinkVM.Add(drinkVMs); } return drinkVM; } }