protected void btnU_Click(object sender, EventArgs e)
 {
     ServiceReference1.Passenger passenger = new ServiceReference1.Passenger();
     passenger.PNR = pnr;
     passenger.Passenger_Name = txtName.Text;
     passenger.Date_Of_Birth = DateTime.Parse(txtBirth.Text);
     passenger.Phone_Number = txtPhone.Text;
     passenger.Email = txtE.Text;
     ServiceReference1.Service1Client sr = new ServiceReference1.Service1Client();
     if (sr.Update_Passengers(passenger) == 1)
     {
         ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Update successed !!!');", true);
         dgPass.DataSource = sr.GetAll_Passengers();
         dgPass.DataBind();
         Reset();
     }
     else
     {
         ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Update failed !!!');", true);
     }
     
 }
 public bool AddPersonInformation()
 {
     ServiceReference2.Person_Accounts ps = new ServiceReference2.Service1Client().GetData(txtUsername.Text.Trim(), txtPassword.Text.Trim(), txtCC.Text.Trim());
     if (ps != null)
     {
         if (!new CheckValidate.CheckDataValidate().checkAge(txtDOB.Text.Trim()))
         {
             if (ps.Total_Amount > Convert.ToDouble(lblTotalPrice.Text.Trim()))
             {
                 pnr = "T";
                 for (int i = 0; i < 2; i++)
                 {
                     int n = new Random().Next(100, 999);
                     pnr += n;
                 }
                 ServiceReference1.Passenger sp = new ServiceReference1.Passenger()
                 {
                     Passenger_Name = txtHo.Text.Trim() + " " + txtName.Text.Trim(),
                     Email = txtEmail.Text.Trim(),
                     Phone_Number = txtPhoneNumber.Text.Trim(),
                     Address = txtAddress.Text.Trim(),
                     Gender = DropDownGen.SelectedItem.Value,
                     Date_Of_Birth = DateTime.Parse(txtDOB.Text.Trim()).Date,
                     Card_Code = txtCC.Text.Trim(),
                     PNR = pnr
                 };
                 if (new ServiceReference1.Service1Client().Add_Passengers(sp) == 1)
                 {
                     return true;
                 }
                 else
                 {
                     lblKQ.Text = "Passenger Incorrect. Please Check Again";
                     return false;
                 }
             }
             else
             {
                 lblKQ.Text = "Your Amount Is Not Enough";
                 return false;
             }
         }
         else
         {
             lblKQ.Text = "Your Age Incorrect";
             return false;
         }
     }
     else
     {
         lblKQ.Text = "Bank Information Incorrect. Please Check Again";
         return false;
     }
 }