static void CRUDExampleOnParts(string connectionString)
{
using (var context = new AutoRepairContext(connectionString))
{
context.Parts.Add(new Part()
{
Name = "Gear", Price = 100
}); //Create
context.SaveChanges();
Console.WriteLine("Запись создана");
Console.ReadLine();
var part = context.Parts.First(x => x.Name == "Gear"); //Read
Console.WriteLine($"Запись получена: {part.Id} {part.Name} {part.Price}");
Console.ReadLine();
part.Price = 150;
context.Update(part); //Update
context.SaveChanges();
Console.WriteLine("Запись обновлена");
Console.ReadLine();
context.Remove(part); //Delete
context.SaveChanges();
Console.WriteLine("Запись удалена");
Console.ReadLine();
}
}
public ActionResult <Motorcycle> Post([FromBody] Motorcycle moto)
{
//chjeck to make sure this motorcycle dosen't already exist in the database
var isExistingMotorcycle = _context.Motorcycles.Any(m => m.Id == moto.Id);
if (isExistingMotorcycle)
{
return(BadRequest("Duplicate. Motorcycle already exists in database"));
}
//add to database
_context.Motorcycles.Add(moto);
_context.Entry(moto).State = Microsoft.EntityFrameworkCore.EntityState.Added;
_context.SaveChanges();
return(Ok(moto));
}
public ActionResult <Automobile> Post([FromBody] Automobile auto)
{
//check to make sure this automobile doesn't already exist in the database
var isExistingAutomobile = _context.Automobiles.Any(a => a.Id == auto.Id);
if (isExistingAutomobile)
{
return(BadRequest("Duplicate. Automobile already exists in database."));
}
//add to database
_context.Automobiles.Add(auto);
_context.Entry(auto).State = Microsoft.EntityFrameworkCore.EntityState.Added;
_context.SaveChanges();
return(Ok(auto));
}
public void SaveOrder(Order order)
{
_context.SaveChanges();
}
/// <summary>
/// Пересоздает базу (удаляет и создает заново), заполняет её тестовыми данными
/// </summary>
public static void ResetAndFillDatabase(string connectionString)
{
using (var context = new AutoRepairContext(connectionString, resetDatabase: true))
{
//Заполняем заказчиков
context.Customers.Add(new Customer()
{
Name = "Hedy Greene", Address = "Ap #696-3279 Viverra. Avenue Latrobe DE 38100"
});
context.Customers.Add(new Customer()
{
Name = "Joan Romero", Address = "Lacinia Avenue Idaho Falls Ohio"
});
context.Customers.Add(new Customer()
{
Name = "Davis Patrick", Address = "2546 Sociosqu Rd. Bethlehem Utah"
});
//Заполняем машины
context.Vehicles.Add(new Vehicle()
{
Make = "Ford", Model = "F-Series", RegistrationPlate = "798 PAK", Year = 2007
});
context.Vehicles.Add(new Vehicle()
{
Make = "Chevrolet", Model = "Silverado", RegistrationPlate = "GHT430", Year = 2003
});
context.Vehicles.Add(new Vehicle()
{
Make = "Suzuki", Model = "Aerio", RegistrationPlate = "50D24H8", Year = 2011
});
//Заполняем список запчастей
context.Parts.Add(new Part()
{
Name = "Front Clip", Price = 5
});
context.Parts.Add(new Part()
{
Name = "Airbag sensor", Price = 10
});
context.Parts.Add(new Part()
{
Name = "Starter Pinion Gear", Price = 50
});
context.Parts.Add(new Part()
{
Name = "Differential", Price = 1500
});
context.Parts.Add(new Part()
{
Name = "Backup Camera", Price = 115
});
context.Parts.Add(new Part()
{
Name = "Door Contact", Price = 75
});
//Заполняем механиков
context.Workers.Add(new Worker()
{
Name = "Leilani Boyer", Position = "Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Edward Nieves", Position = "Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Christian Emerson", Position = "St. Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Raymond Levy", Position = "Jr. Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Tom Adams", Position = "Jr. Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "John Patel", Position = "Jr. Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Pat Quinn", Position = "Jr. Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Mike Usman", Position = "Jr. Mechanic"
});
context.Workers.Add(new Worker()
{
Name = "Diego Yakub", Position = "Jr. Mechanic"
});
context.SaveChanges();
}
}