protected void btRegister_Click(object sender, EventArgs e)
 {
     if (fc.checkCompany(txtIDCompany.Text) == true)
     {
         Response.Write("<script>alert('Đã tồn tại Tên đăng nhập này')</script>");
     }
     else
     {
         try
         {
             CaptchaControl1.ValidateCaptcha(txtCapscha.Text);
         }
         catch (Exception) {
             lbCapcha.Visible = true;
             return;
         }
         if (!CaptchaControl1.UserValidated)
         {
             lbCapcha.Visible = true;
             return;
         }
         else
         {
             try
             {
                 DateTime certifiedDate = DateTime.Parse(txtCertifiedDate.Text);
                 cnDb.connect();
                 SqlCommand cmd = new SqlCommand("sp_AddTourCompany", cnDb.conn);
                 cmd.CommandText = "sp_AddTourCompany";
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.AddWithValue("@IDCompany", txtIDCompany.Text);
                 cmd.Parameters.AddWithValue("@CompanyName", txtNameCompay.Text);
                 cmd.Parameters.AddWithValue("@LegalRepresentative", txtLegalRepresentative.Text);
                 cmd.Parameters.AddWithValue("@TransactionName", txtTransactionName.Text);
                 cmd.Parameters.AddWithValue("@TaxCode", txtTaxCode.Text);
                 cmd.Parameters.AddWithValue("@BusinessLicense", txtBusinessLicense.Text);
                 cmd.Parameters.AddWithValue("@CertifiedDate", certifiedDate);
                 cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
                 cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
                 cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
                 cmd.Parameters.AddWithValue("@Password", txtPass.Text);
                 cmd.Parameters.AddWithValue("@WebAddress", txtWebsite.Text);
                 cmd.ExecuteNonQuery();
                 cnDb.conn.Close();
                 Response.Redirect("UI_CompleteRegister.aspx");
             }
             catch (Exception)
             {
                 cnDb.conn.Close();
                 Response.Write("<script>alert('Vui lòng đăng ký lại sau.')</script>");
             }
         }
     }
 }