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