using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using nmsSetup;
public partial class Admin_AdminMenu : System.Web.UI.UserControl
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Session["officeWebUser"] == null)
        {
            //Session["officeAdmin"] = Request.QueryString["log"].ToString();
            Response.Redirect("../Login/StudentLogin.aspx?User=Logout");
        }
        else
        {
            if (!IsPostBack)
            {
                if (Session["officeWebUser"] != null)
                {
                    string getlist = Session["officeWebUser"] as string; 
                    string[] getval = getlist.Split(',');

                    if (Convert.ToInt32(getval[7]) <=0)
                    {
                        mePanel.Visible = true;
                        upanle.Visible = false; 
                    }
                    else
                    {
                        mePanel.Visible = false;
                        upanle.Visible = true;
                    }


                    BName.InnerText ="Welcome "+ getval[2];
                    
                }
                //BindMainUrl();
            }
        }

        
    }

    public void BindMainUrl()
    {
        if (con.State == System.Data.ConnectionState.Closed)
            con.Open();
        List<PRPSetup> lst = new List<PRPSetup>();

        SqlCommand cmd = new SqlCommand("spMainUrl", con);
        cmd.Connection = con;
        cmd.CommandType = System.Data.CommandType.StoredProcedure;

        cmd.Parameters.AddWithValue("@empID", Session["officeAdmin"]);
        SqlDataReader dr = cmd.ExecuteReader();
        PRPSetup obj;
        if (dr.HasRows)
        {
            while (dr.Read())
            {
                obj = new PRPSetup();

                obj.urlId = dr["urlId"].ToString();
                obj.urlName = dr["urlName"].ToString();
                obj.urlPath = dr["urlPath"].ToString();
                obj.urlPrntId = dr["urlprntId"].ToString();
                lst.Add(obj);
            }
        }
        dr.Dispose();
        cmd.Dispose();
        con.Close();
        //Repcaurse.DataSource = lst;
        //Repcaurse.DataBind();





    }
    public List<PRPSetup> bind_SubMenu(string uid)
    {
        if (con.State == System.Data.ConnectionState.Closed)
            con.Open();
        List<PRPSetup> lst = new List<PRPSetup>();


        SqlCommand cmd = new SqlCommand("spMainUrlByPrntId", con);
        cmd.Connection = con;
        cmd.CommandType = System.Data.CommandType.StoredProcedure;

        cmd.Parameters.AddWithValue("@empID", Session["officeAdmin"]);
        cmd.Parameters.AddWithValue("@prntId", uid);
        SqlDataReader dr = cmd.ExecuteReader();
        PRPSetup obj;
        if (dr.HasRows)
        {
            while (dr.Read())
            {
                obj = new PRPSetup();

                obj.urlId = dr["urlId"].ToString();
                obj.urlName = dr["urlName"].ToString();
                obj.urlPath = dr["urlPath"].ToString();
                obj.urlPrntId = dr["urlprntId"].ToString();
                lst.Add(obj);
            }
        }
        dr.Dispose();
        cmd.Dispose();
        con.Close();
        return lst;
    }

    //protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    //{
    //    if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
    //    {
    //        //DataRowView drv = (DataRowView)e.Item.DataItem;
    //        PRPSetup drv = e.Item.DataItem as PRPSetup;

    //        string uid = drv.urlId; //drv["catid"].ToString();
    //        //string sid = drv.id; //drv["subcatid"].ToString();
    //        Repeater Repeater2 = (Repeater)e.Item.FindControl("Repcaurse_sub");
    //        Repeater2.DataSource = bind_SubMenu(uid);
    //        Repeater2.DataBind();
    //    }
    //}
    protected void lnklogout_Click(object sender, EventArgs e)
    {
        if (Session["officeWebUser"] != null)
        {
            //if (Session["WebSess"] != null)
            //{
            //    Session.Abandon();
            //    Session.Clear();

            //    Request.Cookies.Clear();

            //    HttpContext.Current.Response.AddHeader("Cache-Control", "no-cache, no-store, must-revalidate");
            //    HttpContext.Current.Response.AddHeader("Pragma", "no-cache");
            //    HttpContext.Current.Response.AddHeader("Expires", "0");
            //    Response.Redirect("../../Default.aspx");
            //}
            Session.Abandon();
            Session.Clear();

            Request.Cookies.Clear();

            HttpContext.Current.Response.AddHeader("Cache-Control", "no-cache, no-store, must-revalidate");
            HttpContext.Current.Response.AddHeader("Pragma", "no-cache");
            HttpContext.Current.Response.AddHeader("Expires", "0");
            Response.Redirect("~/Default.aspx");
        }

    }
}