public async Task Import()
{
if (string.IsNullOrEmpty(_workBookBasePath))
{
return;
}
var xlsUploads = await _xlsUploadRepository.GetXlsUploadsNotProcessdAsync();
foreach (var xlsUpload in xlsUploads)
{
SetCurrentParameterIds(xlsUpload);
// Open file
var filePath = $"{_workBookBasePath}/{xlsUpload.FileName}";
var fileInfo = new FileInfo(filePath);
// Open Xls file
using (var package = new ExcelPackage(fileInfo))
{
CurrentWorkBook = package.Workbook;
UpdateXlsFormulas();
package.Save();
RemoveSubVAriableData();
// await _generalRegionDataImporter.RemoveDataAsync();
await _generalRegionDataImporter.ImportDataAsync();
// await _worldRegionDataImporter.RemoveDataAsync();
await _worldRegionDataImporter.ImportDataAsync();
// await _gdpDataImporter.RemoveDataAsync();
await _gdpDataImporter.ImportDataAsync();
}
xlsUpload.IsProcessed = true;
_xlsUploadRepository.Update(xlsUpload);
await _unitOfWork.CompleteAsync();
// Remove File
try
{
fileInfo.Delete();
_logger.LogInformation($"File: {filePath} is deleted");
}
catch (Exception ex)
{
_logger.LogError(ex, $"Error - Delete file: {filePath}");
}
}
}