private void btnOK_Click(object sender, EventArgs e)
{
//Xóa hết checkbox cũ, dictionary cũ, thông tin cũ lưu lại từ phiên tra cứu trước
int c = groupBox2.Controls.Count;
for (int i = c - 1; i >= 0; i--)
{
groupBox2.Controls.Remove(groupBox2.Controls[i]);
}
select_amt.Clear();
amt_pri.Clear();
total_payable = 0;
num_amenities_selected = 0;
lb_it_selected.Text = "0";
ttp.Text = "0";
//CONNECTION
SqlConnection con = new SqlConnection("Data Source=HAINGUYEN;Initial Catalog=module5a;Integrated Security=True");
string query = "SELECT Tickets.FirstName,Tickets.LastName,CabinTypes.Name,Tickets.PassportNumber,Schedules.ID,Routes.DepartureAirportID,Routes.ArrivalAirportID,Schedules.Date,Schedules.Time,CabinTypes.ID,Tickets.ID FROM Tickets INNER JOIN Schedules ON Tickets.ScheduleID = Schedules.ID INNER JOIN Routes ON Schedules.RouteID = Routes.ID INNER JOIN CabinTypes ON Tickets.CabinType = CabinTypes.ID WHERE Tickets.BookingReference = '" + txtBR.Text + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
string Sched_ID, DA_ID, AA_ID, cabin_id;
DateTime Sched_Date;
TimeSpan Sched_Time;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
//MessageBox.Show("OK");
while (sdr.Read())
{
//Lấy thông tin đổ ra giao diên
txtName.Text = sdr.GetString(0) + " " + sdr.GetString(1);
txtCabinClass.Text = sdr.GetString(2);
txtPPNum.Text = sdr.GetString(3);
Sched_ID = sdr.GetString(4);
DA_ID = sdr.GetString(5);
AA_ID = sdr.GetString(6);
Sched_Date = sdr.GetDateTime(7);
Sched_Time = sdr.GetTimeSpan(8);
cabin_id = sdr.GetString(9);
tick_id = sdr.GetString(10);
txtTicketInfo.Text = Sched_ID + ", " + DA_ID + "-" + AA_ID + ", " + Sched_Date.Date.ToString("dd/MM/yyyy") + ", " + Sched_Time.ToString("hh\\:mm");
sdr.Close();
query = "SELECT Amenities.AmenService,Amenities.Price,AmenitiesID FROM Amenities INNER JOIN AmenitiesCabinType ON Amenities.ID = AmenitiesCabinType.AmenitiesID WHERE AmenitiesCabinType.CabinTypeID = '" + cabin_id + "'";
cmd = new SqlCommand(query, con);
sdr = cmd.ExecuteReader();
//Đổ ra thông tin nếu tra được mã booking
if (sdr.HasRows)
{
int index_top = 0, index_left = 0;
while (sdr.Read())
{
//tạo các checkbox mới khi tra được mã booking
CheckBox checkbox_t = new CheckBox();
this.groupBox2.Controls.Add(checkbox_t);
//định vị tọa độ các checkbox theo cột
checkbox_t.AutoSize = true;
checkbox_t.Location = new Point(17 + index_left * 200, 19 + index_top * 19);
if (index_top != 3)
{
index_top++;
}
else
{
index_left++;
index_top = 0;
}
double price = sdr.GetDouble(1);
string amt_id = sdr.GetString(2);
checkbox_t.Tag = amt_id;
amt_pri.Add(amt_id, price);
select_amt.Add(amt_id, false);
if (price != 0)
{
checkbox_t.Text = sdr.GetString(0) + " ($" + price.ToString() + ")";
}
else
{
checkbox_t.Enabled = false;
checkbox_t.Text = sdr.GetString(0) + " (FREE)";
num_amenities_selected++;
}
checkbox_t.Click += chk_Clicked;
}
}
else
{
MessageBox.Show("KHong co amenities thuoc cabin type :" + cabin_id);
}
}
}
else
{
MessageBox.Show("NOT");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
//Xóa hết checkbox cũ, dictionary cũ, thông tin cũ lưu lại từ phiên tra cứu trước
clear_old_data();
total_payable = 0;
num_amenities_selected = 0;
lb_it_selected.Text = "0";
ttp.Text = "0";
//CONNECTION
SqlConnection con = new SqlConnection("Data Source=DESKTOP-Q1QGNFE;Initial Catalog=module5a;Integrated Security=True");
string query = "SELECT Tickets.FirstName,Tickets.LastName,CabinTypes.Name,Tickets.PassportNumber,Schedules.ID,Routes.DepartureAirportID,Routes.ArrivalAirportID,Schedules.Date,Schedules.Time,CabinTypes.ID,Tickets.ID FROM Tickets INNER JOIN Schedules ON Tickets.ScheduleID = Schedules.ID INNER JOIN Routes ON Schedules.RouteID = Routes.ID INNER JOIN CabinTypes ON Tickets.CabinType = CabinTypes.ID WHERE Tickets.BookingReference = '" + txtBR.Text + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
int Sched_ID, DA_ID, AA_ID;
DateTime Sched_Date;
TimeSpan Sched_Time;
//TRA THONG TIN TỪ BOOKING REFERENCE
if (sdr.HasRows)
{
//MessageBox.Show("OK");
while (sdr.Read())
{
//Lấy thông tin đổ ra giao diên
txtName.Text = sdr.GetString(0) + " " + sdr.GetString(1);
txtCabinClass.Text = sdr.GetString(2);
txtPPNum.Text = sdr.GetString(3);
Sched_ID = sdr.GetInt32(4);
DA_ID = sdr.GetInt32(5);
AA_ID = sdr.GetInt32(6);
Sched_Date = sdr.GetDateTime(7);
Sched_Time = sdr.GetTimeSpan(8);
cabin_id = sdr.GetInt32(9);
tick_id = sdr.GetInt32(10);
string temp = Sched_ID + ", " + DA_ID + "-" + AA_ID + ", " + Sched_Date.Date.ToString("dd/MM/yyyy") + ", " + Sched_Time.ToString("hh\\:mm");
txtTicketInfo.Items.Add(temp);
}
txtTicketInfo.Text = txtTicketInfo.Items[0].ToString();
}
else
{
MessageBox.Show("CANNOT FOUND BOOKING REFERENCE");
}
con.Close();
}