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(); } } }
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"); } }