private void reservation_Click(object sender, EventArgs e) //예약 버튼
{
Insert.CommandText = "select RES_NUM.nextval from dual"; //현재 시퀀스 번호
seq = Convert.ToInt64(Insert.ExecuteScalar());
MessageBox.Show(seq.ToString());
CheckBox[] checkbox = new CheckBox[] { num1, num2, num3, num4, num_1, num_2, num_3, num_4 };
foreach (CheckBox c in checkbox)
{
int test = Convert.ToInt32(c.Text);
if (test <= 4)
{
if (c.Checked == true)
{
class_num = "1호차";
switch (c.Text)
{
case "1": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break;
case "2": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break;
case "3": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break;
case "4": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room1.Text, t_state, seq); break;
}
}
}
else
{
if (c.Checked == true)
{
class_num = "2호차";
switch (c.Text)
{
case "5": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break;
case "6": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break;
case "7": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break;
case "8": seat_num = c.Text; this.reservationTableAdapter1.InsertQuery(s_id, a_id, textBox1.Text, c.Text, room2.Text, t_state, seq); break;
}
}
}
}
this.memberTableAdapter1.UpdateQuery(seq, mainPage.M_ID);//회원이 예약하면 예약번호 할당
MessageBox.Show("Reservation 테이블에 삽입");
book2 form = new book2();
form.ShowDialog();
this.Dispose();
}
