/// <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"); }