private static void UpdateAzureRegions(IEnumerable <AzureCatalogue> azureCatalogueResult)
{
try
{
var cmpWapDb = new CmpWapDb();
var cmpRegions = cmpWapDb.FetchAzureRegionList(onlyActiveOnes: false);
var azureRegions = azureCatalogueResult.Select(ac => new AzureRegion
{
Name = ac.RegionName,
Description = ac.RegionDisplayName,
OsImageContainer = null,
IsActive = true,
CreatedBy = "CMP WAP Extension",
LastUpdatedBy = "CMP WAP Extension",
CreatedOn = DateTime.UtcNow,
LastUpdatedOn = DateTime.UtcNow
});
var newRegions = azureRegions.Where(azureItem => !cmpRegions.Any(cmpItem => string.Equals(azureItem.Name.Replace(" ", string.Empty), cmpItem.Name.Replace(" ", string.Empty), StringComparison.InvariantCultureIgnoreCase))).ToList();
if (newRegions.Any())
{
cmpWapDb.InsertAzureRegionByBatch(newRegions);
}
}
catch (Exception ex)
{
throw new Exception("Exception caught in UpdateAzureRegions: " + ex.ToString());
}
}
