private void Login(object sender, RoutedEventArgs e)
{
string email = Email.Text;
string pass = MainWindow.crypto(Password.Password);
MySqlConnection conn = new MySqlConnection(MainWindow.db);
MySqlCommand cmd = new MySqlCommand("select email, password from runners where email = @email and password = @password", conn);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@password", pass);
conn.Open();
MySqlDataReader r = cmd.ExecuteReader();
if (r.Read())
{
window.auth = true;
window.email = r["email"].ToString();
window.parents = new Stack <Page>();
AccountPage page = new AccountPage(window);
window.Content = page;
}
else
{
MessageBox.Show("Неверный логин или пароль", "Ошибка");
}
conn.Close();
}
private void Register(object sender, RoutedEventArgs e)
{
string email = Email.Text;
string pass1 = Password.Password;
string pass2 = RepPassword.Password;
string name = MName.Text;
string surname = Surname.Text;
string gender = Gender.Text;
string country = Country.Text;
string birthdate = Birthdate.Text.Trim();
bool isdate = MainWindow.DateValid(birthdate);
MySqlConnection conn = new MySqlConnection(MainWindow.db);
MySqlCommand find = new MySqlCommand("select email from runners where email = @email", conn);
find.Parameters.AddWithValue("@email", email);
conn.Open();
MySqlDataReader r = find.ExecuteReader();
if (email == "" || pass1 == "" || pass2 == "" || name == "" || surname == "" || gender == "" || country == "" || birthdate == "")
{
MessageBox.Show("Обязательные поля не заполнены", "Ошибка");
}
else if (pass1 != pass2)
{
Password.Password = "";
RepPassword.Password = "";
MessageBox.Show("Введённые пароли не совпадают", "Ошибка");
}
else if (!isdate)
{
MessageBox.Show("Фомат даты неверный", "Ошибка");
}
else if (r.Read())
{
MessageBox.Show("Этот почтовый адрес уже зарегистрирован", "Ошибка");
}
else
{
r.Close();
string pass = MainWindow.crypto(pass1);
MySqlCommand cmd = new MySqlCommand("insert into runners(email, password, name, surname, gender, birthdate, country, photo) values (@email, @password, @name, @surname, @gender, @birthdate, @country, @photo)", conn);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@password", pass);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@surname", surname);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@birthdate", birthdate);
cmd.Parameters.AddWithValue("@country", country);
cmd.Parameters.AddWithValue("@photo", image);
cmd.ExecuteNonQuery();
MessageBox.Show("Ваш аккаунт успешно зарегистрирован", "Успех");
window.parents = new Stack <Page>();
window.parents.Push(new MainPage(window));
window.Content = new LoginPage(window);
}
conn.Close();
}
