protected void CreateDataReport(string queryName, string name, string title, ChartTypes chartType, string groupByCategory, string groupByType, AggregateMethods aggregateMethod)
{
var query = this.GetQuery(queryName);
if (query == null)
{
return;
}
var queryPart = query.As <QueryPart>();
ReportRecord newReport = new ReportRecord
{
Name = name,
Title = title,
Query = queryPart.Record,
ChartType = (int)chartType,
GroupByCategory = groupByCategory,
GroupByType = groupByType,
AggregateMethod = (int)aggregateMethod
};
this.reportRepository.Create(newReport);
this.reportRepository.Flush();
}
public static Chart CreateChartByAxisName(Table table,ChartTypes type,string CellRange,string AxisXName,string AxisYName)
{
Chart chart = CreateChart (table,type,CellRange);
chart.XAxisName = AxisXName;
chart.YAxisName = AxisYName;
return chart;
}
public static Chart CreateChart(Table table,ChartTypes type,string CellRange)
{
Chart chart = new Chart (table,"ch1");
chart.ChartType = type.ToString ();
chart.CreateFromCellRange (CellRange);
return chart;
}
public static IHtmlContent ChartBlock(
this IHtmlHelper helper,
ChartTypes type,
string item,
int size = 4,
string loadedField = "true",
object attrs = null,
object componentAttrs = null,
string classes = null)
{
var acc = proc.Process(helper, "chart_block_" + item, "DashboardItem__" + type.ToString());
if (!acc.Read)
{
return(null);
}
else
{
var model = new DashboardBlockModel
{
Attributes = attrs != null?RazorUtils.ToAttributeString(attrs) : null,
ComponentAttrs = componentAttrs != null?RazorUtils.ToAttributeString(componentAttrs) : null,
Selector = GetTypeSelector(type),
Size = size,
SingleItem = true,
DataField = item,
IsLoadedField = loadedField
};
return(helper.GetComponent("Components/DashboardBlock", model));
}
}
public Highcharts GetChart(ChartTypes chartType, string title, string[] categories, Series[] series,
Color bgColor, Color borderColor, string subTitle = "", string xAxistTitle = "", string yAxistTitle = "")
{
Highcharts columnChart = new Highcharts("columnchart");
columnChart.InitChart(new Chart()
{
Type = chartType,
BackgroundColor = new BackColorOrGradient(bgColor),
Style = "fontWeight: 'bold', fontSize: '12px'",
BorderColor = borderColor,
BorderRadius = 0,
BorderWidth = 1
});
columnChart.SetTitle(new Title()
{
Text = title
});
columnChart.SetSubtitle(new Subtitle()
{
Text = subTitle
});
columnChart.SetXAxis(new XAxis()
{
Type = AxisTypes.Category,
Title = new XAxisTitle()
{
Text = xAxistTitle, Style = "fontWeight: 'bold', fontSize: '12px'"
},
Categories = categories //new[] { "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012" }
});
columnChart.SetYAxis(new YAxis()
{
Title = new YAxisTitle()
{
Text = yAxistTitle,
Style = "fontWeight: 'bold', fontSize: '12px'"
},
ShowFirstLabel = true,
ShowLastLabel = true,
Min = 0,
AllowDecimals = false
});
columnChart.SetLegend(new Legend
{
Enabled = true,
BorderColor = Color.CornflowerBlue,
BorderRadius = 6,
BackgroundColor = new BackColorOrGradient(Color.Transparent)//ColorTranslator.FromHtml("#FFADD8E6"))
});
columnChart.SetSeries(series);
return(columnChart);
}
/// <summary>
/// Adds Statistics Denmark specific functionality for adding Legend.
/// </summary>
protected override void addLegend()
{
base.addLegend();
if (showLegend)
{
Legends.First().Font = Font.Small;
Legends.First().ForeColor = ColorTranslator.FromHtml("#4c4c4c");
Legends.First().LegendStyle = LegendStyle.Table;
if (!ChartTypes.Contains(SeriesChartType.Pie))
{
Legends.First().TextWrapThreshold = 1000;
}
Legends.First().TableStyle = LegendTableStyle.Wide;
if (!ChartTypes.Contains(SeriesChartType.Pie))
{
float y = spaceUsedForTitle + space;
float h = legendHeight;
Legends.First().Position = new ElementPosition(0, y, 100, h);
}
else
{
Legends.First().LegendStyle = LegendStyle.Column;
float top = spaceUsedForTitle + space + space;
Legends.First().Position = new ElementPosition(50, top, 50, 100 - top - SpaceUsedForInfoText);
}
}
}
private void RowsInitialize(InitializationContext context, out int expectedNumberOfSeries, out bool computedSubtotal)
{
Global.Tracer.Assert(null != this.m_rows);
computedSubtotal = false;
this.m_rows.DynamicInitialize(false, 0, context);
this.m_rows.StaticInitialize(context);
expectedNumberOfSeries = ((this.m_staticRows == null) ? 1 : this.m_staticRows.NumberOfStatics);
if (this.m_rows != null && this.m_rows.Grouping == null)
{
context.SpecialTransferRunningValues(this.m_rows.RunningValues);
}
if (this.m_hasSeriesPlotTypeLine && this.m_seriesPlotType != null)
{
if (this.m_type == ChartTypes.Column)
{
if (this.m_staticRows == null)
{
this.m_type = ChartTypes.Line;
}
else
{
this.m_staticRows.PlotTypesLine = this.m_seriesPlotType;
}
}
else
{
context.ErrorContext.Register(ProcessingErrorCode.rsChartSeriesPlotTypeIgnored, Severity.Warning, context.ObjectType, context.ObjectName, "PlotType");
}
}
}
private static ChartSeries GetSeries(ChartTypes seriesChartType, IEnumerable <double> chartData)
{
ChartSeries chartSeries = new ChartSeries(seriesChartType);
chartSeries.Data = new ChartData.VisualizerPointsCollection(chartData);
return(chartSeries);
}
public void SetNumberChartType(int Mode, int StackMode, bool IsLineBased)
{
Mode = Mode % 9;
ChartType = (ChartTypes)Mode;
StrokeMode = IsLineBased;
switch (StackMode)
{
case 0:
int[] IndicesA = { 0, 7, 10, 3, 5, 4, 13, 14, 0 };
ChartSeries.ChartType = ((SeriesChartType)IndicesA[Mode]);
break;
case 1:
int[] IndicesB = { 0, 8, 11, 3, 5, 4, 15, 14, 0 };
ChartSeries.ChartType = ((SeriesChartType)IndicesB[Mode]);
break;
case 2:
int[] IndicesC = { 0, 9, 12, 3, 5, 4, 16, 14, 0 };
ChartSeries.ChartType = ((SeriesChartType)IndicesC[Mode]);
break;
}
}
public void SetStackChartType(int Mode, int JustificationMode)
{
Mode = Mode % 2;
ChartType = (ChartTypes)(12 + Mode);
int[] Indices = { 33, 34 };
ChartSeries.ChartType = ((SeriesChartType)Indices[Mode]);
JustificationMode = JustificationMode % 5;
string[] JustIndex = { "OutsideInColumn", "Outside", "Inside", "Outside", "OutsideInColumn" };
string[] PosIndex = { "Left", "Left", "Right", "Right", "Right" };
switch (Mode)
{
case 0:
ChartSeries["FunnelLabelStyle"] = JustIndex[JustificationMode];
ChartSeries["FunnelOutsideLabelPlacement"] = PosIndex[JustificationMode];
ChartSeries["FunnelInsideLabelPlacement"] = "Center";
break;
case 1:
ChartSeries["PyramidLabelStyle"] = JustIndex[JustificationMode];
ChartSeries["PyramidOutsideLabelPlacement"] = PosIndex[JustificationMode];
ChartSeries["PyramidInsideLabelPlacement"] = "Center";
break;
}
}
public ChartInfo SetupChartAreaFor(string rootname, ChartTypes charttype, int refreshfrequency)
{
Chart c = null;
c = this.GetDefaultChartIfNull(c);
ChartInfo chartinfo = this.AddChartAreaAndLegend(c, rootname);
switch (charttype)
{
case ChartTypes.Acceleration:
this.ChartSeriesAndCustomization(c, chartinfo, SensorGrapherControl.SeriesXYZPostfix, SensorGrapherControl.DefaultXYZColor, SensorGrapherControl.DefaultAclLegendText, 45.0);
break;
case ChartTypes.Velocity:
this.ChartSeriesAndCustomization(c, chartinfo, SensorGrapherControl.SeriesXYZPostfix, SensorGrapherControl.DefaultXYZColor, SensorGrapherControl.DefaultVelLegendText, 6.0);
break;
case ChartTypes.Position:
this.ChartSeriesAndCustomization(c, chartinfo, SensorGrapherControl.SeriesXYZPostfix, SensorGrapherControl.DefaultXYZColor, SensorGrapherControl.DefaultPosLegendText, 4.0);
break;
}
this.InitilizeRefreshCountAndFreq(chartinfo, refreshfrequency);
this.ChartItemsList.Add(chartinfo);
return(chartinfo);
}
public void SetRangeChartType(int Mode)
{
Mode = Mode % 5;
ChartType = (ChartTypes)(Mode + 14);
int[] Indices = { 21, 22, 2, 24, 23 };
ChartSeries.ChartType = ((SeriesChartType)Indices[Mode]);
}
public GoogleChartWrapper(String chartTitle, ChartTypes chartType, int chartHeight, int chartWidth, String divChartName)
{
ChartTitle = chartTitle;
ChartType = chartType;
ChartHeight = chartHeight;
ChartWidth = chartWidth;
DivChartName = divChartName;
}
public static Chart CreateChart(Table table, ChartTypes type, string CellRange)
{
Chart chart = new Chart(table, "ch1");
chart.ChartType = type.ToString();
chart.CreateFromCellRange(CellRange);
return(chart);
}
public static Chart CreateChartByAxisName(Table table, ChartTypes type, string CellRange, string AxisXName, string AxisYName)
{
Chart chart = CreateChart(table, type, CellRange);
chart.XAxisName = AxisXName;
chart.YAxisName = AxisYName;
return(chart);
}
public void SetRadialChartType(int Mode)
{
Mode = Mode % 2;
ChartType = (ChartTypes)(10 + Mode);
int[] Indices = { 26, 25 };
ChartSeries.ChartType = ((SeriesChartType)Indices[Mode]);
}
public static Chart CreateChartByTitle(Table table,string CellRange,ChartTypes type,string title,string xPosition,string yPosition,string xAxisname,string yAxisname)
{
Chart chart = CreateChart(table,type,CellRange);
chart.ChartTitle .SetTitle (title);
chart.ChartTitle .SvgX = xPosition;
chart.ChartTitle .SvgY = yPosition;
chart.XAxisName =xAxisname;
chart.YAxisName =yAxisname;
return chart;
}
internal ChartOptions(ChartTypes chartType, string title, string moneySetting, string yAxisLabel, string yAxisLabel2 = null, string yAxisLabel3 = null, bool reverse = true)
{
this.chartType = chartType;
this.title = title;
this.moneySetting = moneySetting;
this.yAxisLabel = yAxisLabel;
this.yAxisLabel2 = yAxisLabel2;
this.yAxisLabel3 = yAxisLabel3;
this.reverse = reverse;
}
public ChartFormZed(IEnumerable <HttpRequestData> data, string url = null, ChartTypes chartType = ChartTypes.TimeTakenPerRequest, Form parentForm = null)
{
InitializeComponent();
Url = url;
Results = data;
ChartType = chartType;
ParentForm = null;
Text = "WebSurge - Request Times Taken";
}
public ChartFormZed(IEnumerable<HttpRequestData> data, string url = null, ChartTypes chartType = ChartTypes.TimeTakenPerRequest, Form parentForm = null)
{
InitializeComponent();
Url = url;
Results = data;
ChartType = chartType;
ParentForm = null;
Text = "WebSurge - Request Times Taken";
}
public static Chart CreateChartByTitle(Table table, string CellRange, ChartTypes type, string title, string xPosition, string yPosition, string xAxisname, string yAxisname)
{
Chart chart = CreateChart(table, type, CellRange);
chart.ChartTitle.SetTitle(title);
chart.ChartTitle.SvgX = xPosition;
chart.ChartTitle.SvgY = yPosition;
chart.XAxisName = xAxisname;
chart.YAxisName = yAxisname;
return(chart);
}
public static Chart CreateChartByLegend(Table table, string CellRange, ChartTypes type, string legendPos, string Xpos, string Ypos, string XAxisname, string YAxisname)
{
Chart chart = CreateChart(table, type, CellRange);
chart.ChartLegend.LegendPosition = legendPos;
chart.ChartLegend.SvgX = Xpos;
chart.ChartLegend.SvgY = Ypos;
chart.XAxisName = XAxisname;
chart.YAxisName = YAxisname;
return(chart);
}
public ChartFormZed(RequestWriter requestWriter, string url = null, ChartTypes chartType = ChartTypes.TimeTakenPerRequest, Form parentForm = null)
{
InitializeComponent();
Url = url;
Results = requestWriter.GetResults();
RequestWriter = requestWriter;
ChartType = chartType;
ParentForm = null;
Text = "WebSurge - Request Times Taken";
}
// Converting selection type
private void convertSelection(string baseChart, string refChart, ChartTypes baseType, ChartTypes refType)
{
List <ISelection> refObjects = charts_.selection[refChart];
List <ISelection> tempObjects = refObjects.GetRange(0, refObjects.Count);
// Convert to nodes
if (isNodeType(baseType))
{
// Nodes -> Nodes
if (isNodeType(refType))
{
charts_.selection[baseChart].AddRange(tempObjects);
}
// Lines -> Nodes
if (isLineType(refType))
{
foreach (ISelection item in tempObjects)
{
List <string> nodeNames = (List <string>)item.retrieveSelection();
foreach (string name in nodeNames)
{
charts_.selection[baseChart].Add(new Nodes {
nodeName_ = name
});
}
}
}
}
// Convert to lines
if (isLineType(baseType))
{
// Lines -> Lines
if (isLineType(refType))
{
charts_.selection[baseChart].AddRange(tempObjects);
}
// Nodes -> Line
if (isNodeType(refType))
{
Lines line = new Lines();
line.nodeNames_ = new List <string>();
line.lineName_ = "Line" + indLine_.ToString();
foreach (ISelection item in tempObjects)
{
line.nodeNames_.Add((string)item.retrieveSelection());
}
List <ISelection> res = new List <ISelection>();
res.Add((ISelection)line);
charts_.selection[baseChart] = res;
}
}
}
public static string Type2Text(ChartTypes value)
{
switch (value)
{
case ChartTypes.Line: return(Languages.Libs.GetString("line"));
case ChartTypes.Bar: return(Languages.Libs.GetString("bar"));
case ChartTypes.CandleStick: return(Languages.Libs.GetString("candleStick"));
default: return("<" + Languages.Libs.GetString("select") + ">");
}
}
/// <summary>
/// Creat a LineChart or a StackedAreaChart and put it in the index-th position.
/// Make sure the Scene has enough RectTransforms as the number of charts logged.
/// </summary>
/// <param name="chartType"></param>
/// <param name="index"></param>
private void CreateNewChart(ChartTypes chartType, int index)
{
if (index > chartRectObjects.Length)
{
Debug.LogError("Too many charts for this scene!");
return;
}
if (timeCharts[index] != null)
{
Debug.Log("Combine graphs detected, no need for a new chart...");
return;
}
RectTransform transform = (RectTransform)chartRectObjects[index].transform;
GameObject chart;
switch (chartType)
{
case ChartTypes.Line:
chart = Instantiate(lineChartPrefab, transform.localPosition, Quaternion.identity) as GameObject;
LineChart lineChart = chart.GetComponent <LineChart>();
lineChart.InitChart(); // Important to call InitChart!
timeCharts[index] = lineChart; // Maybe not needed!
break;
case ChartTypes.StackedArea:
chart = Instantiate(stackedAreaChartPrefab, transform.localPosition, Quaternion.identity) as GameObject;
StackedAreaChart areaChart = chart.GetComponent <StackedAreaChart>();
areaChart.InitChart(); // Important to call InitChart!
timeCharts[index] = areaChart; // Maybe not needed!
break;
default:
Debug.LogWarning("Chart type not avaiable right now.");
return;
}
RectTransform chartTransform = (RectTransform)chart.transform;
chartTransform.sizeDelta = transform.sizeDelta;
chartTransform.SetParent(transform.parent);
chartTransform.pivot = transform.pivot;
chartTransform.localPosition = transform.localPosition;
chartRectObjects[index] = chart;
Destroy(transform.gameObject);
}
private async void SetChart(ChartTypes type)
{
var products = await _dataRepository.GetProducts();
var chartData = products
.GroupBy(x => new { DateTime.Parse(x.DateOfPurchase).Year, DateTime.Parse(x.DateOfPurchase).Month })
.Select(x => new
{
Key = string.Format($"{x.Key.Year}, {x.Key.Month}"),
Value = type switch
{
ChartTypes.purchase => Math.Round(x.Sum(product => product.PurchasePrice), 2),
ChartTypes.sold => Math.Round(x.Sum(product => product.SellingPrice.Value), 2),
_ => throw new ArgumentOutOfRangeException(nameof(type)),
}
})
/// <summary>
/// Constructor
/// </summary>
public ChartBreak(ChartTypes chartType) : base()
{
BreakType = BreakTypes.ChartBreak;
_chartType = chartType;
_chartData = new List <float>();
_xShift = 0;
_yShift = 0;
_legendScheme = new LegendScheme(ShapeTypes.Polygon);
_maxSize = 50;
_minSize = 10;
_barWidth = 10;
_alignType = AlignType.Center;
_view3D = false;
_thickness = 5;
_shpIdx = 0;
}
/// <summary>
/// Constructor
/// </summary>
public ChartSet()
{
_chartType = ChartTypes.BarChart;
_drawCharts = false;
_fieldNames = new List <string>();
_xShift = 0;
_yShift = 0;
_legendScheme = new LegendScheme(ShapeTypes.Polygon);
_maxSize = 50;
_minSize = 0;
_barWidth = 8;
_avoidCollision = true;
_alignType = AlignType.Center;
_view3D = false;
_thickness = 5;
}
// Add a template object to the tree
private void buttonAddTemplateObject_Click(object sender = null, EventArgs e = null)
{
// Check the type of the current chart
ChartTypes type = (ChartTypes)comboBoxTemplateType.SelectedIndex;
if (type == ChartTypes.UNKNOWN)
{
return;
}
var selection = modelRenderer_.getSelection();
int nSelection = selection.Count;
if (nSelection == 0)
{
return;
}
// Adding the object to the tree
string chart = listBoxTemplateCharts.SelectedItem.ToString();
if (charts_.dependency[chart] != null) // Cannot add items to the dependent chart
{
return;
}
if (isLineType(type))
{
TreeNode line = treeTemplateObjects.Nodes.Add("Line" + indLine_.ToString());
foreach (string item in selection)
{
line.Nodes.Add(item);
}
++indLine_;
Lines selLines = new Lines();
selLines.lineName_ = line.Text;
selLines.nodeNames_ = selection;
charts_.selection[chart].Add(selLines);
}
if (isNodeType(type))
{
foreach (string node in selection)
{
treeTemplateObjects.Nodes.Add(node);
Nodes selNode = new Nodes();
selNode.nodeName_ = node;
charts_.selection[chart].Add(selNode);
}
}
}
private void SetChartType()
{
if (_chartCtl != null && _chartCtl.Areas.Any())
{
ChartTypes selectedChartType = GetSelectedChartType();
RangeCalculationMode calculationMode = GetSelectedChartCalculationMode(selectedChartType);
foreach (ChartArea area in _chartCtl.Areas)
{
area.PrimaryAxis.RangeCalculationMode = calculationMode;
foreach (var item in area.Series)
{
item.Type = selectedChartType;
}
}
}
}
/// <summary>
/// Toggles the report.
/// </summary>
/// <param name="parameter">The parameter.</param>
private void ToggleSelection(object parameter)
{
string m_chartType = parameter.ToString();
if (m_chartType == "Column")
{
this.OlapChartType = ChartTypes.Column;
}
else if (m_chartType == "Stacking Column")
{
this.OlapChartType = ChartTypes.StackingColumn;
}
else if (m_chartType == "Stacking Column 100")
{
this.OlapChartType = ChartTypes.StackingColumn100;
}
}
private string chartTypeToString(ChartTypes type)
{
switch (type)
{
case ChartTypes.Pie:
return("p3");
case ChartTypes.Bar:
return("bvs");
case ChartTypes.Line:
return("lc");
default:
return("");
}
}
/// <summary>
/// Adds Statistics Denmark specific functionality for adding ChartArea.
/// </summary>
protected override void addChartArea()
{
base.addChartArea();
//Since the base chart component doesn't accept this based on the axis template
foreach (Axis axis in ChartAreas["Main"].Axes)
{
axis.TitleFont = Font.Regular;
axis.TitleForeColor = ColorTranslator.FromHtml("#4c4c4c");
}
float top = spaceUsedForTitle + space + spaceUsedForLegend + (spaceUsedForLegend > 0 ? space : 0) + space;
//float left = ChartTypes.Contains(SeriesChartType.Pie) ? 50 : 0;
float width = ChartTypes.Contains(SeriesChartType.Pie) ? 50 : 100;
ChartAreas["Main"].Position = new ElementPosition(0, top, width, 100 - top - SpaceUsedForInfoText);
}
// Creating dependency between charts with specified types
private void createDependency(ChartTypes masterType, ChartTypes slaveType)
{
string slaveChart = null;
string masterChart = null;
// Check if there are several charts with the same type.
// If it is the case, we do not have enough information to create dependencies
var listCharts = charts_.type.Keys;
int iMasterType = 0;
int iSlaveType = 0;
foreach (string chart in listCharts)
{
if (charts_.type[chart] == masterType)
{
++iMasterType;
}
if (charts_.type[chart] == slaveType)
{
++iSlaveType;
}
}
if (iMasterType > 1 || iSlaveType > 1)
{
return;
}
// Create dependencies
foreach (string chart in listCharts)
{
if (charts_.type[chart] == masterType)
{
masterChart = chart;
}
if (charts_.type[chart] == slaveType)
{
slaveChart = chart;
}
if (masterChart != null && slaveChart != null)
{
charts_.dependency[slaveChart] = masterChart;
break;
}
}
}
public static Chart CreateChartByAxises(Table table,string CellRange,ChartTypes type,int dimension)
{
Chart chart = CreateChart(table,type,CellRange);
if (dimension==1)
{
ChartAxis Yaxis = CreateAxis(chart,"y","primary-y");
chart.ChartPlotArea .AxisCollection .Add (Yaxis);
Yaxis.AxesStyle .AxesProperties .DisplayLabel = "true";
}
else if (dimension==2)
{
ChartAxis Yaxis = CreateAxis(chart,"y","primary-y");
chart.ChartPlotArea .AxisCollection .Add (Yaxis);
ChartAxis Xaxis = CreateAxis(chart,"x","primary-x");
chart.ChartPlotArea .AxisCollection .Add (Xaxis);
Yaxis.AxesStyle .AxesProperties .DisplayLabel = "true";
Xaxis.AxesStyle .AxesProperties .DisplayLabel = "true";
}
else
{
ChartAxis Yaxis = CreateAxis(chart,"y","primary-y");
chart.ChartPlotArea .AxisCollection .Add (Yaxis);
ChartAxis Xaxis = CreateAxis(chart,"x","primary-x");
chart.ChartPlotArea .AxisCollection .Add (Xaxis);
ChartAxis Zaxis = CreateAxis(chart,"z","primary-z");
chart.ChartPlotArea .AxisCollection .Add (Zaxis);
Yaxis.AxesStyle .AxesProperties .DisplayLabel = "true";
Xaxis.AxesStyle .AxesProperties .DisplayLabel = "true";
Zaxis.AxesStyle .AxesProperties .DisplayLabel = "true";
chart.ChartPlotArea .PlotAreaStyle.PlotAreaProperties.ThreeDimensional="true";
}
return chart;
}
public static Chart CreateChartByLegend(Table table,string CellRange,ChartTypes type,string legendPos,string Xpos,string Ypos,string XAxisname,string YAxisname)
{
Chart chart = CreateChart(table,type,CellRange);
chart.ChartLegend .LegendPosition = legendPos;
chart.ChartLegend .SvgX = Xpos;
chart.ChartLegend .SvgY = Ypos;
chart.XAxisName = XAxisname;
chart.YAxisName = YAxisname;
return chart;
}
/// <summary>
/// Custom Repository to be Invoked that Returns the Report Result
/// </summary>
public ChartReportAttribute(String name, String description, Type repository, ChartTypes chartType)
: base(name, description, repository)
{
ChartType = chartType;
}
public static string Type2Text(ChartTypes value)
{
switch (value)
{
case ChartTypes.Line: return Languages.Libs.GetString("line");
case ChartTypes.Bar: return Languages.Libs.GetString("bar");
case ChartTypes.CandleStick: return Languages.Libs.GetString("candleStick");
default: return "<"+Languages.Libs.GetString("select")+">";
}
}
public static string FormatWith(this string format, ChartTypes? value)
{
if (value != null)
return string.Format(format, value.Value.ToString().ToLowerInvariant());
return string.Empty;
}
public static Chart CreateChartByCellRange(Table table,string cellRange,ChartTypes type,string xAxisname,string yAxisname,string title,int dimension,string legendPos,string endCellAddress)
{
Chart chart;
if (dimension!=0&&dimension<=3)
{
chart = CreateChartByAxises(table,cellRange,type,dimension);
}
else
{
chart = CreateChart(table,type,cellRange);
}
if (xAxisname!=null)
chart.XAxisName = xAxisname;
if (yAxisname!=null)
chart.YAxisName = yAxisname;
if (title!=null)
chart.ChartTitle .SetTitle (title);
if (legendPos!=null)
chart.ChartLegend .LegendPosition = legendPos;
else
chart.ChartLegend .LegendPosition = "left";
if (endCellAddress!=null)
chart.EndCellAddress = table.TableName +"."+endCellAddress;
return chart;
}
private string chartTypeToString(ChartTypes type)
{
switch (type)
{
case ChartTypes.Pie:
return "p3";
case ChartTypes.Bar:
return "bvs";
case ChartTypes.Line:
return "lc";
default:
return "";
}
}
/// <summary>
/// Single Item Report. Will Generate a DropDown List to Select From
/// </summary>
public ChartReportAttribute(String name, String description, Type repository, Type model, Type listView, String[] listViewDisplayProperties, ChartTypes chartType)
: base(name, description, repository, model, listView, listViewDisplayProperties)
{
ChartType = chartType;
}
