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);
}
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);
}
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);
}
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();
}
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 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_BuildDefinitions(XlHlp.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Description");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "QueueStatus");
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_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_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_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_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_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_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);
}
private XlHlp.XlLocation DisplayListOf_Libraries(XlHlp.XlLocation insertAt, IEnumerable <List> libraries, 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 library in libraries)
{
insertAt.ClearOffsets();
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), library.Title);
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), library.Id.ToString());
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), library.SchemaXml);
insertAt.IncrementRows();
}
XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, insertAt, "End");
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);
}
internal static void Add_TP_WorkItemFieldValues2(XlHlp.XlLocation insertAt)
{
long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME);
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "WI Id");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "WI Type");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 10, "Field 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_BuildControllers(XlHlp.XlLocation insertAt,
Options_AZDO_TFS options,
IBuildServer buildServer,
TeamProject teamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
var buildControllers = buildServer.QueryBuildControllers();
foreach (IBuildController buildController in buildControllers)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildController.Name));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildController.Description));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildController.Enabled));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildController.Agents.Count));
insertAt.IncrementRows();
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
}
internal static void Add_BuildProcessTemplates(XlHlp.XlLocation insertAt,
Options_AZDO_TFS options,
IBuildServer buildServer,
TeamProject teamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
var processTemplates = buildServer.QueryProcessTemplates(teamProject.Name);
foreach (IProcessTemplate processTemplate in processTemplates)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", processTemplate.Id));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", processTemplate.Description));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", processTemplate.TemplateType));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", processTemplate.Version));
insertAt.IncrementRows();
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
}
internal static void Add_Builds(XlHlp.XlLocation insertAt,
Options_AZDO_TFS options,
IBuildServer buildServer,
TeamProject teamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
var builds = buildServer.QueryBuilds(teamProject.Name);
foreach (IBuildDetail buildDetail in builds)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDetail.BuildController.Name));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDetail.LabelName));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDetail.StartTime));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDetail.FinishTime));
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), string.Format("{0}", buildDetail.BuildFinished));
insertAt.IncrementRows();
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
}
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_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_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_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_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);
}
private XlHlp.XlLocation DisplayListOf_SiteColumns(XlHlp.XlLocation insertAt, IEnumerable <Field> siteColumns, bool displayDataOnly, string tableSuffix)
{
XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, 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.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "Title");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "StaticName");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 40, "Description");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 30, "Group");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "Id");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 15, "TypeAsString");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "SchemaXml");
insertAt.IncrementRows();
}
foreach (var field in siteColumns)
{
insertAt.ClearOffsets();
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), field.Title);
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), field.Group);
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), field.Id.ToString());
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), field.TypeAsString.ToString());
XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), field.SchemaXml);
insertAt.IncrementRows();
}
XlHlp.DisplayInWatchWindow(System.Reflection.MethodInfo.GetCurrentMethod().Name, insertAt, "End");
return(insertAt);
}
internal static void Add_TP_Changesets(
XlHlp.XlLocation insertAt,
Options_AZDO_TFS options,
VersionControlServer versionControlServer,
TeamProject teamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
//TeamProject teamProject = VNC.TFS.Helper.Get_TeamProject(versionControlServer, teamProjectName);
var path = teamProject.ServerItem;
//var queryHistory = Server.VersionControlServer.QueryHistory(
// teamProject.ServerItem,
// VersionSpec.Latest,
// 0,
// RecursionType.Full,
// null,
// VersionSpec.Latest,
// VersionSpec.Latest,
// Int32.MaxValue,
// true,
// true,
// false,
// false);
var queryHistory = versionControlServer.QueryHistory(
teamProject.ServerItem,
VersionSpec.Latest,
0,
RecursionType.Full,
null,
null,
null,
Int32.MaxValue,
true,
true,
false,
false);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), teamProject.Name);
try
{
Changeset lastestChangeset = queryHistory.Cast <Changeset>().First();
string lastChangesetId = lastestChangeset.ChangesetId.ToString();
string lastChangeSetCreationDate = lastestChangeset.CreationDate.ToString();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), lastChangesetId);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), lastChangeSetCreationDate);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), teamProject.VersionControlServer.SupportedFeatures.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), teamProject.VersionControlServer.WebServiceLevel.ToString());
}
catch (InvalidOperationException ioe)
{
if (ioe.Message.Equals("Sequence contains no elements"))
{
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "No Changesets");
}
else
{
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), ioe.ToString());
}
}
catch (Exception ex)
{
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), ex.ToString());
}
insertAt.IncrementRows();
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
}
internal static void Add_TP_Changesets(
XlHlp.XlLocation insertAt,
Options_AZDO_TFS options,
ICommonStructureService commonStructureService,
bool listChanges, bool listWorkItems, IEnumerable history)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
foreach (Changeset changeset in history)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.ChangesetId.ToString());
//XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), changeset.CheckinNote.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.Committer);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.CommitterDisplayName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.Owner);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.OwnerDisplayName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.CreationDate.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.CheckinNote.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.Comment);
//XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), changeset.AssociatedWorkItems.Count().ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.Changes.Count().ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.WorkItems.Count().ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), changeset.AssociatedWorkItems.Count().ToString());
insertAt.IncrementRows();
if (listChanges)
{
insertAt.IncrementColumns();
foreach (Change change in changeset.Changes)
{
try
{
XlHlp.AddContentToCell(insertAt.AddRowX(1), Section_VersionControlServer.GetChangeInfo(change));
//XlHlp.AddContentToCell(insertAt.AddRow(), GetIterationInfo(workItem));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
insertAt.DecrementColumns();
}
if (listWorkItems)
{
insertAt.IncrementColumns();
foreach (WorkItem workItem in changeset.WorkItems)
{
try
{
XlHlp.AddContentToCell(insertAt.AddRowX(1), Section_VersionControlServer.GetWorkItemInfo(workItem));
XlHlp.AddContentToCell(insertAt.AddRowX(1), Section_VersionControlServer.GetIterationInfo(workItem, commonStructureService));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
insertAt.DecrementColumns();
}
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
}
