Advertisement
Guest User

Untitled

a guest
Mar 4th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. private string conn;
  2. private MySqlConnection connect;
  3. string user = txt_username.Text;
  4. string pass = passwordbox_psw.Password;
  5.  
  6. private void DbConnection()
  7. {
  8. try
  9. {
  10. conn = "*connectionstring*";
  11. connect = new MySqlConnection(conn);
  12. connect.Open();
  13. }
  14. catch (MySqlException ex)
  15. {
  16. this.ShowMessageAsync("Connection to the database refused. n", ex.Message);
  17. }
  18. }
  19.  
  20. private bool ValidateLogin(string user, string pass)
  21. {
  22. DbConnection();
  23. MySqlCommand cmd = new MySqlCommand();
  24. cmd.CommandText = "Select * from user where username=@user
  25. and password=@password limit 1";
  26. cmd.Parameters.Add("@user", MySqlDbType.VarChar).Value = txt_username.Text;
  27. cmd.Parameters.Add("@password",MySqlDbType.VarChar).Value= passwordbox_psw.Password;
  28. cmd.Connection = connect;
  29. MySqlDataReader login = cmd.ExecuteReader();
  30. if (login.Read())
  31. {
  32. connect.Close();
  33. return true;
  34. }
  35. else
  36. {
  37. connect.Close();
  38. return false;
  39. }
  40. }
  41.  
  42. public static bool CheckPassword(string password, string hashedpassword)
  43. {
  44. if (BCryptHelper.CheckPassword(password, hashedpassword))
  45. return true;
  46. else
  47. return false;
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement