Guest User

Untitled

a guest
Sep 26th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. router.post('/api/v1/Login', jsonParser, function(req, res){
  2. if(!req.body)
  3. return res.sendStatus(400)
  4. console.log(req.body);
  5.  
  6. var UsuarioReg = req.body.user;
  7. var ContraReg = req.body.pass;
  8.  
  9. console.log("User: "+UsuarioReg + " Contraseña: "+ContraReg)
  10.  
  11.  
  12. var request = new sql.Request();
  13.  
  14. try{
  15.  
  16. request.query("SELECT * FROM dbo.[Client] WHERE username = '"+UsuarioReg+"'AND pass = '"+ContraReg+"'", function (err, recordset) {
  17. if(err){
  18. console.log(err);
  19. }else{
  20. if(recordset.rowsAffected > 0){
  21. res.write(JSON.stringify("Usuario identificado correctamente"))
  22.  
  23. console.log("Usuario identificado correctamente")
  24.  
  25. const user = {id: 3};
  26. const token = jwt.sign({ user },'my_secret_key');
  27.  
  28. res.json({
  29. token:token
  30. });
  31. }
  32. }
  33. })
  34. }catch(err){
  35. res.send(JSON.stringify("Error while querying database :- "+err))
  36. console.log("Error while querying database :- "+err)
  37. }
  38.  
  39. });
  40.  
  41. app.use((req, res, next) => {
  42.  
  43. // Dominio que tengan acceso (ej. 'http://example.com')
  44. res.setHeader('Access-Control-Allow-Origin', '*');
  45.  
  46. // Metodos de solicitud que deseas permitir
  47. res.setHeader('Access-Control-Allow-Methods', 'GET, POST, PUT, DELETE');
  48.  
  49. // Encabecedados que permites (ej. 'X-Requested-With,content-type')
  50. res.setHeader('Access-Control-Allow-Headers', '*');
  51.  
  52. next();
  53. })
  54.  
  55. const cors = require('cors')
  56. app.use(cors())
Add Comment
Please, Sign In to add comment