public ActionResult DeleteConfirmed(decimal id) { creditInformation creditInformation = db.creditInformations.Find(id); db.creditInformations.Remove(creditInformation); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: creditInformation/Details/5 public ActionResult Details(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } creditInformation creditInformation = db.creditInformations.Find(id); if (creditInformation == null) { return(HttpNotFound()); } return(View(creditInformation)); }
public ActionResult Edit([Bind(Include = "cardNumber,cardHolder,cardType,username,expiryDate,securityCode")] creditInformation creditInformation) { string user = Session["User"].ToString(); creditInformation.username = user; if (ModelState.IsValid) { db.Entry(creditInformation).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cardType = new SelectList(db.cardTypes, "type", "type", creditInformation.cardType); ViewBag.username = new SelectList(db.users, "username", "firstName", creditInformation.username); return(View(creditInformation)); }
// GET: creditInformation/Edit/5 public ActionResult Edit(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } creditInformation creditInformation = db.creditInformations.Find(id); if (creditInformation == null) { return(HttpNotFound()); } ViewBag.cardType = new SelectList(db.cardTypes, "type", "type", creditInformation.cardType); ViewBag.username = new SelectList(db.users, "username", "firstName", creditInformation.username); return(View(creditInformation)); }
public ActionResult Create([Bind(Include = "firstName,lastName,email,shipAddress,mailAdress")] user user, [Bind(Include = "cardHolder,cardType,cardNumber,expiryDate,securityCode,username")] creditInformation creditInformation, [Bind(Include = "username,orderId,gameId,orderDate,shipDate,status")] order order) { if (ModelState.IsValid) { string currentUser = Session["User"].ToString(); var cartItems = db.carts.ToList(); foreach (var item in cartItems) { if (item.username == currentUser) { for (int i = 0; i < item.quantity; i++) { var newOrder = db.orders.Add(order); newOrder.username = currentUser; // Find id of last order within list, auto increment var orderItems = db.orders.ToList(); var lastOrder = orderItems.Last(); decimal orderId = lastOrder.orderId + 1; newOrder.orderId = orderId; newOrder.gameId = item.gameId; newOrder.orderDate = DateTime.Today; newOrder.shipDate = null; newOrder.status = "Received"; db.SaveChanges(); } } // Remove users' items from cart foreach (var cartItem in cartItems) { if (cartItem.username == currentUser && cartItem.gameId == item.gameId) { db.carts.Attach(cartItem); db.carts.Remove(cartItem); } } } // Save checkout information // User info string firstName = ""; string lastName = ""; var userList = db.users.ToList(); foreach (var userItem in userList) { if (userItem.username == currentUser) { firstName = user.firstName; lastName = user.lastName; userItem.email = user.email; userItem.shipAddress = user.shipAddress; userItem.mailAddress = user.mailAddress; db.SaveChanges(); } } // Payment info bool exists = false; var creditList = db.creditInformations.ToList(); var last = creditList.Last(); foreach (var creditItem in creditList) { // If user has an entry in creditInformation, update that entry if (creditItem.username == currentUser) { exists = true; creditItem.cardNumber = creditInformation.cardNumber; // Concatenate first & last names for cardHolder string cardHolder = firstName + " " + lastName; creditItem.cardHolder = cardHolder; creditItem.cardType = creditInformation.cardType; creditItem.username = Session["User"].ToString(); creditItem.expiryDate = creditInformation.expiryDate; creditItem.securityCode = creditInformation.securityCode; db.SaveChanges(); } // Else, create a new entry for them else if (creditItem.Equals(last) && exists == false) { var newCredit = db.creditInformations.Add(creditInformation); newCredit.cardNumber = creditInformation.cardNumber; // Concatenate first & last names for cardHolder string cardHolder = firstName + " " + lastName; newCredit.cardHolder = cardHolder; newCredit.cardType = creditInformation.cardType; newCredit.username = Session["User"].ToString(); newCredit.expiryDate = creditInformation.expiryDate; newCredit.securityCode = creditInformation.securityCode; db.SaveChanges(); } } return(RedirectToAction("Index", "Game")); } ViewBag.gameId = new SelectList(db.games, "id", "name", order.gameId); ViewBag.status = new SelectList(db.orderStatus, "status", "status", order.status); ViewBag.username = new SelectList(db.users, "username", "firstName", order.username); return(View(order)); }