private void Button1_Click(object sender, EventArgs e)
{
this.Close();
menurun qqqw = new menurun();
qqqw.Show();
}
private void Button2_Click(object sender, EventArgs e)
{
string pattern1 = @"^(?=.*[0-9])(?=.*[!@#$%^&*])(?=.*[a-z])(?=.*[A-Z])[0-9a-zA-Z!@#$%^&*]{6,}$";
Regex t = new Regex(pattern1, RegexOptions.IgnoreCase);
bool matched1 = t.Match(textBox8.Text).Success;
if (textBox4.Text != textBox8.Text)
{
MessageBox.Show("Пароли не совпадают");
}
else if (matched1 != true)
{
MessageBox.Show("Павроль то не торот, пароль должен содержать как минимум 6 символов, рсреди них должен быть специальный символ");
}
else
{
string conn = "Data Source=DESKTOP-AKC6G8I;Initial Catalog=g464_Golubtsov;Integrated Security=True";
string str = "UPDATE [User] SET Password = '******', FirstName = '" + textBox2.Text + "', LastName = '" + textBox3.Text + "', Pictures = '" + textBox7.Text + "' WHERE Email = '" + PEREMEN.Login + "' ";
string str2 = "UPDATE [Runner] SET [Gender] ='" + comboBox1.Text + "', [DateOfBirth] = '" + dateTimePicker1.Value + "', [CountryCode] ='" + comboBox2.Text + "' WHERE [Email] = '" + PEREMEN.Login + "'";
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand(str2, con);
cmd1.ExecuteNonQuery();
con.Close();
MessageBox.Show("Вы успешно изменили");
this.Close();
menurun yyy51 = new menurun();
yyy51.Show();
}
}
private void button2_Click(object sender, EventArgs e)
{
string login;
string pass;
string role;
// textBox1.Text = PONOS.Login;
PEREMEN.Login = textBox1.Text;
if (textBox1.Text == "" && textBox2.Text == "")
{
MessageBox.Show("Пустые поля");
}
else
{
string conn = "Data Source=DESKTOP-AKC6G8I;Initial Catalog=g464_Golubtsov;Integrated Security=True";
//string conn = "Data Source=127.0.0.1;Initial Catalog=g464_Golubtsov;User ID=student;Password=student";
string str = "select [Email],[Password],[RoleId] FROM [User] WHERE [Email]='" + textBox1.Text + "' AND [Password]='" + textBox2.Text + "'";
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read() == true)
{
login = rdr.GetString(0);
pass = rdr.GetString(1);
role = rdr.GetString(2);
switch (role)
{
case "A":
menuadmin open = new menuadmin();
open.Show();
this.Close();
break;
case "C":
menukoor open2 = new menukoor();
open2.Show();
this.Close();
break;
case "R":
menurun open3 = new menurun();
open3.Show();
this.Close();
break;
}
// MessageBox.Show("Вы успешно вышли в систему как "+role);
}
else
{
MessageBox.Show("Неверный логин или пароль");
}
con.Close();
}
}
