public ActionResult DeleteConfirmed(string orderID, string productID) { ORDER_LINE oRDER_LINE = db.ORDER_LINE.Find(orderID, productID); db.ORDER_LINE.Remove(oRDER_LINE); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(string id) { ORDER_LINE oRDER_LINE = db.ORDER_LINE.Find(id); db.ORDER_LINE.Remove(oRDER_LINE); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Order_ID,Product_ID,Ordered_Quantity")] ORDER_LINE oRDER_LINE) { if (ModelState.IsValid) { db.Entry(oRDER_LINE).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Order_ID = new SelectList(db.ORDER, "Order_ID", "Customer_ID", oRDER_LINE.Order_ID); ViewBag.Product_ID = new SelectList(db.PRODUCT, "Product_ID", "Product_Description", oRDER_LINE.Product_ID); return(View(oRDER_LINE)); }
// GET: CUSTOMER_ORDER/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ORDER_LINE oRDER_LINE = db.ORDER_LINE.Find(id); if (oRDER_LINE == null) { return(HttpNotFound()); } return(View(oRDER_LINE)); }
// GET: ORDER_LINE/Details/5 public ActionResult Details(string orderID, string productID) { if (orderID == null || productID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ORDER_LINE oRDER_LINE = db.ORDER_LINE.Find(orderID, productID); if (oRDER_LINE == null) { return(HttpNotFound()); } return(View(oRDER_LINE)); }
private void checkout_Click(object sender, EventArgs e) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { ACCOUNT user = context.ACCOUNTs.First(i => i.id == Home.UserID); decimal balance = user.balance; if (balance + total <= MAX_BALANCE) { //update the balance in the database user.balance += total; context.SubmitChanges(); //add the order to the database ORDER order = new ORDER(); // fields to be insert order.account_id = user.id; order.total_cost = total; order.date = DateTime.Now; context.ORDERs.InsertOnSubmit(order); // executes the commands to implement the changes to the database context.SubmitChanges(); int order_id = order.id; //add the order-line to the database foreach (KeyValuePair <int, int> item in shoppingCart) { ORDER_LINE order_line = new ORDER_LINE(); order_line.item_id = item.Key; order_line.quantity = item.Value; order_line.order_id = order_id; context.ORDER_LINEs.InsertOnSubmit(order_line); context.SubmitChanges(); } //empty the shopping cart shoppingCart.Clear(); total = 0; cart.Text = "Thank you for your purchase. Your balance is now $" + user.balance; } else { balance_error.Visible = true; } } }
// GET: CUSTOMER_ORDER/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ORDER_LINE oRDER_LINE = db.ORDER_LINE.Find(id); if (oRDER_LINE == null) { return(HttpNotFound()); } ViewBag.Order_ID = new SelectList(db.ORDER, "Order_ID", "Customer_ID", oRDER_LINE.Order_ID); ViewBag.Product_ID = new SelectList(db.PRODUCT, "Product_ID", "Product_Description", oRDER_LINE.Product_ID); return(View(oRDER_LINE)); }