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();
}
}
static void CRUDExampleOnWorkers(string connectionString)
{
using (var context = new AutoRepairContext(connectionString))
{
context.Workers.Add(new Worker()
{
Name = "Edward Nieves", Position = "Mechanic"
}); //Create
var worker = context.Workers.First(x => x.Name.StartsWith("Edward"));
worker.Position = "Sr. Mechanic";
context.Update(worker); //Update
context.Remove(worker); //Delete
}
}
static void CRUDExampleOnVehicles(string connectionString)
{
using (var context = new AutoRepairContext(connectionString))
{
context.Vehicles.Add(new Vehicle()
{
Make = "Chevrolet", Model = "Silverado", RegistrationPlate = "GHT430", Year = 2003
}); //Create
var vehicle = context.Vehicles.First(x => x.Make == "Chevrolet" && x.Year == 2003);
vehicle.Year = 2004;
context.Update(vehicle); //Update
context.Remove(vehicle); //Delete
}
}
static void CRUDExampleOnCustomers(string connectionString)
{
using (var context = new AutoRepairContext(connectionString))
{
context.Customers.Add(new Customer()
{
Name = "Johnnie Doe", Address = "New York"
}); //Create
var customer = context.Customers.First(x => x.Name.Contains("Doe")); //Read
customer.Name = "John Doe";
context.Update(customer); //Update
context.Remove(customer); //Delete
}
}