Advertisement
Guest User

Untitled

a guest
Dec 27th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.26 KB | None | 0 0
  1. String _FirstName = firstname.Text;
  2. String _Name = name.Text;
  3. String _Email = email.Text;
  4. String _Username = username.Text;
  5. String _Password = password.Text;
  6. String _PasswordCon = passwordcon.Text;
  7.  
  8. if (_FirstName == "")
  9. {
  10. valid = false;
  11. EroarePrenume.Text = "Error: Name cannot be blank!";
  12. //Response.Write("Error: Name cannot be blank!");
  13. }
  14.  
  15. if (_Name == "")
  16. {
  17. valid = false;
  18. EroareNume.Text = "Error: Name cannot be blank!";
  19. //Response.Write("Error: Name cannot be blank!");
  20. }
  21.  
  22. if (_Email == "")
  23. {
  24. valid = false;
  25. EroareEmail.Text = "Error: Email cannot be blank!";
  26.  
  27. }
  28.  
  29. if (_Username == "")
  30. {
  31. valid = false;
  32. EroareUsername.Text = "Error: Username cannot be blank!";
  33. }
  34.  
  35. if (_Password == "")
  36. {
  37. valid = false;
  38. EroareParola.Text = "Error: Password cannot be blank!";
  39. }
  40.  
  41. if (_PasswordCon == "")
  42. {
  43. valid = false;
  44. EroareConfirmareParola.Text = "Error: Confirm Password cannot be blank!";
  45. }
  46.  
  47. if (_PasswordCon != _Password)
  48. {
  49. valid = false;
  50. EroareConfirmareParola.Text = "Error: Passwords are not the same!";
  51. }
  52.  
  53. if (valid)
  54. {
  55. string query = "INSERT INTO Users(firstName, lastName, email, registerDate, userName, passWord) OUTPUT INSERTED.userId "
  56. + " VALUES (@firstname, @lastname, @email, @registerDate, @userName, @passWord)";
  57. DateTime _localDate = DateTime.Now;
  58. //Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Asus\source\repos\Bookmarks\Bookmarks\App_Data\Database.mdf;Integrated Security=True
  59. //Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Vlad\Source\Repos\Bookmarks\Bookmarks\App_Data\Database.mdf; Integrated Security = True
  60. SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Vlad\Source\Repos\Bookmarks\Bookmarks\App_Data\Database.mdf;Integrated Security=True");
  61.  
  62. try
  63. {
  64. con.Open();
  65. SqlCommand com = new SqlCommand(query, con);
  66. com.Parameters.AddWithValue("firstname", _FirstName);
  67. com.Parameters.AddWithValue("lastname", _Name);
  68. com.Parameters.AddWithValue("email", _Email);
  69. com.Parameters.AddWithValue("registerDate", _localDate.GetDateTimeFormats()[3]);
  70. com.Parameters.AddWithValue("userName", _Username);
  71. com.Parameters.AddWithValue("passWord", _Password);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement