private void FillUserPreferences()
{
sSQL = "select username,full_name,authentication_type,email,security_question,security_answer from users where user_id = '" + ui.GetSessionUserID() + "'";
DataRow dr = null;
if (!dc.sqlGetDataRow(ref dr, sSQL, ref sErr))
{
ui.RaiseError(Page, sErr, true, "");
}
else
{
if (dr != null)
{
lblName.Text = (object.ReferenceEquals(dr["full_name"], DBNull.Value) ? "" : dr["full_name"].ToString());
lblUserName.Text = (object.ReferenceEquals(dr["username"], DBNull.Value) ? "" : dr["username"].ToString());
lblAuthenticationType.Text = (object.ReferenceEquals(dr["authentication_type"], DBNull.Value) ? "" : dr["authentication_type"].ToString());
txtEmail.Text = (object.ReferenceEquals(dr["email"], DBNull.Value) ? "" : dr["email"].ToString());
hidEmail.Value = txtEmail.Text;
txtSecurityQuestion.Text = (object.ReferenceEquals(dr["security_question"], DBNull.Value) ? "" : dc.DeCrypt(dr["security_question"].ToString()));
string sSecurityAnswer = (object.ReferenceEquals(dr["security_answer"], DBNull.Value) ? "" : dc.DeCrypt(dr["security_answer"].ToString()));
if (sSecurityAnswer.Length > 0)
{
txtSecurityAnswer.Attributes.Add("value", sSecurityAnswer);
hidSecurityAnswer.Value = sSecurityAnswer;
}
;
// we know the user has a password, or they would not be on the screen
string sPasswordFiller = "($%#d@x!&";
txtPassword.Attributes.Add("value", sPasswordFiller);
txtPasswordConfirm.Attributes.Add("value", sPasswordFiller);
if (lblAuthenticationType.Text == "ldap")
{
pnlLocalSettings.Visible = false;
}
}
}
}
