private static void GenerateUnreferencedAssembliesPage(Worksheet missingAssembliesPage, ReportingResult analysisResult)
{
List <string> missingAssembliesPageHeader = new List <string>()
{
LocalizedStrings.AssemblyHeader, LocalizedStrings.UsedBy, LocalizedStrings.MissingAssemblyStatus
};
int detailsRows = 0;
missingAssembliesPage.AddRow(missingAssembliesPageHeader.ToArray());
detailsRows++;
var unresolvedAssembliesMap = analysisResult.GetUnresolvedAssemblies();
foreach (var unresolvedAssemblyPair in unresolvedAssembliesMap.OrderBy(asm => asm.Key))
{
if (unresolvedAssemblyPair.Value.Any())
{
foreach (var usedIn in unresolvedAssemblyPair.Value)
{
missingAssembliesPage.AddRow(unresolvedAssemblyPair.Key, usedIn, LocalizedStrings.UnresolvedUsedAssembly);
detailsRows++;
}
}
else
{
missingAssembliesPage.AddRow(unresolvedAssemblyPair.Key, String.Empty, LocalizedStrings.UnresolvedUsedAssembly);
}
}
// Generate the pretty table
missingAssembliesPage.AddTable(1, detailsRows, 1, missingAssembliesPageHeader.ToArray());
missingAssembliesPage.AddColumnWidth(40, 40, 30);
}
private void GenerateSummaryPage(Worksheet summaryPage, ReportingResult analysisResult)
{
var targetNames = _mapper.GetTargetNames(analysisResult.Targets, alwaysIncludeVersion: true);
// This is the submission id
summaryPage.AddRow(LocalizedStrings.SubmissionId, AddSubmissionLink(analysisResult.SubmissionId));
// This is the description of the app
summaryPage.AddRow(LocalizedStrings.Description, _description);
// This is the target list that was submitted to the service.
summaryPage.AddRow(LocalizedStrings.Targets, string.Join(",", targetNames));
// Add an empty row.
summaryPage.AddRow();
if (analysisResult.GetAssemblyUsageInfo().Any())
{
var assemblyInfoHeader = new List <string> {
LocalizedStrings.AssemblyHeader, "Target Framework"
};
assemblyInfoHeader.AddRange(targetNames);
int tableRowCount = 0;
summaryPage.AddRow(assemblyInfoHeader.ToArray());
tableRowCount++;
foreach (var item in analysisResult.GetAssemblyUsageInfo().OrderBy(a => a.SourceAssembly.AssemblyIdentity))
{
var summaryData = new List <object>()
{
analysisResult.GetNameForAssemblyInfo(item.SourceAssembly), item.SourceAssembly.TargetFrameworkMoniker ?? string.Empty
};
// TODO: figure out how to add formatting to cells to show percentages.
summaryData.AddRange(item.UsageData.Select(pui => (object)Math.Round(pui.PortabilityIndex * 100.0, 2)));
summaryPage.AddRow(summaryData.ToArray());
tableRowCount++;
}
summaryPage.AddConditionalFormatting(6, analysisResult.GetAssemblyUsageInfo().Count(), 3, analysisResult.Targets.Count);
summaryPage.AddTable(5, tableRowCount, 1, assemblyInfoHeader.ToArray());
var columnWidths = new List <double>
{
ColumnWidths.SummaryPage.AssemblyName,
ColumnWidths.SummaryPage.TFM
};
columnWidths.AddRange(Enumerable.Repeat(ColumnWidths.Targets, analysisResult.Targets.Count)); // Targets
summaryPage.AddColumnWidth(columnWidths);
}
summaryPage.AddRow();
summaryPage.AddRow(LocalizedStrings.CatalogLastUpdated, _catalogLastUpdated.ToString("D", CultureInfo.CurrentCulture));
summaryPage.AddRow(LocalizedStrings.HowToReadTheExcelTable);
}
private void GenerateBreakingChangesPage(Worksheet worksheet, IEnumerable <BreakingChangeDependency> breakingChanges)
{
var row = 1;
var header = new[]
{
"Break ID",
"API",
"Assembly",
"Title",
"Scope",
"Quirked",
"Requires Retargeting",
"Build Time",
"VersionBroken",
"Version Fixed",
"Details",
"Suggestion",
"Analyzer Status",
"Link",
"Investigated"
};
worksheet.AddRow(header);
foreach (var breakingChange in breakingChanges)
{
var rowContent = new object[]
{
breakingChange.Break.Id,
breakingChange.Member.MemberDocId,
breakingChange.DependantAssembly.ToString(),
breakingChange.Break.Title,
breakingChange.Break.ImpactScope.ToString(),
breakingChange.Break.IsQuirked.ToString((IFormatProvider)CultureInfo.CurrentUICulture),
breakingChange.Break.IsRetargeting.ToString((IFormatProvider)CultureInfo.CurrentUICulture),
breakingChange.Break.IsBuildTime.ToString((IFormatProvider)CultureInfo.CurrentUICulture),
breakingChange.Break.VersionBroken.ToString(),
breakingChange.Break.VersionFixed?.ToString() ?? string.Empty,
breakingChange.Break.Details,
breakingChange.Break.Suggestion,
breakingChange.Break.SourceAnalyzerStatus.ToString(),
string.IsNullOrWhiteSpace(breakingChange.Break.Link) ? "No link" : CreateHyperlink("Link", breakingChange.Break.Link),
string.Empty
};
worksheet.AddRow(rowContent);
row++;
}
worksheet.AddTable(1, row, 1, header);
worksheet.AddColumnWidth(10, 10, 30, 30, 20, 10, 10, 10, 10, 30, 30, 10, 10, 10);
}
private void GenerateNuGetInfoPage(Worksheet page, ReportingResult analysisResult)
{
bool showAssemblyName = analysisResult.NuGetPackages.Any(p => !string.IsNullOrEmpty(p.AssemblyInfo));
var headerList = new List <string>()
{
LocalizedStrings.PackageIdHeader
};
headerList.AddRange(_mapper.GetTargetNames(analysisResult.Targets));
if (showAssemblyName)
{
headerList.Add(LocalizedStrings.AssemblyHeader);
}
var header = headerList.ToArray();
page.AddRow(header);
int rowCount = 1;
foreach (var nugetInfo in analysisResult.NuGetPackages)
{
var rowContent = new List <string>()
{
nugetInfo.PackageId
};
foreach (var target in analysisResult.Targets)
{
var supported = nugetInfo.SupportedVersions.TryGetValue(target, out var version) ? version : LocalizedStrings.NotSupported;
rowContent.Add(supported);
}
if (showAssemblyName && nugetInfo.AssemblyInfo != null)
{
rowContent.Add(nugetInfo.AssemblyInfo);
}
page.AddRow(rowContent.ToArray());
rowCount++;
}
page.AddTable(1, rowCount, 1, header.ToArray());
page.AddColumnWidth(70, 40, 30, 30);
}
private static void GenerateOrderPage(Worksheet page, AnalyzeResponse response)
{
page.AddRow(new[] { LocalizedStrings.RecommendedOrderDetails });
page.AddRow();
var header = new[] { LocalizedStrings.AssemblyHeader };
page.AddRow(header);
int detailsRows = 1;
foreach (var assembly in response.RecommendedOrder)
{
page.AddRow(assembly);
detailsRows++;
}
// Generate the pretty table
page.AddTable(3, detailsRows, 1, header.ToArray());
page.AddColumnWidth(100);
}
private static void GenerateUnreferencedAssembliesPage(Worksheet missingAssembliesPage, AnalyzeResponse response)
{
var missingAssembliesPageHeader = new[] { LocalizedStrings.AssemblyHeader, LocalizedStrings.UsedBy, LocalizedStrings.UnresolvedAssemblyStatus };
int detailsRows = 0;
missingAssembliesPage.AddRow(missingAssembliesPageHeader.ToArray());
detailsRows++;
var unresolvedAssembliesMap = response.ReportingResult.GetUnresolvedAssemblies();
foreach (var unresolvedAssemblyPair in unresolvedAssembliesMap.OrderBy(asm => asm.Key))
{
if (unresolvedAssemblyPair.Value.Any())
{
foreach (var usedIn in unresolvedAssemblyPair.Value)
{
missingAssembliesPage.AddRow(unresolvedAssemblyPair.Key, usedIn, LocalizedStrings.UnresolvedUsedAssembly);
detailsRows++;
}
}
else
{
missingAssembliesPage.AddRow(unresolvedAssemblyPair.Key, string.Empty, LocalizedStrings.UnresolvedUsedAssembly);
detailsRows++;
}
}
if (response.Request.NonUserAssemblies != null)
{
foreach (var unresolvedAssemblyPair in response.Request.NonUserAssemblies.OrderBy(asm => asm.AssemblyIdentity))
{
missingAssembliesPage.AddRow(unresolvedAssemblyPair.AssemblyIdentity, string.Empty, LocalizedStrings.SkippedAssembly);
detailsRows++;
}
}
// Generate the pretty table
missingAssembliesPage.AddTable(1, detailsRows, 1, missingAssembliesPageHeader);
missingAssembliesPage.AddColumnWidth(40, 40, 30);
}
private void GenerateExceptionsPage(Worksheet worksheet, IList <ExceptionInfo> throwingMembers, IList <FrameworkName> targets)
{
var exceptionsPageHeader = new List <string>()
{
LocalizedStrings.AssemblyHeader, LocalizedStrings.TargetMemberHeader, LocalizedStrings.ExceptionColumnHeader
};
exceptionsPageHeader.AddRange(_mapper.GetTargetNames(targets, alwaysIncludeVersion: true));
int exceptionRows = 0;
worksheet.AddRow(exceptionsPageHeader.ToArray());
exceptionRows++;
foreach (var member in throwingMembers.OrderBy(info => info.MemberDocId))
{
var exceptionsByType = member.ExceptionsThrown.GroupBy(exc => exc.Exception, (exception, exceptionList) => new { Key = exception, exceptions = exceptionList });
foreach (var grouping in exceptionsByType)
{
var rowContent = new List <object> {
member.DefinedInAssemblyIdentity, member.MemberDocId, grouping.Key
};
var groupsByTarget = grouping.exceptions.GroupBy(exc => new FrameworkName(exc.Platform, Version.Parse(exc.Version)), (framework, exceptionList) => new { Key = framework, exceptionsByPlatform = exceptionList });
foreach (var target in targets)
{
bool hasExceptions = false;
foreach (var exceptionsByTarget in groupsByTarget)
{
if (exceptionsByTarget.Key.Equals(target))
{
hasExceptions = true;
string resourceIDHolder = string.Empty;
foreach (var exception in exceptionsByTarget.exceptionsByPlatform.OrderBy(exc => exc.RID))
{
resourceIDHolder = string.Concat(resourceIDHolder, exception.RID + ";");
}
if (resourceIDHolder.Length > 0)
{
rowContent.Add(resourceIDHolder);
}
else
{
rowContent.Add(LocalizedStrings.NoExceptionNoted);
}
}
}
if (!hasExceptions)
{
rowContent.Add(LocalizedStrings.NoExceptionNoted);
}
}
worksheet.AddRow(rowContent.ToArray());
exceptionRows++;
}
}
worksheet.AddTable(1, exceptionRows, 1, exceptionsPageHeader.ToArray());
// Generate the columns
var columnWidths = new List <double>
{
ColumnWidths.DetailsPage.AssemblyName, // Assembly name
ColumnWidths.DetailsPage.TargetMember, // Target member
ColumnWidths.DetailsPage.TargetMember // Exception Width
};
columnWidths.AddRange(Enumerable.Repeat(ColumnWidths.Targets, targets.Count)); // Targets
worksheet.AddColumnWidth(columnWidths);
}
private void GenerateDetailsPage(Worksheet detailsPage, ReportingResult analysisResult)
{
var showAssemblyColumn = analysisResult.GetAssemblyUsageInfo().Any();
var detailsPageHeader = new List <string>()
{
LocalizedStrings.TargetTypeHeader, LocalizedStrings.TargetMemberHeader
};
if (showAssemblyColumn)
{
detailsPageHeader.Add(LocalizedStrings.AssemblyHeader);
}
detailsPageHeader.AddRange(_mapper.GetTargetNames(analysisResult.Targets, alwaysIncludeVersion: true));
detailsPageHeader.Add(LocalizedStrings.RecommendedChanges);
int detailsRows = 0;
detailsPage.AddRow(detailsPageHeader.ToArray());
detailsRows++;
// Dump out all the types that were identified as missing from the target
foreach (var item in analysisResult.GetMissingTypes().OrderByDescending(n => n.IsMissing))
{
if (item.IsMissing)
{
if (!showAssemblyColumn)
{
// for a missing type we are going to dump the type name for both the target type and target member columns
var rowContent = new List <object> {
AddLink(item.TypeName), AddLink(item.TypeName)
};
rowContent.AddRange(item.TargetStatus);
rowContent.Add(item.RecommendedChanges);
detailsPage.AddRow(rowContent.ToArray());
detailsRows++;
}
else
{
foreach (var assemblies in item.UsedIn)
{
string assemblyName = analysisResult.GetNameForAssemblyInfo(assemblies);
// for a missing type we are going to dump the type name for both the target type and target member columns
var rowContent = new List <object> {
AddLink(item.TypeName), AddLink(item.TypeName), assemblyName
};
rowContent.AddRange(item.TargetStatus);
rowContent.Add(item.RecommendedChanges);
detailsPage.AddRow(rowContent.ToArray());
detailsRows++;
}
}
}
foreach (var member in item.MissingMembers.OrderBy(type => type.MemberName))
{
if (showAssemblyColumn)
{
foreach (var assem in member.UsedIn.OrderBy(asm => asm.AssemblyIdentity))
{
string assemblyName = analysisResult.GetNameForAssemblyInfo(assem);
var rowContent = new List <object> {
AddLink(item.TypeName), AddLink(member.MemberName), assemblyName
};
rowContent.AddRange(member.TargetStatus);
rowContent.Add(member.RecommendedChanges);
detailsPage.AddRow(rowContent.ToArray());
detailsRows++;
}
}
else
{
var rowContent = new List <object> {
AddLink(item.TypeName), AddLink(member.MemberName)
};
rowContent.AddRange(member.TargetStatus);
rowContent.Add(member.RecommendedChanges);
detailsPage.AddRow(rowContent.ToArray());
detailsRows++;
}
}
}
// Generate the pretty tables
detailsPage.AddTable(1, detailsRows, 1, detailsPageHeader.ToArray());
// Generate the columns
var columnWidths = new List <double>
{
ColumnWidths.DetailsPage.TargetType, // Target type
ColumnWidths.DetailsPage.TargetMember, // Target member
ColumnWidths.DetailsPage.AssemblyName // Assembly name
};
columnWidths.AddRange(Enumerable.Repeat(ColumnWidths.Targets, analysisResult.Targets.Count)); // Targets
columnWidths.Add(ColumnWidths.DetailsPage.RecommendedChanges); // Recommended changes
detailsPage.AddColumnWidth(columnWidths);
}
