public async Task <String> PopulateDatabase()
{
List <Nace> savedNaces = await ds.getAllNaces();
List <Region> savedRegions = await ds.getAllRegions();
List <EuroStatTable> savedTables = await ds.getAllEuroStatTables();
foreach (Nace nace in baseData.getAllNaces())
{
try
{
if (!savedNaces.Contains(nace))
{
await ds.createNace(nace);
}
} catch (Exception exception)
{
_logger.LogError(exception.ToString());
return(exception.ToString());
}
}
foreach (Region region in baseData.getAllRegions())
{
try
{
if (!savedRegions.Contains(region))
{
await ds.createRegion(region);
}
} catch (Exception exception)
{
_logger.LogError(exception.ToString());
return(exception.ToString());
}
}
foreach (EuroStatTable table in baseData.getAllEuroStatTables())
{
try
{
if (!savedTables.Contains(table))
{
await ds.createEuroStatTable(table);
}
} catch (Exception exception)
{
_logger.LogError(exception.ToString());
return(exception.ToString());
}
}
return("The base data was added successfully");
}