public void ReconcileShipRateToShipViaWithRefData() { var referenceData = RetrieveRefData(); var settingsRecords = _settingsRepository.RetrieveRateToShipVias(); var deleteShopifyRateNames = new List <string>(); foreach (var settingsRecord in settingsRecords) { var acumaticaCarrierId = settingsRecord.AcumaticaShipViaId; // Remove if Acumatica Ship Via is missing from Bridge // var acumaticaShipVia = referenceData .AcumaticaShipVia .FirstOrDefault(x => x == acumaticaCarrierId); if (acumaticaShipVia == null) { _logService.Log($"Acumatica Ship Via '{acumaticaCarrierId}' is missing"); deleteShopifyRateNames.Add(settingsRecord.ShopifyRateName); continue; } } foreach (var deleteMe in deleteShopifyRateNames) { _settingsRepository.DeleteRateToShipVia(deleteMe); } }