private void User_Click(object sender, RoutedEventArgs e) { UserLoginWindow userLoginWindow = new UserLoginWindow(); userLoginWindow.Show(); this.Close(); }
private void Registration_Click(object sender, RoutedEventArgs e) { if (nameField.Text != CheckUser.CheckUserName(nameField.Text)) { System.Windows.MessageBox.Show(CheckUser.CheckUserName(nameField.Text)); return; } if (surnamField.Text != CheckUser.CheckUserSurname(surnamField.Text)) { System.Windows.MessageBox.Show(CheckUser.CheckUserSurname(surnamField.Text)); return; } if (loginField.Text != CheckUser.CheckUserLogin(loginField.Text)) { System.Windows.MessageBox.Show(CheckUser.CheckUserLogin(loginField.Text)); return; } if (passwordField.Password.ToString() != CheckUser.CheckUserPassword(passwordField.Password.ToString())) { System.Windows.MessageBox.Show(CheckUser.CheckUserPassword(passwordField.Password.ToString())); return; } string userLogin = loginField.Text; string mySelectQuery = "SELECT * FROM Users WHERE [UserLogin] = '" + userLogin + "'"; using (SqlDataAdapter dataAdapter = new SqlDataAdapter(mySelectQuery, myConnectionString)) { DataTable table = new DataTable(); dataAdapter.Fill(table); if (table.Rows.Count > 0) { System.Windows.MessageBox.Show("Этот логин занят. Введите другой"); return; } else if (table.Rows.Count == 0) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT Users (UserLogin, UserPassword, UserName, UserSurname) VALUES (@login, @password, @name, @surname)"; cmd.Parameters.Add("@login", SqlDbType.VarChar).Value = loginField.Text; cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = passwordField.Password.ToString(); cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = nameField.Text; cmd.Parameters.Add("@surname", SqlDbType.VarChar).Value = surnamField.Text; cmd.Connection = myConnectionString; myConnectionString.Open(); cmd.ExecuteNonQuery(); myConnectionString.Close(); System.Windows.MessageBox.Show("Регистрация прошла успешно"); UserLoginWindow userLoginWindow = new UserLoginWindow(); userLoginWindow.Show(); this.Close(); } } }