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