'use strict';


		var sql = require('mssql');

var config = {
    user: 'venovu@energiklart',
    password: '!fE92bXp4',
    server: 'energiklart.database.windows.net', // You can use 'localhost\\instance' to connect to named instance
    database: 'Energiklart',

    options: {
        encrypt: true // Use this if you're on Windows Azure
    }
}


module.exports = {
    get: function user_get(req, res) {
sql.connect(config).then(function() {
    // Query

    new sql.Request().query('select * from [venovu_com].[user]').then(function (recordset) {
       res.json(recordset)
    }).catch(function (err) {
        // ... error checks
    });
});


    },

	post: function user_post(req, res) {
	var transaction = new sql.Transaction(config);
	transaction.begin(function(err) {
    // ... error checks

    var request = new sql.Request(transaction);
    request.query('insert into [venovu_com].[user] (userName, userPass, phone, mail, root) values (borg, borg,01241, gmail.com, 1)', function(err, recordset) {
        // ... error checks

        transaction.commit(function(err, recordset) {


            console.log("Transaction committed.");
        });
    });
});


}
};