private static void CreateCustomerWithOrder()
{
var products = GetProducts();
var product1 = products[0];
var product2 = products[1];
var customer = new Customer
{
FirstName = "Julie",
LastName = "Lerman",
ContactDetail = new ContactDetail
{
TwitterAlias = "julielerman"
},
DateOfBirth = DateTime.Now
};
var order = new Order
{
DestinationLatLong = DbGeography.FromText("POINT(44.292401 -72.968102)"),
OrderDate = DateTime.Now,
OrderSource = OrderSource.InPerson,
LineItems = { new LineItem {
ProductId = product1.ProductId, Quantity = 2
},
new LineItem {
ProductId = product2.ProductId, Quantity = 1
} }
};
customer.Orders.Add(order);
using (var context = new SalesModelContext())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
private static void InsertCustomer()
{
using (var ctx = new SalesModelContext())
{
var customer = new Customer {
FirstName = "First", LastName = "Last", DateOfBirth = new DateTime(1980, 1, 5)
};
ctx.Customers.Add(customer);
ctx.SaveChanges();
}
}
private static void InsertCustomer()
{
var customer = new Customer {
FirstName = "Julie", LastName = "Lerman", DateOfBirth = DateTime.Now
};
using (var context = new SalesModelContext())
{
context.Customers.Add(customer);
context.SaveChanges();
}
GetCustomer(customer.CustomerId);
}
private static void UpdateCustomer()
{
int id;
using (var context = new SalesModelContext())
{
var customer = context.Customers
.FirstOrDefault(c => c.FirstName == "Julie");
id = customer.CustomerId;
Console.WriteLine(customer.DateOfBirth);
customer.DateOfBirth = DateTime.Now.AddYears(-25);
context.SaveChanges();
}
GetCustomer(id);
}
private static void DeleteJulie()
{
using (var context = new SalesModelContext())
{
var julies = context.Customers
.Where(c => c.FirstName == "Julie")
.ToList();
foreach (var customer in julies)
{
context.Customers.Remove(customer);
}
context.SaveChanges();
}
GetCustomers();
}
private static void InsertCustomer()
{
using (var ctx = new SalesModelContext())
{
var customer = new Customer { FirstName = "First", LastName = "Last", DateOfBirth = new DateTime(1980, 1, 5) };
ctx.Customers.Add(customer);
ctx.SaveChanges();
}
}
