private List <CargoItem> MapMsd1CargoSummaryToCargoItem(string id) { List <CargoItem> cargoItems = new List <CargoItem>(); try { IQueryable <Msd1CargoSummary> cargoSummary = _context.Msd1CargoSummary.Where(x => x.Msd1Id == id) .AsQueryable(); foreach (Msd1CargoSummary msd1CargoSummary in cargoSummary) { CargoItem cargoItem = new CargoItem() { Id = Guid.NewGuid(), Description = msd1CargoSummary.Description, Category = _helperService.GetCategoryDescriptionByCode(msd1CargoSummary.CategoryCode), GrossWeight = (double?)msd1CargoSummary.GrossWeight, TotalUnits = msd1CargoSummary.TotalUnits, UnitsWithCargo = msd1CargoSummary.UnitsWithCargo, UnitsWithoutCargo = msd1CargoSummary.UnitsWithoutCargo, }; cargoItems.Add(cargoItem); } } catch (Exception e) { _logger.LogError(e.Message); } return(cargoItems); }