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); }