public DataTable ListarCategoria()
{
sqlConnection = conexion.GetConnection();
SqlDataAdapter adapter = new SqlDataAdapter("SP_LISTAR_CATEGORIAS", sqlConnection);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
return(dataTable);
}
public DataTable ListarMarcas()
{
sqlConnection = conexion.GetConnection();
SqlDataAdapter adapter = new SqlDataAdapter("SP_LISTAR_MARCAS", sqlConnection);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
return(dataTable);
}
public DataTable ListarInventario()
{
sqlConnection = conexion.GetConnection();
SqlDataAdapter adapter = new SqlDataAdapter("SP_LISTAR_INVENTARIOS", sqlConnection);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
return(dataTable);
}
public DataTable ListarProductos()
{
sqlConnection = conexion.GetConnection();
SqlDataAdapter adapter = new SqlDataAdapter("SP_LISTAR_PRODUCTOS", sqlConnection);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
return(dataTable);
}
public DataTable ListarJugadores()
{
sqlConnection = conexion.GetConnection();
SqlDataAdapter adapter = new SqlDataAdapter("SP_LISTAR_JUGADORES", sqlConnection);
DataTable dt = new DataTable();
adapter.Fill(dt);
return(dt);
}
public DataTable ListarDetalleInventario(int idTienda)
{
sqlConnection = conexion.GetConnection();
SqlCommand cmd = new SqlCommand("SP_LISTAR_DETALLE_INVENTARIO", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IDTIENDA", SqlDbType.Int).Value = idTienda;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
return(dt);
}
