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));
}
