public void GetCustomer() { var da = new CustomerDA(); var entity = da.Get(60); Assert.IsTrue(entity.CustomerId > 0); }
// if shipping details are empty redirect the user to shipping=true public void EmptyShippingInfo() { // makes sure vales are not empty to avoid nullreference exception if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated || Session["AnonymousUserName"] != null) { //Instantiate our customer specific DataAccess Class CustomerDA customerDA = new CustomerDA(); // check to see if user has items in their cart //Create an Object that specifies what we want to Get Customer customer = new Customer(); //gets customer info based on customer id customer.Id = int.Parse(GetCustomerID()); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer = customerDA.Get(customer); // makes sure vales are not empty to avoid nullreference exception if (getCustomer[0].FirstName == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].LastName == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].Address == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].Address2 == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].City == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].State == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].Zip == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } if (getCustomer[0].Country == "") { Response.Redirect("CheckOut.aspx?Shipping=true"); } } }
public Customer Get(int CustomerID) { Customer oCustomer = new Customer(); Conn.Open(); SqlDataReader oReader = null; oReader = CustomerDA.Get(CustomerID, Conn); if (oReader.Read()) { oCustomer = CreateObject(oReader); } Conn.Close(); return(oCustomer); }
/// <summary> /// This method sets up addition user registration information. This code runs after /// the user has been registered to the ASP.Net tables. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void userRegistrationWizard_CreatedUser(object sender, EventArgs e) { // get references to the textboxes on the page MembershipUser newUser = Membership.GetUser(userRegistrationWizard.UserName); var txtFirstName = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("txtFirstName"); var txtLastName = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("txtLastName"); var txtAddress = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("txtAddress"); var txtAddress2 = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("txtAddress2"); var txtCity = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("txtCity"); var cboState = (DropDownList)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("cboState"); var txtZip = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("txtZip"); var cboCountry = (DropDownList)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("cboCountry"); // create a customer dataaccess object CustomerDA customerDA = new CustomerDA(); try { // get a collection of the current list of rows in the DB Collection<Customer> customerCollection = customerDA.Get(null); // get the last user ID in the table int? newUserID = customerCollection[customerCollection.Count - 1].Id + 1; // create a customer business object Customer customerObj = new Customer(newUserID, true, newUser.UserName, txtFirstName.Text, txtLastName.Text, txtAddress.Text, txtAddress2.Text, txtCity.Text, cboState.Text, txtZip.Text, cboCountry.Text); // commit customer business object to the DB using the CustomerDA customerDA.Save(customerObj); }catch(Exception ex) { // there was an error creating the users account, delete the users account Membership.DeleteUser(newUser.UserName); } if (Session["AnonymousUserName"] != null) { // get customerid of user to use customer id // for updating user information //Instantiate our customer specific DataAccess Class CustomerDA customerDA2 = new CustomerDA(); //Create an Object that specifies what we want to Get Customer customer2 = new Customer(); //gets customer info based on customer username customer2.Username = Session["AnonymousUserName"].ToString(); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer2 = customerDA.Get(customer2); TextBox userName = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("UserName"); TextBox firstName = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtFirstName"); TextBox lastName = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtLastName"); TextBox address = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtAddress"); TextBox address2 = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtAddress2"); TextBox city = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtCity"); DropDownList state = (DropDownList) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("cboState"); TextBox zipCode = (TextBox) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtZip"); DropDownList country = (DropDownList) userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("cboCountry"); // update customer information Customer customerShipping = new Customer(); customerShipping.Id = getCustomer2[0].Id; customerShipping.IsActive = true; customerShipping.Username = userName.Text; customerShipping.FirstName = firstName.Text; customerShipping.LastName = lastName.Text; customerShipping.Address = address.Text; customerShipping.Address2 = address2.Text; customerShipping.City = city.Text; customerShipping.State = state.Text; customerShipping.Zip = zipCode.Text; customerShipping.Country = country.Text; //Instantiate our customer specific DataAccess Class CustomerDA customerDAShipping = new CustomerDA(); // save customer information customerDAShipping.Save(customerShipping); // clear customerShipping = null; customerDAShipping = null; // LogIn User System.Web.Security.FormsAuthentication.SetAuthCookie(userName.Text, false); //abandon session Session.Abandon(); Session.Clear(); } }
protected void Page_Load(object sender, EventArgs e) { lblItemsInCart.Text = "0"; if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated) { // get the customerID of the user who is logged on // update customer information Customer customerIDID = new Customer(); customerIDID.Username = Membership.GetUser().UserName; //Instantiate our Category specific DataAccess Class CustomerDA customerDA = new CustomerDA(); Collection<Customer> getCustomerID = customerDA.Get(customerIDID); // returns one item // customerID = ds5.Tables[0].Rows[0].ItemArray[0]; // if statement added by Ethan, will set customerID = 0 if no rows returned. if (getCustomerID.Count > 0) { customerID = getCustomerID[0].Id; ; } else { customerID = 0; } //clear customerIDID = null; customerDA = null; getCustomerID = null; // count how many orders exists from the user that is logged on Order oID = new Order(); oID.CustomerId = int.Parse(customerID.ToString()); oID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrderID = orderIDDA.Get(oID); orderCount = getOrderID.Count; // clear oID = null; orderIDDA = null; getOrderID = null; if (int.Parse(orderCount.ToString()) == 0) { // display answer on label lblItemsInCart.Text = "0"; } else { // get the orderID of the order that has a txnid = "" of the customer Order orderIDID = new Order(); orderIDID.CustomerId = int.Parse(customerID.ToString()); orderIDID.TxnId = ""; OrderDA orderDA = new OrderDA(); Collection<Order> getOrderIDID = orderDA.Get(orderIDID); orderID = getOrderIDID[0].Id; // clear oID = null; orderIDDA = null; getOrderID = null; //count how many items are in the shopping cart for the user //and display them //instantiate class OrderItem orderItemCount = new OrderItem(); orderItemCount.OrderId = int.Parse(orderID.ToString()); OrderItemDA orderItemCountDA = new OrderItemDA(); Collection<OrderItem> getOrderItemCount = orderItemCountDA.Get(orderItemCount); items = getOrderItemCount.Count; // clear orderItemCount = null; orderItemCountDA = null; getOrderItemCount = null; // display answer on label lblItemsInCart.Text = items.ToString(); } } else { // if the customer is not logged on but has an item in there cart if (Session["AnonymousUserName"] != null) { // get the customerID Customer customerIDID = new Customer(); customerIDID.Username = Session["AnonymousUserName"].ToString(); //Instantiate our Category specific DataAccess Class CustomerDA customerDA = new CustomerDA(); Collection<Customer> getCustomerID = customerDA.Get(customerIDID); customerID = getCustomerID[0].Id.ToString(); //clear customerIDID = null; customerDA = null; getCustomerID = null; // get the current orderID if any if not make shopping cart items 0 // count how many orders exists from the user that is logged on Order oID = new Order(); oID.CustomerId = int.Parse(customerID.ToString()); oID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrderID = orderIDDA.Get(oID); orderCount = getOrderID.Count; // clear oID = null; orderIDDA = null; getOrderID = null; if (int.Parse(orderCount.ToString()) == 0) { // display answer on label lblItemsInCart.Text = "0"; } else { // get the customerID // get the customerID Customer customerIDID2 = new Customer(); customerIDID2.Username = Session["AnonymousUserName"].ToString(); //Instantiate our Category specific DataAccess Class CustomerDA customerDA2 = new CustomerDA(); Collection<Customer> getCustomerID2 = customerDA2.Get(customerIDID2); customerID = getCustomerID2[0].Id; //clear customerIDID2 = null; customerDA2 = null; getCustomerID2 = null; // get the orderID of the order with the txnid = "" for the anonyomous user Order oID2 = new Order(); oID2.CustomerId = int.Parse(customerID.ToString()); oID2.TxnId = ""; OrderDA orderIDDA2 = new OrderDA(); Collection<Order> getOrderID2 = orderIDDA2.Get(oID2); orderID = getOrderID2[0].Id; // clear oID2 = null; orderIDDA2 = null; getOrderID2 = null; //count how many items are in the shopping cart for the anonymous user //and display them //instantiate class OrderItem orderItemCount = new OrderItem(); orderItemCount.OrderId = int.Parse(orderID.ToString()); OrderItemDA orderItemCountDA = new OrderItemDA(); Collection<OrderItem> getOrderItemCount = orderItemCountDA.Get(orderItemCount); items = getOrderItemCount.Count; // clear orderItemCount = null; orderItemCountDA = null; getOrderItemCount = null; // display answer on label lblItemsInCart.Text = items.ToString(); } } } }
// on logged in protected void LoggedIn(object sender, EventArgs e) { // seeing if there is an order just in case I missed something if (Session["AnonymousUserName"] != null) { // if the user has an order on going delete it and replace it // with the items that the anonymous user just made(which is really a customer) //Instantiate our Category specific DataAccess Class CustomerDA customerDA = new CustomerDA(); // check to see if user has items in their cart //Create an Object that specifies what we want to Get Customer customer = new Customer(); //gets customer info based on customer username customer.Username = UserLogin.UserName; //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer = customerDA.Get(customer); // count orders with customerid = @customerid and txtnid = @txnid // instantiate class Order orders = new Order(); orders.CustomerId = getCustomer[0].Id; orders.TxnId = ""; OrderDA orderDA = new OrderDA(); Collection<Order> getOrders = orderDA.Get(orders); // returns number of orders object getOrder = getOrders.Count; //clear orders = null; orderDA = null; getOrders = null; // if the user who is logged has items in his cart as an anonymous user // delete the items he had previously on his cart and add the new items and order // that they just put into his cart if (int.Parse(getOrder.ToString()) > 0) { // get the orderID of the customer that he had on going order // instantiate class Order oID = new Order(); oID.CustomerId = getCustomer[0].Id; oID.TxnId = ""; OrderDA ordersDA = new OrderDA(); Collection<Order> getOID = ordersDA.Get(oID); // returns one item object getOrderID = getOID[0].Id; //clear oID = null; ordersDA = null; getOID = null; // delete the order and items that involve the order above // delete items from the orderItem table associated with that order if any //Create an Object that specifies what we want to Get // OrderItem deleteOrderItem = new OrderItem(); //OrderItemDA deleteOrderItemDA = new OrderItemDA(); ////gets orderItem info based on customerID //deleteOrderItem.OrderId = int.Parse(getOrderID.ToString()); //// deletes the orderItems with that customerID //deleteOrderItemDA.Delete(deleteOrderItem); //// clear //deleteOrderItemDA = null; //deleteOrderItem = null; DAL.DataAccess da5 = new DAL.DataAccess( ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, "System.Data.SqlClient"); string comm5 = "Delete FROM OrderItem WHERE OrderID = @orderID"; // array with orderID string[] p5 = { "@orderID" }; string[] v5 = { getOrderID.ToString() }; da5.ExecuteNonQuery(comm5, p5, v5); // clear p5 = null; v5 = null; // delete order //Instantiate our Order specific DataAccess Class OrderDA deleteOrderDA = new OrderDA(); //Create an Object that specifies what we want to Get Order deleteOrder = new Order(); //gets order info based on customerID deleteOrder.Id = int.Parse(getOrderID.ToString()); // deletes the order with that customerID deleteOrderDA.Delete(deleteOrder); // clear deleteOrderDA = null; deleteOrder = null; // get cusotmerID of anonymous user //Instantiate our Category specific DataAccess Class CustomerDA customerDA2 = new CustomerDA(); // check to see if user has items in their cart //Create an Object that specifies what we want to Get Customer customer2 = new Customer(); //gets customer info based on customer username customer2.Username = Session["AnonymousUserName"].ToString(); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer2 = customerDA2.Get(customer2); //for (int i = 0; i < getCustomer2.Count; i++) //{ // getCustomer2[i].Id; //} // get orderID of anonymous user //Create an Object that specifies what we want to Get Order ordersID = new Order(); //gets order info based on customerID ordersID.CustomerId = getCustomer2[0].Id; OrderDA ordersIDDA = new OrderDA(); // deletes the order with that customerID Collection<Order> getOrder2 = ordersIDDA.Get(ordersID); // update the customerid of the anonymous order to the customer, of the user who just logged on DAL.DataAccess da4 = new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, "System.Data.SqlClient"); string comm4 = "UPDATE Orders SET CustomerID = @customerID WHERE OrderID = @orderID AND TXNID = @txnID"; // empty array string[] p4 = { "@customerID", "@orderID", "@txnID" }; string[] v4 = { getCustomer[0].Id.ToString(), getOrder2[0].Id.ToString(), "" }; // new cus old get order da4.ExecuteNonQuery(comm4, p4, v4); // clear p4 = null; v4 = null; // delete anonymous customer from customer table Customer customers = new Customer(); customers.Id = getCustomer2[0].Id; CustomerDA customersDA = new CustomerDA(); customersDA.Delete(customers); // clear customers = null; customersDA = null; //abandon session Session.Abandon(); Session.Clear(); } // if user doesn't have an on going order just // change the customer ID on the order else { // get cusotmerID of anonymous user //Instantiate our Category specific DataAccess Class CustomerDA customerDA2 = new CustomerDA(); // check to see if user has items in their cart //Create an Object that specifies what we want to Get Customer customer2 = new Customer(); //gets customer info based on customer username customer2.Username = Session["AnonymousUserName"].ToString(); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer2 = customerDA2.Get(customer2); //for (int i = 0; i < getCustomer2.Count; i++) //{ // getCustomer2[i].Id; //} // get orderID of anonymous user based on customerID OrderDA ordersIDDA = new OrderDA(); //Create an Object that specifies what we want to Get Order ordersID = new Order(); //gets order info based on customerID ordersID.CustomerId = getCustomer2[0].Id; // deletes the order with that customerID Collection<Order> getOrder2 = ordersIDDA.Get(ordersID); // update the customerid of the anonymous order to the customer, of the user who just logged on DAL.DataAccess da4 = new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, "System.Data.SqlClient"); string comm4 = "UPDATE Orders SET CustomerID = @customerID WHERE OrderID = @orderID AND TXNID = @txnID"; // empty array string[] p4 = { "@customerID", "@orderID", "@txnID" }; string[] v4 = { getCustomer[0].Id.ToString(), getOrder2[0].Id.ToString(), "" }; // new cus old get order da4.ExecuteNonQuery(comm4, p4, v4); // clear p4 = null; v4 = null; // delete anonymous customer from customer table Customer customers = new Customer(); customers.Id = getCustomer2[0].Id; CustomerDA customersDA = new CustomerDA(); customersDA.Delete(customers); // clear customers = null; customersDA = null; //DAL.DataAccess da8 = // new DAL.DataAccess( // ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, // "System.Data.SqlClient"); //string comm8 = // "Delete FROM Customer WHERE CustomerID = @customerID"; //// array with customerID //string[] p8 = { "@customerID" }; //string[] v8 = { getCustomer2[0].Id.ToString() }; //da8.ExecuteNonQuery(comm8, p8, v8); //// clear //p8 = null; //v8 = null; //abandon session Session.Abandon(); Session.Clear(); } } }
protected void btnAddToCart_Click(object sender, EventArgs e) { // try catch for notifying the user when they // try to enter an item to their shopping cart // that is already in their shopping cart try { // call method to get values from the labels and textboxes // on the formview GetItems(); // check to see if user is logged on if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated) { // get the customerID of the user who is logged on // get the id of the user that I just created Customer customer = new Customer(); customer.Username = User.Identity.Name; CustomerDA customerIDDA = new CustomerDA(); Collection<Customer> getCustomersID = customerIDDA.Get(customer); customerID = getCustomersID[0].Id; // clear customer = null; customerIDDA = null; // count how many orders that have not been verified exist in the orders table Order order = new Order(); order.CustomerId = int.Parse(customerID.ToString()); order.TxnId = ""; OrderDA orderDA = new OrderDA(); Collection<Order> getOrders = orderDA.Get(order); // returns one item countOrders = getOrders.Count; //clear order = null; orderDA = null; getOrders = null; // if there are no orders with a txnID = "" then add a new order // then get the OrderID of the Order to add items to the shopping // cart using that OrderID // if there are orders with a txnID = "" then select the OrderID // and add orders to the shopping cart using that OrderID if (int.Parse(countOrders.ToString()) == 0) { // add a new order to the order table // instantiate class DAL.DataAccess da6 = new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, "System.Data.SqlClient"); // make command statement string comm6 = "INSERT INTO Orders VALUES (@customerID, @grossTotal, @tax, @netTotal, @txnID, @paymentStatus)"; // make arrays for paramaters and input string[] s6 = { "@customerID", "@grossTotal", "@tax", "@netTotal", "@txnID", "@paymentStatus" }; string[] v6 = { customerID.ToString(), "0", "0", "0", "", "" }; da6.ExecuteNonQuery(comm6, s6, v6); //clear s6 = null; v6 = null; // get the orderID of the order that was just created // insert sale price Order orderIID = new Order(); orderIID.CustomerId = int.Parse(customerID.ToString()); orderIID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrder = orderIDDA.Get(orderIID); orderID = getOrder[0].Id; //clear orderIID = null; getOrder = null; // see if item is on sale if (isItemOnSale() == true) { // insert item into the database using the OrderID that was created // instantiate class // insert sale price OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(salePriceAnswerDouble.ToString("n2")); orderItem.TotalPrice = decimal.Parse(salePriceAnswerDouble.ToString("n2")); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; //// tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; Response.Redirect(Request.RawUrl); } else { // insert regular price OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(price.ToString("n2")); orderItem.TotalPrice = decimal.Parse(price.ToString("n2")); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); // Response.Redirect(Request.RawUrl); } } else { // get the orderID of the user that has a txnID = "" // instantiate class Order orderIID = new Order(); orderIID.CustomerId = int.Parse(customerID.ToString()); orderIID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrder = orderIDDA.Get(orderIID); orderID = getOrder[0].Id; //clear orderIID = null; getOrder = null; // check to see if the customer has the item in their cart already. // if they do, do not insert item into database OrderItem orderItemExistence = new OrderItem(); orderItemExistence.OrderId = int.Parse(orderID.ToString()); orderItemExistence.ItemId = itemID.Text; OrderItemDA orderItemExistenceDA = new OrderItemDA(); Collection<OrderItem> getOrderItemExistence = orderItemExistenceDA.Get(orderItemExistence); countItems = getOrderItemExistence.Count; if (countItems > 0) { error.Text = "This item is in your shopping cart."; error.Visible = true; } else { // see if item is on sale if (isItemOnSale() == true) { // insert sale price OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(salePriceAnswerDouble.ToString("n2")); orderItem.TotalPrice = decimal.Parse(salePriceAnswerDouble.ToString("n2")); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } else { // insert regular price OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(price.ToString("n2")); orderItem.TotalPrice = decimal.Parse(price.ToString("n2")); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } } } } // if user is not logged on make up and account else { // if the anonymous session anonymouscustomerID is empty // create a new username and customerID if (Session["AnonymousUserName"] == null) { // get all rows to get maximum customerID CustomerDA customerDA = new CustomerDA(); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomers = customerDA.Get(null); // gets max customerID in table // adds one and combines websites domain name // with the anonymousID max = (int)getCustomers[getCustomers.Count - 1].Id; usernameID = int.Parse(max.ToString()) + 1; anonymousUserName = "******" + usernameID; //clear customerDA = null; getCustomers = null; // insert the anonymousCustomerID into the customer table with the username of // and the usernameID/customerID // mypetsfw.com + customerID Customer customer = new Customer(usernameID, true, anonymousUserName, "Fill In", "Fill In", "Fill In", "Fill In", "Fill In", "", "Fill In", ""); CustomerDA customerDA1 = new CustomerDA(); customerDA1.Save(customer); // clear customer = null; customerDA = null; // put the anonymoususername in a session Session["AnonymousUserName"] = anonymousUserName.ToString(); // create a new order of the anonymous user // add a new order to the order table // instantiate class Order oID1 = new Order(); oID1.Id = GetOrderIDPlusOne(); oID1.CustomerId = usernameID; oID1.GrossTotal = 0; oID1.Tax = 0; oID1.NetTotal = 0; // for payment status oID1.TxnId = ""; OrderDA orderIDDA1 = new OrderDA(); // save orderIDDA1.Save(oID1); //DAL.DataAccess da11 = // new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, // "System.Data.SqlClient"); //// make command statement //string comm11 = "INSERT INTO Orders VALUES (@customerID, @grossTotal, @tax, @netTotal, @txnID, @paymentStatus)"; //// make arrays for paramaters and input //string[] s11 = { "@customerID", "@grossTotal", "@tax", "@netTotal", "@txnID", "@paymentStatus" }; //string[] v11 = { usernameID.ToString(), "0", "0", "0", "", "" }; //da11.ExecuteNonQuery(comm11, s11, v11); //clear oID1 = null; orderIDDA1 = null; // get the orderID of the anonymoususer // get the id of the user that I just created Order oID = new Order(); oID.CustomerId = usernameID; oID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrderID = orderIDDA.Get(oID); orderID = getOrderID[0].Id; //clear oID = null; getOrderID = null; // see if item is on sale if (isItemOnSale() == true) { // insert item into the database using the OrderID that was created // instantiate class OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(salePriceAnswerDouble.ToString()); orderItem.TotalPrice = decimal.Parse(salePriceAnswerDouble.ToString()); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; // tell anonymous the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } else { // insert item into the database using the OrderID that was created // instantiate class OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(price.ToString()); orderItem.TotalPrice = decimal.Parse(price.ToString()); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; // tell anonymous the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } } // if the session doesn't != null else { // get the customerID of the user that I just created Customer customer2 = new Customer(); customer2.Username = Session["AnonymousUserName"].ToString(); CustomerDA customerDA2 = new CustomerDA(); Collection<Customer> getCustomers2 = customerDA2.Get(customer2); customerID = getCustomers2[0].Id; // clear customer2 = null; customerDA2 = null; getCustomers2 = null; // see if an order doesn't already exist for the anonymousUser // count how many orderIDs that have not been verified exist in the orders table Order orders = new Order(); orders.CustomerId = int.Parse(customerID.ToString()); orders.TxnId = ""; OrderDA orderDA = new OrderDA(); Collection<Order> getOrder = orderDA.Get(orders); // returns one item countOrders = getOrder.Count; //clear orders = null; orderDA = null; getOrder = null; // if there are no orders with a txnID = "" then add a new order // then get the OrderID of the Order to add items to the shopping // cart using that OrderID // if there are orders with a txnID = "" then select the OrderID // and add orders to the shopping cart using that OrderID if (int.Parse(countOrders.ToString()) == 0) { // get the customerID of the user that I just created Customer customerIDID = new Customer(); customerIDID.Username = Session["AnonymousUserName"].ToString(); CustomerDA customerIDDA = new CustomerDA(); Collection<Customer> getCustomers3 = customerIDDA.Get(customerIDID); customerID = getCustomers3[0].Id; // clear customerIDID = null; customerIDDA = null; getCustomers3 = null; // create a new order of the anonymous user // add a new order to the order table // instantiate class Order oID1 = new Order(); oID1.Id = GetOrderIDPlusOne(); oID1.CustomerId = usernameID; oID1.GrossTotal = 0; oID1.Tax = 0; oID1.NetTotal = 0; // for payment status oID1.TxnId = ""; OrderDA orderIDDA1 = new OrderDA(); // save orderIDDA1.Save(oID1); //DAL.DataAccess da11 = // new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString, // "System.Data.SqlClient"); //// make command statement //string comm11 = "INSERT INTO Orders VALUES (@customerID, @grossTotal, @tax, @netTotal, @txnID, @paymentStatus)"; //// make arrays for paramaters and input //string[] s11 = { "@customerID", "@grossTotal", "@tax", "@netTotal", "@txnID", "@paymentStatus" }; //string[] v11 = { customerID.ToString(), "0", "0", "0", "", "" }; //da11.ExecuteNonQuery(comm11, s11, v11); //clear oID1 = null; orderIDDA1 = null; // get the orderid for the anonymous users new order Order oID = new Order(); oID.CustomerId = int.Parse(customerID.ToString()); oID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrderID = orderIDDA.Get(oID); orderID = int.Parse(getOrderID[0].Id.ToString()); //clear oID = null; orderIDDA = null; getOrderID = null; // see if item is on sale if (isItemOnSale() == true) { // insert item into the database using the OrderID that was created // instantiate class OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(salePriceAnswerDouble.ToString()); orderItem.TotalPrice = decimal.Parse(salePriceAnswerDouble.ToString()); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } else { // insert item into the database using the OrderID that was created // instantiate class OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(price.ToString()); orderItem.TotalPrice = decimal.Parse(price.ToString()); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } } // if an order is open and exists for the anonymous user else { // get the customerID of the user that I just created Customer customerIDID = new Customer(); customerIDID.Username = Session["AnonymousUserName"].ToString(); CustomerDA customerIDDA = new CustomerDA(); Collection<Customer> getCustomers3 = customerIDDA.Get(customerIDID); customerID = getCustomers3[0].Id; // clear customerIDID = null; customerIDDA = null; getCustomers3 = null; // get the orderID of the anonymoususer that has a txnID = "" // instantiate class Order oID = new Order(); oID.CustomerId = int.Parse(customerID.ToString()); oID.TxnId = ""; OrderDA orderIDDA = new OrderDA(); Collection<Order> getOrderID = orderIDDA.Get(oID); orderID = getOrderID[0].Id; //clear oID = null; orderIDDA = null; getOrderID = null; // check to see if the anonymous user has the item in their cart already. // if they do, do not insert item into database OrderItem orderItemExistence = new OrderItem(); orderItemExistence.OrderId = int.Parse(orderID.ToString()); orderItemExistence.ItemId = itemID.Text; OrderItemDA orderItemExistenceDA = new OrderItemDA(); Collection<OrderItem> getOrderItemExistence = orderItemExistenceDA.Get(orderItemExistence); countItems = getOrderItemExistence.Count; if (countItems > 0) { error.Text = "This item is in your shopping cart."; error.Visible = true; } else { // see if item is on sale if (isItemOnSale() == true) { // insert item into the database using the existing OrdersID // instantiate class OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(salePriceAnswerDouble.ToString()); orderItem.TotalPrice = decimal.Parse(salePriceAnswerDouble.ToString()); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // clear orderItem = null; orderItemDA = null; // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } else { // insert item into the database using the existing OrdersID // instantiate class OrderItem orderItem = new OrderItem(); orderItem.OrderId = int.Parse(orderID.ToString()); orderItem.ItemId = itemID.Text; orderItem.VendorId = int.Parse(vendorID.Text); orderItem.Price = decimal.Parse(price.ToString()); orderItem.TotalPrice = decimal.Parse(price.ToString()); orderItem.Quantity = int.Parse(quantity.Text); OrderItemDA orderItemDA = new OrderItemDA(); //Save the Objects to the Database orderItemDA.Save(orderItem); // tell user the item was added to their cart successfully successful.Text = "Added to shopping cart successfully!"; successful.Visible = true; // refresh page Response.AppendHeader("Refresh", "0;URL=ItemDetails.aspx?ItemID=" + Request.QueryString["ItemID"]); } } } } } } catch (SqlException) { // error.Text = "The item is in your shopping cart already."; // error.Visible = true; } catch (Exception) { } }
// method for binding RPTShipping private void BindRPTShipping() { //Instantiate our Category specific DataAccess Class CustomerDA customerDA = new CustomerDA(); // check to see if user has items in their cart //Create an Object that specifies what we want to Get Customer customer = new Customer(); //gets customer info based on customer id customer.Id = int.Parse(GetCustomerID()); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer = customerDA.Get(customer); rptShippingAddress.DataSource = getCustomer; rptShippingAddress.DataBind(); }
// on user created // get the customerid of the user who is making an account // register user using the customerID // redirect user to shipping protected void ReconfigureOrder(object sender, EventArgs e) { if (Session["AnonymousUserName"] != null) { // get customerid of user to use customer id // for updating user information //Instantiate our customer specific DataAccess Class CustomerDA customerDA = new CustomerDA(); //Create an Object that specifies what we want to Get Customer customer = new Customer(); //gets customer info based on customer username customer.Username = Session["AnonymousUserName"].ToString(); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer = customerDA.Get(customer); TextBox userName = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("UserName"); TextBox firstName = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtFirstName"); TextBox lastName = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtLastName"); TextBox address = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtAddress"); TextBox address2 = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtAddress2"); TextBox city = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtCity"); DropDownList state = (DropDownList)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("cboState"); TextBox zipCode = (TextBox)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("RtxtZip"); DropDownList country = (DropDownList)userRegistrationWizard.CreateUserStep.ContentTemplateContainer.FindControl("cboCountry"); // update customer information Customer customerShipping = new Customer(); customerShipping.Id = getCustomer[0].Id; customerShipping.IsActive = true; customerShipping.Username = userName.Text; customerShipping.FirstName = firstName.Text; customerShipping.LastName = lastName.Text; customerShipping.Address = address.Text; customerShipping.Address2 = address2.Text; customerShipping.City = city.Text; customerShipping.State = state.Text; customerShipping.Zip = zipCode.Text; customerShipping.Country = country.Text; //Instantiate our customer specific DataAccess Class CustomerDA customerDAShipping = new CustomerDA(); // save customer information customerDAShipping.Save(customerShipping); // clear customerShipping = null; customerDAShipping = null; // LogIn User System.Web.Security.FormsAuthentication.SetAuthCookie(userName.Text, false); //abandon session Session.Abandon(); Session.Clear(); // redirect user to shipping=true Response.Redirect("CheckOut.aspx?Shipping=true"); } }
protected void GetShippingInformation() { if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated || Session["AnonymousUserName"] != null) { //gets customer info based on customer id Customer customer = new Customer(); customer.Id = int.Parse(GetCustomerID()); CustomerDA customerDA = new CustomerDA(); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer = customerDA.Get(customer); // makes sure vales are not empty to avoid nullreference exception if (getCustomer[0].FirstName != "") { txtFirstName.Text = getCustomer[0].FirstName; } if (getCustomer[0].LastName != "") { txtLastName.Text = getCustomer[0].LastName; } if (getCustomer[0].Address != "") { txtAddress1.Text = getCustomer[0].Address; } if (getCustomer[0].Address2 != "") { txtAddress2.Text = getCustomer[0].Address2; } if (getCustomer[0].City != "") { txtCity.Text = getCustomer[0].City; } if (getCustomer[0].State != "") { ddlState.Text = getCustomer[0].State; } if (getCustomer[0].Zip != "") { txtZipCode.Text = getCustomer[0].Zip; } if (getCustomer[0].Country != "") { ddlCountry.Text = getCustomer[0].Country; } } }
// gets state of user that is logged in or has a session to calculate the tax public string GetState() { if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated || Session["AnonymousUserName"] != null) { //Instantiate our Category specific DataAccess Class CustomerDA customerDA = new CustomerDA(); // check to see if user has items in their cart //Create an Object that specifies what we want to Get Customer customer = new Customer(); //gets customer info based on customer id customer.Id = int.Parse(GetCustomerID()); //We will be returned a collection so lets Declare that and fill it using Get() Collection<Customer> getCustomer = customerDA.Get(customer); return getCustomer[0].State; } return ""; }
// retrieves customerID of anonymous and customer public string GetCustomerID() { if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated) { // get the customerID of the user who is logged on Customer customerIDID = new Customer(); customerIDID.Username = User.Identity.Name; CustomerDA customerIDDA = new CustomerDA(); Collection<Customer> getCustomers3 = customerIDDA.Get(customerIDID); customerID = getCustomers3[0].Id; // clear customerIDID = null; customerIDDA = null; getCustomers3 = null; return customerID.ToString(); } else { // get the customerID of the user who is logged on // get the customerID of the user who is logged on Customer customerIDID = new Customer(); customerIDID.Username = Session["AnonymousUserName"].ToString(); CustomerDA customerIDDA = new CustomerDA(); Collection<Customer> getCustomers3 = customerIDDA.Get(customerIDID); customerID = getCustomers3[0].Id; // clear customerIDID = null; customerIDDA = null; getCustomers3 = null; return customerID.ToString(); } }