private VNC.AddinHelper.Excel.XlLocation DisplayListOf_Lists(VNC.AddinHelper.Excel.XlLocation insertAt, IEnumerable <List> lists, bool displayDataOnly, string tableSuffix) { XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, insertAt); Worksheet ws = insertAt.workSheet; if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "Title"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var list in lists) { insertAt.ClearOffsets(); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), list.Title); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), list.Id.ToString()); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), list.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, insertAt, "End"); return(insertAt); }
private XlHlp.XlLocation DisplayListOf_Libraries(XlHlp.XlLocation insertAt, IEnumerable <List> libraries, 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 library in libraries) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), library.Title); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), library.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), library.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
private XlHlp.XlLocation DisplayListOf_ContentTypes(XlHlp.XlLocation insertAt, ContentTypeCollection contentTypes, bool displayDataOnly, string tableSuffix) { XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, insertAt); Worksheet ws = insertAt.workSheet; if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Group"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var cType in contentTypes) { insertAt.ClearOffsets(); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), cType.Name); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), cType.Group); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), cType.Id.ToString()); XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), cType.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, insertAt, "End"); return(insertAt); }
internal static void Add_TP_Developers( XlHlp.XlLocation insertAt, Options_AZDO_TFS options, string teamProjectName, SortedDictionary <string, int> developers, SortedDictionary <string, DateTime> developersLatestDate, SortedDictionary <string, DateTime> developersEarliestDate) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); foreach (string developer in developers.Keys) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), teamProjectName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), developer); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), developers[developer].ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), developersEarliestDate[developer].ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), developersLatestDate[developer].ToString()); insertAt.IncrementRows(); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }
internal static void Add_TP_Shelvesets( XlHlp.XlLocation insertAt, Options_AZDO_TFS options, Shelveset[] shelvesets) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); try { foreach (Shelveset item in shelvesets) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), item.OwnerDisplayName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), item.OwnerName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), item.Name); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), item.CreationDate.ToString()); //ExcelHlp.AddContentToCell(insertAt.AddOffsetColumn(), item.DisplayName); //ExcelHlp.AddContentToCell(insertAt.AddOffsetColumn(), item.QualifiedName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), item.CheckinNote.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), item.Comment); insertAt.IncrementRows(); } } catch (Exception ex) { string msg = string.Format("{0} - {1}", "TP", ex.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), msg); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }
internal static void Add_TP_Workspaces( XlHlp.XlLocation insertAt, Options_AZDO_TFS options, Workspace[] workSpaces) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); foreach (Workspace workspace in workSpaces) { insertAt.ClearOffsets(); // Keep in same order with headers, supra. XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), workspace.Computer); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), workspace.Name); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), workspace.OwnerDisplayName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), workspace.OwnerName); //ExcelHlp.AddContentToCell(rngOutput.Offset[currentRow, col++], workspace.DisambiguatedDisplayName); //ExcelHlp.AddContentToCell(rngOutput.Offset[currentRow, col++], workspace.DisplayName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), workspace.LastAccessDate.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), workspace.Comment); //ExcelHlp.AddContentToCell(rngOutput.Offset[XlLocation.Rows, col++], workspace.QualifiedName); insertAt.IncrementRows(); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }
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); }
internal static void Add_TP_WorkItemFields(XlHlp.XlLocation insertAt) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "WIT Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "FieldType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "SystemType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 6, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "IsComputed"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "IsCoreField"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "IsEditable"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "IsIdentity"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "IsIndexed"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "IsQueryable"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "ReferenceName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "ReportingAttributes.Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "ReportingAttributes.ReferenceName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Usage"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "FieldNameType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 60, "AllowedValues"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 60, "ProhibitedValues"); insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
internal static void Add_BuildAgents(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Description"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "QueueStatus"); insertAt.IncrementRows(); }
internal static void Add_BuildServiceHosts(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Status"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "StatusChangedOn"); insertAt.IncrementRows(); }
private void CreateWS_Web_Info(ClientContext ctx, string sectionsToDisplay, bool orientVertical) { XlHlp.DisplayInWatchWindow(string.Format("{0}", System.Reflection.MethodInfo.GetCurrentMethod().Name)); var web = ctx.Web; ctx.Load(web); ctx.ExecuteQuery(); string sheetName = XlHlp.SafeSheetName(string.Format("{0}{1}", "SPWeb>", web.Title)); Worksheet ws = XlHlp.NewWorksheet(sheetName, beforeSheetName: "FIRST"); XlHlp.XlLocation insertAt = new XlHlp.XlLocation(ws, row: 2, column: 1, orientVertical: GetDisplayOrientation()); if (insertAt.OrientVertical) { XlHlp.AddContentToCell(insertAt.AddRowX(), "Web Info"); insertAt.IncrementRows(); } else { XlHlp.AddContentToCell(insertAt.AddRowX(), "Web Info"); insertAt.DecrementRows(); // AddRow bumped it. insertAt.IncrementColumns(); } if (sectionsToDisplay.Contains("WebInfo")) { insertAt = AddSection_WebInfo(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Libraries")) { insertAt = AddSection_Libraries(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Lists")) { insertAt = AddSection_Lists(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("SiteGroups")) { insertAt = AddSection_SiteGroups(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("SiteColumns")) { insertAt = AddSection_SiteColumns(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("ContentTypes")) { insertAt = AddSection_ContentTypes(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } }
internal static void Add_BuildControllers(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Description"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "Enabled"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "AgentsCount"); insertAt.IncrementRows(); }
internal static void Add_BuildProcessTemplates(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Description"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TemplateType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Version"); insertAt.IncrementRows(); }
internal static void CreateWS_All_TPC_LastChangeset(Options_AZDO_TFS options, VersionControlServer versionControlServer) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); try { XlHlp.XlLocation insertAt = CreateNewWorksheet(string.Format("{0}_{1}", "All_TPC", "LastChangeset"), options); XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "Last Changeset All TeamProjects", AzureDevOpsExplorer.Presentation.Views.Server.TfsTeamProjectCollection.Name); insertAt.MarkStart(XlHlp.MarkType.GroupTable); Header_VersionControlServer.Add_Changesets(insertAt); //Body_VersionControlServer.Add_Changesets(insertAt, options, versionControlServer); foreach (var teamProjectName in options.TeamProjects) { insertAt.ClearOffsets(); long loopTicks = Log.Trace($"Processing {teamProjectName}", Common.PROJECT_NAME); TeamProject teamProject = VNCTFS.Helper.Get_TeamProject(versionControlServer, teamProjectName.Trim()); if (teamProject != null) { Globals.ThisAddIn.Application.StatusBar = $"Processing {teamProject.Name}"; Body_VersionControlServer.Add_TP_Changesets(insertAt, options, Presentation.Views.Server.VersionControlServer, teamProject); AZDOHelper.ProcessLoopDelay(options); } else { XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), teamProjectName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "No VCS Project"); insertAt.IncrementRows(); } Log.Trace($"EndProcessing {teamProjectName}", Common.PROJECT_NAME, loopTicks); } insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tbl_{0}", insertAt.workSheet.Name)); insertAt.Group(insertAt.OrientVertical, hide: true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }
internal static void Add_Changesets(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Changeset ID"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Creation Date"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Supported Features"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "WebService Level"); insertAt.IncrementRows(); }
internal static void Add_Builds(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildController"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LabelName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "StartTime"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "FinishTime"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Finished"); insertAt.IncrementRows(); }
internal static void Add_TP_Developers(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TFS Team Project"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Developer"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Changeset Count"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Earliest Date"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Latest Date"); insertAt.IncrementRows(); }
internal static void Add_TP_Workspaces(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Computer"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerDisplayName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastAccessDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Comment"); insertAt.IncrementRows(); }
internal static void Add_TP_WorkItemDetails(XlHlp.XlLocation insertAt, Options_AZDO_TFS options) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Project"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Type"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Title"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "CreatedBy"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "CreatedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ChangedBy"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ChangedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AuthorizedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "RevisedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Rev"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Reason"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Tags"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AreaPath"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IterationPath"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "RelatedLinkCount"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ExternalLinkCount"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "HyperLinkCount"); // NOTE(crhodes) // The Query can specify additional fields to display // They are added to the query to avoid a round trip if accessed // after the result set is returned. // Add Headers for any requested if ((options.WorkItemQuerySpec.Fields?.Count ?? 0) > 0) { foreach (string field in options.WorkItemQuerySpec.Fields) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, field); } } insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
internal static void Add_TP_WorkItem_Links(XlHlp.XlLocation insertAt) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "ArtifactLinkType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "BaseType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "Comment"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "IsLocked"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "IsNew"); insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
internal static void Add_Shelvesets(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerDisplayName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "CreationDate"); //ExcelHlp.AddColumnHeaderToheet(insertAt.AddOffsetCoumn(), 20, "DisplayName"); //ExcelHlp.AddColumnHeaderToheet(insertAt.AddOffsetCoumn(), 20, "QualifiedName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "CheckinNote"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Comment"); insertAt.IncrementRows(); }
internal static void Add_TP_Iterations(XlHlp.XlLocation insertAt) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Iteration"); // TODO(crhodes) // This can have a variable number of columns. Not sure how to label them. insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
internal static void Add_BuildDefinitions(XlHlp.XlLocation insertAt, Options_AZDO_TFS options, IBuildServer buildServer, TeamProject teamProject) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); try { var buildDefinitions = buildServer.QueryBuildDefinitions(teamProject.Name); foreach (IBuildDefinition buildDef in buildDefinitions) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", teamProject.Name)); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDef.Name)); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDef.Description)); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDef.QueueStatus)); insertAt.IncrementRows(); } } catch (Exception ex) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", teamProject.Name)); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", "<N/A>")); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", "<N/A>")); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", "<N/A>")); insertAt.IncrementRows(); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }
internal static void Add_TP_WorkItem_WorkItemLinks(XlHlp.XlLocation insertAt) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Source.Type"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "Source.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Source.State"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Source.Title"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Target.Type"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "Target.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Target.State"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Target.Title"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Target.Created"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Target.CreatedBy"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Link Source.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Link Target.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AddedBy"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "AddedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 18, "ArtifactLinkType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 12, "BaseType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "ChangedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Comment"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "IsLocked"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "IsNew"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "LinkTypeEnd.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkTypeEnd.ImmutableName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkTypeEnd.IsForwardLink"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 60, "LinkTypeEnd.LinkType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkTypeEnd.Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "LinkTypeEnd.OppositeEnd.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkTypeEnd.OppostieEnd.ImmutableName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkTypeEnd.OppostieEnd.IsForwardLink"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 60, "LinkTypeEnd.OppostieEnd.LinkType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkTypeEnd.OppositeEnd.Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "RemovedBy"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "RemovedDate"); insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
internal static void Add_TP_WorkItemFieldValues(XlHlp.XlLocation insertAt) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 45, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 45, "ReferenceName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "OriginalValue"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Value"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "FieldType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "SystemType"); insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
internal static void Add_TP_Teams(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TeamProject"); // Team XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Description"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 5, "DefaultTeam"); // Members XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DisplayName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "UniqueName"); insertAt.IncrementRows(); }
internal static void Add_TP_Changesets(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ChangesetId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Committer"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Committer DisplayName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Owner"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Owner DisplayName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "CreationDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 50, "CheckinNote"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Comment"); //ExcelHlp.AddColumnHeaderToheet(insertAt.AddOffsetCoumn(),ciatedWorkItems"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Changes"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "WorkItems"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Associated WorkItems"); insertAt.IncrementRows(); }
internal static void Add_TP_Teams( XlHlp.XlLocation insertAt, Options_AZDO_TFS options, VersionControlServer versionControlServer, TeamProject teamProject, IEnumerable <TeamFoundationTeam> allTeams, TeamFoundationTeam defaultTeam) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); foreach (var team in allTeams.OrderBy(team => team.Name)) { insertAt.ClearOffsets(); TeamFoundationIdentity[] teamMembers = team.GetMembers(versionControlServer.TeamProjectCollection, MembershipQuery.Expanded); foreach (var member in teamMembers.OrderBy(m => m.UniqueName)) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), teamProject.Name); // Team XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), team.Name); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), team.Description); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), defaultTeam.Name.Equals(team.Name) ? "*" : ""); // Members XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), member.DisplayName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), member.UniqueName); insertAt.IncrementRows(); } } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }
internal static XlHlp.XlLocation AddSections( XlHlp.XlLocation insertAt, TeamProject teamProject, List <string> sectionsToDisplay) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); if (sectionsToDisplay.Count != 0) { if (insertAt.OrientVertical) { //XlHlp.AddContentToCell(insertAt.AddRowX(), "TeamProject (TP) Information"); XlHlp.AddSectionInfo(insertAt.AddRow(), "TeamProject (TP) Information", ""); insertAt.IncrementRows(); } else { //XlHlp.AddContentToCell(insertAt.AddRowX(), "TeamProject (TP) Information"); XlHlp.AddSectionInfo(insertAt.AddRow(), "TeamProject(TP) Information", "", orientation: XlOrientation.xlUpward); insertAt.DecrementRows(); // AddRow bumped it. insertAt.IncrementColumns(); } if (sectionsToDisplay.Contains("Info")) { insertAt = Add_Info(insertAt, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Members")) { insertAt = Add_Members(insertAt, teamProject).IncrementPosition(insertAt.OrientVertical); } } Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); return(insertAt); }
internal static void Add_BuildServiceHosts(XlHlp.XlLocation insertAt, Options_AZDO_TFS options, IBuildServer buildServer, TeamProject teamProject) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); var buildServiceHosts = buildServer.QueryBuildServiceHosts("*"); foreach (IBuildServiceHost buildServiceHost in buildServiceHosts) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildServiceHost.Name)); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildServiceHost.Status)); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildServiceHost.StatusChangedOn)); insertAt.IncrementRows(); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); }