Example #1
0
        private static void AddCustomerandOrders()
        {
            var cust = new Customer
            {
                FirstName = "Paul",
                LastName = "Oakenfeld",
                Email = "*****@*****.**",
                Phone = "613 876-5555",
                Fax = "867-0987"
            };

            var order1 = new Order
            {
                 ProductName = "Sunglasses"
            };

            var order2 = new Order
            {
                ProductName = "Shoes"
            };

            using (var context = new CustomerContext())
            {
                context.Database.Log = Console.WriteLine;
                context.Customers.Add(cust);
                cust.CustomerOrders.Add(order1);
                cust.CustomerOrders.Add(order2);
                context.SaveChanges();

            }
        }
 public void SaveNewOrder(Order order, int custId)
 {
     using (var context = new CustomerContext())
     {
         var cust = context.Customers.Find(custId);
         cust.CustomerOrders.Add(order);
         context.SaveChanges();
     }
 }
        public void SaveUpdatedOrder(Order order, int custId)
        {
            using (var context = new CustomerContext())
            {
                var orderFromDb =
                    context.Orders.Include(n => n.Customer).FirstOrDefault(o => o.Id == order.Id);
                context.Entry(orderFromDb).CurrentValues.SetValues(order);
                context.SaveChanges();

            }
        }