protected void Page_Load(object sender, System.EventArgs e)
{
// Populate series data
Random random = new Random();
for (int pointIndex = 0; pointIndex < 10; pointIndex++)
{
Chart1.Series["Series1"].Points.AddY(Math.Round((double)random.Next(45, 95), 0));
Chart1.Series["Series2"].Points.AddY(Math.Round((double)random.Next(5, 75), 0));
Chart1.Series["Series3"].Points.AddY(Math.Round((double)random.Next(5, 95), 0));
Chart1.Series["Series4"].Points.AddY(Math.Round((double)random.Next(35, 95), 0));
}
// Set chart type
string chartTypeName = ChartTypeList.SelectedItem.Text;
if (HundredPercentStacked.Checked)
{
chartTypeName = chartTypeName + "100";
}
// Grouping cannot be done using stacked area charts
if (chartTypeName == "StackedArea" || chartTypeName == "StackedArea100")
{
this.checkBoxGrouped.Enabled = false;
}
else
{
this.checkBoxGrouped.Enabled = true;
}
Chart1.Series["Series1"].ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), chartTypeName, true);
Chart1.Series["Series2"].ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), chartTypeName, true);
Chart1.Series["Series3"].ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), chartTypeName, true);
Chart1.Series["Series4"].ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), chartTypeName, true);
// Show point labels
if (ShowLabels.Checked)
{
Chart1.Series["Series1"].IsValueShownAsLabel = true;
Chart1.Series["Series2"].IsValueShownAsLabel = true;
Chart1.Series["Series3"].IsValueShownAsLabel = true;
Chart1.Series["Series4"].IsValueShownAsLabel = true;
}
// Set X axis margin for the area chart
Chart1.ChartAreas["ChartArea1"].AxisX.IsMarginVisible = ShowMargins.Checked;
// Show as 2D or 3D
if (checkBoxShow3D.Checked)
{
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
}
else
{
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = false;
}
if (checkBoxGrouped.Checked)
{
Chart1.Series["Series1"]["StackedGroupName"] = "Group1";
Chart1.Series["Series2"]["StackedGroupName"] = "Group1";
Chart1.Series["Series3"]["StackedGroupName"] = "Group2";
Chart1.Series["Series4"]["StackedGroupName"] = "Group2";
Chart1.ResetAutoValues();
}
else
{
foreach (Series series in Chart1.Series)
{
series["StackedGroupName"] = "";
}
Chart1.ResetAutoValues();
}
}
protected void ListarGrafico()
{
string IDE_OBJETIVO = string.Empty;
if (ddlObejtivos.SelectedIndex == 0)
{
IDE_OBJETIVO = string.Empty;
}
else
{
IDE_OBJETIVO = ddlObejtivos.SelectedValue.ToString();
}
BL_RRHH_DESEMPENIO_OBJETIVOS obj = new BL_RRHH_DESEMPENIO_OBJETIVOS();
DataTable dtResultado = new DataTable();
dtResultado.Clear();
dtResultado = obj.uspSEL_RRHH_DESEMPENIO_GRAFICO(lblPersonal.Text, Convert.ToInt32(Session["ANIO"]), IDE_OBJETIVO);
DataTable dt = dtResultado;
/*
* string[] x = new string[dt.Rows.Count];
* int[] y = new int[dt.Rows.Count];
*
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* x[i] = dt.Rows[i]["OBJ"].ToString();
* y[i] = Convert.ToInt32(dt.Rows[i]["AVANCE"]);
* }
* Chart1.Series["Series1"].Points.DataBindXY(x, y);
*
* Chart1.Series[0].ChartType = SeriesChartType.Column;
* Chart1.Series["Series1"].Label = "#PERCENT";
* Chart1.Series[0].LegendText = "#VALX";
* Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
* Chart1.Legends["Series1"].Enabled = true;
*
*
* string[] x2 = new string[dt.Rows.Count];
* int[] y2 = new int[dt.Rows.Count];
* string[] l2 = new string[dt.Rows.Count];
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* x2[i] = dt.Rows[i]["obj2"].ToString();
* y2[i] = Convert.ToInt32(dt.Rows[i]["TOTAL_TRANSCURRIDOS"]);
* l2[i] = dt.Rows[i]["LEYENDA_TRANSCURRIDOS"].ToString();
*
* }
* Chart2.Series[0].Points.DataBindXY(x2, y2);
* Chart2.Series[0].ToolTip = l2.ToString();
* Chart2.Series[0].IsValueShownAsLabel = true;
* Chart2.Series[0].ChartType = SeriesChartType.Column;
*/
//Chart1.ResetAutoValues();
Chart1.Series[0].Points.Clear();
Chart1.Series["Series1"].Points.Clear();
Chart1.ResetAutoValues();
Chart1.DataSource = dtResultado;
Chart1.DataBind();
Chart1.Series[0].IsValueShownAsLabel = true;
//Chart1.Series["Series1"].Label = "#PERCENT";
Chart2.DataSource = dtResultado;
Chart2.DataBind();
Chart2.Series[0].IsValueShownAsLabel = true;
Chart2.Series[1].IsValueShownAsLabel = true;
Chart2.Series[0].LegendText = "Días transcurridos";
Chart2.Series[1].LegendText = "Total de días";
}
private void View_Click(object sender, EventArgs e)
{
Chart1.Series.Clear();
Chart1.ResetAutoValues();
int height = Chart1.Height;
Chart1.Height = 1;
Chart1.Height = height;
Dictionary <string, int> chart = new Dictionary <string, int>();
foreach (Skola s in Data)
{
switch (Options1.SelectedIndex)
{
case 0:
{
if (!chart.ContainsKey(s.pbroj))
{
if (Options2.SelectedIndex == 0)
{
chart.Add(s.pbroj, 1);
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart.Add(s.pbroj, a);
}
}
else
{
if (Options2.SelectedIndex == 0)
{
chart[s.pbroj] += 1;
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart[s.pbroj] += a;
}
}
break;
}
case 1:
{
if (!chart.ContainsKey(s.mesto))
{
if (Options2.SelectedIndex == 0)
{
chart.Add(s.mesto, 1);
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart.Add(s.mesto, a);
}
}
else
{
if (Options2.SelectedIndex == 0)
{
chart[s.mesto] += 1;
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart[s.mesto] += a;
}
}
break;
}
case 2:
{
if (!chart.ContainsKey(s.opstina))
{
if (Options2.SelectedIndex == 0)
{
chart.Add(s.opstina, 1);
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart.Add(s.opstina, a);
}
}
else
{
if (Options2.SelectedIndex == 0)
{
chart[s.opstina] += 1;
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart[s.opstina] += a;
}
}
break;
}
case 3:
{
if (!chart.ContainsKey(s.okrug))
{
if (Options2.SelectedIndex == 0)
{
chart.Add(s.okrug, 1);
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart.Add(s.okrug, a);
}
}
else
{
if (Options2.SelectedIndex == 0)
{
chart[s.okrug] += 1;
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart[s.okrug] += a;
}
}
break;
}
case 4:
{
if (!chart.ContainsKey(s.suprava))
{
if (Options2.SelectedIndex == 0)
{
chart.Add(s.suprava, 1);
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart.Add(s.suprava, a);
}
}
else
{
if (Options2.SelectedIndex == 0)
{
chart[s.suprava] += 1;
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart[s.suprava] += a;
}
}
break;
}
case 5:
{
if (!chart.ContainsKey(s.vrsta))
{
if (Options2.SelectedIndex == 0)
{
chart.Add(s.vrsta, 1);
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart.Add(s.vrsta, a);
}
}
else
{
if (Options2.SelectedIndex == 0)
{
chart[s.vrsta] += 1;
}
else
{
int a;
int.TryParse(s.odeljenja, out a);
chart[s.vrsta] += a;
}
}
break;
}
}
}
foreach (KeyValuePair <string, int> entry in chart)
{
Series series = Chart1.Series.Add(entry.Key);
series.Points.Add(entry.Value);
}
}
