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 int Add_TestResolutionStates(
Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int itemCount = 0;
IEnumerable <ITestResolutionState> testResolutionStates = testManagementTeamProject.TestResolutionStates.Query();
int totalItems = testResolutionStates.Count();
XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testResolutionStates");
foreach (ITestResolutionState testResolutionState in testManagementTeamProject.TestResolutionStates.Query())
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResolutionState.Id}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResolutionState.Name}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResolutionState.Project.TeamProjectName}");
insertAt.IncrementRows();
itemCount++;
//ProcessItemDelay(options);
AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount);
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(itemCount);
}
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 static IEnumerable<List> Get_Lists(ClientContext ctx, Web web)
//{
// var alllists = web.Lists;
// IEnumerable<List> lists = ctx.LoadQuery(alllists.Where
// (list => list.BaseType == BaseType.GenericList)
// );
// ctx.ExecuteQuery();
// return lists;
//}
private XlHlp.XlLocation AddSection_Lists(XlHlp.XlLocation insertAt, ClientContext ctx, Web web)
{
long startTicks = XlHlp.DisplayInWatchWindow(insertAt);
if (insertAt.OrientVertical)
{
XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "Lists", web.Title);
}
else
{
XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "Lists", web.Title, orientation: XlOrientation.xlUpward);
insertAt.IncrementColumns();
}
IEnumerable <List> lists = VNCSP.Helper.GetLists(ctx, web);
insertAt.MarkStart(XlHlp.MarkType.GroupTable);
insertAt = DisplayListOf_Lists(insertAt, lists, false, "OneLevel");
insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblLists_{0}", web.Title));
insertAt.Group(insertAt.OrientVertical, hide: true);
insertAt.EndSectionAndSetNextLocation(insertAt.OrientVertical);
XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End");
return(insertAt);
}
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_TestSuite_TestSuite(Excel.XlLocation insertAt)
{
XlHlp.AddLabeledInfo(insertAt.AddRow(), "Test Suite Entry", "Test Suites");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ID");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Title");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AllTestCases");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DefaultConfigurations");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Description");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Error");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "InvalidProperties");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsDirty");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsRoot");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdatedByName");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Parent.Id");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Plan.Id");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Plan.Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestCaseCount");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestSuiteType");
insertAt.IncrementRows();
}
internal static void Add_TestSuite_TestCase(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ID");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Title");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Actions");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Area");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Attachments");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateCreated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateModified");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Error");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Exists");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Implementation");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsAutomated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsDirty");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Links");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerName");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Priority");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TeamProjectName");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Reason");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "WorkItemId");
insertAt.IncrementRows();
}
internal static int Add_Queries(
Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int itemCount = 0;
int totalItems = testManagementTeamProject.Queries.Count;
XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } Queries");
foreach (ITestCaseQuery query in testManagementTeamProject.Queries)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), query.Name);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), query.Owner);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), query.QueryText);
insertAt.IncrementRows();
itemCount++;
AZDOHelper.ProcessItemDelay(options);
AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount);
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(itemCount);
}
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 XlHlp.XlLocation AddSection_SiteGroups(XlHlp.XlLocation insertAt, ClientContext ctx, Web web)
{
long startTicks = XlHlp.DisplayInWatchWindow(insertAt);
//XlHlp.AddTitledInfo(ws.Cells[startingRow++, 1], "Groups", "SiteName");
//Range rng = ws.Cells[startingRow, 1];
//int rowsAdded = 0;
//var siteGroups = web.SiteGroups;
////IEnumerable<List> groups = ctx.LoadQuery(siteGroups.Where(true));
//ctx.Load(siteGroups);
//ctx.ExecuteQuery();
//foreach (var group in siteGroups)
//{
// int col = 0;
// //XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], group.LoginName); // Seems same as Title
// XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], group.Title);
// XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], group.Id.ToString());
// //XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], group.Owner.LoginName);
// XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], group.PrincipalType.ToString());
// rowsAdded++;
// UserCollection users = ctx.Web.SiteGroups.GetById(group.Id).Users;
// ctx.Load(users);
// ctx.ExecuteQuery();
// foreach (var user in users)
// {
// col = 4;
// //XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], user.LoginName);
// XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], user.Title);
// XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], user.Id.ToString());
// //XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], user.UserId.ToString());
// XlHlp.AddContentToCell(rng.Offset[rowsAdded, col++], user.PrincipalType.ToString());
// rowsAdded++;
// }
// rowsAdded++;
//}
//insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblSiteGroups_{0}", web.Title));
//insertAt.Group(insertAt.OrientVertical, hide: true);
//insertAt.EndSectionAndSetNextLocation(insertAt.OrientVertical);
XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End");
return(insertAt);
}
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 int Add_TestVariables(
Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int itemCount = 0;
string query = String.Format(
"SELECT *"
+ " FROM TestVariable");
IEnumerable <ITestVariable> testVariables = testManagementTeamProject.TestVariables.Query();
int totalItems = testVariables.Count();
XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testVariables");
foreach (ITestVariable testVariable in testVariables)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testVariable.Id}");
StringBuilder allowedValues = new StringBuilder();
foreach (var item in testVariable.AllowedValues)
{
if (allowedValues.Length == 0)
{
allowedValues.Append($"{item.Value}");
}
else
{
allowedValues.Append($"; {item.Value}");
}
}
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{allowedValues}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testVariable.Description}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testVariable.Name}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testVariable.Revision}");
insertAt.IncrementRows();
itemCount++;
AZDOHelper.ProcessItemDelay(options);
AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount);
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(itemCount);
}
internal static void Add_TestFailureTypes(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TeamProject");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ID");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Project.TeamProjectName");
insertAt.IncrementRows();
}
internal static void Add_Queries(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestTeamProject");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Owner");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "QueryText");
insertAt.IncrementRows();
}
internal static int Add_TestSuites(
Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int itemCount = 0;
//string query = String.Format(
// "SELECT [System.Id], [System.Title]"
// + " FROM WorkItems"
// + " WHERE [System.WorkItemType] = 'Test Suite'"
// + " AND [Team Project] = '{0}'", testManagementTeamProject.TeamProjectName);
string query = String.Format(
"SELECT *"
+ " FROM TestSuite"
);
ITestSuiteCollection testSuites = testManagementTeamProject.TestSuites.Query(query);
int totalItems = testSuites.Count;
XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testSuites");
foreach (var testSuite in testSuites)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Id}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Title}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Description}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.State}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.LastUpdated}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.LastUpdatedByName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.TestCaseCount}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.TestSuiteType}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.AllTestCases.Count}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Revision}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Plan.Id}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Plan.Name}");
insertAt.IncrementRows();
itemCount++;
AZDOHelper.ProcessItemDelay(options);
AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount);
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(itemCount);
}
internal static int Add_TestResults(
Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int itemCount = 0;
string query = String.Format(
"SELECT *"
+ " FROM TestResult"
+ " WHERE [DateCreated] > '1/1/2021'");
ITestCaseResultCollection testCaseResults = testManagementTeamProject.TestResults.Query(query);
int totalItems = testCaseResults.Count;
int[] associatedWIs = testCaseResults.QueryAssociatedWorkItems();
XlHlp.DisplayInWatchWindow($"Processing ({ totalItems }) testCaseResults");
foreach (ITestResult testResult in testCaseResults)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName);
// IAttachmentOwner
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Attachments.Count}");
// ITestResult
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.CollectorsEnabled.Count}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Comment}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.DateCreated}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.DateStarted}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.DateCompleted}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Duration}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.ErrorMessage}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Outcome}");
insertAt.IncrementRows();
itemCount++;
AZDOHelper.ProcessItemDelay(options);
AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount);
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(itemCount);
}
internal static int Add_TestEnvironments(
Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int itemCount = 0;
string query = String.Format(
"SELECT *"
+ " FROM TestEnvironment");
var testEnvironments = testManagementTeamProject.TestEnvironments.Query();
var totalItems = testEnvironments.Count();
XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testEnvironments");
foreach (ITestEnvironment testEnvironment in testEnvironments)
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testEnvironment.Id.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Name}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.ControllerDisplayName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.ControllerEnvironmentId}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.ControllerName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.DateCreated}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Description}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.DisplayName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.EnvironmentType}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Error}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.InvalidProperties.Count()}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.IsDirty}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.LabEnvironmentUri}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.LabServerUri}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.MachineRoles.Count}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Owner}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.TeamProject.TeamProjectName}");
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.TestController.Name}");
insertAt.IncrementRows();
itemCount++;
//ProcessItemDelay(options);
AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount);
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(itemCount);
}
internal static void Add_TestVariables(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TeamProject");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "ID");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "AllowedValues");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Description");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Name");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Revision");
insertAt.IncrementRows();
}
internal static void Add_TestSuite_Entry(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "ID");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Title");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Configurations");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "EntryType");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "PointAssignments");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestCase");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestObject");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestSuite");
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_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_TestSettings(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TeamProject");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Id");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "IsAutomated");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdated");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdatedBy");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "MachineRoles.Count");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Name");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Revision");
XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Settings");
insertAt.IncrementRows();
}
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 int Add_TestCases(Excel.XlLocation insertAt,
Options_AZDO_TFS options,
ITestManagementTeamProject testManagementTeamProject)
{
Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY);
int count = 0;
string query = String.Format(
"SELECT [System.Id], [System.Title]"
+ " FROM WorkItems"
+ " WHERE [System.WorkItemType] = 'Test Case'"
+ " AND [Team Project] = '{0}'", testManagementTeamProject.TeamProjectName);
//string query = String.Format(
// "SELECT *"
// + " FROM TestCase");
// NOTE(\)
// Seems like all fields get populated.
//int countQueries = testManagementTeamProject.Queries.Count;
foreach (var testCase in testManagementTeamProject.TestCases.Query(query))
{
insertAt.ClearOffsets();
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.Id.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.Title);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.Description);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.DateCreated.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.DateModified.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.Revision.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.State);
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.Links.Count.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.TestSuiteEntry.Id.ToString());
XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testCase.TestSuiteEntry.Title);
insertAt.IncrementRows();
count++;
}
Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks);
return(count);
}
internal static void Add_TestConfigurations(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestTeamProject");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ID");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AreaPath");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Description");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsDefault");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdatedBy");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Values");
insertAt.IncrementRows();
}
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_TestCases(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestTeamProject");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ID");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Title");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Description");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateCreated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateModified");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Links");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestSuiteID");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestSuiteName");
insertAt.IncrementRows();
}
internal static void Add_TestResults(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestTeamProject");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Attachments");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "CollectorsEnabled");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Comment");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateCreated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateStarted");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateCompleted");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Duration");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ErrorMessage");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Outcome");
insertAt.IncrementRows();
}
internal static void Add_TestRuns(Excel.XlLocation insertAt)
{
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestTeamProject");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Title");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Attachments");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildConfigurationId");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildDirectory");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildFlavor");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildNumber");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildPlatform");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "BuildUri");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsBvt");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Iteration");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdated");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdatedBy");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LinkedWorkItemCount");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "NotApplicableTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerName");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "PassedTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "PostProcessState");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TeamProjectName");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.CompletedTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.FailedTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.InconclusiveTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.InProgressTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.PassedTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.PendingTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Statistics.TotalTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestEnvironmentId");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestMessageLogEntries");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestPlanId");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestSettings.Name");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestSettings.Id");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestSettingsId");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TotalTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Type");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "UnanalyzedTests");
XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Version");
insertAt.IncrementRows();
}
