/// <summary>
/// Creates a Defect Age graph under analysis folder
/// </summary>
/// <param name="analysisItemFolder">AnalysisItemFolder Object</param>
/// <param name="graphName">Name of the graph</param>
/// <param name="groupByField">Group by field name</param>
/// <param name="sumOfField">Sum of field, if this is emplty then count of will be automatically selected</param>
/// <param name="ageGrouping">Age Grouping Enum object.</param>
/// <param name="filterString">Filter defects. You can get this using TDFilter Object</param>
/// <returns></returns>
public TDAPIOLELib.AnalysisItem CreateDefectAgeGraph(TDAPIOLELib.AnalysisItemFolder analysisItemFolder, String graphName, String groupByField, DefectSummaryGraphSumOF sumOfField, DefectAgeGrouping ageGrouping, String filterString)
{
TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory;
TDAPIOLELib.AnalysisItem analysisItem = analysisItemFactory.AddItem(System.DBNull.Value);
analysisItem.Name = graphName;
analysisItem.Type = "Graph";
String SOF = "";
if (sumOfField.Equals(DefectSummaryGraphSumOF.ActualFixTime))
{
SOF = "BG_ACTUAL_FIX_TIME";
}
else if (sumOfField.Equals(DefectSummaryGraphSumOF.EstimatedFixTime))
{
SOF = "BG_ESTIMATED_FIX_TIME";
}
else if (sumOfField.Equals(DefectSummaryGraphSumOF.None))
{
SOF = "";
}
else
{
throw (new Exception("Invalid Defect SumOf Fields"));
}
String AG = "";
if (ageGrouping == DefectAgeGrouping.NoGrouping)
{
AG = "All";
}
else if (ageGrouping == DefectAgeGrouping.OneMonth)
{
AG = "OneMonth";
}
else if (ageGrouping == DefectAgeGrouping.OneWeek)
{
AG = "OneWeek";
}
else if (ageGrouping == DefectAgeGrouping.SixMonths)
{
AG = "SixMonth";
}
else if (ageGrouping == DefectAgeGrouping.OneYear)
{
AG = "OneYear";
}
analysisItem.FilterData = GetDefectAgeGraphFilterData(groupByField, SOF, AG, filterString);
analysisItem.SubType = "AgeGraph";
analysisItem.Module = "defect";
analysisItem.Post();
return(analysisItem);
}
private TDAPIOLELib.AnalysisItem CreateSummaryGraph(TDAPIOLELib.AnalysisItemFolder analysisItemFolder, String GraphName, String GroupByField, String SumOfField, String XAxisField, String FilterString, String ReportModule)
{
TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory;
TDAPIOLELib.AnalysisItem analysisItem = analysisItemFactory.AddItem(System.DBNull.Value);
analysisItem.Name = GraphName;
analysisItem.Type = "Graph";
analysisItem.FilterData = GetDefectSummaryGraphFilterData(GroupByField, SumOfField, XAxisField, FilterString);
analysisItem.SubType = "SummaryGraph";
analysisItem.Module = ReportModule;
analysisItem.Post();
return(analysisItem);
}
/// <summary>
/// Creates a new excel report under analysis folder
/// </summary>
/// <param name="analysisItemFolder">AnalysisItemFolder Object</param>
/// <param name="name">Name of the Excel Report</param>
/// <param name="query">Query to be added</param>
/// <returns></returns>
public TDAPIOLELib.AnalysisItem CreateExcelReport(TDAPIOLELib.AnalysisItemFolder analysisItemFolder, String name, String query)
{
TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory;
TDAPIOLELib.AnalysisItem analysisItem = analysisItemFactory.AddItem(System.DBNull.Value);
analysisItem.Name = name;
analysisItem.Type = "ExcelReport";
analysisItem.FilterData = GetExcelReportFilterData(query);
analysisItem.SubType = "ExcelReport";
analysisItem.Module = "UnspecifiedEntity";
analysisItem.Post();
return(analysisItem);
}
public void Test_AnalysisAndDashboardScripts()
{
////Analysis Scripts
TDAPIOLELib.AnalysisItemFolder analysisItemFolder = aLM_CORE.Analysis.FindPrivateFolder();
Console.WriteLine("ID of private folder : " + analysisItemFolder.ID);
analysisItemFolder = aLM_CORE.Analysis.FindPublicFolder();
Console.WriteLine("ID of Public folder : " + analysisItemFolder.ID);
analysisItemFolder = aLM_CORE.Analysis.CreateFolder("Private", "TestFolder1");
analysisItemFolder = aLM_CORE.Analysis.CreateFolderPath("Private\\TestFolder1\\Dummy2\\Dummy3");
TDAPIOLELib.AnalysisItem analysisItem = aLM_CORE.Analysis.CreateExcelReport(analysisItemFolder, "FindAllBugs", "Select * from Bug");
analysisItem = aLM_CORE.Analysis.CreateDefectSummaryGraph(analysisItemFolder, "DefectFirstGraph", "BG_STATUS", ALM_Wrapper.Analysis.DefectSummaryGraphSumOF.ActualFixTime, "BG_DETECTED_IN_REL", "");
Console.WriteLine(analysisItem.LayoutData.ToString());
TDAPIOLELib.AnalysisItemFileFactory analysisItemFileFactory = analysisItem.AnalysisItemFileFactory;
foreach (TDAPIOLELib.AnalysisItemFile aif in analysisItemFileFactory.NewList(""))
{
aif.SetFilePath("C:\\Temp");
aif.Download();
}
//TDAPIOLELib.Gra
TDAPIOLELib.AnalysisItem analysisItem1 = aLM_CORE.Analysis.CreateDefectAgeGraph(analysisItemFolder, "Defect First Age Graph", "BG_RESPONSIBLE", ALM_Wrapper.Analysis.DefectSummaryGraphSumOF.None, ALM_Wrapper.Analysis.DefectAgeGrouping.NoGrouping, "");
aLM_CORE.Analysis.RenameFolder(analysisItemFolder, "TestFolder2");
Console.WriteLine("New Folder Name : " + analysisItemFolder.Name);
///Dashboard Scripts
TDAPIOLELib.DashboardFolder dashboardFolderParent = aLM_CORE.Dashboard.CreateFolder(aLM_CORE.Dashboard.FindPrivateFolder(), "TestFolder1");
TDAPIOLELib.DashboardFolder dashboardFolder = aLM_CORE.Dashboard.CreateFolderPath("Private\\TestFolder1\\Dummy1\\Dummy2");
TDAPIOLELib.DashboardPage dashboardPage = aLM_CORE.Dashboard.CreatePage(dashboardFolder, "TESTPAGE1");
TDAPIOLELib.DashboardPageItem dashboardPage1 = aLM_CORE.Dashboard.AddAnalysisItemToDashboard(dashboardPage, analysisItem, 0, 0);
TDAPIOLELib.DashboardPageItem dashboardPage2 = aLM_CORE.Dashboard.AddAnalysisItemToDashboard(dashboardPage, analysisItem1, 0, 1);
foreach (TDAPIOLELib.DashboardFolder dashboardFolder1 in aLM_CORE.Dashboard.FindChildFolders(aLM_CORE.Dashboard.GetFolderObject("Private\\TestFolder1")))
{
Console.WriteLine("Folder found under Private\\TestFolder1 : " + dashboardFolder1.Name);
}
foreach (TDAPIOLELib.DashboardPage dp in aLM_CORE.Dashboard.FindChildPages(dashboardFolder))
{
Console.WriteLine("Dashboard page found under " + dashboardFolder.Name + " - " + dp.Name);
}
aLM_CORE.Dashboard.RenameFolder(dashboardFolder, "TestFolder2");
Console.WriteLine("New Dashboard Folder name is : " + dashboardFolder.Name);
aLM_CORE.Dashboard.RenamePage(dashboardPage, "PageName1");
Console.WriteLine("New Dashboard page name is : " + dashboardPage.Name);
aLM_CORE.Dashboard.DeletePageItem(dashboardPage1);
aLM_CORE.Dashboard.DeletePageItem(dashboardPage2);
aLM_CORE.Dashboard.DeletePage(dashboardPage);
aLM_CORE.Dashboard.DeleteFolder(dashboardFolder);
aLM_CORE.Dashboard.DeleteFolder(dashboardFolderParent);
aLM_CORE.Analysis.DeleteFolder(analysisItemFolder);
aLM_CORE.Analysis.DeleteFolder(aLM_CORE.Analysis.GetFolderObject("Private\\TestFolder1"));
Console.WriteLine("Done");
}
/// <summary>
/// Deletes report or graph
/// </summary>
/// <param name="analysisItem">analysisItem Object for graph or report</param>
/// <returns></returns>
public Boolean DeleteReportOrGraph(TDAPIOLELib.AnalysisItem analysisItem)
{
TDAPIOLELib.AnalysisItemFactory analysisItemFactory = tDConnection.AnalysisItemFactory;
analysisItemFactory.RemoveItem(analysisItem.ID);
return(true);
}
/// <summary>
/// Renames a report or graph
/// </summary>
/// <param name="analysisItem">Analysis Item object</param>
/// <param name="newItemName">new item name</param>
/// <returns></returns>
public Boolean RenameReportOrGraph(TDAPIOLELib.AnalysisItem analysisItem, String newItemName)
{
analysisItem.Name = newItemName;
analysisItem.Post();
return(true);
}
public TDAPIOLELib.DashboardPageItem AddAnalysisItemToDashboard(TDAPIOLELib.DashboardPage dashboardPage, TDAPIOLELib.AnalysisItem analysisItem, int Row, int Column)
{
TDAPIOLELib.DashboardPageItemFactory dashboardPageItemFactory = dashboardPage.DashboardPageItemFactory;
TDAPIOLELib.DashboardPageItem dashboardPageItem = dashboardPageItemFactory.AddItem(System.DBNull.Value);
dashboardPageItem.AnalysisItemId = analysisItem.ID;
dashboardPageItem.Column = Column;
dashboardPageItem.Row = Row;
dashboardPageItem.Post();
return(dashboardPageItem);
}
