protected void Page_Load(object sender, EventArgs e) { /// retrive cart object from session state on every postback cart = CartItemList.GetCart(); //on initial page load, add cart items to list control if (!IsPostBack) { this.DisplayCart(); } }
protected void btnCheckOut_Click(object sender, EventArgs e) { Session["cart"] = cart; Random rnd = new Random(); int extensionNumber = rnd.Next(1, 2000000); Session["extensionNumber"] = extensionNumber; using (SqlConnection connection = new SqlConnection("Data Source = SQLEXPRESS; Initial Catalog = steveale_db; Integrated Security = True")) { using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = "INSERT into LineItems(extension, ProductID, UnitPrice, Quantity)" + "VALUES (@extension, @ProductID, @UnitPrice, @Quantity)"; connection.Open(); for (int i = 0; i < CartItemList.GetCart().Count; i++) { command.Parameters.Clear(); command.Parameters.AddWithValue("@extension", extensionNumber); command.Parameters.AddWithValue("@ProductID", cart[i].Product.ProductNumber.ToString()); command.Parameters.AddWithValue("@UnitPrice", Convert.ToDecimal(cart[i].Product.ProductPrice)); command.Parameters.AddWithValue("@Quantity", Convert.ToInt32(cart[i].Quantity)); command.ExecuteNonQuery(); } connection.Close(); } } Response.Redirect("PaymentMethod.aspx"); }
protected void Page_Load(object sender, EventArgs e) { cart = CartItemList.GetCart(); lblSFName.Visible = false; lblSLName.Visible = false; lblShippingaddress.Visible = false; lblSAddress.Visible = false; lblSCity.Visible = false; lblSState.Visible = false; lblSZip.Visible = false; txtSAddress.Visible = false; txtSCity.Visible = false; txtSFName.Visible = false; txtSLName.Visible = false; txtSZip.Visible = false; ddlSStates.Visible = false; }
protected void btnAddToCart_Click(object sender, EventArgs e) { string sessionAccount; try { sessionAccount = Session["sessionAccount"].ToString(); } catch (NullReferenceException) { sessionAccount = ""; } if (sessionAccount != "") { sessionAccount = Session["sessionAccount"].ToString(); } if (sessionAccount == "") { Response.Redirect("LoginPage.aspx"); } if (IsValid) { CartItemList cart = CartItemList.GetCart(); CartItem cartItem = cart[selectedProduct.ProductNumber]; if (cartItem == null) { cart.AddItem(selectedProduct, Convert.ToInt32(ddlQuantityOrdered.SelectedItem.Text)); } else { cartItem.AddQuantity(Convert.ToInt32(ddlQuantityOrdered.SelectedItem.Text)); } } Response.Redirect("~/Cart.aspx"); }
protected void btnProceedOrderConfirm_Click(object sender, EventArgs e) { int extensionNumber = Convert.ToInt32(Session["extensionNumber"]); sessionAccount = Session["sessionAccount"].ToString(); decimal Subtotal = 0m; decimal ShippingCost = 7.99m; decimal SalesTax = 1.065m; decimal Total = 0.0m; string CreditCardType = ""; double CardNumber = 0; string ExpirationMonth = ""; string ExpirationYear = ""; string CvcCode = ""; CreditCardType = ddlCreditCardType.Text.ToString(); CardNumber = Convert.ToDouble(txtCreditCardNumber.Text); ExpirationMonth = ddlExpMonth.Text.ToString(); ExpirationYear = ddlexpYear.Text.ToString(); CvcCode = txtcreditCardCVCcode.Text.ToString(); int tempquanity = 0; decimal tempPrice = 0.0m; for (int i = 0; i < CartItemList.GetCart().Count; i++) { tempquanity = cart[i].Product.ProductQuantity; tempPrice = cart[i].Product.ProductPrice; Subtotal += tempPrice * tempquanity; } Total = (Subtotal + ShippingCost) * SalesTax; Session["subtotalSession"] = Subtotal; Session["totalSession"] = Total; Session["shippingSession"] = ShippingCost; Session["taxSession"] = "6.5%"; string query = "INSERT INTO Invoices(extension, OrderDate, Subtotal, CustEmail, ShippingCost, SalesTax, Total, CreditCardType, CardNumber, ExpirationMonth, ExpirationYear, CvcCode)" + "Values('" + Subtotal + "', '" + sessionAccount + "', '" + ShippingCost + "', '" + SalesTax + "', '" + Total + "', '" + CreditCardType + "', '" + CardNumber + "', '" + ExpirationMonth + "', '" + ExpirationYear + "', '" + CvcCode + "')"; using (SqlConnection connection = new SqlConnection("Data Source = SQLEXPRESS; Initial Catalog = steveale_db; Integrated Security = True")) { using (SqlCommand command = new SqlCommand()) { connection.Open(); command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = "INSERT into Invoices (extension, OrderDate, Subtotal, CustEmail, ShippingCost, SalesTax, Total, CreditCardType, CardNumber, ExpirationMonth, ExpirationYear, CvcCode)" + "VALUES (@extension, @OrderDate, @Subtotal, @CustEmail, @ShippingCost, @SalesTax, @Total, @CreditCardType, @CardNumber, @ExpirationMonth, @ExpirationYear, @CvcCode)"; command.Parameters.AddWithValue("@extension", extensionNumber); command.Parameters.AddWithValue("@OrderDate", DateTime.Now); command.Parameters.AddWithValue("@Subtotal", Subtotal); command.Parameters.AddWithValue("@CustEmail", sessionAccount); command.Parameters.AddWithValue("@ShippingCost", ShippingCost); command.Parameters.AddWithValue("@SalesTax", SalesTax); command.Parameters.AddWithValue("@Total", Total); command.Parameters.AddWithValue("@CreditCardType", CreditCardType); command.Parameters.AddWithValue("@CardNumber", CardNumber); command.Parameters.AddWithValue("@ExpirationMonth", ExpirationMonth); command.Parameters.AddWithValue("@ExpirationYear", ExpirationYear); command.Parameters.AddWithValue("@CvcCode", CvcCode); command.ExecuteNonQuery(); connection.Close(); } } Response.Redirect("OrderConfirmation.aspx"); }