private void ShowOwner() { try{ SearchRecord sr = new SearchRecord(); sr.DBPath = DBPath; sr.TableName = "tblCustomerTenant"; sr.Criteria = " where isActive = 1"; sr.FieldOutput = "sysid,LastName,FirstName,MiddleName,Address,ContactNumber,(LastName + ',' + Firstname ++ ' ' + MiddleName)as TagOutput"; sr.ShowDialog(); if (sr.Result != null) { TextBox tb = (TextBox)sr.Result; string sysID = tb.Text; textBox5.Text = tb.Tag.ToString(); lblOwnerID.Text = sysID; } } catch { } }
private void tenantRecordsToolStripMenuItem_Click(object sender, EventArgs e) { radioButton2.Select(); SearchRecord sr = new SearchRecord(); sr.DBPath = DBPath; sr.TableName = "tblTenant"; sr.Criteria = " where isActive = 1"; sr.FieldOutput = "sysid,Lastname,Firstname,middlename,Address,ContactNumber,(Lastname + ',' + Firstname + ' ' + middlename) as TagOutput"; sr.ShowDialog(); if (sr.Result != null) { TextBox tb = (TextBox)sr.Result; string sysID = tb.Text; textBox1.Text = tb.Tag.ToString(); textBox2.Text = sysID; LoadRoomAssignment(sysID); comboBox1.Focus(); } }