public void TestMethod1() { var uatConnectionString = ""; var qaConnectionString = ""; var uatQuery = @""; var qaQuery = uatQuery; var uatSqlServerHelper = new SQLServerHelper(uatConnectionString); var qaSqlServerHelper = new SQLServerHelper(qaConnectionString); var uatResult = uatSqlServerHelper.GetDataTable(uatQuery); var qaResult = qaSqlServerHelper.GetDataTable(qaQuery); uatResult.PrimaryKey = new DataColumn[] { uatResult.Columns[""] }; qaResult.PrimaryKey = new DataColumn[] { qaResult.Columns[""] }; var diff = DataTableMerger.Merge(uatResult, qaResult, null, "UAT", "QA"); var path = string.Format(@"E:\Test_{0}.xlsx", DateTime.Now.Ticks); var excelExport = new ExcelGenerator(); excelExport.Export(uatResult, path, "UAT"); excelExport.Export(qaResult, path, "QA"); excelExport.Export(diff, path, "Diff"); }
public void GetDifferenceTest_NoDifference() { DataTable firstTable = ExcelGeneratorTests.MockDataTable("firstTable"); DataTable secondTable = firstTable.Copy(); DataTable expected = null; // TODO: Initialize to an appropriate value DataTable actual; actual = DataTableMerger.Merge(firstTable, secondTable); var path = string.Format(@"E:\Test_{0}.xlsx", DateTime.Now.Ticks); var excelExport = new ExcelGenerator(); excelExport.Export(firstTable, path, "first"); excelExport.Export(secondTable, path, "second"); excelExport.Export(actual, path, "diff"); Assert.AreEqual(expected, actual); }
public void ExportTestThenSuccess() { var dataTable = TestHelper.MockDataTable("Test-case"); var path = string.Format(CultureInfo.CurrentCulture, @"D:\Test_{0}.xlsx", DateTime.Now.Ticks); var workbook = ExcelGenerator.Export(dataTable); workbook.SaveAs(path); Assert.IsTrue(File.Exists(path)); File.Delete(path); }
public void HighlightTextThenSuccess() { var ticks = DateTime.Now.Ticks; using (var dataTable = TestHelper.MockMergedDataTable()) { var workbook = ExcelGenerator.Export(dataTable); var worksheet = workbook.Worksheet("Result"); ExcelGenerator.Highlight(worksheet, "_UAT", "_PROD", "_Gap"); var highlightPath = string.Format(CultureInfo.CurrentCulture, @"D:\hightlight_{0}.xlsx", ticks); workbook.SaveAs(highlightPath); } }