Guest User

Untitled

a guest
Jan 6th, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. <iron-ajax id="ajaxUser"
  2. url="http://localhost:8080/login"
  3. method="post"
  4. handle-as="json"
  5. params="[[params]]"
  6. on-response="saveUserCredentials"
  7. last-response="{{user}}"></iron-ajax>
  8.  
  9. <paper-input id="username"></paper-input>
  10. <paper-input id="password"></paper-input>
  11. <paper-button on-tap="loginUser"></paper-button>
  12.  
  13. loginUser() {
  14. this.params = {"username": this.$.username.value, "password": this.$.password.value};
  15. console.log(this.params); // logs this.params as populated JSON
  16. let request = this.$.ajaxUser.generateRequest();
  17. request.completes.then(req => {
  18. console.log(req); // logs <iron-request></iron-request>
  19. console.log(this.user); // logs []
  20. })
  21. .catch(rejected => {
  22. console.log(rejected.request); // not returned
  23. console.log(rejected.error); // not returned
  24. })
  25. }
  26.  
  27. saveUserCredentials() {
  28. console.log(this.user);
  29. }
  30.  
  31. app.post("/login", (req, res) => {
  32. session.login(req, res)
  33. })
  34.  
  35. exports.login = (req, res) => {
  36. sql.connect(config.properties)
  37. .then(pool => {
  38. pool.request()
  39. .input('user', sql.VarChar(50), req.body.username)
  40. .input('password', sql.VarChar(50), req.body.password)
  41. .query("SELECT role FROM Login WHERE username = @user AND password = @password")
  42. .then(response => res.send(response))
  43. .catch(err => res.send(err))
  44. })
  45. }
Add Comment
Please, Sign In to add comment