public void CompareReport(CompareTestCase testData) { string goldenCopyPath = Paths.GetGoldenCopyPath(testData.ProjectName, testData.GoldenCopyPath); TestContext.WriteLine("1st spreadsheet is the golden copy of report"); TestContext.AddTestAttachment(goldenCopyPath, "Golden copy of report"); var DownloadReportModal = InitialPage.GoToProjectLink(testData.ProjectLink) .GoToReportsPage().SelectReport(testData.ReportGroup, testData.ReportName); string downloadedReport = DownloadReportModal .GenerateReport(testData.FullYear, testData.YpeNUM, testData.BooksetType, testData.LayerType) .DownloadReport(); TestContext.WriteLine("2nd spreadsheet is the downloaded report"); TestContext.AddTestAttachment(downloadedReport, "Downloaded report"); var reporteCompartor = new ExcelReportComparator(goldenCopyPath); Assert.That(reporteCompartor.DevopsCompareExcelReport(downloadedReport), "Downloaded report and golden copy should have equal data"); }
public void BrowserlessCompareReport(CompareTestCase testData) { //GOOD PATH string goldenCopyPath = Paths.GetGoldenCopyPath(testData.ProjectName, testData.GoldenCopyPath); TestContext.WriteLine("1st spreadsheet is the golden copy of report"); TestContext.AddTestAttachment(goldenCopyPath, "Golden copy of report"); string fakeDownloadedReport = "C:\\Users\\GK122LX\\Desktop\\FrameworkEY_cloned\\InputData\\R1.11.3\\SS_R1.11.3_Smoketest_Remedial_FIFO\\Golden Copies\\Set_1_6H_CostRecoveryPartnersBSI_GOLDEN-Bad.xlsm"; //string fakeDownloadedReport = Path.Combine(Settings.DownloadPath, badCopy.Substring(0, badCopy.Length - 5) + " - FakeDownloadedReport.xlsm"); //File.Copy(goldenCopyPath, fakeDownloadedReport); TestContext.WriteLine("2nd spreadsheet is the downloaded report"); TestContext.AddTestAttachment(fakeDownloadedReport, "Downloaded report"); var reporteCompartor = new ExcelReportComparator(goldenCopyPath); Assert.That(reporteCompartor.DevopsCompareExcelReport(fakeDownloadedReport), "Downloaded report and golden copy should have equal data"); }