public void AddNewOrderLine(WinkelMandItem winkelMandItem, int orderID)
{
using (var db = new ToysForBoysEntities())
{
orderdetail newOrderDetail = new orderdetail();
newOrderDetail.orderId = orderID;
newOrderDetail.priceEach = winkelMandItem.Prijs;
newOrderDetail.quantityOrdered = winkelMandItem.AantalTeBestellen;
newOrderDetail.productId = winkelMandItem.ID;
db.orderdetails.Add(newOrderDetail);
db.SaveChanges();
}
}
public void VerwijderOrderLine(WinkelMandItem winkelMandItem, int orderID)
{
using (var db = new ToysForBoysEntities())
{
orderdetail orderdetail = (from order in db.orderdetails
where (order.orderId == orderID) && (order.productId == winkelMandItem.ID)
select order).FirstOrDefault();
if (orderdetail != null)
{
db.orderdetails.Remove(orderdetail);
db.SaveChanges();
}
}
}
public ActionResult Verwijderen(int id)
{
var winkelMandItems = (List <WinkelMandItem>)Session["winkelMandItems"];
WinkelMandItem verwijderOrderLine = new WinkelMandItem();
WinkelMandItem idtoDelete = null;
foreach (var winkelmanditem in winkelMandItems)
{
if (winkelmanditem.ID == id)
{
db.VerwijderOrderLine(winkelmanditem, (Int32)Session["orderid"]);
idtoDelete = winkelmanditem;
}
}
winkelMandItems.Remove(idtoDelete);
Session["winkelMandItems"] = winkelMandItems;
return(RedirectToAction("WinkelMandje"));
}
public ActionResult WinkelMandje(int?id)
{
List <WinkelMandItem> winkelMandItems = new List <WinkelMandItem>();
WinkelMandItem newWinkelMandItem = new WinkelMandItem();
//if (Session["opgestart"] == null)
//{
// List<orderdetail> openOrderDetails = db.findMANDJEOrders(((customer)Session["customer"]).id);
// if (openOrderDetails.Count() > 0)
// {
// foreach (var orderDetail in openOrderDetails)
// {
// product newProduct = db.GetProductById(orderDetail.productId);
// if (newProduct != null)
// {
// newWinkelMandItem.ID = newProduct.id;
// newWinkelMandItem.Naam = newProduct.name;
// newWinkelMandItem.AantalTeBestellen = (Int32)orderDetail.quantityOrdered;
// newWinkelMandItem.Prijs = newProduct.buyPrice;
// newWinkelMandItem.AantalInStock = newProduct.quantityInStock;
// winkelMandItems.Add(newWinkelMandItem);
// }
// }
// Session["winkelMandItems"] = winkelMandItems;
// Session["orderid"] = openOrderDetails[0].orderId;
// Session["opgestart"] = 1;
// }
//}
if (id != null)
{
product newProduct = db.GetProductById(id);
if (newProduct != null)
{
newWinkelMandItem.ID = newProduct.id;
newWinkelMandItem.Naam = newProduct.name;
newWinkelMandItem.AantalTeBestellen = 1;
newWinkelMandItem.Prijs = newProduct.buyPrice;
newWinkelMandItem.AantalInStock = newProduct.quantityInStock;
if (Session["orderid"] == null)
{
order winkelmandorder = new order()
{
orderDate = DateTime.Now,
requiredDate = DateTime.Now.AddDays(10),
customerId = ((customer)Session["customer"]).id,
status = "MANDJE"
};
Session["orderid"] = db.CreateNewOrder(winkelmandorder);
}
if (Session["winkelMandItems"] != null)
{
winkelMandItems = (List <WinkelMandItem>)Session["winkelMandItems"];
var gevonden = 0;
foreach (var winkelmandItem in winkelMandItems)
{
if (winkelmandItem.ID == id)
{
gevonden = 1;
winkelmandItem.AantalTeBestellen += 1;
Session["winkelMandItems"] = winkelMandItems;
db.UpdateOrderDetailLine((Int32)id, (Int32)Session["orderid"]);
return(View(winkelMandItems));
}
}
if (gevonden != 1)
{
winkelMandItems.Add(newWinkelMandItem);
Session["winkelMandItems"] = winkelMandItems;
}
}
else
{
winkelMandItems.Add(newWinkelMandItem);
Session["winkelMandItems"] = winkelMandItems;
}
db.AddNewOrderLine(newWinkelMandItem, (Int32)Session["orderid"]);
}
}
else
{
winkelMandItems = (List <WinkelMandItem>)Session["winkelMandItems"];
}
ViewBag.Totaal = 0;
if (winkelMandItems != null)
{
foreach (var item in winkelMandItems)
{
ViewBag.Totaal += (item.AantalTeBestellen * item.Prijs);
}
}
return(View(winkelMandItems));
}
