void Menu_Load()
{
XmlDataSource dsMenu = new XmlDataSource();
DataSet myReaderEnabled = SQLHelper.ExecuteDataset(Cache["ApplicationDatabase"].ToString(), "GetUserLogged", new object[] { UserHelper.GetUserId(Request.LogonUserIdentity.Name) });
if (myReaderEnabled.Tables[0].Rows.Count > 0)
{
lblUserLogged.Text = myReaderEnabled.Tables[0].Rows[0].ItemArray[0].ToString();
}
else if (Session["UserLogged"] != null && !Session["UserLogged"].Equals(""))
{
lblUserLogged.Text = Session["UserLogged"].ToString();
}
else
{
lblUserLogged.Text = "";
}
if (Cache["Profile"].ToString().IndexOf(UserHelper.GetUserId(Request.LogonUserIdentity.Name)) > 0)
{
if (UserHelper.IsAdminUO(Request.LogonUserIdentity.Name))
{
dsMenu.XPath = @"/*/*[@profile='Admin' or @profile='VisionGlobal' or @profile='Everyone' ]";
}
else
{
dsMenu.XPath = @"/*/*[@profile='Admin' or @profile='VisionGlobal' or @profile='Everyone' or @profile='AdminCentral']";
}
}
else if (Cache["VisionGlobal"].ToString().IndexOf(UserHelper.GetUserId(Request.LogonUserIdentity.Name)) > 0 || Cache["VisionGlobalTotal"].ToString().IndexOf(UserHelper.GetUserId(Request.LogonUserIdentity.Name)) > 0)
{
dsMenu.XPath = @"/*/*[@profile='VisionGlobal' or @profile='Everyone']";
}
else
{
dsMenu.XPath = @"/*/*[@profile='Everyone']";
}
if (myReaderEnabled.Tables[0].Rows.Count > 0 && !myReaderEnabled.Tables[0].Rows[0].ItemArray[1].ToString().Equals(""))
{
dsMenu.XPath = dsMenu.XPath.Replace("]", " or @profile='Self']");
}
dsMenu.DataFile = "~/App_Data/Menu.xml";
Menu.DataSource = dsMenu;
Menu.DataBind();
dsMenu.Dispose();
}