private void Button6_Click(object sender, EventArgs e)
{
ActiveForm.Hide();
MyRaceResults reg = new MyRaceResults();
reg.ShowDialog();
Close();
}
public Form9()
{
SqlConnection scc = new SqlConnection();
InitializeComponent();
timer1.Start();
//Form9 f9 = new Form9();
MyRaceResults mrs = new MyRaceResults();
runnerid = mrs.runnerid;
}
public MyRaceResults()
{
InitializeComponent();
timer1.Start();
//runnerid = runnerid1;
SqlConnection scc = new SqlConnection();
//MyRaceResults mrf = new MyRaceResults();
MyRaceResults mrf = this;
scc.MyRaceResults(mrf, runnerid);
}
public void MyRaceResults(MyRaceResults mrf, int runid)
{
string connStr = "server=localhost;user=root;database=ketrar;password="******"SELECT Gender FROM runner WHERE RunnerId = '" + runid + "'";
MySqlCommand command = new MySqlCommand(sql, conn);
string gender = command.ExecuteScalar().ToString();
mrf.label4.Text += " " + gender;
string sql1 = "SELECT DateOfBirth FROM runner WHERE RunnerId = '" + runid + "'";
command = new MySqlCommand(sql1, conn);
DateTime date = Convert.ToDateTime(command.ExecuteScalar());
int dt = DateTime.Now.Year - date.Year;
if (dt < 18)
{
mrf.label5.Text += " до 18";
}
else
{
if (dt >= 18 && dt <= 29)
{
mrf.label5.Text += " от 18 до 29";
}
else
{
if (dt >= 30 && dt <= 39)
{
mrf.label5.Text += " от 30 до 39";
}
else
{
if (dt >= 40 && dt <= 55)
{
mrf.label5.Text += " от 40 до 55";
}
else
{
if (dt >= 56 && dt <= 70)
{
mrf.label5.Text += " от 56 до 70";
}
else
{
if (dt > 70)
{
mrf.label5.Text += " более 70";
}
}
}
}
}
}
string sql3 = "SELECT RegistrationId FROM registration WHERE RunnerId = '" + runid + "'";
command = new MySqlCommand(sql3, conn);
int regid = Convert.ToInt32(command.ExecuteScalar());
string sql4 = "SELECT marathon.CityName,marathon.YearHeld,eventtype.EventTypeName,runner.DateOfBirth, `RaceTime`, `BibNumber` FROM registrationevent JOIN event ON registrationevent.EventId = event.EventId JOIN marathon ON event.MarathonId = marathon.MarathonId JOIN eventtype ON event.EventTypeId=eventtype.EventTypeId JOIN registration ON registrationevent.RegistrationId = registration.RegistrationId JOIN runner ON registration.RunnerId=runner.RunnerId WHERE registrationevent.RegistrationId = " + regid;
command = new MySqlCommand(sql4, conn);
MySqlDataReader reader = command.ExecuteReader();
bool a = reader.HasRows;
while (reader.Read())
{
string mar = reader[1].ToString() + " " + reader[0].ToString();
string dist;
if (reader.IsDBNull(2))
{
dist = "";
}
else
{
dist = reader[2].ToString();
}
int hour;
int min;
int sec;
if (reader.IsDBNull(4))
{
hour = 0;
min = 0;
sec = 0;
}
else
{
hour = Convert.ToInt32(reader.GetValue(4)) / 3600;
min = (Convert.ToInt32(reader.GetValue(4)) - hour * 3600) / 60;
sec = Convert.ToInt32(reader.GetValue(4)) - hour * 3600 - min * 60;
}
ListViewItem item = new ListViewItem(new string[] { mar, dist, hour.ToString() + "h " + min.ToString() + "m " + sec.ToString() + "s", reader[5].ToString(), reader[3].ToString() });
mrf.listView1.Items.Add(item);
}
reader.Close();
conn.Close();
}
