protected void Page_Load(object sender, EventArgs e) { cFunctions oFunctions = new cFunctions(); int count = 0; try { if (Membership.GetUser().ToString().Trim() == string.Empty) { Response.Redirect("Login.aspx"); } } catch { Response.Redirect("Login.aspx"); } Session["UserName"] = Membership.GetUser().ToString().Trim(); try { if (Request.QueryString["m"].ToString().Trim() == "y") { DeleteAll(); } } catch { Response.Redirect("Index.aspx"); } count = oFunctions.GetCount("SELECT count(*) from dbo.ShoppingCart WHERE (UserName = '******') AND (Active = 1)"); if (count == 0) { this.lblEmptyCart.Visible = true; this.btnCheckout.Enabled = false; this.btnRemoveAll.Enabled = false; } else { this.lblEmptyCart.Visible = false; this.btnCheckout.Enabled = true; this.btnRemoveAll.Enabled = true; } string sum2 = oFunctions.GetString("SELECT SUM(Items.RegularPrice * Items.Discount / 100) AS Expr1 FROM ShoppingCart INNER JOIN Items ON ShoppingCart.ItemID = Items.ItemID WHERE (ShoppingCart.UserName = '******') AND (ShoppingCart.Active = 1)"); if (sum2 == string.Empty) { this.lblOrderTotal.Text = " "; } else { this.lblOrderTotal.Text = String.Format("Order Total: {0:c}", Convert.ToDouble(sum2)); } }
protected void btnConfirm_Click(object sender, EventArgs e) { cFunctions ocFunctions = new cFunctions(); Hashtable oHashtable = new Hashtable(); int count = 0; oHashtable.Add("@UserName", Session["UserName"].ToString().Trim()); oHashtable.Add("@FirstName", Session["First"].ToString().Trim()); oHashtable.Add("@LastName", Session["Last"].ToString().Trim()); oHashtable.Add("@MI", Session["MI"].ToString().Trim()); oHashtable.Add("@Address", Session["Address"].ToString().Trim()); oHashtable.Add("@City", Session["City"].ToString().Trim()); oHashtable.Add("@State", Session["State"].ToString().Trim()); oHashtable.Add("@ZipCode", Session["Zip"].ToString().Trim()); oHashtable.Add("@PhoneNumber", Session["Phone"].ToString().Trim()); oHashtable.Add("@Email", Session["Email"].ToString().Trim()); // See if user record exists already count = ocFunctions.GetCount("SELECT count(*) from dbo.UserDetails WHERE UserName = '******'"); if (count == 0) { // Add User Details for new user ocFunctions.RunSprocBool("AddUserDetails", oHashtable); } else { // Update User Details for exisiting user ocFunctions.RunSprocBool("UpdateUserDetails", oHashtable); } // Add to Orders oHashtable.Clear(); oHashtable.Add("@UserName", Session["UserName"].ToString().Trim()); ocFunctions.RunSprocBool("PlaceOrder", oHashtable); Response.Redirect("ThankYou.aspx"); }
protected void Page_Load(object sender, EventArgs e) { int count = 0; cFunctions oFunctions = new cFunctions(); string itemID; itemID = Request.QueryString["c"].ToString().Trim(); if (itemID == string.Empty) { count = 0; } else { count = oFunctions.GetCount("SELECT count(*) from dbo.Items WHERE CategoryID = " + Request.QueryString["c"].ToString().Trim()); } if (count == 0) { this.lblNoItems.Visible = true; } else { this.lblNoItems.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { cFunctions oFunctions = new cFunctions(); String path = ""; int count = 0; try { if (Membership.GetUser().ToString().Trim() == string.Empty) { Response.Redirect("Login.aspx"); } } catch { Response.Redirect("Login.aspx"); } try { if (Request.QueryString["i"].ToString().Trim() == string.Empty) { Response.Redirect("Categories.aspx"); } } catch { Response.Redirect("Categories.aspx"); } if (oFunctions.GetStringBool("SELECT ReleaseDate FROM dbo.Items WHERE ItemID = " + Request.QueryString["i"].ToString().Trim()) != true) { this.btnAddToCart.Enabled = true; this.lblNote.Visible = false; } else { this.btnAddToCart.Enabled = false; this.lblNote.Visible = true; } path = oFunctions.GetString("SELECT ImageURL FROM dbo.Items WHERE ItemID = " + Request.QueryString["i"].ToString().Trim()); if (path != String.Empty) { this.Image1.ImageUrl = path; } else { this.Image1.ImageUrl = ""; } count = oFunctions.GetCount("SELECT count(*) from dbo.Items WHERE ItemID = " + Request.QueryString["i"].ToString().Trim()); if (count == 0) { this.Label2.Visible = true; this.lblNote.Visible = false; } else { this.Label2.Visible = false; } }