protected void registerBtn_Click(object sender, EventArgs e) { if (Page.IsValid) { using (ECTDBContext entities = new ECTDBContext()) { var member = entities.Customers.Create(); var address = entities.Addresses.Create(); member.FirstName = firstNameTxt.Text; member.LastName = lastNameTxt.Text; member.Email = emailTxt.Text; member.UserName = userNameTxt2.Text; member.Password = SecuredPassword.GenerateHash(passwordTxt2.Text); member.DateRegistered = DateTime.Now.Date; entities.Customers.Add(member); entities.SaveChanges(); var pwdHash = SecuredPassword.GenerateHash(passwordTxt2.Text); var user = (from u in entities.Customers where u.UserName == userNameTxt2.Text && u.Password == pwdHash select u).FirstOrDefault(); address.CustomerID = user.ID; address.Address1 = addressTxt.Text; address.City = cityTxt.Text; address.State = stateTxt.Text; address.AddressType = "Billing"; entities.Addresses.Add(address); entities.Addresses.Add(address); entities.SaveChanges(); clearTextBoxes(registerControl); registerSuccessLbl.Visible = true; } } }
protected void update_Click(object sender, EventArgs e) { if (Page.IsValid) { pnlMain.Visible = true; pnlUpdate.Visible = false; using (ECTDBContext entities = new ECTDBContext()) { var userID = Int32.Parse(Session["LoggedInId"].ToString()); var userInfo = (from u in entities.Customers where u.ID == userID select u).FirstOrDefault(); var userAddress = (from a in entities.Addresses where a.CustomerID == userID select a).FirstOrDefault(); userInfo.Email = emailTxt.Text; userInfo.FirstName = firstNameTxt.Text; userInfo.LastName = lastNameTxt.Text; userInfo.UserName = userNameTxt2.Text; userAddress.Address1 = addressTxt.Text; userAddress.State = stateTxt.Text; userAddress.City = cityTxt.Text; entities.SaveChanges(); } Response.Redirect("Account.aspx"); } }
private List <String> getProducts(Object ID) { int orderID = Convert.ToInt32(ID); using (ECTDBContext entities = new ECTDBContext()) { var products = (from od in entities.OrderDetails where od.OrderID == orderID select od.ProductName).ToList(); return(products); } }
private List <int> getQuantities(Object ID) { int orderID = Convert.ToInt32(ID); using (ECTDBContext entities = new ECTDBContext()) { var quantities = (from od in entities.OrderDetails where od.OrderID == orderID select od.Quantity).ToList(); return(quantities); } }
public void placeOrderClick(object sender, EventArgs e) { if (Session["update"].ToString() == ViewState["update"].ToString()) { using (ECTDBContext context = new ECTDBContext()) { var order = (from or in context.Orders where or.CustomerID == userID && or.IsCart == "true" select or).FirstOrDefault(); if (order != null) { String cost = order.Total.ToString(); String orderID = order.ID.ToString(); var orderDetailList = (from od in context.OrderDetails where od.OrderID == order.ID select od).ToList(); foreach (OrderDetail od in orderDetailList) { if (od.OrderID == order.ID) { int quantity = od.Quantity; int productID = od.ProductID; var product = (from p in context.Products where p.ID == productID select p).FirstOrDefault(); product.TotalOnHand -= quantity; order.IsCart = "false"; order.Date = DateTime.Now.ToString("MM/dd/yy"); Session["cartCount"] = "0"; context.SaveChanges(); RedirectUser(orderID, cost); } } Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString()); } } } else { return; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["LoggedInId"] == null) { Response.Redirect("Login.aspx"); } else { if (!IsPostBack) { Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString()); } userID = int.Parse(Session["LoggedInId"].ToString()); //update cart text in header String cartCount = Session["cartCount"].ToString(); this.Master.CartText = cartCount; String userName = Session["UserName"].ToString(); Master.UserNameHeader = userName; Master.FindControl("signOut").Visible = true; using (ECTDBContext entities = new ECTDBContext()) { var sorted = entities.Products.OrderBy(c => c.ID); var firstRowProducts = (from p in sorted select p).Skip(0).Take(5).ToList(); var secondRowProducts = (from p in sorted select p).Skip(5).Take(5).ToList(); if (!Page.IsPostBack) { productListView.DataSource = firstRowProducts; productListView2.DataSource = secondRowProducts; productListView.DataBind(); productListView2.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["LoggedInId"] == null) { Response.Redirect("Login.aspx"); } else if (!IsPostBack) { Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString()); } userID = int.Parse(Session["LoggedInId"].ToString()); String cartCount = Session["cartCount"].ToString(); Master.CartText = cartCount; String userName = Session["UserName"].ToString(); Master.UserNameHeader = userName; Master.FindControl("signOut").Visible = true; using (ECTDBContext context = new ECTDBContext()) { var orderList = (from o in context.Orders where o.CustomerID == userID && o.IsCart == "true" select o).ToList(); if (orderList.Count != 0) { var order = orderList.First(); var orderDetailList = (from od in context.OrderDetails where od.OrderID == order.ID select od).ToList(); if (!Page.IsPostBack) { totalListView.DataSource = orderList; summaryListView.DataSource = orderDetailList; totalListView.DataBind(); summaryListView.DataBind(); } } } }
protected void login(object sender, EventArgs e) { if (Page.IsValid) { using (ECTDBContext context = new ECTDBContext()) { var pwdHash = SecuredPassword.GenerateHash(txtPassword.Text); var user = (from u in context.Customers where u.UserName == txtUserName.Text && u.Password == pwdHash select u).FirstOrDefault(); if (user == null) { errorMessage.Visible = true; } else { Session["LoggedInId"] = user.ID.ToString(); Session["FirstName"] = user.FirstName; Session["LastName"] = user.LastName; Session["UserName"] = user.UserName; var userOrder = (from order in context.Orders where order.CustomerID == user.ID && order.IsCart == "true" select order).FirstOrDefault(); //if user has existing cart, restore cart number at top of page and store session variable if (userOrder != null) { var cart = (from od in context.OrderDetails where od.OrderID == userOrder.ID select od.Quantity).ToList(); int cartCount = cart.Sum(); Session["cartCount"] = cartCount.ToString(); } else { Session["cartCount"] = "0"; } Response.Redirect("Home.aspx"); } } } }
public void removeFromCart(Object sender, EventArgs e) { if (Session["update"].ToString() == ViewState["update"].ToString()) { Button b = (Button)sender; //store the commandargument attached to the delete button int id = Convert.ToInt32(b.CommandArgument.ToString()); using (ECTDBContext context = new ECTDBContext()) { var orderDetail = (from o in context.OrderDetails where o.ID == id select o).FirstOrDefault(); Decimal deletePrice = orderDetail.Cost * orderDetail.Quantity; context.OrderDetails.Remove(orderDetail); context.SaveChanges(); //update cart item number at top of page int cartCount = int.Parse(Session["cartCount"].ToString()); cartCount -= orderDetail.Quantity; Session["cartCount"] = cartCount; Master.CartText = cartCount.ToString(); var updatedOrder = (from order in context.Orders where order.CustomerID == userID && order.IsCart == "true" select order).ToList(); var newOrder = updatedOrder.First(); newOrder.Total -= deletePrice; context.SaveChanges(); var updatedOrderDetail = (from od in context.OrderDetails where od.OrderID == newOrder.ID select od).ToList(); summaryListView.DataSource = updatedOrderDetail; totalListView.DataSource = updatedOrder; summaryListView.DataBind(); totalListView.DataBind(); } Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString()); } else { return; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["LoggedInId"] == null) { Response.Redirect("Login.aspx"); } else { int userID = Int32.Parse(Session["LoggedInId"].ToString()); String cartCount = Session["cartCount"].ToString(); Master.CartText = cartCount; String userName = Session["UserName"].ToString(); Master.UserNameHeader = userName; Master.FindControl("signOut").Visible = true; //To display order history gridview SqlDataSource1.SelectParameters.Add("userID", userID.ToString()); SqlDataSource1.SelectParameters.Add("false", "false"); SqlDataSource1.SelectCommand = "select Orders.ID, Orders.Total, Orders.Date from Orders where @userID = Orders.CustomerID and Orders.IsCart = @false"; using (ECTDBContext context = new ECTDBContext()) { var customer = ( from c in context.Customers where c.ID == userID select c).FirstOrDefault(); var address = ( from a in context.Addresses where a.CustomerID == userID select a).FirstOrDefault(); lblFirst.Text = "First Name: " + customer.FirstName; lblLast.Text = "Last Name: " + customer.LastName; lblEmail.Text = "Email: " + customer.Email; lblAddress.Text = "Address: " + address.Address1; lblCity.Text = "City: " + address.City; lblState.Text = "State: " + address.State; } } }
public void createNewCart(int itemID, int quantity) { using (ECTDBContext context = new ECTDBContext()) { //Edit the cart number at top of page int cartCount = int.Parse(Session["cartCount"].ToString()); cartCount += quantity; Session["cartCount"] = cartCount; Master.CartText = cartCount.ToString(); //Build new Order entry var newOrder = new Order(); newOrder.CustomerID = userID; newOrder.IsCart = "true"; newOrder.Total = 0; newOrder.ShippingID = 1; newOrder.ShippingAddressID = 1; context.Orders.Add(newOrder); context.SaveChanges(); //Build new OrderDetail entry var newOrderDetail = new OrderDetail(); //find new order var newOrderVar = (from order in context.Orders where order.IsCart == "true" && order.CustomerID == userID select order).FirstOrDefault(); newOrderDetail.OrderID = newOrderVar.ID; var product = (from p in context.Products where p.ID == itemID select p).FirstOrDefault(); newOrderDetail.Cost = product.Cost; newOrderDetail.Quantity = quantity; newOrderDetail.ProductID = itemID; newOrderDetail.ProductName = product.Name; newOrderVar.Total += newOrderDetail.Cost * newOrderDetail.Quantity; context.OrderDetails.Add(newOrderDetail); context.SaveChanges(); } }
protected void passWordConfirm_Click(object sender, EventArgs e) { if (Page.IsValid) { pnlMain.Visible = true; orderHistory.Visible = true; pnlPassword.Visible = false; using (ECTDBContext entities = new ECTDBContext()) { var pwdHash = SecuredPassword.GenerateHash(passwordTxt.Text); var userID = Int32.Parse(Session["LoggedInId"].ToString()); var customer = (from c in entities.Customers where c.ID == userID select c).FirstOrDefault(); if (customer.Password == pwdHash && newPasswordTxt.Text.ToString().Length > 0) { customer.Password = SecuredPassword.GenerateHash(newPasswordTxt.Text); entities.SaveChanges(); } } } }
public void addToCartClick(object sender, EventArgs e) { if (Session["update"].ToString() == ViewState["update"].ToString()) { using (ECTDBContext context = new ECTDBContext()) { Button b = (Button)sender; //store the commandargument attached to the delete button int id = Convert.ToInt32(b.CommandArgument.ToString()); //Get quantity value from textbox ListViewDataItem item = b.NamingContainer as ListViewDataItem; TextBox quantityText = item.FindControl("quantityText") as TextBox; int quantity = Convert.ToInt32(quantityText.Text); if (quantity == 0) { return; } else { var product = (from p in context.Products where p.ID == id select p).FirstOrDefault(); var userOrdersList = (from o in context.Orders where o.CustomerID == userID && o.IsCart == "true" select o).ToList(); //If user has an existing cart if (userOrdersList.Count > 0) { //Edit the cart number at top of page int cartCount = int.Parse(Session["cartCount"].ToString()); cartCount += quantity; Session["cartCount"] = cartCount; this.Master.CartText = cartCount.ToString(); var userOrders = userOrdersList.First(); var repeatOrderDetail = (from or in context.OrderDetails where or.OrderID == userOrders.ID && or.ProductID == id select or).FirstOrDefault(); if (repeatOrderDetail != null) { repeatOrderDetail.Quantity += quantity; userOrders.Total += quantity * product.Cost; context.SaveChanges(); var orderDetailSummary = (from orderDetail in context.OrderDetails where orderDetail.OrderID == userOrders.ID select orderDetail).ToList(); var updatedUserOrderList = (from o in context.Orders where o.CustomerID == userID && o.IsCart == "true" select o).ToList(); } else { //Build new OrderDetail entry var newOrderDetail = new OrderDetail(); newOrderDetail.ProductID = id; //set orderID to the current order newOrderDetail.OrderID = userOrders.ID; newOrderDetail.Cost = product.Cost; newOrderDetail.ProductName = product.Name; newOrderDetail.Quantity = quantity; //update the running total for entire order userOrders.Total += newOrderDetail.Cost * newOrderDetail.Quantity; context.OrderDetails.Add(newOrderDetail); context.SaveChanges(); } } //if user does not have an existing cart else { createNewCart(id, quantity); } } } Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString()); } else { return; } }