protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if ((Request.QueryString["pid"] != null && !string.IsNullOrEmpty(Request.QueryString["pid"])))
                {
                    uiPanelProductDetails.Visible = true;
                    uiPanelProducts.Visible = false;
                    uiPanelCats.Visible = false;
                    DBLayer db = new DBLayer();
                    DataSet ds = db.GetProductContent(Convert.ToInt32(Request.QueryString["pid"].ToString()));
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        DataSet ds2 = db.GetCategoryContent(Convert.ToInt32(Request.QueryString["cid"].ToString()));

                        uiLabelProducCat.Text = ds2.Tables[0].Rows[0]["CategoryName"].ToString();
                        DataSet pics = db.GetAllItemsByProductID(Convert.ToInt32(Request.QueryString["pid"].ToString()));

                        uiLabelProductName.Text = ds.Tables[0].Rows[0]["ProductName"].ToString();
                        uiLiteralDescription.Text = Server.HtmlDecode(ds.Tables[0].Rows[0]["Description"].ToString());
                        uiRepeaterProjectPics.DataSource = pics;
                        uiRepeaterProjectPics.DataBind();
                    }
                    else
                    {
                        Response.Redirect("projects.aspx");
                    }
                }
                else if ((Request.QueryString["cid"] != null && !string.IsNullOrEmpty(Request.QueryString["cid"])))
                {
                    uiPanelProducts.Visible = true;
                    uiPanelCats.Visible = false;
                    uiPanelProductDetails.Visible = false;

                    BindProducts();
                }

                else
                {
                    uiPanelProducts.Visible = false;
                    uiPanelCats.Visible = true;
                    uiPanelProductDetails.Visible = false;

                    DBLayer db = new DBLayer();
                    DataSet ds = new DataSet();
                    ds = db.GetAllCats();
                    uiRepeaterCats.DataSource = ds;
                    uiRepeaterCats.DataBind();

                }

            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.QueryString["PID"] != null && !string.IsNullOrEmpty(Request.QueryString["PID"].ToString()))
            {
                int id = Convert.ToInt32(Request.QueryString["PID"].ToString());
                DBLayer db = new DBLayer();
                DataSet ds = new DataSet();
                ds = db.GetPageContent(id);
                if (ds.Tables[0].Rows.Count != 0)
                {

                    Master.PageTitle = ds.Tables[0].Rows[0]["Title"].ToString();
                    lblPaceContent.Text = Server.HtmlDecode(ds.Tables[0].Rows[0]["Content"].ToString());
                }
                else
                {
                    Response.Redirect("Pages.aspx?PID=14");
                }
            }
            else
            {
                Response.Redirect("Pages.aspx?PID=14");
            }
        }
        private void BindProducts()
        {
            DBLayer db = new DBLayer();
            DataSet ds = new DataSet();
            DataSet ds2 = new DataSet();
            ds2 = db.GetCategoryContent(Convert.ToInt32(Request.QueryString["cid"].ToString()));
            if (ds2.Tables[0].Rows.Count > 0)
            {
                ds = db.GetAllProductByCatID(Convert.ToInt32(Request.QueryString["cid"].ToString()));

                uiLabelCategory.Text = ds2.Tables[0].Rows[0]["CategoryName"].ToString();
                PagedDataSource dt = new PagedDataSource();
                dt.DataSource = ds.Tables[0].DefaultView;
                dt.AllowPaging = true;
                dt.PageSize = 12;
                dt.CurrentPageIndex = PageIndex;
                uiLinkButtonPrev.Enabled = !dt.IsFirstPage;
                uiLinkButtonNext.Enabled = !dt.IsLastPage;
                uiLabelPages.Text = "Page " + (PageIndex + 1).ToString() + " of " + dt.PageCount.ToString() + " Pages";

                uiRepeaterProducts.DataSource = dt;
                uiRepeaterProducts.DataBind();
            }
            else
            {
                Response.Redirect("projects.aspx");
            }
        }