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