public async Task BulkInsertAsync(NormalizedCsvModel normalizedCsvModel)
{
_logger.LogInformation("Convert list of object to json.");
var serializeCsvData = JsonConvert.SerializeObject(normalizedCsvModel);
_logger.LogInformation("Write serialized data to json file.");
await File.WriteAllTextAsync($"{_fileSettings.JsonFilePath}\\NormalizedCSVData.json", serializeCsvData);
}
public async Task BulkInsertAsync(NormalizedCsvModel normalizedCsvModel)
{
try
{
_logger.LogInformation("Saving Colors.");
await _dbContext.BulkInsertAsync <Color>(normalizedCsvModel.Colors);
_logger.LogInformation("Saving ColorCodes.");
await _dbContext.BulkInsertAsync <ColorCode>(normalizedCsvModel.ColorCodes);
_logger.LogInformation("Saving Products.");
await _dbContext.BulkInsertAsync <Product>(normalizedCsvModel.Products);
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message, ex);
throw;
}
}
public async Task SaveNormalizedItemsAsync(NormalizedCsvModel normalizedCsvModel, StorageTypeEnum storageType)
{
await _storage(storageType.ToString()).BulkInsertAsync(normalizedCsvModel);
}
