// GET: InventoryTransRecords public async Task <IActionResult> Index() { var inventoryTransRecord = _context.InventoryTransRecord.ToList(); var result = new List <InventoryTransRecordDetails>(); foreach (var item in inventoryTransRecord) { var inventoryTransRecordDetails = new InventoryTransRecordDetails(); inventoryTransRecordDetails.TransId = item.TransId; inventoryTransRecordDetails.Date = item.Date; inventoryTransRecordDetails.ItemName = _context.Catalogue.Find(item.ItemNumber).ItemName; inventoryTransRecordDetails.DepartmentOrSupplier = b.FindDepartmentOrSupplier(item.RecordId); inventoryTransRecordDetails.Qty = item.Qty; inventoryTransRecordDetails.Balance = item.Balance; result.Add(inventoryTransRecordDetails); } return(View(result)); }