public ActionResult Shipments() { List<Confirmation> model; using (var context = new OrderContext()) { var shipments = from s in context.Shipments orderby s.ShipmentId descending select new { s.Order.Item, s.Order.OrderId }; model = shipments .AsEnumerable() .Select(s => new Confirmation { Item = s.Item, ConfirmationNumber = "CN" + s.OrderId }) .ToList(); } return View(model); }
private static Order SaveAsOrder(ShoppingCart shoppingCart) { Order order; using (var context = new OrderContext()) { // TODO 8.3: Look for existing order by uniquifier. var matchingOrders = from o in context.Orders where o.Uniquifier == shoppingCart.Uniquifier select o; order = matchingOrders.FirstOrDefault(); if (order != null) return order; order = new Order { Item = shoppingCart.Item, // TODO 8.4: Copy uniquifier. Uniquifier = shoppingCart.Uniquifier }; context.Orders.Add(order); context.SaveChanges(); } return order; }