var dbConfig = {
user: 'CAU',
password: '123',
server: '192.168.1.201',
database: 'CAISSE',
stream: true, // You can enable streaming globally
options: {
    encrypt: true // Use this if you're on Windows Azure
 }
};

//Function to connect to database and execute query
    var  executeQuery = function(res, query){
 sql.connect(dbConfig, function (err) {
    if (err) {
        console.log("Error while connecting database :- " + err);
        res.send(err);
    }
    else {
        // create Request object
        var request = new sql.Request();
        // query to the database
        var tab = []
        request.query(query,function (err, rs) {
            if (err) {
                console.log("Error while querying database :- " + err);
                res.send(err);
                sql.close();
            }
            else {
                var ros =  JSON.stringify(rs)
                res.send(rs)
                //console.log('rs = ' +ros);
                sql.close()
            }
        });
    }

    var request = new sql.Request()

    request.on('done', function(returnValue) {
        sql.close()
    });
});

}

//GET API
app.get("/", function(req , res){
var query = "select * from F_FAMILLE";

executeQuery (res, query);

});

//POST API
app.post("/api", function(req , res){
console.log(req.body);


const data = req.body


var query = 'INSERT INTO F_Famille(FA_CodeFamille,FA_Intitule) VALUES
(data.codefamille,data.intitule)'

executeQuery (res, query);

});