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("Вы не выбрали картинку"); }
}
