private void FillData(IXLWorksheet worksheet, IList <string> columns, CompareFile compareData, ExcelReportConfigurationDocument config)
{
var rowId = config.SkipRow + HEADER_ROW_COUNT + 1;
foreach (var item in compareData.CompareItems)
{
FillItem(worksheet, rowId++, columns, item, config);
}
worksheet.Range(config.SkipRow + HEADER_ROW_COUNT + 1, config.SkipColumn + 1, rowId - 1, config.SkipColumn + 1).SetStyle(config.BorderStyle);
worksheet.Range(config.SkipRow + HEADER_ROW_COUNT + 1, config.SkipColumn + 2, rowId - 1, config.SkipColumn + 1 + columns.Count).SetStyle(config.BorderStyle);
worksheet.Range(config.SkipRow + HEADER_ROW_COUNT + 1, config.SkipColumn + 1 + columns.Count + 1, rowId - 1, config.SkipColumn + 1 + columns.Count * 2).SetStyle(config.BorderStyle);
}
public void NewSheet(CompareFile compareData, string path1, string path2, ExcelReportConfigurationDocument config)
{
Preconditions.NotNull(compareData, "compareData");
Preconditions.Check(compareData.CompareItems.Count > 0, "CompareData should not be empty.");
Preconditions.NotNullOrWhiteSpace(path1, "path1");
Preconditions.NotNullOrWhiteSpace(path2, "path2");
Preconditions.Check(!path1.Equals(path2, StringComparison.OrdinalIgnoreCase), "Path1 should not be same as Path2");
var columns = compareData.CompareItems.First().Data.Select(x => x.Key).ToList();
var worksheet = workbook.Worksheets.Add(compareData.FileName);
OutputHeader(worksheet, columns, path1, path2, config);
FillData(worksheet, columns, compareData, config);
UpdateWorksheetStyles(worksheet, compareData.CompareItems.Count, columns.Count, config);
}
private void compareFile(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
var item = listView1.Items[listView1.SelectedItems[0].Index].Tag as FileEntry;
if (item.Status == EntryStateEnum.Modified)
{
string beforeFilePath = Path.Combine(txtFileBefore.Text, item.FileName);
string afterFilePath = Path.Combine(txtFileAfter.Text, item.FileName);
CompareFile form = new CompareFile(File.ReadAllText(beforeFilePath), File.ReadAllText(afterFilePath));
form.Text = string.Format("Compare {0} with {1}", beforeFilePath, afterFilePath);
form.Show();
}
}
}
/// <summary>
/// sauvegarde les données du fichier en base, compare avec la BDD et créé un rapport
/// </summary>
public void WorkerMethod()
{
string result = new CompareFile(WorkSheets).CompareTwoSheet(columnsFile1, columnsFile2);
OnWorkerComplete(result);
}
