var express = require('express');
var path = require('path');

var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var http = require('http');
var url = require('url');
var dbUtils = require('./modules/dbUtils');
var app = express();

app.use(bodyParser.json());



app.post('/login', function(request, response) {
    var result = {error: '', message:''};

    console.log(request.body);
    var userName = request.body.userName;
    var password = request.body.password;
    dbUtils.VerifyCredentials(userName, password, result);
    console.log('login response was:::::' + result);
    response.setHeader('content-type', 'application/json');
    response.end(JSON.stringify(result));
});

http.createServer(app).listen(8080, function() {
    console.log('Express server listening on port 8080');
});

var sql = require('seriate');
var config = {
    "name"  : "******",
    "host"  : "10.1.1.1",
    "port"  : 1433,
    "user"      : "*******",
    "password"  : "*******",
    "database"  : "*******"
};


sql.setDefaultConfig(config);

var verifyCredentials = function(userName, password, result) {
    sql.execute({
        query : 'Select count(*) as rowsReturned from dbo.tblUsers where   UserName = @userName and Password = @password',
        params: {
            userName    : {
                type    : sql.VARCHAR,
                val     : userName
            },
            password    : {
                type    : sql.VARCHAR,
                val     : password
            }
        }
    }).then(function(results) {
        result.data = results;
        console.log(result.data);
    }, function (err) {
        result.error = err.message;
    });
};

module.exports = {
        VerifyCredentials : verifyCredentials
};