/// <summary>
/// Updates the chart displaying data on the Form.
/// </summary>
private void UpdateAllChart()
{
if (Grid.TimePassed > 200)
{
ChartTotal.Series["TotalPwProduction"].Points.RemoveAt(0);
ChartTotal.Series["TotalPwRequest"].Points.RemoveAt(0);
ChartTotal.Series["PwDeficit"].Points.RemoveAt(0);
ChartTotal.Series["TotalCO2Emission"].Points.RemoveAt(0);
ChartTotal.Series["TotalOperatingCost"].Points.RemoveAt(0);
foreach (Series series in ChartNode.Series)
{
series.Points.RemoveAt(0);
}
}
ChartTotal.Series["TotalPwProduction"].Points.AddY(Grid.TotalPwProduction);
ChartTotal.Series["TotalPwRequest"].Points.AddY(Grid.TotalPwRequest);
ChartTotal.Series["PwDeficit"].Points.AddY(Grid.PwDeficit);
ChartTotal.Series["TotalCO2Emission"].Points.AddY(Grid.TotalCO2Emission);
ChartTotal.Series["TotalOperatingCost"].Points.AddY(Grid.TotalOperatingCost);
for (int i = 0; i < Grid.List_Node.Count; i++)
{
if (Grid.List_Node[i] is Plant)
{
Plant Plant = Grid.List_Node[i] as Plant;
ChartNode.Series[Plant.Name].Points.AddY(Plant.PwProduction);
}
else if (Grid.List_Node[i] is Consumer)
{
Consumer Consumer = Grid.List_Node[i] as Consumer;
ChartNode.Series[Consumer.Name].Points.AddY(Consumer.PwRequest);
}
}
ChartTotal.ResetAutoValues();
ChartNode.ResetAutoValues();
}
protected void cargaFrecuencias()
{
int numMes = Convert.ToInt32(DropDownListMes.SelectedValue);
using (SqlConnection conexionDB = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("estadisticasCategorias", conexionDB);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@numMes", numMes);
conexionDB.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter adaptador = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adaptador.Fill(ds);
DataTable tbTotal = ds.Tables[0];
DataTable tbMes = ds.Tables[1];
ChartTotal.DataSource = tbTotal;
ChartTotal.Series[0].XValueMember = "categoria";
ChartTotal.Series[0].YValueMembers = "cantidad";
ChartTotal.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartTotal.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartTotal.ChartAreas[0].AxisY.Title = "Numero de tickets";
ChartTotal.DataBind();
ChartTotalMes.DataSource = tbMes;
ChartTotalMes.Series[0].XValueMember = "categoria";
ChartTotalMes.Series[0].YValueMembers = "cantidad";
ChartTotalMes.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartTotalMes.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartTotalMes.ChartAreas[0].AxisY.Title = "Numero de tickets";
ChartTotalMes.DataBind();
}
}
protected void cargaFrecuencias()
{
int responsable_id = DropDownListResponsable.SelectedIndex + 1;
int numMes = Convert.ToInt32(DropDownListMes.SelectedValue);
using (SqlConnection conexionDB = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("estadisticasResponsables", conexionDB);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@numMes", numMes);
cmd.Parameters.AddWithValue("@responsable_id", responsable_id);
conexionDB.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter adaptador = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adaptador.Fill(ds);
DataTable tbTotal = ds.Tables[0];
DataTable tbMes = ds.Tables[1];
DataTable tbPromedio = ds.Tables[2];
DataTable tbSolMes = ds.Tables[3];
DataTable tbSolCategoria = ds.Tables[4];
ChartTotal.DataSource = tbTotal;
ChartTotal.Series[0].XValueMember = "nombre";
ChartTotal.Series[0].YValueMembers = "cantidad";
ChartTotal.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartTotal.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartTotal.ChartAreas[0].AxisY.Title = "Numero de tickets";
ChartTotal.DataBind();
ChartTotalMes.DataSource = tbMes;
ChartTotalMes.Series[0].XValueMember = "nombre";
ChartTotalMes.Series[0].YValueMembers = "cantidad";
ChartTotalMes.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartTotalMes.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartTotalMes.ChartAreas[0].AxisY.Title = "Numero de tickets";
ChartTotalMes.DataBind();
// por responsable
DataRow row = tbPromedio.Rows[0];
lblPromedioMinutos.Text = Convert.ToString(row["promedioMinutos"]);
ChartMesResponsable.DataSource = tbSolMes;
ChartMesResponsable.Series[0].XValueMember = "mes";
ChartMesResponsable.Series[0].YValueMembers = "solucionados";
ChartMesResponsable.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartMesResponsable.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartMesResponsable.ChartAreas[0].AxisY.Title = "Numero de tickets";
ChartMesResponsable.DataBind();
ChartCategoria.DataSource = tbSolCategoria;
ChartCategoria.Series[0].XValueMember = "categoria";
ChartCategoria.Series[0].YValueMembers = "cantidad";
ChartCategoria.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartCategoria.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartCategoria.ChartAreas[0].AxisY.Title = "Numero de tickets";
ChartCategoria.DataBind();
}
}
