private void Reg_Click(object sender, RoutedEventArgs e) { string pr1; bool check = true; string sqlExpression = ("Insert INTO [User](Name,Surname,[E-mail],Adress,Password) values (@name,@surname,@email,@adress,@password)"); string sqlExpression2 = ("Select [E-Mail] from [User]"); SqlConnection connection = new SqlConnection(connectingString); connection.Open(); try { check = true; SqlCommand command = new SqlCommand(sqlExpression, connection); SqlCommand command2 = new SqlCommand(sqlExpression2, connection); DataSet table = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(command2); adapter.Fill(table); foreach (DataTable dt in table.Tables) { foreach (DataRow row in dt.Rows) { var cells = row.ItemArray; pr1 = cells[0].ToString(); if (pr1 == Email.Text) { check = false; } } } if (check == true) { command.Parameters.AddWithValue("@name", Name.Text); command.Parameters.AddWithValue("@surname", Surname.Text); command.Parameters.AddWithValue("@email", Email.Text); command.Parameters.AddWithValue("@adress", Adress.Text); command.Parameters.AddWithValue("@password", Password.Text); command.ExecuteNonQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message); check = false; } finally { connection.Close(); if (check) { MessageBox.Show("Регистрация прошла успешно!"); User.StartUserWindow startUserWindow = new StartUserWindow(); startUserWindow.Show(); this.Close(); } else { MessageBox.Show("При регистрации произошла ошибка!Возможно на данный E-Mail уже зарегистрирован аккаунт."); } } }
private void Button_Click_1(object sender, RoutedEventArgs e) { User.StartUserWindow startUserWindow = new User.StartUserWindow(); startUserWindow.Show(); this.Close(); }