public async Task <IActionResult> GetBomListXQty(string name, int xQty) { var bomList = await _repo.GetBomListXQty(xQty, name); var listas = new List <BomListWithXQtyForListDto>(); var suma = 0; foreach (var item in bomList) { var componentas = await _context.Componentass.Include(u => u.Reels).FirstOrDefaultAsync(u => u.BuhNr == item.BuhNr); if (componentas != null) { foreach (var itemas in componentas.Reels) { suma = suma + itemas.QTY; } } listas.Add(new BomListWithXQtyForListDto { Id = item.Id, BuhNr = item.BuhNr, xQty = item.Qty, QtyInDb = suma, BomNameId = item.BomNameId }); suma = 0; } return(Ok(listas)); }