예제 #1
0
        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);
        }
예제 #2
0
        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);
        }
예제 #3
0
        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);
        }
예제 #4
0
        //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);
        }
예제 #5
0
        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);
        }
예제 #6
0
        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();
        }
예제 #7
0
        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();
        }
예제 #8
0
        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);
        }
예제 #9
0
        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);
        }
예제 #10
0
        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);
        }
예제 #11
0
        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);
            }
        }
예제 #12
0
        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);
        }
예제 #13
0
        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();
        }
예제 #14
0
        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();
        }
예제 #15
0
        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);
        }
예제 #16
0
        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);
        }
예제 #17
0
        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);
        }
예제 #18
0
        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();
        }
예제 #19
0
        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();
        }
예제 #20
0
        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);
        }
예제 #21
0
        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);
        }
예제 #22
0
        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);
        }
예제 #23
0
        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();
        }
예제 #24
0
        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);
        }
예제 #25
0
        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);
        }
예제 #26
0
        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();
        }
예제 #27
0
        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);
        }
예제 #28
0
        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();
        }
예제 #29
0
        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();
        }
예제 #30
0
        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();
        }