private void button1_Click(object sender, EventArgs e)
{
runner r = new runner();
r.Show();
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
int login = 0;
string role = "";
using (SqlConnection conn = new
SqlConnection(марафон2.Properties.Settings.Default.MaraphonConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT Count(*) FROM [User] WHERE Email='" + textBox1.Text + "'AND Password = '******'";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
login = Convert.ToInt32(reader[0]);
}
conn.Close();
conn.Open();
SqlCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "SELECT RoleId FROM [User] WHERE Email='" + textBox1.Text + "'AND Password = '******'";
SqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
role = reader1[0].ToString();
}
conn.Close();
}
if (login == 1)
{
{
File.WriteAllText("Resources/login.txt", textBox1.Text);
if (role == "R")
{
runner Runner = new runner();
Runner.Show();
this.Hide();
}
else
{
if (role == "A")
{
admin Admin = new admin();
Admin.Show();
this.Hide();
}
else
{
if (role == "C")
{
coordinators Coordinator = new coordinators();
Coordinator.Show();
this.Hide();
}
}
}
}
}
else
{
MessageBox.Show("Не правильный логин/пароль.");
}
}
private void button4_Click(object sender, EventArgs e)
{
string code = "";
using (SqlConnection con = new SqlConnection(марафон2.Properties.Settings.Default.MaraphonConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT CountryCode FROM Country where CountryName='" + comboBox2.Text + "'OR CountryCode='" + comboBox2.Text + "'";
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
code = r[0].ToString();
}
con.Close();
}
if (textBox4.Text == "" && textBox5.Text == "")
{
SqlConnection con = new SqlConnection(марафон2.Properties.Settings.Default.MaraphonConnectionString);
//Выборка
adapter = new SqlDataAdapter("SELECT * FROM [User] INNER JOIN Runner ON [User].Email = Runner.Email", con);
//Запрос на вставку
adapter.InsertCommand = new SqlCommand("Update [User] set FirstName='" +
textBox1.Text + "',LastName='" + textBox2.Text + "' where Email='" + label4.Text + "'" +
"Update Runner set Gender = '" + comboBox1.Text + "', DateOfBirth = '" + dateTimePicker1.Value +
"', CountryCode = '" + code + "', Image='" + textBox4.Text + "' where Email = '" + label4.Text + "'", con);
//Создание набора таблиц
dataSet = new DataSet();
//Заполнение таблицы
adapter.Fill(dataSet, str);
//Привязка к таблице
bs = new BindingSource(dataSet, str);
con.Open();
adapter.InsertCommand.ExecuteNonQuery();
con.Close();
runner r = new runner();
r.Show();
this.Close();
}
else
if (textBox4.Text == textBox5.Text && textBox4.Text != "" && textBox5.Text != "")
{
SqlConnection con = new SqlConnection(марафон2.Properties.Settings.Default.MaraphonConnectionString);
// Выборка
adapter = new SqlDataAdapter("SELECT * FROM [User] INNER JOIN Runner ON [User].Email = Runner.Email", con);
// Запрос на вставку
adapter.InsertCommand = new SqlCommand("Update [User] set [Password]='" + textBox4.Text +
"',FirstName='" + textBox1.Text + "',LastName='" + textBox2.Text + "' where Email='" +
label4.Text + "'" + "Update Runner set Gender = '" + comboBox1.Text + "', DateOfBirth = '"
+ dateTimePicker1.Value + "', CountryCode = '" + code + "', Image='" + textBox3.Text + "' where Email = '" + label4.Text + "'", con);
//Создание набора таблиц
dataSet = new DataSet();
//Заполнение таблицы
adapter.Fill(dataSet, str);
//Привязка к таблице
bs = new BindingSource(dataSet, str);
con.Open();
adapter.InsertCommand.ExecuteNonQuery();
con.Close();
runner r = new runner();
r.Show();
this.Close();
}
else
{
MessageBox.Show("Пароли не совпадают.");
}
}
