private void button2_Click(object sender, EventArgs e) { this.Hide(); RunnerMenu runmen = new RunnerMenu(); runmen.Show(); }
private void button1_Click(object sender, EventArgs e) { sqlconn = new SqlConnection(connection); sqlconn.Open(); SqlDataReader sqlread; SqlCommand select = new SqlCommand("use MSSKills2018 select [User].Email,Password,RunnerId,RoleId from [User] inner join Runner on Runner.Email = [User].Email", sqlconn); sqlread = select.ExecuteReader(); while (sqlread.Read()) { if (textBox1.Text == sqlread["Email"].ToString()) { prov1 = true; if (sqlread["Password"].ToString() == textBox2.Text) { prov = true; if (sqlread["RoleId"].ToString() == "R") { Email = textBox1.Text; RunId = sqlread["RunnerID"].ToString(); this.Hide(); RunnerMenu run = new RunnerMenu(); run.Show(); } if (sqlread["RoleId"].ToString() == "C") { this.Hide(); Coordinator coor = new Coordinator(); coor.Show(); } if (sqlread["RoleId"].ToString() == "A") { this.Hide(); Admin adm = new Admin(); adm.Show(); } } } } if (prov1 == false) { MessageBox.Show("Такого email не существует"); } if (prov1 == true && prov == false) { MessageBox.Show("Вы ввели непраильный пароль"); textBox2.Text = ""; } sqlconn.Close(); }
private void button5_Click(object sender, EventArgs e) { prov1 = false; prov2 = false; string s1 = textBox3.Text; string s2 = textBox5.Text; for (int i = 0; i < s1.Length; i++) { if (!Char.IsLetter(s1[i])) { prov1 = true; } } for (int i = 0; i < s2.Length; i++) { if (!Char.IsLetter(s2[i])) { prov2 = true; } } try { byte[] img = null; FileStream file = new FileStream(path, FileMode.Open, FileAccess.Read); BinaryReader bin = new BinaryReader(file); img = bin.ReadBytes((int)file.Length); if (textBox3.Text != "" && textBox5.Text != "" && textBox6.Text != "" && comboBox1.Text != "" && comboBox2.Text != "" && dateTimePicker1.Text != "") { if (prov1 == false && prov2 == false) { if (textBox4.Text != "" && textBox5.Text != "") { if (textBox4.Text.Length >= 6 && Regex.IsMatch(textBox4.Text, @"[a-z,A-Z,А-Я,а-я]") && Regex.IsMatch(textBox4.Text, @"[\#\$\!\@\%\^]") && Regex.IsMatch(textBox4.Text, @"[0-9]")) { if (textBox2.Text == textBox4.Text) { SqlCommand select = new SqlCommand("Update [User] set FirstName = @FirstName,LastName = @LastName,Password = @Pass,Photo = @Photo where Email = '" + label4.Text + "';Update Runner set Gender = @Gender,DateOfBirth =@Date,CountryCode = @Country where Email = '" + label4.Text + "';", sqlconn); select.Parameters.AddWithValue("FirstName", textBox3.Text); select.Parameters.AddWithValue("LastName", textBox5.Text); select.Parameters.AddWithValue("Pass", textBox4.Text); select.Parameters.AddWithValue("Photo", img); select.Parameters.AddWithValue("Gender", comboBox1.Text); select.Parameters.AddWithValue("Date", dateTimePicker1.Value); select.Parameters.AddWithValue("Country", comboBox2.SelectedValue); select.ExecuteNonQuery(); MessageBox.Show("Данные сохранены"); this.Hide(); RunnerMenu main = new RunnerMenu(); main.Show(); } else { MessageBox.Show("Пароли не совпадают"); } } else { MessageBox.Show("Пароль не соответсвует требованиям"); } } else { SqlCommand select = new SqlCommand("Update [User] set FirstName = @FirstName,LastName = @LastName,Photo = @Photo where Email = '" + label4.Text + "';Update Runner set Gender = @Gender,DateOfBirth =@Date,CountryCode = @Country where Email = '" + label4.Text + "';", sqlconn); select.Parameters.AddWithValue("FirstName", textBox3.Text); select.Parameters.AddWithValue("LastName", textBox5.Text); select.Parameters.AddWithValue("Photo", img); select.Parameters.AddWithValue("Gender", comboBox1.Text); select.Parameters.AddWithValue("Date", dateTimePicker1.Value); select.Parameters.AddWithValue("Country", comboBox2.SelectedValue); select.ExecuteNonQuery(); MessageBox.Show("Двнные сохранены"); this.Hide(); RunnerMenu main = new RunnerMenu(); main.Show(); } } else { MessageBox.Show("В имени или фамили запрещенные символы"); } } else { MessageBox.Show("Какие-то из полей не заполнены"); } } catch { MessageBox.Show("Вы не выбрали картинку"); } }