/// <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);
}
/// <summary>
/// Returns a list of reports or graphs under analysis folder
/// </summary>
/// <param name="analysisItemFolder">Analysis folder object</param>
/// <returns></returns>
public TDAPIOLELib.List GetChildGraphs(TDAPIOLELib.AnalysisItemFolder analysisItemFolder)
{
TDAPIOLELib.List anaFolderNames = new TDAPIOLELib.List();
TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory;
foreach (TDAPIOLELib.AnalysisItemFolder aif in analysisItemFactory.NewList(""))
{
anaFolderNames.Add(aif);
}
return(anaFolderNames);
}
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);
}
/// <summary>
/// Returns list of graph and report names under analysis folder
/// </summary>
/// <param name="analysisItemFolder">Analysis folder object</param>
/// <returns></returns>
public List <String> GetChildGraphNames(TDAPIOLELib.AnalysisItemFolder analysisItemFolder)
{
List <String> list = new List <String>();
TDAPIOLELib.AnalysisItemFactory analysisItemFactory = analysisItemFolder.AnalysisItemFactory;
foreach (TDAPIOLELib.AnalysisItemFolder aif in analysisItemFactory.NewList(""))
{
list.Add(aif.Name);
}
return(list);
}
/// <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);
}
