Beispiel #1
0
        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);
        }