private void UserProfile_Click(object sender, RoutedEventArgs e) { UserProfileView userProfileView = new UserProfileView(); userProfileView.Show(); this.Close(); }
private void SignupButton_Click(object sender, RoutedEventArgs e) { string name = NameTextBox.Text.ToString(); string email = EmailTextBox.Text.ToString(); string password = PasswordTextBox.Text.ToString(); try { string MyConString = "Server=127.0.0.1;Port=3306;Uid=root;Pwd=;Database=tokiohotel;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); command.CommandText = "INSERT INTO users (name,password,email,image) VALUES (@nam,@pass, @eml,@img)"; //command.Parameters.AddWithValue("@id", 2); command.Parameters.AddWithValue("@nam", name); command.Parameters.AddWithValue("@pass", password); command.Parameters.AddWithValue("@eml", email); command.Parameters.AddWithValue("@img", "none"); connection.Open(); command.ExecuteNonQuery(); command.CommandText = "select id from users where name=@na and email=@mai and password=@pas"; command.Parameters.AddWithValue("@na", name); command.Parameters.AddWithValue("@pas", password); command.Parameters.AddWithValue("@mai", email); MySqlDataReader Reader; Reader = command.ExecuteReader(); while (Reader.Read()) { ID = Reader[0].ToString(); } user.UserName = name; user.Pasword = password; user.UserEmail = email; connection.Close(); MessageBox.Show("User Added Successfully"); NameTextBox.Text = ""; EmailTextBox.Text = ""; PasswordTextBox.Text = ""; userProfileViewModel = new UserProfileViewModel(User); _userProfileView = new UserProfileView(userProfileViewModel); _userProfileView.DataContext = userProfileViewModel; _userProfileView.Show(); } catch (Exception) { MessageBox.Show("DB Error"); } }
private void LogInClick(object sender, RoutedEventArgs e) { string email = EmailTextBox.Text.ToString(); string password = PasswordTextBox.Text.ToString(); try { string MyConString = "Server=127.0.0.1;Port=3306;Uid=root;Pwd=;Database=tokiohotel;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); MySqlDataReader Reader; command.CommandText = "select * from users where email =@uname AND password =@pass"; command.Parameters.AddWithValue("@uname", email); command.Parameters.AddWithValue("@pass", password); connection.Open(); int count = Convert.ToInt32(command.ExecuteScalar()); if (count > 0) { user.UserName = email; user.Pasword = password; ID = count.ToString(); } else { MessageBox.Show("Email or password is incorrect"); } connection.Close(); userProfileViewModel = new UserProfileViewModel(User); _userProfileView = new UserProfileView(userProfileViewModel); _userProfileView.DataContext = userProfileViewModel; _userProfileView.Show(); } catch (Exception ex) { MessageBox.Show("DB Error"); } }