/// <summary>
/// Task09.
/// </summary>
public static string DeleteMany(string carbrands, BaseparkingContext db)
{
Car car = db.Cars.Find(db.Cars.Where(c => c.Carbrands == carbrands).FirstOrDefault().Id);
db.Cars.Remove(car);
db.SaveChanges();
return($"Carbrands: {car.Carbrands}, Numberofthecar = {car.Numberofthecar}\n");
}
/// <summary>
/// Task08.
/// </summary>
public static string DeleteOne(string fio, BaseparkingContext db)
{
Owner owner = db.Owners.Find(db.Owners.Where(o => o.Fio == fio).FirstOrDefault().Id);
db.Owners.Remove(owner);
db.SaveChanges();
return($"Fio: {owner.Fio}, NameFone = {owner.NameFone}\n");
}
/// <summary>
/// Task10.
/// </summary>
public static string UpdateOne(string oldFio, string fio, string nameFone, BaseparkingContext db)
{
Owner owner = db.Owners.Find(db.Owners.Where(o => o.Fio == oldFio).FirstOrDefault().Id);
owner.Fio = fio;
owner.NameFone = nameFone;
db.SaveChanges();
return($"Fio: {fio}, NameFone = {nameFone}\n");
}
/// <summary>
/// Task06.
/// </summary>
public static string InsertOne(string fio, string nameFone, BaseparkingContext db)
{
Owner owner = new Owner();
owner.Fio = fio;
owner.NameFone = nameFone;
db.Owners.Add(owner);
db.SaveChanges();
return($"Fio: {fio}, NameFone = {nameFone}\n");
}
/// <summary>
/// Task07.
/// </summary>
public static string InsertMany(string carbrands, string numberofthecar, string fio, BaseparkingContext db)
{
Car car = new Car();
car.Carbrands = carbrands;
car.Numberofthecar = numberofthecar;
car.OwnersId = db.Owners.Where(o => o.Fio == fio).FirstOrDefault().Id;
db.Cars.Add(car);
db.SaveChanges();
return($"Carbrands: {carbrands}, Numberofthecar = {numberofthecar}\n");
}