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