public void SumarioDatos(EntidadDashboard obj)
{
cmd = new MySqlCommand("Dashboard", ConexionDB.AbrirConexion());
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter total = new MySqlParameter("@totVentas", 0); total.Direction = ParameterDirection.Output;
MySqlParameter cantpro = new MySqlParameter("@cantProd", 0); cantpro.Direction = ParameterDirection.Output;
MySqlParameter cantCateg = new MySqlParameter("@cantCateg", 0); cantCateg.Direction = ParameterDirection.Output;
MySqlParameter cantEmple = new MySqlParameter("@cantEmple", 0); cantEmple.Direction = ParameterDirection.Output;
MySqlParameter cantProve = new MySqlParameter("@cantProve", 0); cantProve.Direction = ParameterDirection.Output;
MySqlParameter cantClient = new MySqlParameter("@cantClient", 0); cantClient.Direction = ParameterDirection.Output;
cmd.Parameters.Add(total);
cmd.Parameters.Add(cantpro);
cmd.Parameters.Add(cantCateg);
cmd.Parameters.Add(cantEmple);
cmd.Parameters.Add(cantProve);
cmd.Parameters.Add(cantClient);
ConexionDB.AbrirConexion();
cmd.ExecuteNonQuery();
obj.TotalVentas1 = cmd.Parameters["@totVentas"].Value.ToString();
obj.CantProductos1 = cmd.Parameters["@cantProd"].Value.ToString();
obj.CantCateg1 = cmd.Parameters["@cantCateg"].Value.ToString();
obj.CantEmple1 = cmd.Parameters["@cantEmple"].Value.ToString();
obj.CantProv1 = cmd.Parameters["@cantProve"].Value.ToString();
obj.CantClient1 = cmd.Parameters["@cantClient"].Value.ToString();
ConexionDB.CerrarConexion();
}
public void Dashboard(EntidadDashboard obj)
{
DataDashboard accesDB = new DataDashboard();
accesDB.ProdPorCategoria(obj);
accesDB.ProdPreferidos(obj);
accesDB.SumarioDatos(obj);
}
public void ProdPreferidos(EntidadDashboard obj)
{
cmd = new MySqlCommand("ProdPreferidos", ConexionDB.AbrirConexion());
cmd.CommandType = CommandType.StoredProcedure;
ConexionDB.AbrirConexion();
dr = cmd.ExecuteReader();
while (dr.Read())
{
obj.Producto1.Add(dr.GetString(0));
obj.Cant1.Add(dr.GetInt32(1));
}
dr.Close();
ConexionDB.AbrirConexion();
}
public void ProdPorCategoria(EntidadDashboard obj)
{
cmd = new MySqlCommand("ProdPorCategoria", ConexionDB.AbrirConexion());
cmd.CommandType = CommandType.StoredProcedure;
ConexionDB.AbrirConexion();
dr = cmd.ExecuteReader();
while (dr.Read())
{
obj.Categoria1.Add(dr.GetString(0));
obj.CantProd1.Add(dr.GetInt32(1));
}
dr.Close();
ConexionDB.CerrarConexion();
}
private void Dashboard()
{
LogicaDashboard neg = new LogicaDashboard();
EntidadDashboard obj = new EntidadDashboard();
neg.Dashboard(obj);
//recuperamos datos de entidad para cargarlos los datos de Dashboard
chartProdPreferidos.Series[0].Points.DataBindXY(obj.Producto1, obj.Cant1);
chartProdxCategoria.Series[0].Points.DataBindXY(obj.Categoria1, obj.CantProd1);
lblCantCateg.Text = obj.CantCateg1;
lblCantClient.Text = obj.CantClient1;
lblCantEmple.Text = obj.CantEmple1;
lblCantProv.Text = obj.CantProv1;
lblTotalVentas.Text = obj.TotalVentas1;
lblCantProd.Text = obj.CantProductos1;
}
