private static void CreateLogWorkSheetHeader(XlHlp.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 8, "ID");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TimeStamp");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Category");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "Priority");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "Severity");
// TODO(crhodes)
// Add a UI Config for supporting EventID
//XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "EventID");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "ProcessName");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 12, "ProcessID");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 14, "ThreadName");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 12, "ThreadID");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "UserName");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 50, "ClassName.MethodName");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Duration");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 100, "Message");
}
internal static XlHlp.XlLocation DisplayListOf_TeamProjects(XlHlp.XlLocation insertAt,
ReadOnlyCollection <CatalogNode> projectNodes, bool displayDataOnly, string tableSuffix)
{
long startTicks = XlHlp.DisplayInWatchWindow(insertAt);
if (!displayDataOnly)
{
insertAt.MarkStart(XlHlp.MarkType.GroupTable);
//XlHlp.AddTitledInfo(insertAt.AddRow(), "Name", teamProjects.Count.ToString());
//XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), Name, 12, XlHlp.MakeBold.Yes);
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 25, "DisplayName");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 35, "Description");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 35, "Identifier");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 35, "ProjectId");
//XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 25, "ProjectName", 12);
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 25, "ProjectState");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 62, "ProjectUri");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "Tfvc Enabled");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 25, "SCC");
//XlHlp.AddTitledInfo(insertAt.AddRow(2), "TP Name", teamProject.Name);
//XlHlp.AddTitledInfo(insertAt.AddRow(2), "AbsoluteUri", teamProject.ArtifactUri.AbsoluteUri);
//XlHlp.AddTitledInfo(insertAt.AddRow(2), "ServerItem", teamProject.ServerItem);
//XlHlp.AddTitledInfo(insertAt.AddRow(2), "VCS ServerQuid", teamProject.VersionControlServer.ServerGuid.ToString());
insertAt.IncrementRows();
}
// The columns in this method need to be kept in sync with CreateTeamProjectsInfo()
foreach (CatalogNode projectNode in projectNodes.OrderBy(tp => tp.Resource.DisplayName))
{
insertAt.ClearOffsets();
try
{
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.DisplayName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Description);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Identifier.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectId"]);
//XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectName"]);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectState"]);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectUri"]);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["SourceControlTfvcEnabled"]);
string sccType = "??";
if (projectNode.Resource.Properties.Keys.Contains("SourceControlCapabilityFlags"))
{
switch (int.Parse(projectNode.Resource.Properties["SourceControlCapabilityFlags"]))
{
case 0:
sccType = "NONE";
break;
case 1:
sccType = "TFS";
break;
case 2:
sccType = "GIT";
break;
case 3:
sccType = "TFS/GIT";
break;
default:
break;
}
}
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), sccType);
}
catch (Exception ex)
{
}
//projectNode.FullPath
// projectNode.Resource.Description
// projectNode.Resource.Identifier
insertAt.IncrementRows();
}
if (!displayDataOnly)
{
insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblTP_{0}", tableSuffix));
insertAt.Group(insertAt.OrientVertical, hide: true);
}
XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End");
return(insertAt);
}
