public async void Select_WorkSheet_By_Index()
{
var providerSettings = TestHelper.CreateProviderSettings();
var excelPackage = TestHelper.CreateSampleExcelPackage(providerSettings);
var excelTerminologyService =
new ExcelTermLoaderService(providerSettings);
var worksheet = await excelTerminologyService.GetTerminologyWorksheet(excelPackage);
Assert.Equal(worksheet.Name, "Glossary");
}
public async void Select_WorkSheet_Which_Doesnt_Exists()
{
var providerSettings = TestHelper.CreateProviderSettings();
var excelPackage = TestHelper.CreateSampleExcelPackage(providerSettings);
providerSettings.WorksheetName = "Worksheet";
var excelTerminologyService =
new ExcelTermLoaderService(providerSettings);
var worksheet = await excelTerminologyService.GetTerminologyWorksheet(excelPackage);
Assert.Equal(worksheet, null);
}
public async void Get_All_Terms_With_Header(int id
, string expectedSource
, string expectedTarget
, string expectedApproved
, int expectedCount)
{
var providerSettings = TestHelper.CreateProviderSettings();
var excelPackage = TestHelper.CreateSampleExcelPackage(providerSettings);
var excelTerminologyService =
new ExcelTermLoaderService(providerSettings);
var worksheet = await excelTerminologyService.GetTerminologyWorksheet(excelPackage);
var actual = await excelTerminologyService.GetTermsFromExcel(worksheet);
Assert.Equal(actual.Count, expectedCount);
var actualExcelTerm = actual[id];
Assert.Equal(actualExcelTerm.Source, expectedSource);
Assert.Equal(actualExcelTerm.SourceCulture.Name,
providerSettings.SourceLanguage.Name);
Assert.Equal(actualExcelTerm.Target, expectedTarget);
Assert.Equal(actualExcelTerm.TargetCulture.Name,
providerSettings.TargetLanguage.Name);
Assert.Equal(actualExcelTerm.Approved, expectedApproved);
}