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