private void button2_Click(object sender, EventArgs e) { ActiveForm.Hide(); SponsorForm sf = new SponsorForm(); sf.ShowDialog(); Close(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string str; string [] str1; str = comboBox1.Text; str1 = str.Split(' '); SqlConnClass scc = new SqlConnClass(); SponsorForm sf = this; scc.CharityForRunner(sf, str1[0]); }
public SponsorForm() { InitializeComponent(); label19.Text = "$" + textBox2.Text; SponsorForm sf = this; SqlConnClass scc = new SqlConnClass(); scc.ConectRunnerFoeSponsor(sf); tm.Tick += timer1_Tick; tm.Interval = 1000; tm.Enabled = true; tm.Start(); }
public void CharityForRunner(SponsorForm sf, string str) { string connStr = "server=localhost;user=root;database=pafenov;password="******"SELECT CharityName FROM registration JOIN charity ON registration.CharityId = Charity.CharityId WHERE registration.RunnerId = " + str; MySqlCommand command = new MySqlCommand(sql, conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { sf.label20.Text = reader[0].ToString(); } reader.Close(); conn.Close(); }
public void ConectRunnerFoeSponsor(SponsorForm sf) { string connStr = "server=localhost;user=root;database=pafenov;password="******"SELECT runner.RunnerId, user.FirstName, user.LastName, country.CountryName FROM user JOIN runner ON user.Email = runner.Email JOIN country ON runner.CountryCode = country.CountryCode"; MySqlCommand command = new MySqlCommand(sql, conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { sf.comboBox1.Items.Add(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString() + " " + reader[3].ToString()); } reader.Close(); conn.Close(); }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "" || comboBox1.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "" || label19.Text == "$0") { MessageBox.Show("Какие то поля не заполнены либо сумма равна 0!"); } else { string str; string[] str1; str = comboBox1.Text; str1 = str.Split(' '); SqlConnClass scc = new SqlConnClass(); SponsorForm sf = this; scc.SponsorAddRec(sf, str1[0], textBox1.Text, textBox2.Text); //scc.CharityForRunner(sf, str1[0]); ActiveForm.Hide(); SponsConfirm sc = new SponsConfirm(comboBox1.Text, label20.Text, label19.Text); sc.ShowDialog(); Close(); } }
public void SponsorAddRec(SponsorForm sf, string str, string name, string sum) { string connStr = "server=localhost;user=root;database=pafenov;password="******"SELECT RegistrationId FROM registration WHERE RunnerId = " + str; MySqlCommand command = new MySqlCommand(sql, conn); MySqlDataReader reader = command.ExecuteReader(); string regid = ""; while (reader.Read()) { regid = reader[0].ToString(); } string sql1 = "INSERT INTO sponsorship(SponsorName,RegistrationId,Amount) VALUES('" + name + "', '" + regid + "', '" + sum + "')"; reader.Close(); command = new MySqlCommand(sql1, conn); command.ExecuteNonQuery(); conn.Close(); }