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