public void SetUserInfo()
        {
            try
            {
            DataTable dt;
            ErmTsPersonalInfoLinq Userinfo = new ErmTsPersonalInfoLinq();
               // TransactionDB trans = new TransactionDB();

            dt = Userinfo.GetDataList("replace(mobile_no,'-','')='" +  txtNumber.Text + "'", "", null);
             //   trans.CommitTransaction();
            if (dt.Rows.Count > 0)
            {
                LiveFaceScan.userinfo.id = dt.Rows[0]["id"] + "";
                if (Convert.IsDBNull(dt.Rows[0]["first_name"]) == false && Convert.IsDBNull(dt.Rows[0]["last_name"]) == false) {
                    LiveFaceScan.userinfo.fullname = "คุณ" + dt.Rows[0]["first_name"] + " " + dt.Rows[0]["last_name"];
                }
                if (Convert.IsDBNull(dt.Rows[0]["email"]) == false)
                {
                    LiveFaceScan.userinfo.email = dt.Rows[0]["email"] + "";
                }

                if (Convert.IsDBNull(dt.Rows[0]["company_name"]) == false)
                {
                    LiveFaceScan.userinfo.companyname = dt.Rows[0]["company_name"] + "";
                }

                this.Visible = false;
                //this.Close();
                frmSelectBrochures f = new frmSelectBrochures();
                f.ShowDialog();
            }
            else {
                Dialog.frmDialogMsg f = new Dialog.frmDialogMsg();
                f.lblText.Text = "ไม่พบข้อมูล";
                f.ShowDialog();
            }
            }
            catch (Exception exUserinfo) {
                Dialog.frmDialogMsg f = new Dialog.frmDialogMsg();
                f.lblText.Text = "ไม่พบข้อมูล";
                f.ShowDialog();
            }
        }
 private void pictureOK_Click(object sender, EventArgs e)
 {
     this.Visible = false;
     this.Close();
     frmSelectBrochures f = new frmSelectBrochures();
     f.ShowDialog();
 }