public static void DeletePerson(int PersonId) { using (var db = new PersonsToCityContext()) { var ToDelete = db.Persons.FirstOrDefault(x => x.PersonId == PersonId); db.Persons.Remove(ToDelete); db.SaveChanges(); } }
public static List <_City> ListCities() { using (var db = new PersonsToCityContext()) { var ToReturn = new List <_City>(); foreach (var city in db.Cities) { ToReturn.Add(new _City(city)); } return(ToReturn); } }
public static List <_Person> ListPersons() { using (var db = new PersonsToCityContext()) { List <_Person> ToReturn = new List <_Person>(); foreach (var person in db.Persons.Where(x => x.PersonName.Contains("e"))) { ToReturn.Add(new _Person(person)); } return(ToReturn); } }
public static Person GetPerson(int PersonId) { using (var db = new PersonsToCityContext()) { var PersonFromDb = db.Persons.FirstOrDefault(x => x.PersonId == PersonId); if (PersonFromDb != null) { PersonFromDb.City = db.Cities.FirstOrDefault(x => x.CityId == PersonFromDb.CityId); } return(PersonFromDb); } }
public static Person CreatePerson(string PersonName, int CityId) { using (var db = new PersonsToCityContext()) { var ToAdd = new Person(); ToAdd.PersonName = PersonName; ToAdd.CityId = CityId; var AddedPerson = db.Persons.Add(ToAdd); AddedPerson.City = db.Cities.FirstOrDefault(x => x.CityId == CityId); db.SaveChanges(); return(AddedPerson); } }
public static Person UpdatePerson(int PersonId, string PersonName, int CityId) { using (var db = new PersonsToCityContext()) { var ToUpdate = db.Persons.FirstOrDefault(x => x.PersonId == PersonId); ToUpdate.PersonName = PersonName; ToUpdate.CityId = CityId; db.SaveChanges(); var UpdatedPerson = ToUpdate; UpdatedPerson.City = db.Cities.FirstOrDefault(x => x.CityId == CityId); return(UpdatedPerson); } }
public static City GetCity(int CityId) { using (var db = new PersonsToCityContext()) { var CityFromDb = db.Cities.FirstOrDefault(x => x.CityId == CityId); if (CityFromDb.Persons == null) { CityFromDb.Persons = new List <Person>(); foreach (var person in db.Persons.Where(x => x.CityId == CityFromDb.CityId)) { CityFromDb.Persons.Add(person); } } return(CityFromDb); } }
public static City UpdateCity(int CityId, string CityName) { using (var db = new PersonsToCityContext()) { var ToUpdate = db.Cities.FirstOrDefault(x => x.CityId == CityId); ToUpdate.CityName = CityName; db.SaveChanges(); var UpdatedCity = ToUpdate; if (UpdatedCity == null) { UpdatedCity.Persons = new List <Person>(); foreach (var person in db.Persons.Where(x => x.CityId == UpdatedCity.CityId)) { UpdatedCity.Persons.Add(person); } } return(UpdatedCity); } }
public static City CreateCity(string CityName) { using (var db = new PersonsToCityContext()) { var ToAdd = new City(); ToAdd.CityName = CityName; var AddedCity = db.Cities.Add(ToAdd); db.SaveChanges(); if (AddedCity.Persons == null) { AddedCity.Persons = new List <Person>(); foreach (var person in db.Persons.Where(x => x.CityId == AddedCity.CityId)) { AddedCity.Persons.Add(person); } } return(AddedCity); } }