public int CreateNewOrder(order order)
{
var neworderid = 0;
using (var db = new ToysForBoysEntities())
{
db.orders.Add(order);
db.SaveChanges();
neworderid = order.id;
}
return(neworderid);
}
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 RegisterCustomer(RegisterViewModel model)
{
customer newcustomer = new customer()
{
name = model.Name, streetAndNumber = model.StreetAndNr, city = model.City, state = model.State, postalCode = model.PostalCode, countryId = model.CountryID, email = model.Email
};
using (var db = new ToysForBoysEntities())
{
db.customers.Add(newcustomer);
db.SaveChanges();
}
}
public void UpdateAantallenInStock(List <WinkelMandItem> winkelmanditems)
{
using (var db = new ToysForBoysEntities())
{
foreach (var item in winkelmanditems)
{
var product = db.products.Find(item.ID);
product.quantityInOrder += item.AantalTeBestellen;
product.quantityInStock -= item.AantalTeBestellen;
db.SaveChanges();
}
}
}
public void changeOrderStatus(int id)
{
using (var db = new ToysForBoysEntities())
{
order openOrderCustomer = (from order in db.orders
where (order.id == id)
select order).FirstOrDefault();
if (openOrderCustomer != null)
{
openOrderCustomer.status = "ORDERED";
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 void UpdateOrderDetailLine(int productId, int OrderId, int aantal)
{
using (var db = new ToysForBoysEntities())
{
orderdetail orderdetail = (from order in db.orderdetails
where (order.orderId == OrderId) && (order.productId == productId)
select order).FirstOrDefault();
if (orderdetail != null)
{
orderdetail.quantityOrdered = aantal;
db.SaveChanges();
}
}
}
