Пример #1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     DBLayer db = new DBLayer();
     DataSet ds = new DataSet();
     ds = db.GetPageContent(9);
     if (ds.Tables[0].Rows.Count != 0)
     {
         Master.PageTitle = ds.Tables[0].Rows[0]["Title"].ToString();
         uiLiteralContent.Text = Server.HtmlDecode(ds.Tables[0].Rows[0]["Content"].ToString());
     }
 }
Пример #2
0
        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();

                }

            }
        }
Пример #3
0
 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();
             uiLiteralContent.Text = Server.HtmlDecode(ds.Tables[0].Rows[0]["Content"].ToString());
         }
         else
         {
             Response.Redirect("Page.aspx?PID=10");
         }
     }
     else
     {
         Response.Redirect("Page.aspx?PID=10");
     }
 }
Пример #4
0
        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");
            }
        }