private void FetchEmployeeInfo() { string id = IDNumTextBox.Text; DataTable dt = AccountClass.GetEmployeeInfo(id); foreach (DataRow row in dt.Rows) { lastname = row["LastName"].ToString(); firstname = row["FirstName"].ToString(); email = row["Email"].ToString(); gender = GetGender(row["Gender"].ToString()); gender_int = Convert.ToInt32(row["Gender"].ToString()); employeepic_int = AccountClass.EmployeePictureInHRIS(id); if (employeepic_int == 1) { employeepic = "~/images/users/" + row["EmployeeKey"].ToString() + ".jpg"; } else { employeepic = "~/images/users/ID.jpg"; } } if (dt.Rows.Count == 0) { lastname = ""; firstname = ""; email = ""; gender = ""; gender_int = -1; employeepic_int = 0; employeepic = "~/images/users/ID.jpg"; } }
protected void btnSearchIDNum_Click(object sender, EventArgs e) { if (txtIDNumber.Text.ToString().Trim() != "") { DataTable dtEmployee = AccountClass.GetEmployeeInfo(txtIDNumber.Text.ToString()); if (dtEmployee.Rows.Count > 0) { foreach (DataRow row in dtEmployee.Rows) { txtEmployeeKey.Text = row["EmployeeKey"].ToString(); txtLastName.Text = row["LastName"].ToString(); txtFirstName.Text = row["FirstName"].ToString(); txtMiddleName.Text = row["MiddleName"].ToString(); txtEmailAdd.Text = row["Email"].ToString(); //txtDomainAccount.Text = row["DomainAccount"].ToString(); } } dtEmployee.Clear(); } }