private void addprobtn_Click(object sender, EventArgs e)
{
Form18 form = new Form18(ID);
form.Show();
this.Hide();
}
private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Form18 form = new Form18();
form.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
Form18 f = new Form18();
this.Hide();
f.ShowDialog();
Close();
}
private void button3_Click(object sender, EventArgs e)
{
int index, n;
string ID_Pasagir;
string Surname, Name, NomerTelefony, Pasport, TicketsID, ReysID;
string SqlText = "DELETE FROM [Pasagir] WHERE [Pasagir].ID_Pasagir = ";
// перевірка, чи є взагалі записи в таблиці Source
n = dataGridView1.Rows.Count;
if (n == 1)
{
return;
}
Form18 f = new Form18();
index = dataGridView1.CurrentRow.Index;
ID_Pasagir = Convert.ToString(dataGridView1[0, index].Value);
// сформувати SQL-команду
SqlText = SqlText + ID_Pasagir;
// заповнити інформаційну довідку у вікні Form5
ID_Pasagir = Convert.ToString(dataGridView1[1, index].Value);
Surname = Convert.ToString(dataGridView1[2, index].Value);
Name = Convert.ToString(dataGridView1[2, index].Value);
NomerTelefony = Convert.ToString(dataGridView1[2, index].Value);
Pasport = Convert.ToString(dataGridView1[2, index].Value);
TicketsID = Convert.ToString(dataGridView1[2, index].Value);
ReysID = Convert.ToString(dataGridView1[2, index].Value);
f.label2.Text = ID_Pasagir + " - " + ID_Pasagir + " - " + Surname + " - " + Name + "-" + NomerTelefony + "-" + Pasport + "-" + TicketsID + "-" + ReysID;
if (f.ShowDialog() == DialogResult.OK) // вивести форму
{
// виконати SQL-команду
MyExecuteNonQuery(SqlText);
// відобразити таблицю Source
Pasagir();
}
}
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 cmd = "INSERT INTO GroupProject (ProjectId, GroupId, AssignmentDate) VALUES (@prid, @gid, @asgnDate)";
SqlCommand AddCommand = new SqlCommand(cmd, conn);
AddCommand.Parameters.Add(new SqlParameter("prid", pid));
AddCommand.Parameters.Add(new SqlParameter("gid", gid));
AddCommand.Parameters.Add(new SqlParameter("asgnDate", DateTime.Today));
count = AddCommand.ExecuteNonQuery();
Form18 form = new Form18(gid);
form.Show();
this.Hide();
}
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();
}
}
