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 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); }
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_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_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_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 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 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 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 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_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_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 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_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_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_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(); }
internal static int Add_TestConfigurations(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 TestConfiguration"); ITestConfigurationCollection testConfigurations = testManagementTeamProject.TestConfigurations.Query(query); int totalItems = testConfigurations.Count; XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testConfigurations"); foreach (ITestConfiguration testConfiguration in testConfigurations) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.Id}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.Name}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.AreaPath}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.Description}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.IsDefault}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.LastUpdated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.LastUpdatedByName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.Revision}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.State}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testConfiguration.Values.Count}"); insertAt.IncrementRows(); itemCount++; //ProcessItemDelay(options); AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }
internal static int Add_TestSettings( 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 TestSettings"); IEnumerable <ITestSettings> testSettings = testManagementTeamProject.TestSettings.Query(query); int totalItems = testSettings.Count(); XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testRuns"); foreach (ITestSettings testSetting in testSettings) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.Id}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.IsAutomated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.LastUpdated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.LastUpdatedBy}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.MachineRoles.Count}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.Name}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.Revision}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSetting.Settings}"); 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_TestSuites(Excel.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TeamProject"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "ID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Title"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Description"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "State"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdated"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdatedBy"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestCaseCount"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestSuiteType"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestCasesCount"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Revision"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "PlanID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "PlanName"); insertAt.IncrementRows(); }
internal static int Add_TestPoints( 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 TestPoint"); XlHlp.AddLabeledInfo(insertAt.AddRow(), "Not Implemented", "Yet"); //// TODO(crhodes) //// Learn what TestPoints are. testManagementTeamProject.TestPoints returns a helper with methods //ITestPointHelper testPoints = testManagementTeamProject.TestPoints; //testPoints. //foreach (ITestPoint testPoint in testManagementTeamProject.TestPoints) //{ // insertAt.ClearOffsets(); // XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}"); // XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), $"{testFailureType.Id}"); // XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), $"{testFailureType.Name}"); // XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), $"{testFailureType.Project.TeamProjectName}"); // insertAt.IncrementRows(); // itemCount++; // ProcessLoopDelay(options); // DisplayLoopUpdates(options, totalItems, itemCount); //} Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }
internal static void Add_TestPlans(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, "Description"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AreaPath"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Iteration"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "StartDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "EndDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "OwnerName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdated"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdatedByName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Links"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "RootSuiteId"); insertAt.IncrementRows(); }
internal static void Add_TestPoints(Excel.XlLocation insertAt) { // TODO(crhodes) // Commented out rows show up in watch window XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "AssignedToName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Comment"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ConfigurationId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ConfigurationName"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "FailureType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "HasCachedProperties"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "History.Count"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "InvalidProperties"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsDirty"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsSaved"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsTestCaseAutomated"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdated"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastUpdatedBy"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentFailureType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentFailureTypeId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentResolutionStateId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentResult"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentResultId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentResultOutcome"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentResultState"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MostRecentRunId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Plan.Id"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Revision"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "State"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "SuiteId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestCaseExists"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestCaseId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestCaseWorkItem.Id"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TotalInvalidProperties"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "UserData"); insertAt.IncrementRows(); }
internal static void Add_TestEnvironments(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, "ControllerDisplayName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ControllerEnvironmentId"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "ControllerName"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "DateCreate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Description"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "EnvironmentType"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Error"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "InvalidProperties"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "IsDirty"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LabEnvironmentUri"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LabServerUri"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "MachineRoles"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Owner"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TeamProject.Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "TestController.Name"); insertAt.IncrementRows(); }
internal static int Add_TestPlans( 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]" // + " FROM TestPlan" // + " WHERE [Team Project] = '{0}'", testManagementTeamProject.TeamProjectName); string query = String.Format( "SELECT *" + " FROM TestPlan"); ITestPlanCollection testPlans = testManagementTeamProject.TestPlans.Query(query); int totalItems = testPlans.Count; XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testPlans"); foreach (var testPlan in testPlans) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}"); try { XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.Id}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.Name}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.Description}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.State}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.AreaPath}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.Iteration}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.StartDate}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.EndDate}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.OwnerName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.LastUpdated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.LastUpdatedByName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.Revision}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.Links.Count}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testPlan.RootSuite.Id}"); } catch (Exception ex) { XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{ex}"); } 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_TestRuns( 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 TestRun"); //+ " WHERE [DateCreated] > '1/1/2021'"); IEnumerable <ITestRun> testRuns = testManagementTeamProject.TestRuns.Query(query); int totalItems = testRuns.Count(); XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testRuns"); foreach (ITestRun testRun in testRuns) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Title}"); // IAttachmentOwner XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Attachments.Count}"); // ITestRun XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.BuildConfigurationId}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.BuildDirectory}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.BuildFlavor}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.BuildNumber}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.BuildPlatform}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.BuildUri}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.IsBvt}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Iteration}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.LastUpdated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.LastUpdatedByName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.LinkedWorkItemCount}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.NotApplicableTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.OwnerName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.PassedTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.PostProcessState}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Project.TeamProjectName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Revision}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.State}"); try { XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.CompletedTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.FailedTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.InconclusiveTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.InProgressTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.PassedTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.PendingTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Statistics.TotalTests}"); } catch (Exception ex) { var message = ex.ToString(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), "<Exception>"); } XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.TestEnvironmentId}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.TestMessageLogEntries.Count}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.TestPlanId}"); string testSettingsName = "<null>"; string testSettingsId = "<null>"; if (testRun.TestSettings != null) { testSettingsName = $"{testRun.TestSettings.Name}"; testSettingsId = $"{testRun.TestSettings.Id}"; } XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testSettingsName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testSettingsId); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.TestSettingsId}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.TotalTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Type}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.UnanalyzedTests}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testRun.Version}"); insertAt.IncrementRows(); itemCount++; AZDOHelper.ProcessItemDelay(options); AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }