public async Task Post([FromBody] TranslationDTO translations)
{
var validationResult = _translationValidator.Validate(translations);
if (validationResult.IsFailed)
{
throw new Exception(validationResult.Error);
}
await _translationService.SaveTranslationForCulture(translations.CultureId, translations.Translations);
}
public async Task SaveExcelData(int cultureId, Stream file)
{
using (ExcelPackage package = new ExcelPackage(file))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
int totalRows = workSheet.Dimension.Rows;
var translations = new List <TranslationVO>();
for (int i = 2; i <= totalRows; i++)
{
translations.Add(new TranslationVO
{
Key = workSheet.Cells[i, 1].Value.ToString(),
Value = workSheet.Cells[i, 2].Value.ToString(),
});
}
await _translationService.SaveTranslationForCulture(cultureId, translations);
}
return;
}
