protected void Page_Load(object sender, EventArgs e) { SqlDataReader r = new Database().getAllHotDeals(); litems.DataSource = r; litems.DataBind(); }
// get all data // // populate div private void startUp() { Database o = new Database(); String res = o.getCatName(Int32.Parse(category)); String[] c = res.Split(','); String cn = c[0]; String cl = c[1]; cat.InnerHtml = cn; cat.HRef = cl; }
public void addItemToCart(String[] items) { Database obj = new Database(); itemsoncart = obj.cartDetails(items); Session["CurrentCart"] = itemsoncart; //rePopulate(); obj.closeConnection(); }
public void DynamicClick(String id) { String temp = id.Substring(id.LastIndexOf('e')+1); int tid = int.Parse(temp); String pn = itemsoncart.Rows[tid].Field<String>(1); String pid = new Database().getPid(pn); itemsoncart.Rows.RemoveAt(tid); delCookie(pid); //rePopulate(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { //alert here Response.Redirect("Index.aspx"); } else { try { if(String.IsNullOrEmpty(Session["Checksum"].ToString())) Response.Redirect("Index.aspx"); if (Session["Checksum"].ToString() == Session["Cart"].ToString()) { // get cookie Session.Remove("Checksum"); Session.Remove("Cart"); DataTable cart = (DataTable)Session["CurrentCart"]; if (cart.Rows.Count <= 0) Response.Redirect("Index.aspx"); // decrypt // compute new values double total = 0;int k=0; //String pname = ""; for (int j = 0; j < cart.Rows.Count; j++) { //pname += cart.Rows[j].Field<String>("Product") + "=" + cart.Rows[j].Field<int>("Qty") + ","; total += (cart.Rows[j].Field<double>("Cost")-cart.Rows[j].Field<double>("Discount")) * cart.Rows[j].Field<int>("Qty"); } //create Order ID String ordid; DateTime d = new DateTime(); d = DateTime.Now; ordid = d.Year + "-" + d.Month + "-"+"0"; ordid += new Database().getOrderCount(); order_id.Value = ordid; amount.Value = Convert.ToString(total); merchant_id.Value = "41296"; cancel_url.Value = "http://giftdezires.com/estore/Index.aspx"; //get month's orders //Session.Remove("CurrentCart"); // check for logged or no Boolean b = new Boolean(); //b = (Boolean)Session["Logged"]; if (Session["Logged"] == null) b = false; else b = (Boolean)Session["Logged"]; if (b == true) { //get and set address } else { // copy code from CCAvenue response handler //set all forms items here and redirect or do all from related stuff here } //Session["ItemsSelected"] = pname; String s = @"<script ' type='text/javascript'>document.getElementById('form1').submit();</script>"; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", s, false); } else { Response.Redirect("Index.aspx"); } } catch (Exception ex) { // send email for the error new ProjectUtilities().sendError(ex); Response.Redirect("Index.aspx"); } } }
public SqlDataReader getWishlist() { // call DB for items with price,name,desc,disc SqlDataReader r = new Database().getPrice(this.wishlistitems); return r; }
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()); } }
protected void RegularSubmit_Click(object sender, EventArgs e) { String username = Username.Text; String password = Password.Text; if (!String.IsNullOrEmpty(username) && !String.IsNullOrEmpty(password)) { Object[] o = new Database().isUserValid(username, password); if ((Boolean)o[0] == true) Session["user"] = (String)o[1]; else { String sb = @"<script>alert('Incorrect Username / Password !')</script>"; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "script", sb, false); } } else { String sb = @"<script>alert('Please Enter Both Details')</script>"; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "script", sb, false); return; } //check details and display }
//protected void Page_Init(object sender, EventArgs e) //{ // Button b = new Button(); // b.Click += new EventHandler(a2c_Click); //} //protected void Page_Load(object sender, EventArgs e) protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { NavBar.SkipLinkText = ""; //NavBar.Visible = false; // Button11.ServerClick += new EventHandler(this.fb_Click); // Button22.ServerClick += new EventHandler(this.fb_Click); DataTable table = new DataTable(); string strCon; ProjectUtilities obj = new ProjectUtilities(); strCon = obj.cons(); SqlConnection conn = new SqlConnection(strCon); string sql = "select menu_id, menu_name, menu_parent_id, menu_url from menuMaster"; conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(table); DataView view = new DataView(table); view.RowFilter = "menu_parent_id is NULL"; foreach (DataRowView row in view) { MenuItem menuItem = new MenuItem(row["menu_name"].ToString(), row["menu_id"].ToString()); menuItem.NavigateUrl = row["menu_url"].ToString(); NavBar.Items.Add(menuItem); AddChildItems(table, menuItem); } conn.Close(); displayItems(); String cid = Request.QueryString["Cid"]; int temp; if (!String.IsNullOrEmpty(cid) && int.TryParse(cid,out temp) && cid.Length<=8) { String temp1 = new Database().getCatName(temp); if (temp1 == "NA") Response.Redirect("Index.aspx"); String[] catg = temp1.Split(','); A1.InnerHtml = catg[0]; A1.HRef = catg[1]; Page.Title = A1.InnerHtml + " | GiftDezires.com"; Image banner = new Image(); banner.Style.Add("width", "100%"); if (!catg[2].Contains("false")) { banner.ImageUrl = "http://giftdezires.com/estore/images/Banner/" + catg[2]; bannerdiv.Controls.Clear(); bloc = banner.ImageUrl; bannerdiv.Controls.Add(banner); } else bannerdiv.Visible = false; } else { Response.Redirect("Index.aspx"); } } else { Image banner = new Image(); banner.Style.Add("width", "100%"); banner.ImageUrl = bloc; bannerdiv.Controls.Clear(); bannerdiv.Controls.Add(banner); // if (filterl.Count != 0) // FilterList.Visible = true; if (Request.Form["__EVENTTARGET"] == "removeFilters1") { string passedArgument = Request.Params.Get("__EVENTARGUMENT"); removeFilters1_click(passedArgument); } else if (Request.Form["__EVENTTARGET"] == "Button1") { String[] s = Request.Params.Get("__EVENTARGUMENT").Split(','); int s1 = Int32.Parse(s[0]); int s2 = Int32.Parse(s[1]); //filterPrice(s1, s2); ll = s1; ul = s2; //q= createQuery(); query(); } else if (Request.Form["__EVENTTARGET"] == "_Range") _Range_ValueChanged(); else if (Request.Form["__EVENTTARGET"] == "_Age") _Age_ValueChanged(); else if (Request.Form["__EVENTTARGET"].ToString().Contains("a2c")) { //Request.Form["__EVENTTARGET"].ToString() a2c_Click(Request.Form["__EVENTTARGET"].ToString(), null); //Response.Redirect(Request.Url.AbsoluteUri); } // else // Response.Redirect(Request.Url.AbsoluteUri); //Request.Form["__EVENTTARGET"] } }