private void loadLookupData() { int UserId = UserManagement.GetUserId_FromUsername(); WTS_User u = new WTS_User(UserId); u.Load(); DataTable dt = WTSData.GetViewOptions(userId: UserId, gridName: GridType); DataTable dtSetting = u.UserSettingList_Get(u.ID, (int)UserSettingType.GridView, GridTypeEnum); if (dt != null && dt.Rows.Count > 0) { ddlView.Items.Clear(); ListItem item = null; foreach (DataRow row in dt.Rows) { item = new ListItem(); item.Text = row["ViewName"].ToString(); item.Value = row["GridViewID"].ToString(); item.Attributes.Add("OptionGroup", row["WTS_RESOURCEID"].ToString() != "" ? "Custom Views" : "Process Views"); item.Attributes.Add("MyView", row["MyView"].ToString()); item.Attributes.Add("Tier1RollupGroup", row["Tier1RollupGroup"].ToString()); item.Attributes.Add("Tier1ColumnOrder", row["Tier1ColumnOrder"].ToString()); item.Attributes.Add("Tier2ColumnOrder", row["Tier2ColumnOrder"].ToString()); item.Attributes.Add("DefaultSortType", row["Tier2SortOrder"].ToString()); item.Attributes.Add("SectionsXML", row["SectionsXML"].ToString()); // Set the default, over-write below if user has saved a view preference. if (Session["Levels"] == null && item.Text.ToString().ToLower() == "default") { if (row["SectionsXML"].ToString() != "") { XmlDocument xml = new XmlDocument(); xml.LoadXml(row["SectionsXML"].ToString()); HttpContext.Current.Session["Levels"] = xml; //------------------------------------------ } } ddlView.Items.Add(item); try { if (Session[DefaultGridViewNameSessionKey] != null) { if (ddlView.Items.FindByText(row["ViewName"].ToString()) == null) { // If user has saved view preference, save that XML to Session. if (Session[DefaultGridViewNameSessionKey].ToString().ToLower() == item.Text.ToString().ToLower()) { if (row["SectionsXML"].ToString() != "") { XmlDocument xml = new XmlDocument(); xml.LoadXml(row["SectionsXML"].ToString()); HttpContext.Current.Session["Levels"] = xml; //------------------------------------------ } } } } } catch (Exception) { // Nothing to do here, will use default. } } // 11626 - 2 > Use saved preferences: if (Session[DefaultGridViewNameSessionKey] != null && !string.IsNullOrWhiteSpace(Session[DefaultGridViewNameSessionKey].ToString()) && ddlChanged_ML != "yes") { ListItem itemGridView = ddlView.Items.FindByText(Session[DefaultGridViewNameSessionKey].ToString()); if (itemGridView != null) { itemGridView.Selected = true; } else { this.Grid_View = string.Empty; } } else // No saved view preference { if (!string.IsNullOrWhiteSpace(this.Grid_View)) { ListItem itemGridView = ddlView.Items.FindByText(this.Grid_View); if (itemGridView != null) { itemGridView.Selected = true; } else { this.Grid_View = string.Empty; } } else { if (dtSetting != null && dtSetting.Rows.Count > 0) { WTSUtility.SelectDdlItem(ddlView, dtSetting.Rows[0]["SettingValue"].ToString().Trim()); } } } if (Session[GridViewCurrentDropDownSessionKey] != null) { // Not working, may be because of "Process Views" "Custom Views" //ddlView.SelectedIndex = Convert.ToInt32(Session["CurrentDropDown"].ToString()); } if (Session[GridViewLevelsSessionKey] != null) // HttpContext.Current. { Page.ClientScript.RegisterArrayDeclaration("dtSectionsView", JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.None)); } } }
private void loadUserData() { DataTable dt = _loggedInUser.UserSettingList_Get(this.UserId, (int)UserSettingType.GridView, 0); if (dt == null || dt.Rows.Count == 0) { return; } //ListItem item = null; //default view options DataRow[] rows; rows = dt.Select(string.Format("GridNameID='{0}'", ddlMainView.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlMainView.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlMainView, rows[0]["SettingValue"].ToString().Trim()); } else { ddlMainView.Attributes.Add("UserSettingID", "0"); } rows = dt.Select(string.Format("GridNameID='{0}'", ddlView_Main.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlView_Main.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlView_Main, rows[0]["SettingValue"].ToString().Trim()); } else { ddlView_Main.Attributes.Add("UserSettingID", "0"); } //Workload view rows = dt.Select(string.Format("GridNameID='{0}'", ddlView_Workload.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlView_Workload.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlView_Workload, rows[0]["SettingValue"].ToString().Trim()); } else { ddlView_Workload.Attributes.Add("UserSettingID", "0"); } //Crosswalk view rows = dt.Select(string.Format("GridNameID='{0}'", ddlView_Crosswalk.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlView_Crosswalk.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlView_Crosswalk, rows[0]["SettingValue"].ToString().Trim()); } else { ddlView_Crosswalk.Attributes.Add("UserSettingID", "0"); } //AOR view rows = dt.Select(string.Format("GridNameID='{0}'", ddlView_AOR.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlView_AOR.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlView_AOR, rows[0]["SettingValue"].ToString().Trim()); } else { ddlView_AOR.Attributes.Add("UserSettingID", "0"); } //Work Request view rows = dt.Select(string.Format("GridNameID='{0}'", ddlView_Request.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlView_Request.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlView_Request, rows[0]["SettingValue"].ToString().Trim()); } else { ddlView_Request.Attributes.Add("UserSettingID", "0"); } //Hotlist view rows = dt.Select(string.Format("GridNameID='{0}'", ddlView_Hotlist.Attributes["GridNameID"].ToString())); if (rows.Length > 0) { ddlView_Hotlist.Attributes.Add("UserSettingID", rows[0]["UserSettingID"].ToString()); WTSUtility.SelectDdlItem(ddlView_Hotlist, rows[0]["SettingValue"].ToString().Trim()); } else { ddlView_Hotlist.Attributes.Add("UserSettingID", "0"); } }