Beispiel #1
0
 void IOrderManager.Update(int orderId, string description, int quantity)
 {
     using (var context = new MasterDetailEntities())
     {
         Order a = context.Orders.Where(i => i.OrderId == orderId).First();
         a.Description = description;
         a.Quantity    = quantity;
         context.SaveChanges();
     }
 }
Beispiel #2
0
 void ICustomerManager.Update(int customerId, string firstName, string lastName)
 {
     using (var context = new MasterDetailEntities())
     {
         Customer c = context.Customers.Where(i => i.CustomerId == customerId).First();
         c.FirstName = firstName;
         c.LastName  = lastName;
         context.SaveChanges();
     }
 }
Beispiel #3
0
 int IOrderManager.Add(string description, int quantity, int customerId)
 {
     using (var context = new MasterDetailEntities())
     {
         Order order = new Order {
             Description = description, Quantity = quantity
         };
         context.Customers.First(i => i.CustomerId == customerId).Orders.Add(order);
         context.SaveChanges();
         return(order.OrderId);
     }
 }
Beispiel #4
0
 int ICustomerManager.Add(string firstName, string lastName)
 {
     using (var context = new MasterDetailEntities())
     {
         Customer c = new Customer {
             FirstName = firstName, LastName = lastName
         };
         context.Customers.AddObject(c);
         context.SaveChanges();
         return(c.CustomerId);
     }
 }