asd

var express = require('express');
var app = express();
var ConnectionPool = require('tedious-connection-pool');
var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;
var async = require('async');

var poolConfig = {
  min: 2,
  max: 3,
  log: true
};

var config = {
  userName: 'wo_cliente',
  password: 'wo_cliente',
  server: '190.145.158.202',
  options: {
    encrypt: true
  }
}

var pool = new ConnectionPool(poolConfig, config);

var statement = "USE EMPRESA_PRUEBA SELECT IdInventario, CódigoInventario, Codigo_Producto, Descripción, Precio2, Precio3, Precio4 FROM Vista_Tabla_Inventarios WHERE Vista_Tabla_Inventarios.Clasificacion = 'Producto'";


function executeTest(callback) {
  pool.acquire(function (err, connection) {
    var results = [];

    var request = new Request(statement, function (error) {
      if (error) {
        return callback(error);
      }
      callback(null, results);
    });

    request.on("row", function (rowObject) {
      results.push(rowObject);
    });
    connection.execSql(request);
  });
}

function executeSelectProduct(product, callback) {
  pool.acquire(function (err, connection) {
    var results = [];
    var request = new Request("USE EMPRESA_PRUEBA SELECT Codigo_Producto, Precio2 FROM Vista_Tabla_Inventarios WHERE Vista_Tabla_Inventarios.Clasificacion = 'Producto' AND Vista_Tabla_Inventarios.Codigo_Producto = @Product;", function (error) {
      if (error) {
        return callback(error);
      }
      callback(null, results);
    });

    request.addParameter('Product', TYPES.NVarChar, product);

    request.on("row", function (rowObject) {
      results.push(rowObject);
    });
    connection.execSql(request);
  });
}

app.get('/product', function (req, res) {
  executeTest(function (error, results) {
    res.json(results);
  });

});


app.get('/product/:id', function (req, res) {
  executeSelectProduct(req.params.id, function (error, results) {
    res.json(results);
  });
});


var server = app.listen(5000, function () {
  console.log('Server is running..');
});