private void CreateWS_Web_Info(ClientContext ctx, string sectionsToDisplay, bool orientVertical) { XlHlp.DisplayInWatchWindow(string.Format("{0}", System.Reflection.MethodInfo.GetCurrentMethod().Name)); var web = ctx.Web; ctx.Load(web); ctx.ExecuteQuery(); string sheetName = XlHlp.SafeSheetName(string.Format("{0}{1}", "SPWeb>", web.Title)); Worksheet ws = XlHlp.NewWorksheet(sheetName, beforeSheetName: "FIRST"); XlHlp.XlLocation insertAt = new XlHlp.XlLocation(ws, row: 2, column: 1, orientVertical: GetDisplayOrientation()); if (insertAt.OrientVertical) { XlHlp.AddContentToCell(insertAt.AddRowX(), "Web Info"); insertAt.IncrementRows(); } else { XlHlp.AddContentToCell(insertAt.AddRowX(), "Web Info"); insertAt.DecrementRows(); // AddRow bumped it. insertAt.IncrementColumns(); } if (sectionsToDisplay.Contains("WebInfo")) { insertAt = AddSection_WebInfo(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Libraries")) { insertAt = AddSection_Libraries(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Lists")) { insertAt = AddSection_Lists(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("SiteGroups")) { insertAt = AddSection_SiteGroups(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("SiteColumns")) { insertAt = AddSection_SiteColumns(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("ContentTypes")) { insertAt = AddSection_ContentTypes(insertAt, ctx, web).IncrementPosition(insertAt.OrientVertical); } }
internal static XlHlp.XlLocation AddSections( XlHlp.XlLocation insertAt, TeamProject teamProject, List <string> sectionsToDisplay) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); if (sectionsToDisplay.Count != 0) { if (insertAt.OrientVertical) { //XlHlp.AddContentToCell(insertAt.AddRowX(), "TeamProject (TP) Information"); XlHlp.AddSectionInfo(insertAt.AddRow(), "TeamProject (TP) Information", ""); insertAt.IncrementRows(); } else { //XlHlp.AddContentToCell(insertAt.AddRowX(), "TeamProject (TP) Information"); XlHlp.AddSectionInfo(insertAt.AddRow(), "TeamProject(TP) Information", "", orientation: XlOrientation.xlUpward); insertAt.DecrementRows(); // AddRow bumped it. insertAt.IncrementColumns(); } if (sectionsToDisplay.Contains("Info")) { insertAt = Add_Info(insertAt, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Members")) { insertAt = Add_Members(insertAt, teamProject).IncrementPosition(insertAt.OrientVertical); } } Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); return(insertAt); }
internal static XlHlp.XlLocation AddSections(XlHlp.XlLocation insertAt, Options_AZDO_TFS options, IBuildServer buildServer, TeamProject teamProject, List <string> sectionsToDisplay) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); if (sectionsToDisplay.Count > 0) { if (insertAt.OrientVertical) { XlHlp.AddSectionInfo(insertAt.AddRow(), "Build Server (BS) Information", ""); } else { XlHlp.AddSectionInfo(insertAt.AddRow(), "Build Server (BS) Information", "", orientation: XlOrientation.xlUpward); insertAt.DecrementRows(); // AddRow bumped it. insertAt.IncrementColumns(); } //_buildServer.QueryBuildAgents; //_buildServer.QueryBuildControllers; //_buildServer.QueryBuildDefinitions; //_buildServer.QueryBuilds; //_buildServer.QueryBuildServiceHosts; //_buildServer.QueryProcessTemplates; insertAt = Add_Info(insertAt); if (sectionsToDisplay.Contains("Build Agents")) { insertAt = Add_BuildAgents(insertAt, options, buildServer, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Build Controllers")) { insertAt = Add_BuildControllers(insertAt, options, buildServer, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Build Definitions")) { insertAt = Add_BuildDefinitions(insertAt, options, buildServer, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Builds")) { insertAt = Add_Builds(insertAt, options, buildServer, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Build ServiceHosts")) { insertAt = Add_BuildServiceHosts(insertAt, options, buildServer, teamProject).IncrementPosition(insertAt.OrientVertical); } if (sectionsToDisplay.Contains("Build ProcessTemplates")) { insertAt = Add_BuildProcessTemplates(insertAt, options, buildServer, teamProject).IncrementPosition(insertAt.OrientVertical); } } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }