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();
}
}
