private void PopulateUserMenu()
{
AppMenuBLL appMenu = new AppMenuBLL();
try
{
DataTable dtUserMenu = appMenu.GetUserGroupMenuData(userGroupIdForSetMenuHiddenField.Value.Trim(), menuForAppDropDownList.SelectedValue.Trim(), menuTypeDropDownList.SelectedValue.Trim());
DataTable dtAllMenu = appMenu.GetAllMenusForMappingUserMenu(menuForAppDropDownList.SelectedValue.Trim(), menuTypeDropDownList.SelectedValue.Trim());
DataRow dr = null;
//for (int i = 0; i < dtUserMenu.Rows.Count; i++)
//{
// if (dtUserMenu.Rows[i]["IsDisplay"].ToString() == "False")
// {
// dtUserMenu.Rows.RemoveAt(i);
// i--;
// }
//}
for (int i = 0; i < dtUserMenu.Rows.Count; i++)
{
for (int j = 0; j < dtAllMenu.Rows.Count; j++)
{
if (dtUserMenu.Rows[i]["ParentMenuId"].ToString() == dtAllMenu.Rows[j]["MenuId"].ToString())
{
dr = dtUserMenu.NewRow();
dr["MenuId"] = dtAllMenu.Rows[j]["MenuId"].ToString();
dr["MenuName"] = dtAllMenu.Rows[j]["MenuName"].ToString();
dr["ToolTipDescription"] = dtAllMenu.Rows[j]["ToolTipDescription"].ToString();
dr["ParentMenuId"] = dtAllMenu.Rows[j]["ParentMenuId"].ToString();
dr["URL"] = dtAllMenu.Rows[j]["URL"].ToString();
dr["MenuSorting"] = dtAllMenu.Rows[j]["MenuSorting"].ToString();
dr["DisplayName"] = dtAllMenu.Rows[j]["DisplayName"].ToString();
dr["ImageURL"] = dtAllMenu.Rows[j]["ImageURL"].ToString();
dr["MenuTarget"] = dtAllMenu.Rows[j]["MenuTarget"].ToString();
dtUserMenu.Rows.Add(dr);
}
}
}
///////////////////////////////to convert column data type////////////////////////////////
//DataTable dtCloned = dtUserMenu.Clone();
//dtCloned.Columns["UserMenuSorting"].DataType = typeof(Int32);
//foreach (DataRow row in dtUserMenu.Rows)
//{
// dtCloned.ImportRow(row);
//}
dtUserMenu = dtUserMenu.DefaultView.ToTable(true, "MenuId", "MenuName", "ToolTipDescription", "ParentMenuId", "URL", "MenuSorting", "DisplayName", "MenuTarget", "ImageURL");
dtUserMenu.DefaultView.Sort = "MenuSorting";
dtUserMenu = dtUserMenu.DefaultView.ToTable();
///////////////////////////////to sort by column(s)///////////////////////////////////////
//if (dtUserMenu.Rows.Count > 0)
//{
// DataView dv = dtUserMenu.DefaultView;
// dv.Sort = "UserMenuSorting";
// dtUserMenu = dv.ToTable();
//}
if (dtUserMenu.Rows.Count > 0)
{
//testAllMenu.Items.Clear();
AddTopMenuItems(dtUserMenu);
}
else
{
//msgbox.Visible = true; msgTitleLabel.Text = "User Menu Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
appMenu = null;
}
}
