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");
            }
        }
Ejemplo n.º 2
0
        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();
        }