Advertisement
Guest User

my leet code

a guest
Sep 26th, 2017
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.40 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 MySql.Data.MySqlClient;
  10. using System.Windows.Forms;
  11.  
  12. namespace volgerschool
  13. {
  14. public partial class Formregister : 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 Formregister()
  23. {
  24. server = "127.0.0.1";
  25. database = "svs";
  26. uid = "svs";
  27. password = "kaas123";
  28.  
  29. string connString;
  30. connString = $"SERVER={server};DATABASE={database};UID={uid};PASSWORD={password};";
  31.  
  32. conn = new MySqlConnection(connString);
  33. InitializeComponent();
  34. }
  35. //login
  36. private void button1_Click(object sender, EventArgs e)
  37. {
  38. string user = textBox1.Text;
  39. string pass = textBox2.Text;
  40. if (IsLogin(user, pass))
  41. {
  42. MessageBox.Show($"Welkom {user}");
  43. }
  44. else
  45. {
  46. MessageBox.Show($"Sorry {user}, de login is niet gelukt");
  47. }
  48. }
  49. //register
  50. private void button2_Click(object sender, EventArgs e)
  51. {
  52. string user = textBox1.Text;
  53. string pass = textBox2.Text;
  54. if (Register(user, pass))
  55. {
  56. MessageBox.Show($"Welkom {user}");
  57. }
  58. else
  59. {
  60. MessageBox.Show($"Sorry {user}, Het is niet gelukt"); ///THIS IS WHERE IT BREAKS///
  61. }
  62.  
  63. }
  64.  
  65. public bool Register(string user, string pass)
  66. {
  67. string query = $"INSTERT INTO users (id, naam, password) VALUES ('', '{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 true;
  95. }
  96. }
  97. public bool IsLogin(string user, string pass)
  98. {
  99. string query = $"SELECT FROM users WHERE naam ='{user}' AND password ='{pass}';";
  100.  
  101. try
  102. {
  103. if (OpenConnection())
  104. {
  105. MySqlCommand cmd = new MySqlCommand(query, conn);
  106. MySqlDataReader reader = cmd.ExecuteReader();
  107.  
  108. if (reader.Read())
  109. {
  110. reader.Close();
  111. conn.Close();
  112. return true;
  113. }
  114. else
  115. {
  116. reader.Close();
  117. conn.Close();
  118. return false;
  119. }
  120. }
  121. else
  122. {
  123. conn.Close();
  124. return false;
  125. }
  126.  
  127. }
  128. catch(Exception ex)
  129. {
  130. conn.Close();
  131. return false;
  132. }
  133.  
  134. }
  135. private bool OpenConnection()
  136. {
  137. try
  138. {
  139. conn.Open();
  140. return true;
  141. }
  142. catch (MySqlException ex)
  143. {
  144. switch (ex.Number)
  145. {
  146. case 0:
  147. MessageBox.Show("Connectie met server gefaalt");
  148. break;
  149. case 1045:
  150. MessageBox.Show("Server credentials incorrect");
  151. break;
  152.  
  153. }
  154. return false;
  155. }
  156. }
  157.  
  158. }
  159. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement