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