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 void PrintAllInventory()
{
using (AutoLotEntities context = new AutoLotEntities())
{
foreach (Car item in context.Cars)
{
Console.WriteLine(item);
}
}
}
private static void ShowAllOrdersEagerlyFetched()
{
using (var context = new AutoLotEntities())
{
WriteLine("*********** Pending Orders ***********");
var orders = context.Orders
.Include(x => x.Customer)
.Include(y => y.Car)
.ToList();
foreach (var itm in orders)
{
WriteLine($"-> {itm.Customer.FullName} is waiting on {itm.Car.Name}");
}
}
}
private static void UpdateRecord()
{
// Find a car to delete by primary key.
using (AutoLotEntities context = new AutoLotEntities())
{
Car carToUpdate = (from c in context.Cars
where c.CarID == 2222
select c).FirstOrDefault();
if (carToUpdate != null)
{
carToUpdate.Color = "Blue";
context.SaveChanges();
}
}
}
private static void AddNewRecord()
{
// Add record to the Inventory table of the AutoLot
// database.
using (AutoLotEntities context = new AutoLotEntities())
{
try
{
// Hard-code data for a new record, for testing.
context.Cars.Add(new Car()
{
CarID = 2222,
Make = "Yugo",
Color = "Brown"
});
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException.Message);
}
}
}