private void HydrateChartSeriesList(DataTable originalChartData, EpmChartAggregateType aggregateType, SPField xAxisField, SPField yAxisField, SPField zAxisField, bool hasZAxis, bool hasZAxisColor, BubbleChartAxisToColumnMapping columnMappings)
{
var colorsAlreadyInLegend = new List <Color>();
var chartData = originalChartData.Copy();
RemoveUnusedChartDataColumns(chartData);
var xAxisColumn = chartData.Columns[columnMappings.XaxisColumnIndex];
var yAxisColumn = chartData.Columns[columnMappings.YaxisColumnIndex];
var titleColumn = chartData.Columns[chartData.Columns.Count - 1];
var zAxisColumn = new DataColumn();
if (hasZAxis)
{
zAxisColumn = chartData.Columns[columnMappings.ZaxisColumnIndex];
}
var zAxisColorColumn = chartData.Columns[columnMappings.ZaxisColorColumnIndex];
var zAxisColorMap = GetZAxisColorMap(chartData, zAxisColorColumn);
//TODO: Update this to not hardcode the series.
const string hardcodingBubblechartForNow = "BubbleChart";
var chartDataSeries = new EpmChartDataSeries(hardcodingBubblechartForNow);
foreach (DataRow row in chartData.Rows)
{
var zAxisColorFieldValue = "";
if (hasZAxisColor)
{
zAxisColorFieldValue = row[zAxisColorColumn].ToString();
}
var chartDataPoint = new EpmChartDataPoint(aggregateType);
chartDataPoint.Title = row[titleColumn].ToString();
chartDataPoint.XAxisLabel = ParseValue(xAxisColumn.ColumnName);
chartDataPoint.XAxisValue = ChartHelper.ParseDouble(ParseValue(row[xAxisColumn].ToString()), _englishNumberFormat, aggregateType, FieldIsPercentage(xAxisField));
chartDataPoint.XAxisFieldName = xAxisField.InternalName;
chartDataPoint.YAxisFieldName = yAxisField.InternalName;
chartDataPoint.ZAxisFieldName = zAxisField.InternalName;
chartDataPoint.LegendText = zAxisColorFieldValue == "" ? "No Value" : zAxisColorFieldValue;
chartDataPoint.ZAxisValue = ChartHelper.ParseDouble(ParseValue(row[zAxisColumn].ToString()), _englishNumberFormat, aggregateType, FieldIsPercentage(zAxisField));
chartDataPoint.AddYAxisValue(ChartHelper.ParseDouble(ParseValue(row[yAxisColumn].ToString()), _englishNumberFormat, aggregateType, FieldIsPercentage(yAxisField)));
//Only show one of each color in the legend.
if (hasZAxisColor)
{
if (zAxisColorMap.ContainsKey(zAxisColorFieldValue))
{
chartDataPoint.DataPointColor = zAxisColorMap[zAxisColorFieldValue];
if (!colorsAlreadyInLegend.Contains(chartDataPoint.DataPointColor))
{
chartDataPoint.ShowInLegend = true;
colorsAlreadyInLegend.Add(chartDataPoint.DataPointColor);
}
else
{
chartDataPoint.ShowInLegend = false;
}
}
}
else
{
chartDataPoint.DataPointColor = HtmlColorService.GetRandomHtmlColor();
}
chartDataSeries.AddDataPoint(chartDataPoint);
}
//NOTE: This is to set the zindex of the bubbles, but visifire doesnt support it on datapoints, only dataseries. So, we just need to order by ZAxis descending so smaller bubbles land on top.
chartDataSeries.OrderDataPointsSoSmallerBubblesAreInFront();
Add(chartDataSeries);
}
public void AddDataPoint(EpmChartDataPoint dataPoint)
{
ChartDataPoints.Add(dataPoint);
}