Advertisement
Guest User

Untitled

a guest
Aug 29th, 2016
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.20 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using MySql.Data.MySqlClient;
  11.  
  12. namespace Project_Royal
  13. {
  14. public partial class Login : Form
  15. {
  16. private MySqlConnection conn;
  17. private string server;
  18. private string database;
  19. private string uid;
  20. private string password;
  21.  
  22. public Login()
  23. {
  24. server = "82.197.130.215";
  25. database = "2190559_users";
  26. uid = "2190559_users";
  27. password = "";
  28.  
  29. string connString;
  30. connString = $"SERVER={server};DATABASE={database};UID={uid};PASSWORD={password};";
  31.  
  32. conn = new MySqlConnection(connString);
  33.  
  34. InitializeComponent();
  35. }
  36.  
  37. private void button2_Click(object sender, EventArgs e)
  38. {
  39. string user = textBox1.Text;
  40. string pass = textBox2.Text;
  41. if (Register(user, pass))
  42. {
  43. MessageBox.Show($"User {user} has been created!");
  44. }
  45. else
  46. {
  47. MessageBox.Show($"User {user} has not been created!");
  48. }
  49. }
  50.  
  51. private void button1_Click(object sender, EventArgs e)
  52. {
  53. string user = textBox1.Text;
  54. string pass = textBox2.Text;
  55. if (IsLogin(user, pass))
  56. {
  57. MessageBox.Show($"Welcome {user}!");
  58. }
  59. else
  60. {
  61. MessageBox.Show($"{user} does not exist or password is incorrect!");
  62. }
  63. }
  64.  
  65. public bool Register(string user, string pass)
  66. {
  67. string query = $"INSERT INTO Whitelisted (id, username, password) VALUE ('', '{user}', '{pass}');";
  68.  
  69. try
  70. {
  71. if (OpenConnection())
  72. {
  73. MySqlCommand cmd = new MySqlCommand(query, conn);
  74.  
  75. try
  76. {
  77. cmd.ExecuteNonQuery();
  78. return true;
  79. }
  80. catch (Exception ex)
  81. {
  82. return false;
  83. }
  84. }
  85. else
  86. {
  87. conn.Close();
  88. return false;
  89. }
  90. }
  91. catch (Exception ex)
  92. {
  93. conn.Close();
  94. return false;
  95. }
  96. }
  97.  
  98. public bool IsLogin(string user, string pass)
  99. {
  100. string query = $"SELECT * FROM Whitelisted WHERE username = '{user}' AND password = '{pass}');";
  101.  
  102. try
  103. {
  104. if (OpenConnection())
  105. {
  106. MySqlCommand cmd = new MySqlCommand(query, conn);
  107. MySqlDataReader reader = cmd.ExecuteReader();
  108.  
  109. if (reader.Read())
  110. {
  111. reader.Close();
  112. conn.Close();
  113. return true;
  114. }
  115. else
  116. {
  117. reader.Close();
  118. conn.Close();
  119. return false;
  120. }
  121. }
  122. else
  123. {
  124. conn.Close();
  125. return false;
  126. }
  127. }
  128. catch (Exception ex)
  129. {
  130. conn.Close();
  131. return false;
  132. }
  133. }
  134. private bool OpenConnection()
  135. {
  136. try
  137. {
  138. conn.Open();
  139. return true;
  140. }
  141. catch (MySqlException ex)
  142. {
  143. switch (ex.Number)
  144. {
  145. case 0:
  146. MessageBox.Show("Connection to server failed!");
  147. break;
  148. case 1045:
  149. MessageBox.Show("Server username or password is incorrect!");
  150. break;
  151. }
  152. return false;
  153. }
  154. }
  155. }
  156. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement