public Dictionary <string, string> GetExpecedMultipleHierarchyPieData(ManualTimeRange manualTimeRange, string[] dimensionPaths = null)
{
Dictionary <string, string> expectedPieDict = new Dictionary <string, string>();
var pieValues = Chart.GetPieDataLegendAndTexts();
HierarchysAndTags[] HierarchysAndTagsLists = GetActualHierarchysAndTags();
expectedPieDict.Add("TimeRange", GetExpectedTimeRange(manualTimeRange));
for (int i = 0; i < HierarchysAndTagsLists.Length; i++)
{
string taglist = ConvertTagsArrayToString(HierarchysAndTagsLists[i].tags);
if (expectedPieDict.ContainsKey(HierarchysAndTagsLists[i].Hieararchy))
{
expectedPieDict[HierarchysAndTagsLists[i].Hieararchy] = expectedPieDict[HierarchysAndTagsLists[i].Hieararchy] + "," + taglist;
}
else
{
expectedPieDict.Add(HierarchysAndTagsLists[i].Hieararchy, taglist);
}
}
foreach (var pieValue in pieValues)
{
expectedPieDict.Add(pieValue.tagOrCommodity, pieValue.valueAndUOM);
}
return(expectedPieDict);
}
public DataTable GetExpecedMultipleHierarchyPieDataTable(ManualTimeRange manualTimeRange, string[] dimensionPaths = null)
{
DataTable dt = new DataTable();
var pieValues = Chart.GetPieDataLegendAndTexts();
HierarchysAndTags[] HierarchysAndTagsLists = GetActualHierarchysAndTags();
dt.Columns.Add("Key");
dt.Columns.Add("Value");
dt.Rows.Add("TimeRange", GetExpectedTimeRange(manualTimeRange));
for (int i = 0; i < HierarchysAndTagsLists.Length; i++)
{
string taglist = ConvertTagsArrayToString(HierarchysAndTagsLists[i].tags);
dt.Rows.Add(HierarchysAndTagsLists[i].Hieararchy, taglist);
}
foreach (var pieValue in pieValues)
{
dt.Rows.Add(pieValue.tagOrCommodity, pieValue.valueAndUOM);
}
return(dt);
}
public void ExportMulTimePieDataTableToExcel(string[] hierarchyPaths, ManualTimeRange manualTimeRange, string fileName, string path, string[] dimensionPaths = null)
{
if (ExecutionConfig.isCreateExpectedDataViewExcelFile)
{
DataTable expectedactualPieDict = GetMulTimePieDataToDataTable(hierarchyPaths, manualTimeRange, dimensionPaths);
//Export to excel
string actualFileName = Path.Combine(path, fileName);
JazzFunction.ChartViewOperation.MoveDataTableExpectedDataToExcel(expectedactualPieDict, actualFileName, JazzFunction.DataViewOperation.sheetNameExpected);
}
}
public void ExportExpectedDataTableToExcelMultiHiearachy(ManualTimeRange manualTimeRange, string fileName, string path, string[] dimensionPaths = null)
{
if (ExecutionConfig.isCreateExpectedDataViewExcelFile)
{
DataTable expectedactualPieDataTable = GetExpecedMultipleHierarchyPieDataTable(manualTimeRange);
//Export to excel
string actualFileName = Path.Combine(path, fileName);
JazzFunction.ChartViewOperation.MoveDataTableExpectedDataToExcel(expectedactualPieDataTable, actualFileName, JazzFunction.DataViewOperation.sheetNameExpected);
}
}
public Dictionary <string, string> GetMulTimePieData(string[] hierarchyTag, ManualTimeRange manualTimeRange, string[] dimensionPaths = null)
{
Dictionary <string, string> actualPieDict = new Dictionary <string, string>();
var pieValues = Chart.GetPieDataLegendAndTexts();
actualPieDict.Add("Hierarchy", GetExpectedHierarchyPath(hierarchyTag, dimensionPaths));
actualPieDict.Add("TimeRange", GetExpectedTimeRange(manualTimeRange));
foreach (var pieValue in pieValues)
{
actualPieDict.Add(pieValue.tagOrCommodity, pieValue.valueAndUOM);
}
return(actualPieDict);
}
public string GetExpectedTimeRange(ManualTimeRange manualTimeRange)
{
string ExpectedTimeRange = null;
if (String.IsNullOrEmpty(manualTimeRange.StartTime) || String.IsNullOrEmpty(manualTimeRange.EndTime))
{
ExpectedTimeRange = manualTimeRange.StartDate + " 00:00" + " to " + "24:00 " + manualTimeRange.EndDate;
}
else
{
ExpectedTimeRange = manualTimeRange.StartDate + " " + manualTimeRange.StartTime + " to " + manualTimeRange.EndTime + " " + manualTimeRange.EndDate;
}
return(ExpectedTimeRange);
}
public DataTable GetMulTimePieDataToDataTable(string[] hierarchyTag, ManualTimeRange manualTimeRange, string[] dimensionPaths = null)
{
DataTable dt = new DataTable();
dt.Columns.Add("Key");
dt.Columns.Add("Value");
var pieValues = Chart.GetPieDataLegendAndTexts();
dt.Rows.Add("Hierarchy", GetExpectedHierarchyPath(hierarchyTag, dimensionPaths));
//dt.Rows.Add("TimeRange", GetExpectedTimeRange(manualTimeRange));
foreach (var pieValue in pieValues)
{
dt.Rows.Add(pieValue.tagOrCommodity, pieValue.valueAndUOM);
}
return(dt);
}
/// <summary>
/// Export expected data table to excel file for Multime pie
/// </summary>
/// <param name="displayStep"></param>
public void ExportMulTimeDictionaryToExcel(string[] hierarchyPaths, ManualTimeRange manualTimeRange, string fileName, string[] dimensionPaths = null)
{
ExportMulTimePieDictionaryToExcel(hierarchyPaths, manualTimeRange, fileName, CostPiePath, dimensionPaths);
}
public void ExportExpectedDataTableForMultipleHierarchyToExcel(ManualTimeRange manualTimeRange, string fileName)
{
ExportExpectedDataTableToExcelMultiHiearachy(manualTimeRange, fileName, EAPiePath);
}
public void ExportMulTimePieDataTableToExcel(string[] hierarchyPaths, ManualTimeRange manualTimeRange, string fileName)
{
ExportMulTimePieDataTableToExcel(hierarchyPaths, manualTimeRange, fileName, EAPiePath);
}
public void ExportExpectedPieDataToExcel(string[] hierarchyPaths, string fileName, ManualTimeRange manualTimeRange = null)
{
ExportExpectedPieDataTableToExcel(hierarchyPaths, manualTimeRange, fileName, EAPiePath);
}
/// <summary>
/// Export expected dictionary data to excel file
/// </summary>
/// <param name="displayStep"></param>
public void ExportExpectedDictionaryToExcel(string[] hierarchyPaths, ManualTimeRange manualTimeRange, string fileName)
{
ExportExpectedDictionaryToExcel(hierarchyPaths, manualTimeRange, fileName, EAPiePath);
}
