public ActionResult Create([Bind(Include = "CarId,Make,Color,PetName,Timestamp")] Inventory inventory)
{
if (ModelState.IsValid)
{
db.Inventories.Add(inventory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(inventory));
}
public ActionResult Create([Bind(Include = "CustId,FirstName,LastName,Timestamp")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public IHttpActionResult PostInventory(Inventory inventory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Inventory.Add(inventory);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = inventory.CarId }, inventory));
}
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);
}
}
private static int AddNewRecord()
{
var car = new Car
{
Make = "Honda",
CarNickName = "Civic",
Color = "Blue"
};
try
{
using (var context = new AutoLotEntities())
{
context.Cars.Add(car);
context.SaveChanges();
}
return(car.CarId);
}
catch (Exception ex)
{
WriteLine(ex.InnerException?.Message);
return(0);
}
}
internal int SaveChanges()
{
try
{
return(ctx.SaveChanges());
}
catch (DbUpdateConcurrencyException ex)
{
//Thrown when there is a concurrency error
//for now, just rethrow the exception
throw;
}
catch (DbUpdateException ex)
{
//Thrown when database update fails
//Examine the inner exception(s) for additional
//details and affected objects
//for now, just rethrow the exception
throw;
}
catch (CommitFailedException ex)
{
//handle transaction failures here
//for now, just rethrow the exception
throw;
}
catch (Exception ex)
{
//some other exception happened and should be handled
throw;
}
}
//Added a helper AddNewRecord() to insert a new record by using EF.
private static int AddNewRecord()
{
// Add record to the Inventory table of the AutoLot database.
using (var context = new AutoLotEntities())
{
try
{
// Hard-code data for a new record, for testing.
var car = new Car()
{
Make = "Yugo", Color = "Brown", CarNickName = "Brownie"
};
//DbSet<TEntity> has Add().
//With this, I add car object which is created above to Cars property.
//And it is stored in memory in DbSet<Car> type.
//In memory, DbSet<Car> = car1, car2, ..
context.Cars.Add(car);
//I put DbSet<Car> which is put by new car just above, when I SaveChanges() of DbContext, EF does that task on behalf of myself.
//After finish this task, DB is changed.
context.SaveChanges();
// On a successful save, EF populates the database generated identity field.
//The CarId of the new record is showing.
//EF executes a SELECT statement on behalf of myself to get CarId value, even if I don't do anything to get that value from DB
return(car.CarId);
}
catch (Exception ex)
{
WriteLine(ex.InnerException.Message);
return(0);
}
}
}
internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException e)
{
// Генерируется, когда возникает ошибка, связанная с параллелизмом.
// Пока что просто повторно сгенерировать исключение.
throw;
}
catch (DbUpdateException e)
{
// Генерируется, когда обновление базы данных терпит неудачу.
// Проверить внутреннее исключение (исключения), чтобы получить
// дополнительные сведения и выяснить, на какие объекты это повлияло.
// Пока что просто повторно сгенерировать исключение.
throw;
}
catch (CommitFailedException e)
{
// Обработать здесь отказы транзакции.
// Пока что просто повторно сгенерировать исключение.
throw;
}
catch (Exception e)
{
// Произошло какое-то другое исключение, которое должно быть обработано.
throw;
}
}
internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (DbUpdateConcurrencyException e)
{
//parallelism error
Console.WriteLine(e);
throw;
}
catch (DbUpdateException e)
{
//error of update. Check inner exception.
Console.WriteLine(e);
throw;
}
catch (CommitFailedException e)
{
//error of transaction
Console.WriteLine(e);
throw;
}
catch (Exception e)
{
//other exception
Console.WriteLine(e);
throw;
}
}
private static int AddNewRecord()
{
// Добавить запись в таблицу Inventory базы данных AutoLot.
using (var context = new AutoLotEntities())
{
try
{
// В целях тестирования жестко закодировать данные для новой записи,
var car = new Car()
{
Make = "Yugo",
Color = ’’Brown", CarNickName="Brownie’'};
context.Cars.Add(car);
context.SaveChanges();
// В случае успешного сохранения EF заполняет поле идентификатора
// значением, сгенерированным базой данных,
return car.Carld;
catch (Exception ex)
{
Console.WriteLine(ex.InnerException?.Message);
return 0;
}
}
}
private static int AddNewRecord()
{
//Add record to the Inventory table to the AutoLot
//Database
using (var context = new AutoLotEntities())
{
try
{
//Hard-code data for a new record, for testing.
var car = new Car()
{
Make = "Yugo", Color = "Brown", CarNickName = "Brownie"
};
context.Cars.Add(car);
context.SaveChanges();
//On a successful save, EF populates the database generated identity field.
return(car.CarId);
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException.Message);
return(0);
}
}
}
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);
try
{
context.SaveChanges();
}
catch (DbUpdateException ex)
{
WriteLine(ex);
}
return(creditRisk);
}
}
private static void RemoveMultipleRecords(IEnumerable <Car> carsToRemove)
{
using (var context = new AutoLotEntities())
{
context.Cars.RemoveRange(carsToRemove);
context.SaveChanges();
}
}
private static void AddNewRecords(IEnumerable <Car> carsToAdd)
{
using (var context = new AutoLotEntities())
{
context.Cars.AddRange(carsToAdd);
context.SaveChanges();
}
}
private static void RemoveMultipleRecords(IEnumerable <Car> carsToRemove)
{
using (var context = new AutoLotEntities())
{
//Each record must be loaded in the DbChangeTracker
context.Cars.RemoveRange(carsToRemove);
context.SaveChanges();
}
}
static void RemoveMultipleRecords(IEnumerable <Car> carsToRemove)
{
using (var context = new AutoLotEntities())
{
//Каждая запись должна быть загружен в DbChangeTracker
context.Cars.RemoveRange(carsToRemove);
context.SaveChanges();
}
}
public void AddBook(string name)
{
using (AutoLotEntities entities = new AutoLotEntities())
{
Customer book = new Customer {
FirstName = name
};
entities.Customers.Add(book);
entities.SaveChanges();
}
}
internal int SaveChanges()
{
try
{
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw;
}
}
private static void RemoveRecord(int carId)
{
using (var context = new AutoLotEntities())
{
var carToDelete = context.Cars.Find(carId);
if (carToDelete != null)
{
context.Cars.Remove(carToDelete);
context.SaveChanges();
}
}
}
private static void UpdateRecord(int carId)
{
using (var context = new AutoLotEntities())
{
Car carToUpdate = context.Cars.Find(carId);
if (carToUpdate != null)
{
carToUpdate.Color = "Blue";
context.SaveChanges();
}
}
}
public static void UpdateCarRecord(int carId)
{
using (AutoLotEntities context = new AutoLotEntities()) {
Car carToUpdate = context.Cars.Find(carId);
if (carToUpdate != null)
{
Console.WriteLine("State Before Update: {0}", context.Entry(carToUpdate).State);
carToUpdate.PetName = "Sabrina";
Console.WriteLine("State After Update: {0}", context.Entry(carToUpdate).State);
context.SaveChanges();
}
}
}
private static void RemoveRecord(int carId)
{
ForegroundColor = ConsoleColor.Cyan;
WriteLine($"=> Deleting Record: {carId}");
using (var context = new AutoLotEntities()) {
Car carToRemove = context.cars.Find(carId);
if (carToRemove != null)
{
context.cars.Remove(carToRemove);
context.SaveChanges();
}
}
}
internal int SaveChanges()
{
try {
return(db.SaveChanges());
} catch (DbUpdateConcurrencyException ex) {
throw;
} catch (DbUpdateException ex) {
throw;
} catch (CommitFailedException ex) {
throw;
} catch (Exception ex) {
throw;
}
}
private static void UpdateRecord(int carId)
{
using (var context = new AutoLotEntities())
{
var carToUpdate = context.Cars.Find(carId);
if (carToUpdate != null)
{
Console.WriteLine(context.Entry(carToUpdate).State);
carToUpdate.Color = "Blue";
Console.WriteLine(context.Entry(carToUpdate).State);
context.SaveChanges();
}
}
}
private static void RemoveRecord(int carId)
{
// Find a car to delete by primary key.
using (var context = new AutoLotEntities())
{
// See if we have it.
Car carToDelete = context.Cars.Find(carId);
if (carToDelete != null)
{
context.Cars.Remove(carToDelete);
context.SaveChanges();
}
}
}
private static void AddNewRecords(IEnumerable <Car> carsToAdd)
{
using (var context = new AutoLotEntities())
{
try
{
context.Cars.AddRange(carsToAdd);
context.SaveChanges();
}
catch (Exception ex)
{
WriteLine(ex.InnerException?.Message);
}
}
}
private static void UpdateRecord(int carId)
{
using (var context = new AutoLotEntities())
{
// Grab the car, change it, save!
Car carToUpdate = context.Cars.Find(carId);
if (carToUpdate != null)
{
WriteLine(context.Entry(carToUpdate).State);
carToUpdate.Color = "Blue";
WriteLine(context.Entry(carToUpdate).State);
context.SaveChanges();
}
}
}
static void Main(string[] args)
{
// Строка подключения автоматически читается из конфигурационного файла.
using (AutoLotEntities context = new AutoLotEntities())
{
// Добавить новую строку в таблицу Inventory, используя нашу модель.
context.Cars.Add(new Car()
{
Color = "Black”,
Make = "Pinto",
PetName = "Pete"
});
context.SaveChanges();
}
}
private static void RemoveRecord(int carID) //extra round trip to dbase. Use EntityState for more efficiency.
{
// find a car to delete by primary key
using (var context = new AutoLotEntities())
{
// see if we have it
Car carToDelete = context.Cars.Find(carID);
if (carToDelete != null)
{
context.Cars.Remove(carToDelete);
context.SaveChanges();
Console.WriteLine("Removed carID:{0}", carID);
}
}
}
private static void RemoveMultipleRecords(IEnumerable <Car> carsToRemove)
{
using (var context = new AutoLotEntities())
{
try
{
context.Cars.RemoveRange(carsToRemove);
context.SaveChanges();
}
catch (Exception ex)
{
WriteLine(ex.InnerException?.Message);
}
}
}
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);
}
}
}