public IActionResult FoodRecipeDetails() { var res = from ls in _context.RequiredMaterial .AsNoTracking().Include(s => s.FoodItem). Include(s => s.Ingredient) group ls by ls.FoodItemId into p let temp = ( from val in p select new { Price = val.FoodItem.Price, FoodItemId = val.FoodItem.FoodItemId, FoodName = val.FoodItem.FoodName, IngredientName = val.Ingredient.IngredientName, Quantity = val.QuantityInGram, IngredientId = val.IngredientId, RequiredMaterialId = val.RequiredMaterialId } ) select temp; var sent = new List <RequiredMaterialVm>(); List <MaterialVm> prt = new List <MaterialVm>(); int c = 1; foreach (var item in res) { var ass = new RequiredMaterialVm(); foreach (var it in item) { ass.Price = it.Price; ass.FoodItemId = it.FoodItemId; ass.FoodItemNames = it.FoodName; MaterialVm t = new MaterialVm() { QuantityInGram = it.Quantity, IngredientName = it.IngredientName }; ass.MaterialVms.Add(t); ass.Serial = c; } sent.Add(ass); c++; } return(View(sent)); }
public async Task <ActionResult <MaterialVm> > GetMaterial(short id) { var material = await _context.Materials.FindAsync(id); if (material == null) { return(NotFound()); } var materialvm = new MaterialVm { ID = material.ID, Name = material.Name, Status = material.Status }; return(materialvm); }