private static CreditRisk MakeCustomerARisk(Customer customer)
{
using (var context = new AutoLotEntities())
{
context.Customers.Attach(customer);
context.Customers.Remove(customer);
var creditRisk = new CreditRisk()
{
FirstName = customer.FirstName,
LastName = customer.LastName
};
context.CreditRisks.Add(creditRisk);
try
{
context.SaveChanges();
}
catch (DbUpdateException ex)
{
WriteLine(ex);
}
catch (Exception ex)
{
WriteLine(ex);
}
return(creditRisk);
}
}
private static CreditRisk MakeCustomerARisk(Customer customer)
{
using (var context = new AutoLotEntities()) {
context.Customers.Attach(customer);
context.Customers.Remove(customer);
var creditRisk = new CreditRisk {
FirstName = customer.FirstName,
LastName = customer.LastName
};
context.CreditRisks.Add(creditRisk);
var creditRiskDupe = new CreditRisk {
FirstName = customer.FirstName,
LastName = customer.LastName
};
context.CreditRisks.Add(creditRiskDupe);
//exception occurs because of adding the record twice
try { context.SaveChanges(); }
catch (DbUpdateException ex) {
WriteLine($"Db Update Exception: {ex.Message}");
}
catch (Exception ex) { WriteLine($"Exception: {ex.Message}"); }
return(creditRisk);
}
}
public Client(Guid id, string name, Document document, string address, string phone, CreditRisk creditRisk)
{
Id = id;
Name = name;
Document = document;
Address = address;
Phone = phone;
CreditRisk = creditRisk;
}
private static void DeleteCreditRisk(CreditRisk risk)
{
using (var repo = new CreditRiskRepo())
{
try
{
repo.Delete(risk);
}
catch (Exception ex)
{
WriteLine(ex);
}
}
}
// Seeding the Database
protected override void Seed(AutoLotEntities context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
#region Add Customers To AutoLot
// ------------------------ Add Customers To AutoLot -------------------------
var customers = new List <Customer>()
{
new Customer {
FirstName = "Dave", LastName = "Brenner"
},
new Customer {
FirstName = "Matt", LastName = "Walton"
},
new Customer {
FirstName = "Steve", LastName = "Hagen"
},
new Customer {
FirstName = "Pat", LastName = "Walton"
},
new Customer {
FirstName = "Bad", LastName = "Customer"
},
};
// any of the next two statements add customers to db
context.Customers.AddOrUpdate(c => new { c.FirstName, c.LastName }, customers.ToArray());
//customers.ForEach(cust => context.Customers.AddOrUpdate(c => new { c.FirstName, c.LastName}, cust));
// -------------------------------------------------------------------------
#endregion
#region Add Cars To AutoLot
// ------------------------ Add Cars To AutoLot -------------------------
var cars = new List <Inventory>()
{
new Inventory {
Make = "VW", Color = "Black", PetName = "Zippy"
},
new Inventory {
Make = "Ford", Color = "Rust", PetName = "Rusty"
},
new Inventory {
Make = "Saab", Color = "Black", PetName = "Mel"
},
new Inventory {
Make = "Yugo", Color = "Yellow", PetName = "Clunker"
},
new Inventory {
Make = "BMW", Color = "Black", PetName = "Bimmer"
},
new Inventory {
Make = "BMW", Color = "Green", PetName = "Hank"
},
new Inventory {
Make = "BMW", Color = "Pink", PetName = "Pinky"
},
new Inventory {
Make = "Pinto", Color = "Black", PetName = "Pete"
},
new Inventory {
Make = "Yugo", Color = "Brown", PetName = "Brownie"
},
};
// any of the next two statements add cars to db
context.Inventory.AddOrUpdate(c => new { c.Color, c.Make }, cars.ToArray());
//cars.ForEach(car => context.Inventory.AddOrUpdate(c => new { c.Color, c.Make }, car));
#endregion
#region Add Orders To AutoLot
// ------------------------ Add Orders To AutoLot -------------------------
var orders = new List <Order>
{
new Order {
Inventory = cars[0], Customer = customers[0]
},
new Order {
Inventory = cars[1], Customer = customers[1]
},
new Order {
Inventory = cars[2], Customer = customers[2]
},
new Order {
Inventory = cars[3], Customer = customers[3]
},
};
// any of the next two statements add orders to db
//context.Orders.AddOrUpdate(order => new { order.CarId, order.CustId }, orders.ToArray());
orders.ForEach(x => context.Orders.AddOrUpdate(c => new { c.CarId, c.CustId }, x));
#endregion
#region Add CreditRisk To AutoLot
// ------------------------ Add CreditRisk To AutoLot -------------------------
var creditRisk1 = new CreditRisk()
{
Id = customers[4].Id,
FirstName = customers[4].FirstName,
LastName = customers[4].LastName,
};
context.CreditRisks.AddOrUpdate(x => new { x.FirstName, x.LastName }, creditRisk1);
#endregion
}
protected override void Seed(AutoLotEntities context)
{
//base.Seed(context);
// add Customers
// ------------------------------------------------------------
var customers = new List <Customer>()
{
new Customer {
FirstName = "Dave", LastName = "Brenner"
},
new Customer {
FirstName = "Matt", LastName = "Walton"
},
new Customer {
FirstName = "Steve", LastName = "Hagen"
},
new Customer {
FirstName = "Pat", LastName = "Walton"
},
new Customer {
FirstName = "Bad", LastName = "Customer"
},
};
// any of the next two statements add customers to db
context.Customers.AddOrUpdate(c => new { c.FirstName, c.LastName }, customers.ToArray());
//customers.ForEach(cust => context.Customers.AddOrUpdate(c => new { c.FirstName, c.LastName}, cust));
// add Cars
// ------------------------------------------------------------
var cars = new List <Inventory>()
{
new Inventory {
Make = "VW", Color = "Black", PetName = "Zippy"
},
new Inventory {
Make = "Ford", Color = "Rust", PetName = "Rusty"
},
new Inventory {
Make = "Saab", Color = "Black", PetName = "Mel"
},
new Inventory {
Make = "Yugo", Color = "Yellow", PetName = "Clunker"
},
new Inventory {
Make = "BMW", Color = "Black", PetName = "Bimmer"
},
new Inventory {
Make = "BMW", Color = "Green", PetName = "Hank"
},
new Inventory {
Make = "BMW", Color = "Pink", PetName = "Pinky"
},
new Inventory {
Make = "Pinto", Color = "Black", PetName = "Pete"
},
new Inventory {
Make = "Yugo", Color = "Brown", PetName = "Brownie"
},
};
// any of the next two statements add cars to db
context.Inventory.AddOrUpdate(c => new { c.Color, c.Make }, cars.ToArray());
//cars.ForEach(car => context.Inventory.AddOrUpdate(c => new { c.Color, c.Make }, car));
// add Orders
// ------------------------------------------------------------
var orders = new List <Order>
{
new Order {
Inventory = cars[0], Customer = customers[0]
},
new Order {
Inventory = cars[1], Customer = customers[1]
},
new Order {
Inventory = cars[2], Customer = customers[2]
},
new Order {
Inventory = cars[3], Customer = customers[3]
},
};
// any of the next two statements add orders to db
//context.Orders.AddOrUpdate(order => new { order.CarId, order.CustId }, orders.ToArray());
orders.ForEach(x => context.Orders.AddOrUpdate(c => new { c.CarId, c.CustId }, x));
// add CreditRisk
// ------------------------------------------------------------
var creditRisk1 = new CreditRisk()
{
Id = customers[4].Id,
FirstName = customers[4].FirstName,
LastName = customers[4].LastName,
};
context.CreditRisks.AddOrUpdate(x => new { x.FirstName, x.LastName }, creditRisk1);
}
