Advertisement
Guest User

Untitled

a guest
Aug 28th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. [Route("Login")]
  2. [HttpPost]
  3. public async Task<UserSession> Login()
  4. {
  5. string input = await Request.Content.ReadAsStringAsync();
  6. dynamic data = Newtonsoft.Json.Linq.JObject.Parse(input);
  7. LoginUser user = new LoginUser();
  8. user.Email= data.email;
  9. user.Password = data.password;
  10. user.Token = data.token.ToObject<byte[]>();
  11. byte[] mSessionID = new Session().getToken(user.Token);
  12. /* using (System.Data.SqlClient.SqlConnection _conn = new System.Data.SqlClient.SqlConnection
  13. ("data source=devtest.dataquest.com.au;" + "initial catalog=Safe2Pay;" + "user id=sa;password=ipsec@21;"));
  14. using (System.Data.SqlClient.SqlCommand _cmdLoginDetails = new System.Data.SqlClient.SqlCommand(
  15. "INSERT into Login (" + "Email,Token,UserLogged)" + "VALUES(@user.Email,@Token,@UserLogged)", _conn))
  16. {
  17. System.Data.SqlClient.SqlParameter paramEmail = _cmdLoginDetails.Parameters.Add("@user.Email", System.Data.SqlDbType.NVarChar);
  18. System.Data.SqlClient.SqlParameter paramToken = _cmdLoginDetails.Parameters.Add("@Token", System.Data.SqlDbType.Binary);
  19. System.Data.SqlClient.SqlParameter paramUserLogged = _cmdLoginDetails.Parameters.Add(@UserLogge)
  20.  
  21. } */
  22. _conn = new System.Data.SqlClient.SqlConnection("data source=devtest.dataquest.com.au;" + "initial catalog=Safe2Pay;" + "user id=sa;password=ipsec@21;");
  23. System.Data.SqlClient.SqlCommand _cmdLoginDetails = new System.Data.SqlClient.SqlCommand("INSERT INTO Login ("+
  24. "Email, Token, UserLogged)"+
  25. "VALUES(@Email,@Token,@UserLogged)",_conn);
  26. _cmdLoginDetails.Parameters.Add("@Email", System.Data.SqlDbType.NVarChar, 30).Value = user.Email;
  27. _cmdLoginDetails.Parameters.Add("@Token", System.Data.SqlDbType.VarBinary).Value = mSessionID;
  28. _cmdLoginDetails.Parameters.Add("@UserLogged", System.Data.SqlDbType.Bit).Value = 1;
  29. _conn.Open();
  30. _cmdLoginDetails.ExecuteNonQuery();
  31. _conn.Close();
  32. return new UserSession
  33. {
  34. SessionID = mSessionID
  35. };
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement