private void LoadUserSession()
{
using (HanDatabase db = new HanDatabase())
{
DataTable result = db.ExecuteQuery(
"SELECT SelfLearning, PreferredLanguage FROM vUserInfo WHERE UserID=@UserID",
new SqlParameter[] { new SqlParameter("UserID", UserID) }
);
if (result.Rows.Count == 1)
{
DataRow userData = result.Rows[0];
int selfLearning = -1;
if (int.TryParse(userData["SelfLearning"].ForceToString(), out selfLearning))
{
Session["SelfLearning"] = selfLearning == 1;
}
string culture = userData["PreferredLanguage"].ForceToString();
if (string.IsNullOrWhiteSpace(culture))
{
culture = null;
}
Session["PreferredLanguage"] = culture;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Build Culture list
StringBuilder builder = new StringBuilder();
using (HanDatabase db = new HanDatabase())
{
DataTable data = db.ExecuteQuery("SELECT Culture FROM vCultureList ORDER BY Culture DESC");
foreach (DataRow row in data.Rows)
{
string culture = row["culture"].ForceToString();
builder.AppendFormat("<option value='{0}' {1}>{2}</option>", culture, culture == PreferredLanguage ? "selected='selected'" : "", GetGlobalResourceObject("Literals", culture));
}
}
cultureOptions.Controls.Add(new LiteralControl(builder.ToString()));
}
