public async Task<Order> UpdateOrder(Order order)
{
// Update entity state
_dbContext.ApplyChanges(order);
try
{
await _dbContext.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException updateEx)
{
throw new FaultException(updateEx.Message);
}
// Load related entities, accept changes and return updated order
await _dbContext.LoadRelatedEntitiesAsync(order);
order.AcceptChanges();
return order;
}
public async Task<Order> CreateOrder(Order order)
{
// Mark order as added
order.TrackingState = TrackingState.Added;
_dbContext.ApplyChanges(order);
try
{
await _dbContext.SaveChangesAsync();
}
catch (DbUpdateException updateEx)
{
throw new FaultException(updateEx.Message);
}
// Load related entities and accept changes
await _dbContext.LoadRelatedEntitiesAsync(order);
order.AcceptChanges();
return order;
}
private static void PrintOrder(Order o)
{
Console.WriteLine("{0} {1}",
o.OrderId,
o.OrderDate.GetValueOrDefault().ToShortDateString());
}
private static void PrintOrderWithDetails(Order o)
{
Console.WriteLine("{0} {1}",
o.OrderId,
o.OrderDate.GetValueOrDefault().ToShortDateString());
foreach (var od in o.OrderDetails)
{
Console.WriteLine("\t{0} {1} {2} {3}",
od.OrderDetailId,
od.Product.ProductName,
od.Quantity,
od.UnitPrice.ToString("c"));
}
}
static void Main(string[] args)
{
Console.WriteLine("Press Enter to start");
Console.ReadLine();
ICustomerService customerService = new ChannelFactory<ICustomerService>("customerService").CreateChannel();
IOrderService orderService = new ChannelFactory<IOrderService>("orderService").CreateChannel();
using ((IDisposable)customerService)
using ((IDisposable)orderService)
{
try
{
// Get customers
Console.WriteLine("Customers:");
IEnumerable<Customer> customers = customerService.GetCustomersAsync().Result;
if (customers == null) return;
foreach (var c in customers)
PrintCustomer(c);
// Get orders for a customer
Console.WriteLine("\nGet customer orders {CustomerId}:");
string customerId = Console.ReadLine();
if (!customers.Any(c => string.Equals(c.CustomerId, customerId, StringComparison.OrdinalIgnoreCase)))
{
Console.WriteLine("Invalid customer id: {0}", customerId.ToUpper());
return;
}
IEnumerable<Order> orders = orderService.GetCustomerOrdersAsync(customerId).Result;
foreach (var o in orders)
PrintOrder(o);
// Get an order
Console.WriteLine("\nGet an order {OrderId}:");
int orderId = int.Parse(Console.ReadLine());
if (!orders.Any(o => o.OrderId == orderId))
{
Console.WriteLine("Invalid order id: {0}", orderId);
return;
}
Order order = orderService.GetOrderAsync(orderId).Result;
PrintOrderWithDetails(order);
// Create a new order
Console.WriteLine("\nPress Enter to create a new order for {0}",
customerId.ToUpper());
Console.ReadLine();
var newOrder = new Order
{
CustomerId = customerId,
OrderDate = DateTime.Today,
ShippedDate = DateTime.Today.AddDays(1),
OrderDetails = new ChangeTrackingCollection<OrderDetail>
{
new OrderDetail { ProductId = 1, Quantity = 5, UnitPrice = 10 },
new OrderDetail { ProductId = 2, Quantity = 10, UnitPrice = 20 },
new OrderDetail { ProductId = 4, Quantity = 40, UnitPrice = 40 }
}
};
var createdOrder = orderService.CreateOrderAsync(newOrder).Result;
PrintOrderWithDetails(createdOrder);
// Update the order
Console.WriteLine("\nPress Enter to update order details");
Console.ReadLine();
// Start change-tracking the order
var changeTracker = new ChangeTrackingCollection<Order>(createdOrder);
// Modify order details
createdOrder.OrderDetails[0].UnitPrice++;
createdOrder.OrderDetails.RemoveAt(1);
createdOrder.OrderDetails.Add(new OrderDetail
{
OrderId = createdOrder.OrderId,
ProductId = 3,
Quantity = 15,
UnitPrice = 30
});
// Submit changes
Order changedOrder = changeTracker.GetChanges().SingleOrDefault();
Order updatedOrder = orderService.UpdateOrderAsync(changedOrder).Result;
// Merge changes
changeTracker.MergeChanges(updatedOrder);
Console.WriteLine("Updated order:");
PrintOrderWithDetails(createdOrder);
// Delete the order
Console.WriteLine("\nPress Enter to delete the order");
Console.ReadLine();
bool deleted = orderService.DeleteOrderAsync(createdOrder.OrderId).Result;
// Verify order was deleted
Order deletedOrder = orderService.GetOrderAsync(createdOrder.OrderId).Result;
Console.WriteLine(deleted && deletedOrder == null
? "Order was successfully deleted"
: "Order was not deleted");
}
catch (AggregateException aggEx)
{
var baseEx = aggEx.Flatten().GetBaseException();
var innerExMsg = baseEx.InnerException != null ? "\r\n" + baseEx.InnerException.Message : "";
Console.WriteLine(baseEx.Message + innerExMsg);
}
finally
{
var channel = customerService as IClientChannel;
if (channel != null && channel.State == CommunicationState.Faulted)
{
channel.Abort();
}
}
// Keep console open
Console.WriteLine("Press any key to exit");
Console.ReadKey(true);
}
}