private static void VerifyReportRows(ErrorWriter writer, InstanceReport baseReport, InstanceReport genReport)
{
if (baseReport.Rows.Count != genReport.Rows.Count)
{
int differences = Math.Abs(baseReport.Rows.Count - genReport.Rows.Count);
List <string> baseRows = baseReport.Rows.ConvertAll(row => WHITE_SPACE.Replace(row.Label, " "));
List <string> genRows = genReport.Rows.ConvertAll(row => WHITE_SPACE.Replace(row.Label, " "));
if (baseRows.Count < genRows.Count)
{
writer.StartError("The new rendering generated too MANY rows.");
foreach (string commonLabel in baseRows)
{
if (genRows.Contains(commonLabel))
{
genRows.Remove(commonLabel);
}
}
if (genRows.Count == differences)
{
foreach (string newLabel in genRows)
{
writer.WriteError("\tAdded: " + newLabel);
}
}
else
{
writer.WriteError("\tSEVERAL LABELS CHANGED");
}
writer.EndError();
}
else
{
writer.StartError("The new rendering generated too FEW rows.");
foreach (string commonLabel in genRows)
{
if (baseRows.Contains(commonLabel))
{
baseRows.Remove(commonLabel);
}
}
if (baseRows.Count == differences)
{
foreach (string newLabel in baseRows)
{
writer.WriteError("\tRemoved: " + newLabel);
}
}
else
{
writer.WriteError("\tSEVERAL LABELS CHANGED");
}
writer.EndError();
}
}
for (int bIdx = 0; bIdx < baseReport.Rows.Count; bIdx++)
{
InstanceReportRow baseRow = baseReport.Rows[bIdx];
string baseLabel = WHITE_SPACE.Replace(baseRow.Label, " ");
int gIdx = -1;
InstanceReportRow genRow = null;
if (genReport.Rows.Count > bIdx)
{
if (WHITE_SPACE.Replace(genReport.Rows[bIdx].Label, " ") == baseLabel)
{
gIdx = bIdx;
genRow = genReport.Rows[bIdx];
}
}
if (genRow == null)
{
if (bIdx >= genReport.Rows.Count)
{
writer.WriteError(
"Generated report has too few rows to match Base row:",
"\tRow " + bIdx + ": " + baseLabel,
"\t***Row Skipped***"
);
continue;
}
gIdx = bIdx == 0 ?
genReport.Rows.FindIndex(bIdx, row => WHITE_SPACE.Replace(row.Label, " ") == baseLabel) :
genReport.Rows.FindIndex(bIdx - 1, row => WHITE_SPACE.Replace(row.Label, " ") == baseLabel);
if (gIdx == -1)
{
writer.WriteError(
"Base row not found in generated report:",
"\tRow " + bIdx + ": " + baseLabel,
"\t***Row Skipped***"
);
continue;
}
genRow = genReport.Rows[gIdx];
if (bIdx != gIdx)
{
writer.WriteError(
"Row moved: " + baseLabel,
"\tExpected: " + bIdx.ToString(),
"\tGenerated: " + gIdx.ToString()
);
}
}
if (!string.Equals(baseRow.FootnoteIndexer, genRow.FootnoteIndexer))
{
writer.WriteError(
"Row footnotes changed: " + baseLabel,
"\tExpected: " + baseRow.FootnoteIndexer,
"\tGenerated: " + genRow.FootnoteIndexer
);
}
decimal baseSum = 0M;
baseRow.Cells.FindAll(c => c.IsNumeric).ForEach(c => baseSum += c.NumericAmount);
decimal genSum = 0M;
genRow.Cells.FindAll(c => c.IsNumeric).ForEach(c => genSum += c.NumericAmount);
bool checkNumericCells = false;
decimal difference = baseSum - genSum;
if (difference != 0)
{
checkNumericCells = true;
if (difference > 0)
{
writer.WriteError(
"Row sum is SMALLER than expected:",
"\tRow " + bIdx + ": " + baseLabel,
"\tExpected: " + baseSum,
"\tGenerated: " + genSum
);
}
else
{
writer.WriteError(
"Row sum is LARGER than expected:",
"\tRow " + bIdx + ": " + baseLabel,
"\tExpected: " + baseSum,
"\tGenerated: " + genSum
);
}
}
foreach (Cell baseCell in baseRow.Cells)
{
if (!checkNumericCells && baseCell.IsNumeric)
{
continue;
}
Cell genCell = null;
int cIdx = baseRow.Cells.IndexOf(baseCell);
if (genRow.Cells.Count > cIdx)
{
genCell = genRow.Cells[cIdx];
}
if (genCell == null)
{
writer.WriteError("Base cell not found in Generated report.");
continue;
}
if (genCell.IsNumeric)
{
if (!checkNumericCells)
{
continue;
}
}
else
{
genCell.NonNumbericText = WHITE_SPACE.Replace(genCell.NonNumbericText, " ");
}
if (!baseCell.IsNumeric)
{
baseCell.NonNumbericText = WHITE_SPACE.Replace(baseCell.NonNumbericText, " ");
}
if (!baseCell.ValueEquals(genCell))
{
//if( baseCell.IsNumeric )
//{
// genCell = genRow.Cells.Find( c => c.NumericAmount == baseCell.NumericAmount || c.RoundedNumericAmount == baseCell.RoundedNumericAmount );
// if( genCell != null )
//}
baseCell.FlagID = 1;
genCell.FlagID = 1;
writer.WriteError("Cell value does not match:",
"\tRow " + bIdx + ", Cell " + cIdx,
"\tExpected: " + baseCell.ToString() + "[" + baseCell.FootnoteIndexer + "]",
"\tGenerated: " + genCell.ToString() + "[" + genCell.FootnoteIndexer + "]");
}
else if (!string.Equals(baseCell.FootnoteIndexer, genCell.FootnoteIndexer))
{
writer.WriteError("Cell footnotes changed:",
"\tRow " + bIdx + ", Cell " + cIdx,
"\tExpected: " + baseCell.FootnoteIndexer,
"\tGenerated: " + genCell.FootnoteIndexer);
}
}
List <Cell> baseEmbedCells = baseRow.Cells.FindAll(c => c.HasEmbeddedReport && c.EmbeddedReport != null && c.EmbeddedReport.InstanceReport != null);
List <Cell> genEmbedCells = genRow.Cells.FindAll(c => c.HasEmbeddedReport && c.EmbeddedReport != null && c.EmbeddedReport.InstanceReport != null);
if (baseEmbedCells.Count != genEmbedCells.Count)
{
difference = Math.Abs(baseEmbedCells.Count - genEmbedCells.Count);
if (baseEmbedCells.Count > genEmbedCells.Count)
{
writer.WriteError("Row has MISSING embedded reports:",
"\tExpected: " + baseEmbedCells.Count,
"\tGenerated: " + genEmbedCells.Count);
}
else
{
writer.WriteError("Row has EXTRA embedded reports:",
"\tExpected: " + baseEmbedCells.Count,
"\tGenerated: " + genEmbedCells.Count);
}
}
for (int c = 0; c < baseEmbedCells.Count; c++)
{
Cell embedCell = baseEmbedCells[c];
InstanceReport baseEmbed = embedCell.EmbeddedReport.InstanceReport;
int genCellIndex = c == 0 ?
genEmbedCells.FindIndex(cell => baseEmbed.ReportLongName == cell.EmbeddedReport.InstanceReport.ReportLongName) :
genEmbedCells.FindIndex(c - 1, cell => baseEmbed.ReportLongName == cell.EmbeddedReport.InstanceReport.ReportLongName);
if (genCellIndex == -1)
{
writer.WriteError("Embedded report not found in generated report:",
"\tRow " + bIdx + ", Cell " + c + ": " + baseEmbed.ReportName,
"\tEMBED Skipped");
continue;
}
Cell genEmbedCell = genEmbedCells[genCellIndex];
InstanceReport genEmbed = genEmbedCell.EmbeddedReport.InstanceReport;
try
{
writer.StartReport(baseEmbed.ReportLongName + ".xml", baseEmbed, genEmbed, null);
writer.WriteLine("*************** EMBED Comparison Started ***************");
VerifyReports(writer, baseEmbed, genEmbed);
writer.WriteLine("*************** EMBED Comparison Ended ***************");
}
finally
{
writer.EndReport(baseEmbed.ReportLongName + ".xml");
}
}
}
}
private static void VerifyReportRows( ErrorWriter writer, InstanceReport baseReport, InstanceReport genReport )
{
if( baseReport.Rows.Count != genReport.Rows.Count )
{
int differences = Math.Abs( baseReport.Rows.Count - genReport.Rows.Count );
List<string> baseRows = baseReport.Rows.ConvertAll( row => WHITE_SPACE.Replace( row.Label, " " ) );
List<string> genRows = genReport.Rows.ConvertAll( row => WHITE_SPACE.Replace( row.Label, " " ) );
if( baseRows.Count < genRows.Count )
{
writer.StartError( "The new rendering generated too MANY rows." );
foreach( string commonLabel in baseRows )
{
if( genRows.Contains( commonLabel ) )
genRows.Remove( commonLabel );
}
if( genRows.Count == differences )
{
foreach( string newLabel in genRows )
{
writer.WriteError( "\tAdded: " + newLabel );
}
}
else
{
writer.WriteError( "\tSEVERAL LABELS CHANGED" );
}
writer.EndError();
}
else
{
writer.StartError( "The new rendering generated too FEW rows." );
foreach( string commonLabel in genRows )
{
if( baseRows.Contains( commonLabel ) )
baseRows.Remove( commonLabel );
}
if( baseRows.Count == differences )
{
foreach( string newLabel in baseRows )
{
writer.WriteError( "\tRemoved: " + newLabel );
}
}
else
{
writer.WriteError( "\tSEVERAL LABELS CHANGED" );
}
writer.EndError();
}
}
for( int bIdx = 0; bIdx < baseReport.Rows.Count; bIdx++ )
{
InstanceReportRow baseRow = baseReport.Rows[ bIdx ];
string baseLabel = WHITE_SPACE.Replace( baseRow.Label, " " );
int gIdx = -1;
InstanceReportRow genRow = null;
if( genReport.Rows.Count > bIdx )
{
if( WHITE_SPACE.Replace( genReport.Rows[ bIdx ].Label, " " ) == baseLabel )
{
gIdx = bIdx;
genRow = genReport.Rows[ bIdx ];
}
}
if( genRow == null )
{
if( bIdx >= genReport.Rows.Count )
{
writer.WriteError(
"Generated report has too few rows to match Base row:",
"\tRow " + bIdx + ": " + baseLabel,
"\t***Row Skipped***"
);
continue;
}
gIdx = bIdx == 0 ?
genReport.Rows.FindIndex( bIdx, row => WHITE_SPACE.Replace( row.Label, " " ) == baseLabel ) :
genReport.Rows.FindIndex( bIdx - 1, row => WHITE_SPACE.Replace( row.Label, " " ) == baseLabel );
if( gIdx == -1 )
{
writer.WriteError(
"Base row not found in generated report:",
"\tRow " + bIdx + ": " + baseLabel,
"\t***Row Skipped***"
);
continue;
}
genRow = genReport.Rows[ gIdx ];
if( bIdx != gIdx )
{
writer.WriteError(
"Row moved: " + baseLabel,
"\tExpected: " + bIdx.ToString(),
"\tGenerated: " + gIdx.ToString()
);
}
}
if( !string.Equals( baseRow.FootnoteIndexer, genRow.FootnoteIndexer ) )
{
writer.WriteError(
"Row footnotes changed: " + baseLabel,
"\tExpected: " + baseRow.FootnoteIndexer,
"\tGenerated: " + genRow.FootnoteIndexer
);
}
decimal baseSum = 0M;
baseRow.Cells.FindAll( c => c.IsNumeric ).ForEach( c => baseSum += c.NumericAmount );
decimal genSum = 0M;
genRow.Cells.FindAll( c => c.IsNumeric ).ForEach( c => genSum += c.NumericAmount );
bool checkNumericCells = false;
decimal difference = baseSum - genSum;
if( difference != 0 )
{
checkNumericCells = true;
if( difference > 0 )
{
writer.WriteError(
"Row sum is SMALLER than expected:",
"\tRow " + bIdx + ": " + baseLabel,
"\tExpected: " + baseSum,
"\tGenerated: " + genSum
);
}
else
{
writer.WriteError(
"Row sum is LARGER than expected:",
"\tRow " + bIdx + ": " + baseLabel,
"\tExpected: " + baseSum,
"\tGenerated: " + genSum
);
}
}
foreach( Cell baseCell in baseRow.Cells )
{
if( !checkNumericCells && baseCell.IsNumeric )
continue;
Cell genCell = null;
int cIdx = baseRow.Cells.IndexOf( baseCell );
if( genRow.Cells.Count > cIdx )
genCell = genRow.Cells[ cIdx ];
if( genCell == null )
{
writer.WriteError( "Base cell not found in Generated report." );
continue;
}
if( genCell.IsNumeric )
{
if( !checkNumericCells )
continue;
}
else
{
genCell.NonNumbericText = WHITE_SPACE.Replace( genCell.NonNumbericText, " " );
}
if( !baseCell.IsNumeric )
{
baseCell.NonNumbericText = WHITE_SPACE.Replace( baseCell.NonNumbericText, " " );
}
if( !baseCell.ValueEquals( genCell ) )
{
//if( baseCell.IsNumeric )
//{
// genCell = genRow.Cells.Find( c => c.NumericAmount == baseCell.NumericAmount || c.RoundedNumericAmount == baseCell.RoundedNumericAmount );
// if( genCell != null )
//}
baseCell.FlagID = 1;
genCell.FlagID = 1;
writer.WriteError( "Cell value does not match:",
"\tRow " + bIdx + ", Cell " + cIdx,
"\tExpected: " + baseCell.ToString() + "[" + baseCell.FootnoteIndexer + "]",
"\tGenerated: " + genCell.ToString() + "[" + genCell.FootnoteIndexer + "]" );
}
else if( !string.Equals( baseCell.FootnoteIndexer, genCell.FootnoteIndexer ) )
{
writer.WriteError( "Cell footnotes changed:",
"\tRow " + bIdx + ", Cell " + cIdx,
"\tExpected: " + baseCell.FootnoteIndexer,
"\tGenerated: " + genCell.FootnoteIndexer );
}
}
List<Cell> baseEmbedCells = baseRow.Cells.FindAll( c => c.HasEmbeddedReport && c.EmbeddedReport != null && c.EmbeddedReport.InstanceReport != null );
List<Cell> genEmbedCells = genRow.Cells.FindAll( c => c.HasEmbeddedReport && c.EmbeddedReport != null && c.EmbeddedReport.InstanceReport != null );
if( baseEmbedCells.Count != genEmbedCells.Count )
{
difference = Math.Abs( baseEmbedCells.Count - genEmbedCells.Count );
if( baseEmbedCells.Count > genEmbedCells.Count )
{
writer.WriteError( "Row has MISSING embedded reports:",
"\tExpected: " + baseEmbedCells.Count,
"\tGenerated: " + genEmbedCells.Count );
}
else
{
writer.WriteError( "Row has EXTRA embedded reports:",
"\tExpected: " + baseEmbedCells.Count,
"\tGenerated: " + genEmbedCells.Count );
}
}
for( int c = 0; c < baseEmbedCells.Count; c++ )
{
Cell embedCell = baseEmbedCells[ c ];
InstanceReport baseEmbed = embedCell.EmbeddedReport.InstanceReport;
int genCellIndex = c == 0 ?
genEmbedCells.FindIndex( cell => baseEmbed.ReportLongName == cell.EmbeddedReport.InstanceReport.ReportLongName ) :
genEmbedCells.FindIndex( c - 1, cell => baseEmbed.ReportLongName == cell.EmbeddedReport.InstanceReport.ReportLongName );
if( genCellIndex == -1 )
{
writer.WriteError( "Embedded report not found in generated report:",
"\tRow " + bIdx + ", Cell " + c + ": " + baseEmbed.ReportName,
"\tEMBED Skipped" );
continue;
}
Cell genEmbedCell = genEmbedCells[ genCellIndex ];
InstanceReport genEmbed = genEmbedCell.EmbeddedReport.InstanceReport;
try
{
writer.StartReport( baseEmbed.ReportLongName + ".xml", baseEmbed, genEmbed, null );
writer.WriteLine( "*************** EMBED Comparison Started ***************" );
VerifyReports( writer, baseEmbed, genEmbed );
writer.WriteLine( "*************** EMBED Comparison Ended ***************" );
}
finally
{
writer.EndReport( baseEmbed.ReportLongName + ".xml" );
}
}
}
}
private static void VerifyIndividualReports(ErrorWriter writer, string baselineResultFolder, string generatedResultFolder, string failedResultsFolder)
{
string[] baseFiles = new string[0];
if (Directory.Exists(baselineResultFolder))
{
baseFiles = Directory.GetFiles(baselineResultFolder, "R*.xml");
Array.Sort(baseFiles, natcasecmp);
}
string[] genFiles = new string[0];
if (Directory.Exists(generatedResultFolder))
{
genFiles = Directory.GetFiles(generatedResultFolder, "R*.xml");
Array.Sort(genFiles, natcasecmp);
}
if (baseFiles.Length < genFiles.Length)
{
writer.StartError("The new rendering generated too MANY files:");
for (int i = 0; i < genFiles.Length; i++)
{
string gFile = Path.GetFileName(genFiles[i]);
bool found = Array.Exists(baseFiles, bFile => bFile.EndsWith(gFile));
if (!found)
{
writer.WriteError("\tAdded: " + gFile);
}
}
writer.EndError();
}
else if (baseFiles.Length > genFiles.Length)
{
writer.StartError("The new rendering generated too FEW files.");
for (int i = 0; i < baseFiles.Length; i++)
{
string bFile = Path.GetFileName(baseFiles[i]);
bool found = Array.Exists(genFiles, gFile => gFile.EndsWith(bFile));
if (!found)
{
writer.WriteError("\tAdded: " + bFile);
}
}
writer.EndError();
}
Dictionary <string, int> allFiles = new Dictionary <string, int>();
foreach (string bFile in baseFiles)
{
allFiles[Path.GetFileName(bFile)] = 1;
}
foreach (string gFile in genFiles)
{
allFiles[Path.GetFileName(gFile)] = 1;
}
Dictionary <string, InstanceReport> tryVerifyEmbedded = new Dictionary <string, InstanceReport>();
foreach (string file in allFiles.Keys)
{
if (!R_FILE_REGEX.IsMatch(file))
{
continue;
}
InstanceReport baseReport = null;
InstanceReport genReport = null;
try
{
string baseReportPath = Path.Combine(baselineResultFolder, file);
if (File.Exists(baseReportPath))
{
baseReport = InstanceReport.LoadXml(baseReportPath);
}
string genReportPath = Path.Combine(generatedResultFolder, file);
if (File.Exists(genReportPath))
{
genReport = InstanceReport.LoadXml(genReportPath);
}
if (baseReport == null)
{
throw new Exception("Base report is missing.");
}
if (genReport == null)
{
throw new Exception("Generated report is missing.");
}
writer.StartReport(file, baseReport, genReport, failedResultsFolder);
writer.WriteLine(PathCombine(baselineResultFolder, file));
writer.WriteLine(PathCombine(generatedResultFolder, file));
VerifyReports(writer, baseReport, genReport);
}
catch (Exception ex)
{
writer.StartReport(file, baseReport, genReport, failedResultsFolder);
writer.WriteError(ex.Message);
}
finally
{
writer.EndReport(file);
}
}
}
private static void VerifyIndividualReports( ErrorWriter writer, string baselineResultFolder, string generatedResultFolder, string failedResultsFolder )
{
string[] baseFiles = new string[0];
if( Directory.Exists( baselineResultFolder ) )
{
baseFiles = Directory.GetFiles( baselineResultFolder, "R*.xml" );
Array.Sort( baseFiles, natcasecmp );
}
string[] genFiles = new string[ 0 ];
if( Directory.Exists( generatedResultFolder ) )
{
genFiles = Directory.GetFiles( generatedResultFolder, "R*.xml" );
Array.Sort( genFiles, natcasecmp );
}
if( baseFiles.Length < genFiles.Length )
{
writer.StartError( "The new rendering generated too MANY files:" );
for( int i = 0; i < genFiles.Length; i++ )
{
string gFile = Path.GetFileName( genFiles[ i ] );
bool found = Array.Exists( baseFiles, bFile => bFile.EndsWith( gFile ) );
if( !found )
writer.WriteError( "\tAdded: " + gFile );
}
writer.EndError();
}
else if( baseFiles.Length > genFiles.Length )
{
writer.StartError( "The new rendering generated too FEW files." );
for( int i = 0; i < baseFiles.Length; i++ )
{
string bFile = Path.GetFileName( baseFiles[ i ] );
bool found = Array.Exists( genFiles, gFile => gFile.EndsWith( bFile ) );
if( !found )
writer.WriteError( "\tAdded: " + bFile );
}
writer.EndError();
}
Dictionary<string, int> allFiles = new Dictionary<string, int>();
foreach( string bFile in baseFiles )
allFiles[ Path.GetFileName( bFile ) ] = 1;
foreach( string gFile in genFiles )
allFiles[ Path.GetFileName( gFile ) ] = 1;
Dictionary<string, InstanceReport> tryVerifyEmbedded = new Dictionary<string, InstanceReport>();
foreach( string file in allFiles.Keys )
{
if( !R_FILE_REGEX.IsMatch( file ) )
continue;
InstanceReport baseReport = null;
InstanceReport genReport = null;
try
{
string baseReportPath = Path.Combine( baselineResultFolder, file );
if( File.Exists( baseReportPath ) )
baseReport = InstanceReport.LoadXml( baseReportPath );
string genReportPath = Path.Combine( generatedResultFolder, file );
if( File.Exists( genReportPath ) )
genReport = InstanceReport.LoadXml( genReportPath );
if( baseReport == null )
throw new Exception( "Base report is missing." );
if( genReport == null )
throw new Exception( "Generated report is missing." );
writer.StartReport( file, baseReport, genReport, failedResultsFolder );
writer.WriteLine( PathCombine( baselineResultFolder, file ) );
writer.WriteLine( PathCombine( generatedResultFolder, file ) );
VerifyReports( writer, baseReport, genReport );
}
catch( Exception ex )
{
writer.StartReport( file, baseReport, genReport, failedResultsFolder );
writer.WriteError( ex.Message );
}
finally
{
writer.EndReport( file );
}
}
}
