Advertisement
Guest User

Untitled

a guest
May 17th, 2016
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.13 KB | None | 0 0
  1. public partial class LogintoProfile : Form
  2. {
  3. public LogintoProfile()
  4. {
  5. InitializeComponent();
  6. }
  7.  
  8. private void BoxPawo_TextChanged(object sender, EventArgs e)
  9. {
  10. //Boxen viser stjerner i stedet for text
  11. BoxPawo.PasswordChar = '*';
  12. //Maxlængde på Password
  13. BoxPawo.MaxLength = 36;
  14. }
  15.  
  16. private void BoxCopawo_TextChanged(object sender, EventArgs e)
  17. {
  18. //Boxen viser stjerner i stedet for text
  19. BoxPawo.PasswordChar = '*';
  20. //Maxlængde på Password
  21. BoxPawo.MaxLength = 36;
  22. }
  23.  
  24. private void Update_Click(object sender, EventArgs e)
  25. {
  26. string connStr = "server=localhost;user=root;database=p4_projekt;port=3306;password=Jeppesen95;charset=latin1;";
  27. MySqlConnection conn = new MySqlConnection(connStr);
  28.  
  29. try
  30. {
  31. MessageBox.Show("Forbinder til databasen");
  32. conn.Open();
  33. string sql = "UPDATE p4_projekt.customer_table set First_name='" + BoxFornavn.Text + "',Last_name='" + BoxEfternavn.Text + "',Email='" + textBoxEmail.Text + "',Password=" + BoxPawo.Text + "WHERE Customer_id=@id";
  34. MySqlCommand cmd = new MySqlCommand(sql, conn);
  35. MySqlDataReader rdr = cmd.ExecuteReader();
  36.  
  37. while (rdr.Read())
  38. {
  39. Console.WriteLine(rdr[0] + " -- " + rdr[1]); // [] kan ikke huske om det er array plads?!
  40. }
  41.  
  42. rdr.Close();
  43. }
  44. catch (Exception ex)
  45. {
  46. Console.WriteLine(ex.ToString());
  47. }
  48.  
  49. conn.Close();
  50. Console.WriteLine("Done.");
  51. Console.ReadLine();
  52. }
  53.  
  54. private void TankOp_Click(object sender, EventArgs e)
  55. {
  56. string connStr = "server=localhost;user=root;database=p4_projekt;port=3306;password=**********;charset=latin1;";
  57. MySqlConnection conn = new MySqlConnection(connStr);
  58.  
  59. try
  60. {
  61. MessageBox.Show("Forbinder til databasen");
  62. conn.Open();
  63. string sql = "UPDATE p4_projekt.customer_table set Balance'" + Balance.Text + "WHERE Customer_id=@id";
  64. MySqlCommand cmd = new MySqlCommand(sql, conn);
  65. MySqlDataReader rdr = cmd.ExecuteReader();
  66.  
  67. while (rdr.Read())
  68. {
  69. Console.WriteLine(rdr[0] + " -- " + rdr[1]); // [] kan ikke huske om det er array plads?!
  70. }
  71.  
  72. rdr.Close();
  73. }
  74. catch (Exception ex)
  75. {
  76. Console.WriteLine(ex.ToString());
  77. }
  78.  
  79. conn.Close();
  80. Console.WriteLine("Done.");
  81. Console.ReadLine();
  82. }
  83.  
  84. private void Back_Click(object sender, EventArgs e)
  85. {
  86. this.Hide();
  87. Login.Login name = new Login.Login();
  88. name.ShowDialog();
  89. }
  90. }
  91.  
  92. public partial class Login : Form
  93. {
  94. private string connStr;
  95. private MySqlConnection conn;
  96.  
  97. public Login()
  98. {
  99. InitializeComponent();
  100. }
  101.  
  102. private void connect_to_DB()
  103. {
  104. try
  105. {
  106. connStr = "server=localhost;user=root;database=p4_projekt;port=3306;password=**********;charset=latin1;";
  107. conn = new MySqlConnection(connStr);
  108. conn.Open();
  109. }
  110. catch (MySqlException e)
  111. {
  112. throw;
  113. }
  114. }
  115.  
  116. private bool login_validation(string email, string pass)
  117. {
  118. connect_to_DB();
  119.  
  120. MySqlCommand cmd = new MySqlCommand();
  121. cmd.CommandText = "Select * from customer_table where Email=@email and Password=@pass";
  122. cmd.Parameters.AddWithValue("@email", email);
  123. cmd.Parameters.AddWithValue("@pass", pass);
  124. cmd.Connection = conn;
  125.  
  126. MySqlDataReader login = cmd.ExecuteReader();
  127.  
  128. if (login.Read())
  129. {
  130. conn.Close();
  131. return true;
  132. }
  133. else
  134. {
  135. conn.Close();
  136. return false;
  137. }
  138. }
  139.  
  140. private void buttonSubmit_Click(object sender, EventArgs e)
  141. {
  142. string email = textBoxEmail.Text;
  143. string pass = textBoxPass.Text;
  144.  
  145. if (email == "" || pass == "")
  146. {
  147. MessageBox.Show("Tomme felter, udfyld venligst begge felter");
  148. return;
  149. }
  150.  
  151. bool r = login_validation(email, pass);
  152.  
  153. if (r)
  154. {
  155. MessageBox.Show("Korrekte oplysninger");
  156. this.Hide();
  157. LogintoProfile name = new LogintoProfile();
  158. name.ShowDialog();
  159. }
  160. else
  161. MessageBox.Show("Forkerte oplysninger");
  162. }
  163. }
  164.  
  165. UPDATE ...
  166. WHERE Email = @Email
  167.  
  168. string sql = @"UPDATE p4_projekt.customer_table
  169. set First_name=@firstname, Last_name=@lastname,
  170. Email=@email,Password=@password
  171. WHERE Customer_id=@id";
  172. MySqlCommand cmd = new MySqlCommand(sql, conn);
  173. cmd.Parameters.Add("@firstname", MySqlDbType.VarChar).Value = BoxFornavn.Text;
  174. cmd.Parameters.Add("@lastname, MySqlDbType.VarChar).Value = BoxEfternavn.Text;
  175. cmd.Parameters.Add("@email, MySqlDbType.VarChar).Value = textBoxEmail.Text;
  176. cmd.Parameters.Add("@password, MySqlDbType.VarChar).Value = BoxPawo.Text;
  177. cmd.Parameters.Add("@id, MySqlDbType.Int32).Value = ???? // no value for id ???
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement