protected void cargaCategoriaMes()
{
int numeroMes = Convert.ToInt32(DropDownListMeses.SelectedValue);
using (SqlConnection conexionDB = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
string query = @"select COUNT(tickets.categoria_id) as cantidad, categorias.categoria as categoria
from tickets join categorias
on tickets.categoria_id = categorias.categoria_id
where tickets.solucionado = 1 and DATEPART(MONTH, fecha)=@mesNumero
group by tickets.categoria_id, categorias.categoria
order by categorias.categoria";
SqlCommand cmd = new SqlCommand(query);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@mesNumero", numeroMes);
cmd.Connection = conexionDB;
conexionDB.Open();
SqlDataAdapter adaptador = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adaptador.Fill(ds);
DataTable tabla = ds.Tables[0];
ChartFinal.DataSource = tabla;
ChartFinal.Series[0].XValueMember = "categoria";
ChartFinal.Series[0].YValueMembers = "cantidad";
ChartFinal.Series[0].ChartType = SeriesChartType.Pie;
ChartFinal.ChartAreas[0].AxisX.Title = "Test TEst";
ChartFinal.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartFinal.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartFinal.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conexionDB = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
string query = @"select COUNT(tickets.categoria_id) as cantidad, categorias.categoria as categoria
from tickets join categorias
on tickets.categoria_id = categorias.categoria_id
where tickets.solucionado = 1 and DATEPART(MONTH, fecha)=@mesNumero
group by tickets.categoria_id, categorias.categoria
order by COUNT(tickets.categoria_id)";
SqlCommand cmd = new SqlCommand(query);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@mesNumero", 2);
cmd.Connection = conexionDB;
conexionDB.Open();
SqlDataAdapter adaptador = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adaptador.Fill(ds);
DataTable tabla = ds.Tables[0];
DataView dataView = new DataView(tabla);
ChartFinal.DataSource = tabla;
ChartFinal.Series[0].XValueMember = "categoria";
ChartFinal.Series[0].YValueMembers = "cantidad";
ChartFinal.ChartAreas[0].AxisX.Title = "Test TEst";
ChartFinal.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
ChartFinal.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
ChartFinal.DataBind();
}
}
}
