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);
}
