public void deletePerson(PersonModel personToDelete)
{
using (var db = new PersonContext())
{
db.allPersons.Attach(personToDelete);
db.allPersons.Remove(personToDelete);
db.SaveChanges();
}
}
public PersonModel addPerson(PersonModel personToAdd)
{
using (var db = new PersonContext())
{
db.allPersons.Add(personToAdd);
db.SaveChanges();
}
syncData();
return personToAdd;
}
public void syncData()
{
using (var db = new PersonContext())
{
var people = (from person in db.allPersons
orderby person.Id
select person);
personsList = people.ToList<PersonModel>();
}
}
public void updatePerson(PersonModel personToUpdate)
{
using (var db = new PersonContext())
{
var p = (from person in db.allPersons
where person.Id == personToUpdate.Id
select person);
foreach (var pr in p)
{
pr.FirstName = personToUpdate.FirstName;
pr.SecondName = personToUpdate.SecondName;
pr.Age = personToUpdate.Age;
pr.TelNumber = personToUpdate.TelNumber;
}
db.SaveChanges();
}
}
