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