protected void Page_Load(object sender, EventArgs e)
        {
         
            Button11.ServerClick += new EventHandler(this.fb_Click);
            RegularSubmit.Click += new EventHandler(this.RegularSubmit_Click);
            if (Session["User"] != null)
            {
                LoginName.Visible = true;
                LoginName.Text = "Welcome " + Session["User"].ToString();
            }
                
            //RegularSubmit
            //Button22.ServerClick += new EventHandler(this.gp_Click);
            //if (Session["user"] != null && String.IsNullOrEmpty(Session["user"].ToString()) == false)
            //    LoginName.Text = "Welcome " + Session["user"];
            if (!IsPostBack)
            {
                //NavBar.SkipLinkText = "";
                
                Button11.ServerClick += new EventHandler(this.fb_Click);
                //Button22.ServerClick += new EventHandler(this.fb_Click);
                DataTable table = new DataTable();
                string strCon;
                ProjectUtilities obj = new ProjectUtilities();
                strCon = obj.cons();
                SqlConnection conn = new SqlConnection(strCon);
                string sql = "select * from menuMaster";
                SqlCommand cmd = new SqlCommand(sql, conn);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(table);
                DataView view = new DataView(table);
                view.RowFilter = "menu_parent_id is NULL";
                foreach (DataRowView row in view)
                {
                    MenuItem menuItem = new MenuItem(row["menu_name"].ToString(),
                    row["menu_id"].ToString());
                    menuItem.NavigateUrl = row["menu_url"].ToString();
                    NavBar.Items.Add(menuItem);
                    AddChildItems(table, menuItem);
                }

                recordData();
                BrowsingData o = (BrowsingData)Session["BrowsingData"];
                if (o != null)
                    o.commit(o);
            }
        }
 public void Button1_Click(object sender, EventArgs e)
 {
     ProjectUtilities obj = new ProjectUtilities();
     try
     {
         SqlConnection con = new SqlConnection(obj.cons());
         String q = "Insert into SocialDB (Email,ContactNo,Address,FirstName,LastName,DOB,Gender,Location) Values (@email,@Cno,@address,@fname,@lname,@DOB,@Gender,@Location)";
         con.Open();
         SqlCommand com = new SqlCommand(q, con);
         com.CommandText = q;
         com.CommandType = CommandType.Text;
         com.Parameters.Add(new SqlParameter("@username", username));
         if(Address.Text!=null)
             com.Parameters.Add(new SqlParameter("@address", Address.Text));
         else
             com.Parameters.Add(new SqlParameter("@address", DBNull.Value));
         com.Parameters.Add(new SqlParameter("@email", email));
         com.Parameters.Add(new SqlParameter("@fname", firstname));
         com.Parameters.Add(new SqlParameter("@lname", lastname));
         if(ContactNo.Text!=null)
             com.Parameters.Add(new SqlParameter("@Cno", ContactNo.Text));
         else
             com.Parameters.Add(new SqlParameter("@Cno", DBNull.Value));
         if(DOB.Value!=null)
             com.Parameters.Add(new SqlParameter("@DOB", DOB.Value));
         else
             com.Parameters.Add(new SqlParameter("@DOB", DBNull.Value));
         com.Parameters.Add(new SqlParameter("@Gender", gender));
         com.Parameters.AddWithValue("@Location", location);
         //com.Parameters.Add(new SqlParameter("@Name", name));
         int v = com.ExecuteNonQuery();
         con.Close();
         Session["Logged"] = "True";
         Session["User"] = firstname;
         //Response.Redirect("Index.aspx",false);
     }
     catch (Exception ex)
     {
         new ProjectUtilities().sendError(ex);
     }
     finally
     {
         Response.Redirect("Index.aspx");
     }
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                NavBar.SkipLinkText = "";
                //NavBar.Visible = false;

                // Button11.ServerClick += new EventHandler(this.fb_Click);
                // Button22.ServerClick += new EventHandler(this.fb_Click);
                DataTable table = new DataTable();
                string strCon;
                ProjectUtilities obj = new ProjectUtilities();
                strCon = obj.cons();
                SqlConnection conn = new SqlConnection(strCon);
                string sql = "select menu_id, menu_name, menu_parent_id, menu_url from menuMaster";
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(table);
                DataView view = new DataView(table);
                view.RowFilter = "menu_parent_id is NULL";
                foreach (DataRowView row in view)
                {
                    MenuItem menuItem = new MenuItem(row["menu_name"].ToString(),
                    row["menu_id"].ToString());
                    menuItem.NavigateUrl = row["menu_url"].ToString();
                    NavBar.Items.Add(menuItem);
                    AddChildItems(table, menuItem);
                }
                conn.Close();
                displayItems();
                qr = Request.QueryString["q"];                
                if (!String.IsNullOrEmpty(q.Trim()))
                {
                    FilterList.Visible = false;
                    Page.Title = qr + " - Buy Best Products Online!";
                }
                else
                {
                    Response.Redirect("Index.aspx");
                }
            }
            else
            {
                if (Request.Form["__EVENTTARGET"] == "removeFilters1")
                {
                    string passedArgument = Request.Params.Get("__EVENTARGUMENT");
                    removeFilters1_click(passedArgument);
                }
                else if (Request.Form["__EVENTTARGET"] == "Button1")
                {
                    String[] s = Request.Params.Get("__EVENTARGUMENT").Split(',');
                    int s1 = Int32.Parse(s[0]);
                    int s2 = Int32.Parse(s[1]);
                    //filterPrice(s1, s2);
                    ll = s1;
                    ul = s2;
                    //q= createQuery();
                    query();
                }
                else if (Request.Form["__EVENTTARGET"] == "_Range")
                {
                    _Range_ValueChanged();
                }
                else if (Request.Form["__EVENTTARGET"] == "_Age")
                {
                    _Age_ValueChanged();
                }
            }
        }
        //protected void Page_Init(object sender, EventArgs e)
        //{
        //    Button b = new Button();
        //    b.Click += new EventHandler(a2c_Click);            
        //}


        //protected void Page_Load(object sender, EventArgs e)

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                NavBar.SkipLinkText = "";
                //NavBar.Visible = false;

                // Button11.ServerClick += new EventHandler(this.fb_Click);
                // Button22.ServerClick += new EventHandler(this.fb_Click);
                DataTable table = new DataTable();
                string strCon;
                ProjectUtilities obj = new ProjectUtilities();
                strCon = obj.cons();
                SqlConnection conn = new SqlConnection(strCon);
                string sql = "select menu_id, menu_name, menu_parent_id, menu_url from menuMaster";
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(table);
                DataView view = new DataView(table);
                view.RowFilter = "menu_parent_id is NULL";
                foreach (DataRowView row in view)
                {
                    MenuItem menuItem = new MenuItem(row["menu_name"].ToString(),
                    row["menu_id"].ToString());
                    menuItem.NavigateUrl = row["menu_url"].ToString();
                    NavBar.Items.Add(menuItem);
                    AddChildItems(table, menuItem);
                }
                conn.Close();
                displayItems();
                String cid = Request.QueryString["Cid"];
                int temp;
                if (!String.IsNullOrEmpty(cid) && int.TryParse(cid,out temp) && cid.Length<=8)
                {
                    String temp1 = new Database().getCatName(temp);
                    if (temp1 == "NA")
                        Response.Redirect("Index.aspx");
                    String[] catg = temp1.Split(',');
                    A1.InnerHtml = catg[0];
                    A1.HRef = catg[1];
                    Page.Title = A1.InnerHtml + " | GiftDezires.com";
                    Image banner = new Image();
                    banner.Style.Add("width", "100%");
                    if (!catg[2].Contains("false"))
                    {
                        banner.ImageUrl = "http://giftdezires.com/estore/images/Banner/" + catg[2];
                        bannerdiv.Controls.Clear();
                        bloc = banner.ImageUrl;
                        bannerdiv.Controls.Add(banner);
                    }
                    else
                        bannerdiv.Visible = false;
                }
                else
                {
                    Response.Redirect("Index.aspx");
                }
            }
            else
            {
                Image banner = new Image();
                banner.Style.Add("width", "100%");
                banner.ImageUrl = bloc;
                bannerdiv.Controls.Clear();
                bannerdiv.Controls.Add(banner);
               // if (filterl.Count != 0)
              //     FilterList.Visible = true;
                if (Request.Form["__EVENTTARGET"] == "removeFilters1")
                {
                    string passedArgument = Request.Params.Get("__EVENTARGUMENT");
                    removeFilters1_click(passedArgument);
                }
                else if (Request.Form["__EVENTTARGET"] == "Button1")
                {
                    String[] s = Request.Params.Get("__EVENTARGUMENT").Split(',');
                    int s1 = Int32.Parse(s[0]);
                    int s2 = Int32.Parse(s[1]);
                    //filterPrice(s1, s2);
                    ll = s1;
                    ul = s2;
                    //q= createQuery();
                    query();
                }
                else if (Request.Form["__EVENTTARGET"] == "_Range")
                    _Range_ValueChanged();
                else if (Request.Form["__EVENTTARGET"] == "_Age")
                    _Age_ValueChanged();
                else if (Request.Form["__EVENTTARGET"].ToString().Contains("a2c"))
                {
                    //Request.Form["__EVENTTARGET"].ToString()
                    a2c_Click(Request.Form["__EVENTTARGET"].ToString(), null);
                    //Response.Redirect(Request.Url.AbsoluteUri);
                }
               // else
                 //   Response.Redirect(Request.Url.AbsoluteUri); 
                //Request.Form["__EVENTTARGET"]

            }
        }