public List <productline> GetAllProductLines() { using (var db = new ToysForBoysEntities()) { return(db.productlines.OrderBy(m => m.name).ToList()); } }
public product GetProductById(int?id) { using (var db = new ToysForBoysEntities()) { var product = db.products.Find(id); return(product); } }
public List <country> GetAllCountries() { using (var db = new ToysForBoysEntities()) { var query = (from countries in db.countries select countries).ToList(); return(query); } }
public customer GetCustomerByEmail(string email) { using (var db = new ToysForBoysEntities()) { customer customer = (from custom in db.customers where custom.email == email select custom).FirstOrDefault(); return(customer); } }
public List <product> GetProductLineDetails(int id) { using (var db = new ToysForBoysEntities()) { var query = from productLineDetails in db.products.Include("productline") where productLineDetails.productline.id == id && productLineDetails.buyPrice != 0 orderby productLineDetails.name select productLineDetails; return(query.ToList()); } }
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(); } } }
public List <order> getGeplaatsteBestellingenKlant(int customerId) { List <order> openOrders = new List <order>(); using (var db = new ToysForBoysEntities()) { List <order> openOrderCustomer = (from order in db.orders where (order.customerId == customerId) select order).ToList(); if (openOrderCustomer != null) { openOrders = openOrderCustomer; } } return(openOrders); }
public List <orderdetail> findMANDJEOrders(int id) { List <orderdetail> mandjeOrderDetails = new List <orderdetail>(); using (var db = new ToysForBoysEntities()) { order openOrderCustomer = (from order in db.orders where (order.customerId == id) && (order.status == "MANDJE") select order).FirstOrDefault(); if (openOrderCustomer != null) { mandjeOrderDetails = (from orderdetails in db.orderdetails where orderdetails.orderId == openOrderCustomer.id select orderdetails).ToList(); } } return(mandjeOrderDetails); }