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);
        }