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