public void addItemToCart(String[] items) { Database obj = new Database(); itemsoncart = obj.cartDetails(items); Session["CurrentCart"] = itemsoncart; //rePopulate(); obj.closeConnection(); }
protected void Page_Load(object sender, EventArgs e) { //HtmlGenericControl nc = new HtmlGenericControl(); try { ProjectUtilities o = new ProjectUtilities(); Panel q1; Database dobj = new Database(); SqlDataReader r = dobj.getHotDeals(); // Hot Deals if (r != null) { while (r.Read()) { Panel p = new Panel(); p.CssClass = "ProdList"; Image i = new Image(); i.ImageUrl = r["ImageLocation"].ToString(); //r["Image"].ToString(); var h3 = new HtmlGenericControl("h3"); // h3.Attributes.Add("class", "details"); h3.InnerHtml = r["Name"].ToString(); HyperLink a = new HyperLink(); a.Controls.Add(i); a.Controls.Add(h3); Panel cr = crPrice(r); cr.Style.Add("margin-top", "5px"); cr.Style.Add("text-align", "center"); a.Controls.Add(cr); a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString(); //p.Controls.Add(i); p.Controls.Add(a); //p.Controls.Add(h4); hd.Controls.Add(p); } q1 = new Panel(); q1.CssClass = "clearf"; HyperLink a1 = new HyperLink(); a1.NavigateUrl = "HotDeals.aspx"; a1.CssClass = "morebtn"; hd.Controls.Add(a1); hd.Controls.Add(q1); // <a href="HotDeals.aspx" style="height:100%;width:30px;float:right;margin-top:150px;"> // <img src="images/rarrow.png" style="display:block;margin:auto" alt="" /> //</a> r.Close(); } else hd.Visible = false; // RETEIVE BEST SELLERS // r = new Database().bestSeller(); r = null; if (r != null) { while (r.Read()) { Panel p = new Panel(); p.CssClass = "ProdList"; Image i = new Image(); i.ImageUrl = r["ImageLocation"].ToString(); //r["Image"].ToString(); var h3 = new HtmlGenericControl("h3"); h3.InnerHtml = r["Name"].ToString(); HyperLink a = new HyperLink(); a.Controls.Add(i); a.Controls.Add(h3); Panel cr = crPrice(r); cr.Style.Add("margin-top", "5px"); cr.Style.Add("text-align", "center"); a.Controls.Add(cr); a.NavigateUrl = "ViewProduct.aspx?pid=" + r["PId"].ToString(); //p.Controls.Add(i); p.Controls.Add(a); //p.Controls.Add(h4); bs.Controls.Add(p); } q1 = new Panel(); q1.CssClass = "clearf"; HyperLink a1 = new HyperLink(); a1.NavigateUrl = "HotDeals.aspx"; a1.CssClass = "morebtn"; bs.Controls.Add(a1); bs.Controls.Add(q1); } else //bs.Visible = false; bs.Parent.Visible = false; // New Arrivals r = dobj.newArrivals(); if (r != null) { while (r.Read()) { Panel p = new Panel(); p.CssClass = "ProdList"; Image i = new Image(); i.ImageUrl = r["ImageLocation"].ToString(); //r["Image"].ToString(); var h3 = new HtmlGenericControl("h3"); h3.InnerHtml = r["Name"].ToString(); HyperLink a = new HyperLink(); a.Controls.Add(i); a.Controls.Add(h3); Panel cr = crPrice(r); cr.Style.Add("margin-top", "5px"); cr.Style.Add("text-align", "center"); a.Controls.Add(cr); a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString(); //p.Controls.Add(i); p.Controls.Add(a); //p.Controls.Add(h4); na.Controls.Add(p); } q1 = new Panel(); q1.CssClass = "clearf"; //na.Controls.Add(q1); HyperLink a1 = new HyperLink(); a1.NavigateUrl = "NewArrivals.aspx"; a1.CssClass = "morebtn"; na.Controls.Add(a1); na.Controls.Add(q1); } else na.Parent.Visible = false; // Brands on Sale r = dobj.brandsOnSale(); if (r != null) { while (r.Read()) { Panel p = new Panel(); p.CssClass = "ProdList-brands"; Image i = new Image(); i.ImageUrl = r["Image_Location"].ToString(); //r["Image"].ToString(); //var h3 = new HtmlGenericControl("h3"); // var h4 = new HtmlGenericControl("h4"); // h4.InnerHtml = r["Cost"].ToString(); //h3.InnerHtml = r["Brand_Name"].ToString(); //HyperLink a = new HyperLink(); //a.Controls.Add(i); //a.Controls.Add(h3); //a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString(); //p.Controls.Add(i); p.Controls.Add(i); //p.Controls.Add(h4); bos.Controls.Add(p); } //q1 = new Panel(); //q1.CssClass = "clearf"; // bos.Controls.Add(q1); } else bos.Parent.Visible = false; // RETRIEVE COOKIES FOR RECENTLY VIEWED HttpCookie c = Request.Cookies["Viewed"]; if (c == null ) Div1.Visible = false; else { List<String> pid = new List<String>(); foreach (String key in c.Values.Keys) { pid.Add(key); } r = new Database().recentlyViewed(pid); if (r == null) Div1.Visible = false; else { try { while (r.Read()) { Panel p = new Panel(); p.CssClass = "ProdList"; Image i = new Image(); i.ImageUrl = r["ImageLocation"].ToString(); //r["Image"].ToString(); var h3 = new HtmlGenericControl("h3"); h3.InnerHtml = r["Name"].ToString(); HyperLink a = new HyperLink(); a.Controls.Add(i); a.Controls.Add(h3); Panel cr = crPrice(r); cr.Style.Add("margin-top", "5px"); cr.Style.Add("text-align", "center"); a.Controls.Add(cr); a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString(); p.Controls.Add(a); Div1.Controls.Add(p); } HyperLink a1 = new HyperLink(); a1.NavigateUrl = "HotDeals.aspx"; a1.CssClass = "morebtn"; Div1.Controls.Add(a1); } catch (SqlException se) { } finally { dobj.closeConnection(); } } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }