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();
}
}
}
