internal static int Add_TestResolutionStates( Excel.XlLocation insertAt, Options_AZDO_TFS options, ITestManagementTeamProject testManagementTeamProject) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); int itemCount = 0; IEnumerable <ITestResolutionState> testResolutionStates = testManagementTeamProject.TestResolutionStates.Query(); int totalItems = testResolutionStates.Count(); XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testResolutionStates"); foreach (ITestResolutionState testResolutionState in testManagementTeamProject.TestResolutionStates.Query()) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResolutionState.Id}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResolutionState.Name}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResolutionState.Project.TeamProjectName}"); insertAt.IncrementRows(); itemCount++; //ProcessItemDelay(options); AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }
private XlHlp.XlLocation DisplayListOf_ContentTypes(XlHlp.XlLocation insertAt, ContentTypeCollection contentTypes, bool displayDataOnly, string tableSuffix) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); Worksheet ws = insertAt.workSheet; if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Name"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 30, "Group"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var cType in contentTypes) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Name); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Group); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
private 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); }
//private static IEnumerable<List> Get_Lists(ClientContext ctx, Web web) //{ // var alllists = web.Lists; // IEnumerable<List> lists = ctx.LoadQuery(alllists.Where // (list => list.BaseType == BaseType.GenericList) // ); // ctx.ExecuteQuery(); // return lists; //} private XlHlp.XlLocation AddSection_Lists(XlHlp.XlLocation insertAt, ClientContext ctx, Web web) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); if (insertAt.OrientVertical) { XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "Lists", web.Title); } else { XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "Lists", web.Title, orientation: XlOrientation.xlUpward); insertAt.IncrementColumns(); } IEnumerable <List> lists = VNCSP.Helper.GetLists(ctx, web); insertAt.MarkStart(XlHlp.MarkType.GroupTable); insertAt = DisplayListOf_Lists(insertAt, lists, false, "OneLevel"); insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblLists_{0}", web.Title)); insertAt.Group(insertAt.OrientVertical, hide: true); insertAt.EndSectionAndSetNextLocation(insertAt.OrientVertical); XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
internal static 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); }
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); } }
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); }
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 int Add_TestSuites( Excel.XlLocation insertAt, Options_AZDO_TFS options, ITestManagementTeamProject testManagementTeamProject) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); int itemCount = 0; //string query = String.Format( // "SELECT [System.Id], [System.Title]" // + " FROM WorkItems" // + " WHERE [System.WorkItemType] = 'Test Suite'" // + " AND [Team Project] = '{0}'", testManagementTeamProject.TeamProjectName); string query = String.Format( "SELECT *" + " FROM TestSuite" ); ITestSuiteCollection testSuites = testManagementTeamProject.TestSuites.Query(query); int totalItems = testSuites.Count; XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testSuites"); foreach (var testSuite in testSuites) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testManagementTeamProject.TeamProjectName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Id}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Title}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Description}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.State}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.LastUpdated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.LastUpdatedByName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.TestCaseCount}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.TestSuiteType}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.AllTestCases.Count}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Revision}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Plan.Id}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testSuite.Plan.Name}"); insertAt.IncrementRows(); itemCount++; AZDOHelper.ProcessItemDelay(options); AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }
internal static int Add_TestResults( Excel.XlLocation insertAt, Options_AZDO_TFS options, ITestManagementTeamProject testManagementTeamProject) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); int itemCount = 0; string query = String.Format( "SELECT *" + " FROM TestResult" + " WHERE [DateCreated] > '1/1/2021'"); ITestCaseResultCollection testCaseResults = testManagementTeamProject.TestResults.Query(query); int totalItems = testCaseResults.Count; int[] associatedWIs = testCaseResults.QueryAssociatedWorkItems(); XlHlp.DisplayInWatchWindow($"Processing ({ totalItems }) testCaseResults"); foreach (ITestResult testResult in testCaseResults) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName); // IAttachmentOwner XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Attachments.Count}"); // ITestResult XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.CollectorsEnabled.Count}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Comment}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.DateCreated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.DateStarted}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.DateCompleted}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Duration}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.ErrorMessage}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testResult.Outcome}"); insertAt.IncrementRows(); itemCount++; AZDOHelper.ProcessItemDelay(options); AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }
internal static int Add_TestEnvironments( Excel.XlLocation insertAt, Options_AZDO_TFS options, ITestManagementTeamProject testManagementTeamProject) { Int64 startTicks = Log.APPLICATION("Enter", Common.LOG_CATEGORY); int itemCount = 0; string query = String.Format( "SELECT *" + " FROM TestEnvironment"); var testEnvironments = testManagementTeamProject.TestEnvironments.Query(); var totalItems = testEnvironments.Count(); XlHlp.DisplayInWatchWindow($"Processing ({ totalItems } testEnvironments"); foreach (ITestEnvironment testEnvironment in testEnvironments) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testManagementTeamProject.TeamProjectName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), testEnvironment.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Name}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.ControllerDisplayName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.ControllerEnvironmentId}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.ControllerName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.DateCreated}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Description}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.DisplayName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.EnvironmentType}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Error}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.InvalidProperties.Count()}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.IsDirty}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.LabEnvironmentUri}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.LabServerUri}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.MachineRoles.Count}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.Owner}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.TeamProject.TeamProjectName}"); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), $"{testEnvironment.TestController.Name}"); insertAt.IncrementRows(); itemCount++; //ProcessItemDelay(options); AZDOHelper.DisplayLoopUpdates(startTicks, options, totalItems, itemCount); } Log.APPLICATION("Exit", Common.LOG_CATEGORY, startTicks); return(itemCount); }
internal static 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); }
private void PopulateSitesPicker(string uri) { // NB. This does not recurse. Just gets direct subsites. try { using (var ctx = new ClientContext(uri)) { //ctx.Credentials = new NetworkCredential("user", "password", "domain"); var web = ctx.Web; ctx.Load(web, info => info.Webs); ctx.ExecuteQuery(); //ctx.Load(web.Webs); //ctx.ExecuteQuery(); var itemCol = cbeWeb.Items; itemCol.BeginUpdate(); itemCol.Clear(); foreach (Web w in web.Webs) { // Some stuff came with the web already //ctx.Load(w); ////ctx.Load(w, info => info.Url, info => info.Title); //ctx.ExecuteQuery(); XlHlp.DisplayInWatchWindow(string.Format("{0} - {1}", w.Title, w.ServerRelativeUrl)); string subSiteUrl = string.Format("{0}{1}", uri, w.ServerRelativeUrl); itemCol.Add(subSiteUrl); } itemCol.EndUpdate(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private XlHlp.XlLocation AddSection_SiteColumns(XlHlp.XlLocation insertAt, ClientContext ctx, Web web) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); if (insertAt.OrientVertical) { XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "SiteColumns", web.Title); } else { XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "SiteColumns", web.Title, orientation: XlOrientation.xlUpward); insertAt.IncrementColumns(); } var siteColumns = VNCSP.Helper.GetSiteColumns(ctx, web); //ctx.Load(web.Fields); //ctx.ExecuteQuery(); //var siteColumns = web.Fields; //ctx.ExecuteQuery(); insertAt.MarkStart(XlHlp.MarkType.GroupTable); insertAt = DisplayListOf_SiteColumns(insertAt, siteColumns, false, "OneLevel"); insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblSiteColumns_{0}", web.Title)); insertAt.Group(insertAt.OrientVertical, hide: true); insertAt.EndSectionAndSetNextLocation(insertAt.OrientVertical); XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
private void CreateWS_SiteCollection_Info(ClientContext ctx, bool param1) { XlHlp.DisplayInWatchWindow(string.Format("{0}", System.Reflection.MethodInfo.GetCurrentMethod().Name)); var site = ctx.Site; var web = ctx.Web; ctx.Load(site); ctx.ExecuteQuery(); // Display Site (SiteCollection stuff) ctx.Load(web); ctx.ExecuteQuery(); foreach (Web w in web.Webs) { XlHlp.DisplayInWatchWindow(w.Title); } }
private XlHlp.XlLocation AddSection_WebInfo(XlHlp.XlLocation insertAt, ClientContext ctx, Web web) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); //ctx.Load(web, info => info.HasUniqueRoleAssignments); //ctx.Load(web1, // info => info.Url, // info => info.MasterUrl, // info => info.Description, // info => info.HasUniqueRoleAssignments, // info => info.Created); //ctx.ExecuteQuery(); XlHlp.AddLabeledInfoX(insertAt.AddOffsetRowX(), "Url:", ctx.Url); XlHlp.AddLabeledInfoX(insertAt.AddOffsetRowX(), "Title:", web.Title); XlHlp.AddLabeledInfoX(insertAt.AddOffsetRowX(), "Created:", web.Created.ToString()); XlHlp.AddLabeledInfoX(insertAt.AddOffsetRowX(), "Description:", web.Description); XlHlp.AddLabeledInfoX(insertAt.AddOffsetRowX(), "Id:", web.Id.ToString()); //XlHlp.AddTitledInfo(ws.Cells[startingRow++, 1], "HasUniqueRoleAssignments:", web.HasUniqueRoleAssignments.ToString()); //XlHlp.AddTitledInfo(ws.Cells[startingRow++, 1], "MasterUrl:", web.MasterUrl); return(insertAt); }
private XlHlp.XlLocation AddSection_ContentTypes(XlHlp.XlLocation insertAt, ClientContext ctx, Web web) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); if (insertAt.OrientVertical) { XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "ContentTypes", web.Title); } else { XlHlp.AddLabeledInfoX(insertAt.AddRowX(), "ContentTypes", web.Title, orientation: XlOrientation.xlUpward); insertAt.IncrementColumns(); } ctx.Load(web.ContentTypes); ctx.ExecuteQuery(); //IEnumerable<List> cTypes = ctx.LoadQuery(allContentTypes.Where // (list => list.BaseType == BaseType.DocumentLibrary) // ); ctx.ExecuteQuery(); insertAt.MarkStart(XlHlp.MarkType.GroupTable); insertAt = DisplayListOf_ContentTypes(insertAt, web.ContentTypes, false, "Full"); insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblContentTypes_{0}", web.Title)); insertAt.Group(insertAt.OrientVertical, hide: true); insertAt.EndSectionAndSetNextLocation(insertAt.OrientVertical); XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
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); }
private XlHlp.XlLocation DisplayListOf_SiteColumns(XlHlp.XlLocation insertAt, IEnumerable <Field> siteColumns, bool displayDataOnly, string tableSuffix) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); Worksheet ws = insertAt.workSheet; //<Field //ID="{56747800-D36E-4625-ABE3-B1BC74A7D5F8}" //Name="LowerValuesAreBetter" //StaticName="LowerValuesAreBetter" //Description="Whether lower is better or higher is better" //Group="Status Indicators" Type="Boolean" //DisplayName="Lower values are better" //SourceID="http://schemas.microsoft.com/sharepoint/v3" /> //<Field //Type="Lookup" //DisplayName="FA Page Type" //Required="FALSE" //EnforceUniqueValues="FALSE" //List="{b1d6a5ff-876b-4761-a05d-210038e31639}" //WebId="666b287f-2709-476b-a739-e1de9150fb37" //ShowField="Title" //UnlimitedLengthInDocumentLibrary="FALSE" //Group="Custom Columns" //ID="{3090abc3-526c-458f-9c65-302ad853db65}" //SourceID="{666b287f-2709-476b-a739-e1de9150fb37}" //StaticName="FA_x0020_Page_x0020_Type" //Name="FA_x0020_Page_x0020_Type" /> if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Title"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Name"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "StaticName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Description"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 30, "Group"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "TypeAsString"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var field in siteColumns) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Title); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Group); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.TypeAsString.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
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); }