public Chart Draw(params string[] filtros)
{
// Create a new instance of Chart
Chart chart = new Chart();
chart.AnimationEnabled = true;
// Create a new instance of Title
Title title = new Title();
// Set title property
title.Text = "AREA";
// Add title to Titles collection
chart.Titles.Add(title);
// Create a new instance of DataSeries
DataSeries dataSeries = new DataSeries();
// Set DataSeries property
dataSeries.RenderAs = RenderAs.Area;
#region configuracion eje X
// Creating AxisX
Axis axisX = new Axis();
// Date time standard format
//axisX.ValueFormatString = "000000";
// To avoid auto skip
chart.AxesX.Add(axisX);
#endregion
// Create a DataPoint
DataPoint dataPoint;
DataPoint dataPoint2;
DataPoint dataPointClientes;
#region consulta
DataTable kpis;
DataTable kpiClientes;
try
{
kpis = new DataTable();
Consultas consulta = new Consultas();
kpis = consulta.SelectParametros().Tables[0];
kpiClientes = new DataTable();
if (filtros[0] != "Todos")
kpiClientes = consulta.SelectPointsClientesFiltrado(filtros[0]).Tables[0];
else
kpiClientes = consulta.SelectPointsClientes().Tables[0];
consulta = null;
string serAnt = "-5555";
string ser = "-1111";
foreach (DataRow g in kpis.Rows)
{
Decimal? y = g["y"] != DBNull.Value ? (Decimal?)g["y"] : null;
Decimal? x = (Decimal?)g["minbudi"];
Decimal? x2 = (Decimal?)g["maxbudi"];
ser = (string)g["segment"];
ser = ser.ToUpper();
//Creando las series
if (serAnt != ser)
{
if (serAnt != "-5555")
{
chart.Series.Add(dataSeries);
}
// Create a new instance of DataSeries
dataSeries = new DataSeries();
dataSeries.Name = ser;
// Set DataSeries property
dataSeries.RenderAs = RenderAs.Area;
//dataSeries.MarkerType = Visifire.Commons.MarkerTypes.Circle;
dataSeries.SelectionEnabled = true;
//dataSeries.LineThickness = 3;
dataSeries.ToolTipText = null;
}
// Create a new instance of DataPoint
dataPoint = new DataPoint();
dataPoint.XValue = System.Convert.ToDouble(x);
dataPoint.YValue = System.Convert.ToDouble(y);
// Add dataPoint to DataPoints collection.
dataSeries.DataPoints.Add(dataPoint);
// Create a new instance of DataPoint
dataPoint2 = new DataPoint();
dataPoint2.XValue = System.Convert.ToDouble(x2);
dataPoint2.YValue = System.Convert.ToDouble(y);
dataSeries.DataPoints.Add(dataPoint2);
serAnt = ser;
}
if (ser != "-1111")
{
chart.Series.Add(dataSeries);
}
serAnt = "-5555";
ser = "-1111";
string cliente;
foreach (DataRow g in kpiClientes.Rows)
{
Decimal? x = (Decimal?)g["TotalBudi"];
Decimal? y = (Decimal?)g["CPW"];
cliente = (string)g["NombrePos"];
ser = "Clientes";
//Creando las series
if (serAnt != ser)
{
if (serAnt != "-5555")
{
chart.Series.Add(dataSeries);
}
// Create a new instance of DataSeries
dataSeries = new DataSeries();
dataSeries.Name = ser;
dataSeries.RenderAs = RenderAs.Point;
dataSeries.SelectionEnabled = true;
}
Decimal? valorXreal=x;
Decimal? valorYreal=y;
if(x>4)
x=4;
if (y > 2500)
y = 2500;
// Create a new instance of DataPoint
dataPointClientes = new DataPoint();
dataPointClientes.XValue = System.Convert.ToDouble(x);
dataPointClientes.YValue = System.Convert.ToDouble(y);
dataPointClientes.ToolTipText ="NOMBRE CLIENTE: "+cliente+"\nTOTAL BUDI:"+ valorXreal.ToString() + "\nCPW: " + valorYreal.ToString();
dataSeries.DataPoints.Add(dataPointClientes);
serAnt = ser;
}
// Add dataSeries to Series collection.
if (ser != "-1111")
{
chart.Series.Add(dataSeries);
}
return chart;
}
catch (Exception Error)
{
throw (new Exception(Error.ToString()));
}
#endregion
}