private void viewevabtn_Click(object sender, EventArgs e)
{
Form22 form = new Form22(ID);
form.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
if (radioButton1.Checked || radioButton2.Checked || radioButton3.Checked || radioButton4.Checked)
{
Form22 f = new Form22();
this.Hide();
f.ShowDialog();
Close();
}
else
{
MessageBox.Show("Надо ответить на вопрос", "Заголовок", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void addbtn_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=DESKTOP-OLL88JR\\SQLEXPRESS;Initial Catalog=ProjectA;Persist Security Info=True;User ID=sa;Password=12345678");
conn.Open();
String AddCMD = "INSERT INTO GroupEvaluation (GroupId, EvaluationId, ObtainedMarks, EvaluationDate) VALUES (@gid, @eid, @marks, @evalDate)";
SqlCommand AddCommand = new SqlCommand(AddCMD, conn);
AddCommand.Parameters.Add(new SqlParameter("status", 3));
AddCommand.Parameters.Add(new SqlParameter("eid", eid));
AddCommand.Parameters.Add(new SqlParameter("gid", gid));
AddCommand.Parameters.Add(new SqlParameter("marks", Convert.ToInt32(marksbox.Text)));
AddCommand.Parameters.Add(new SqlParameter("evalDate", DateTime.Today));
int count = AddCommand.ExecuteNonQuery();
Form22 form = new Form22(gid);
form.Show();
this.Hide();
}
private void button3_Click(object sender, EventArgs e)
{
int index, n;
string TicketsID;
string ReysID, Cina, DataVidpravlennya, ID_Pasagir;
string SqlText = "DELETE FROM [Pasagir] WHERE [Pasagir].ID_Pasagir = ";
// перевірка, чи є взагалі записи в таблиці Source
n = dataGridView1.Rows.Count;
if (n == 1)
{
return;
}
Form22 f = new Form22();
index = dataGridView1.CurrentRow.Index;
TicketsID = Convert.ToString(dataGridView1[0, index].Value);
// сформувати SQL-команду
SqlText = SqlText + TicketsID;
// заповнити інформаційну довідку у вікні Form5
TicketsID = Convert.ToString(dataGridView1[1, index].Value);
ReysID = Convert.ToString(dataGridView1[2, index].Value);
Cina = Convert.ToString(dataGridView1[2, index].Value);
DataVidpravlennya = Convert.ToString(dataGridView1[2, index].Value);
ID_Pasagir = Convert.ToString(dataGridView1[2, index].Value);
f.label2.Text = TicketsID + " - " + TicketsID + " - " + ReysID + " - " + Cina + "-" + DataVidpravlennya + "-" + ID_Pasagir;
if (f.ShowDialog() == DialogResult.OK) // вивести форму
{
// виконати SQL-команду
MyExecuteNonQuery(SqlText);
// відобразити таблицю Source
Tickets();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 0)
{
Form2 form2 = new Form2();
this.Hide();
form2.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 1)
{
Form3 form3 = new Form3();
this.Hide();
form3.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 2)
{
Form4 form4 = new Form4();
this.Hide();
form4.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 3)
{
Form5 form5 = new Form5();
this.Hide();
form5.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 4)
{
Form6 form6 = new Form6();
this.Hide();
form6.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 5)
{
Form7 form7 = new Form7();
this.Hide();
form7.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 6)
{
Form8 form8 = new Form8();
this.Hide();
form8.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 7)
{
Form9 form9 = new Form9();
this.Hide();
form9.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 8)
{
Form10 form10 = new Form10();
this.Hide();
form10.Show();
}
if (sexual.SelectedIndex == 0 && st.SelectedIndex == 9)
{
Form11 form11 = new Form11();
this.Hide();
form11.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 0)
{
Form12 form12 = new Form12();
this.Hide();
form12.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 1)
{
Form13 form13 = new Form13();
this.Hide();
form13.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 2)
{
Form14 form14 = new Form14();
this.Hide();
form14.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 3)
{
Form15 form15 = new Form15();
this.Hide();
form15.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 4)
{
Form16 form16 = new Form16();
this.Hide();
form16.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 5)
{
Form17 form17 = new Form17();
this.Hide();
form17.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 6)
{
Form18 form18 = new Form18();
this.Hide();
form18.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 7)
{
Form19 form19 = new Form19();
this.Hide();
form19.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 8)
{
Form20 form20 = new Form20();
this.Hide();
form20.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 9)
{
Form21 form21 = new Form21();
this.Hide();
form21.Show();
}
if (sexual.SelectedIndex == 1 && st.SelectedIndex == 10)
{
Form22 form22 = new Form22();
this.Hide();
form22.Show();
}
}