private VNC.AddinHelper.Excel.XlLocation DisplayListOf_Lists(VNC.AddinHelper.Excel.XlLocation insertAt, IEnumerable <List> lists, bool displayDataOnly, string tableSuffix)
{
long startTicks = XlHlp.DisplayInWatchWindow(insertAt);
Worksheet ws = insertAt.workSheet;
if (!displayDataOnly)
{
insertAt.MarkStart(XlHlp.MarkType.GroupTable);
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Title");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml");
insertAt.IncrementRows();
}
foreach (var list in lists)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), list.Title);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), list.Id.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), list.SchemaXml);
insertAt.IncrementRows();
}
XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End");
return(insertAt);
}
private XlHlp.XlLocation DisplayListOf_ContentTypes(XlHlp.XlLocation insertAt, ContentTypeCollection contentTypes, bool displayDataOnly, string tableSuffix)
{
long startTicks = XlHlp.DisplayInWatchWindow(insertAt);
Worksheet ws = insertAt.workSheet;
if (!displayDataOnly)
{
insertAt.MarkStart(XlHlp.MarkType.GroupTable);
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Name");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 30, "Group");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml");
insertAt.IncrementRows();
}
foreach (var cType in contentTypes)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Name);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Group);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Id.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.SchemaXml);
insertAt.IncrementRows();
}
XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End");
return(insertAt);
}
internal static void Add_TP_WorkItemTypes(XlHlp.XlLocation insertAt)
{
long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME);
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Count");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "FieldCount");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastCreateDate");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastChangedDate");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastRevisedDate");
// TODO(crhodes)
// Since we now can pass in a CellFormatSpecification, might be able to go back to just using insertAt.AddOffsetColumn
insertAt.AddOffsetColumnX();
CellFormatSpecification lucidia7 = insertAt.CreateCellFormat("lucidia7", fontSize: 7);
lucidia7.Font.Name = "Lucida Sans Typewriter";
XlHlp.AddColumnHeaderToSheetX(insertAt.workSheet, insertAt.RowCurrent, insertAt.ColumnOffset,
180, "Transitions", lucidia7);
insertAt.IncrementRows();
Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks);
}
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");
}
private XlHlp.XlLocation DisplayListOf_SiteColumns(XlHlp.XlLocation insertAt, IEnumerable <Field> siteColumns, bool displayDataOnly, string tableSuffix)
{
long startTicks = XlHlp.DisplayInWatchWindow(insertAt);
Worksheet ws = insertAt.workSheet;
//<Field
//ID="{56747800-D36E-4625-ABE3-B1BC74A7D5F8}"
//Name="LowerValuesAreBetter"
//StaticName="LowerValuesAreBetter"
//Description="Whether lower is better or higher is better"
//Group="Status Indicators" Type="Boolean"
//DisplayName="Lower values are better"
//SourceID="http://schemas.microsoft.com/sharepoint/v3" />
//<Field
//Type="Lookup"
//DisplayName="FA Page Type"
//Required="FALSE"
//EnforceUniqueValues="FALSE"
//List="{b1d6a5ff-876b-4761-a05d-210038e31639}"
//WebId="666b287f-2709-476b-a739-e1de9150fb37"
//ShowField="Title"
//UnlimitedLengthInDocumentLibrary="FALSE"
//Group="Custom Columns"
//ID="{3090abc3-526c-458f-9c65-302ad853db65}"
//SourceID="{666b287f-2709-476b-a739-e1de9150fb37}"
//StaticName="FA_x0020_Page_x0020_Type"
//Name="FA_x0020_Page_x0020_Type" />
if (!displayDataOnly)
{
insertAt.MarkStart(XlHlp.MarkType.GroupTable);
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Title");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Name");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "StaticName");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Description");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 30, "Group");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "TypeAsString");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml");
insertAt.IncrementRows();
}
foreach (var field in siteColumns)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Title);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Group);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Id.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.TypeAsString.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.SchemaXml);
insertAt.IncrementRows();
}
XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End");
return(insertAt);
}
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);
}
