using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Xml; using System.Data.SqlClient; public partial class _01AdminMaster : System.Web.UI.MasterPage { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); //SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]); DataSet ds = new DataSet(); string uid; string qryfld = ""; string colid = ""; string rowid = ""; protected void Page_Load(object sender, EventArgs e) { try { if (Request.UserAgent.IndexOf("AppleWebKit") > 0) { Request.Browser.Adapters.Clear(); } if (Session["AdminAuth"] == null | Session["AdminAuth"] == null | Session["UserId"] == null) { Response.Redirect("../Administrator/Index.aspx"); } else { lblUName.Text = Session["AdminAuth"].ToString(); lblLogAt.Text = Session["LogAt"].ToString(); uid = Session["UserId"].ToString(); } if (!Page.IsPostBack) { PopulateMenu(); } //Session["AdminAuth"] = "Admin"; } catch (Exception ex) { Response.Write(ex.Message); } } public void PopulateMenu() { string sqlqry = "Select * from tbl_SetPermission Where UserId = " + uid + ""; SqlDataAdapter da = new SqlDataAdapter(sqlqry, con); da.Fill(ds, "GetMenus"); da.Dispose(); int col = ds.Tables["GetMenus"].Columns.Count; int flg = 0; for (int i = 2; i < col; i++) { if (flg == 0) { colid = ds.Tables["GetMenus"].Columns[i].Caption + " "; rowid = ds.Tables["GetMenus"].Rows[0].ItemArray[i].ToString().Trim(); if (rowid == "Yes") { qryfld = colid; } flg = 1; } else { colid = ds.Tables["GetMenus"].Columns[i].Caption; rowid = ds.Tables["GetMenus"].Rows[0].ItemArray[i].ToString().Trim(); if (rowid == "Yes") { if (qryfld == "") { qryfld = colid; } else if (qryfld != "") { qryfld = qryfld + ", " + colid; } } } } DataSet dst = GetMenuData(); foreach (DataRow masterRow in dst.Tables["Menu"].Rows) { MenuItem masterItem = new MenuItem((string)masterRow["Text"]); if (masterRow.ItemArray[3].ToString() == "") { Menu1.Items.Add(masterItem); } foreach (DataRow childRow in masterRow.GetChildRows("Children")) { MenuItem childItem = new MenuItem((string)childRow["Text"],"","",(string)childRow["NavigateUrl"]); masterItem.ChildItems.Add(childItem); // masterItem.NavigateUrl = masterRow.ItemArray[5].ToString(); } } } DataSet GetMenuData() { string sql = "Select MenuID, Text, Description, ParentID, ToolTip, NavigateUrl from Menu Where MenuId IN (" + qryfld + ")"; SqlDataAdapter da1 = new SqlDataAdapter(sql, con); DataSet dst = new DataSet(); da1.Fill(dst, "Menu"); da1.Dispose(); dst.Relations.Add("Children", dst.Tables["Menu"].Columns["MenuID"], dst.Tables["Menu"].Columns["ParentID"]); return dst; } //---------------------------- protected void lnkLogOut_Click(object sender, EventArgs e) { try { Response.Write(""); Response.Write(""); Response.Write(""); Session.Abandon(); } catch (Exception ex) { lblDgErr.Text = "Error! : " + ex.Message; } } }