Untitled

<!doctype html>
<html lang="en">
  <head>
    <title>Users</title>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="E:Projectsnode_modulesbootstrapdistcssbootstrap.css">
  </head>
  <body>
    <h1><center>Add a new user</center></h1><br>

    <center>
      <form action = "http://127.0.0.1:8080/api/user" method = "POST" enctype = "multipart/form-data">
         <input type ="text" name ="first_name" placeholder="Enter First Name"><br>
         <br>
         <input type ="text" name = "last_name" placeholder="Enter Last Name"><br>
         <br>
         <input type="radio" name="gender" id="male" value="male"> Male
         <input type="radio" name="gender" id="female" value="female"> Female
         <input type="radio" name="gender" id="other" value="other"> Other<br>
         <br>
         <input type = "submit" value = "Submit">
      </form><br>
    </center>

    <h1><center>List all users</center></h1><br>

    <center>
      <form action = "http://127.0.0.1:8080/api/user" method = "GET">
         <input type = "submit" value = "Go get'em!">
      </form>
    </center>

    <!-- Optional JavaScript -->
      <script src="sql.js"></script>
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js" integrity="sha384-vFJXuSJphROIrBnz7yo7oB41mKfc8JzQZiCq4NCceLEaO4IHwicKwpJf9c9IpFgh" crossorigin="anonymous"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
  </body>
</html>

//Initiallising node modules
var express = require('express');
var app = express();
var bodyParser = require('body-parser');
var sql = require("mssql");
var form = require('multer');

// Body Parser Middleware
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
var urlencodedParser = bodyParser.urlencoded({ extended: false });
app.use(bodyParser.text({ type: 'text/html' }));

//CORS Middleware
app.use(function (req, res, next) {
    //Enabling CORS
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Methods", "GET,HEAD,OPTIONS,POST,PUT");
    res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, contentType,Content-Type, Accept, Authorization");
    next();
});

//Setting up server
 var server = app.listen(process.env.PORT || 8080, function () {
    var port = server.address().port;
    console.log("App now running on port", port);
 });

// Configure database connection
var dbConfig = {
    user: 'user',
    domain: 'domain',
    password: 'password',
    server: 'server',
    database: 'database'
};


//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
                         request.query(query, function (err, rs) {
                           if (err) {
                                      console.log("Error while querying database :- " + err);
                                      res.send(err);
                                     }
                                     else {
                                       res.send(rs);
                                       sql.close();
                                            }
                               });
                       }
      });
};

//GET API
app.get("/api/user", function(req , res){
                var query = "select * from [Names]";
                executeQuery (res, query);
});

// //POST API
app.post('/api/user', function (req, res) {
    res.setHeader('Content-Type', 'text/plain');
    // connect to your database
    sql.connect(dbConfig, function (err) {
        if (err) console.log(err);

        // create Request object
        var request = new sql.Request();
        request.input('first_name',sql.VarChar,req.body.first_name);
        request.input('last_name',sql.VarChar,req.body.last_name);
        request.input('gender',sql.VarChar,req.body.gender);

        request.query("INSERT INTO Names (First_Name, Last_Name, Gender) VALUES (@first_name, @last_name, @gender)", function (err, recordset) {
            if (err) console.log(err);
            // send records as a response
            res.send(recordset);
            sql.close();
        });
    });
});

// //POST API
//  app.post("/api/user", function(req , res){
//                 //var query = "INSERT INTO Names (First_Name, Last_Name, Gender) VALUES ('Test', 'User', 'Female')";
//                 var query = "INSERT INTO Names (First_Name,Last_Name,Gender) VALUES ()";
//                 executeQuery (res, query);
// });

//PUT API
 app.put("/api/user/:id", function(req , res){
                var query = "UPDATE [Names] SET First_Name= " + req.body.first_name  +  " , Last_Name=  " + req.body.last_name + " , Gender=  " + req.body.gender + "  WHERE Id= " + req.params.id;
                executeQuery (res, query);
});

// DELETE API
 app.delete("/api/user/:id", function(req , res){
                var query = "DELETE FROM [Names] WHERE Id=" + req.params.id;
                executeQuery (res, query);
});