public void AddPerson(string name, int age)
{
using (PersonContex pc = new PersonContex())
{
Person person = new Person {
Name = name, Age = age
};
pc.People.Add(person);
pc.SaveChanges();
}
}
public void DeletePerson(int idObject)
{
using (PersonContex pc = new PersonContex())
{
Person person = new Person()
{
Id = idObject
};
pc.People.Attach(person);
pc.People.Remove(person);
pc.SaveChanges();
}
}
public void UpdateObject(int idObject, string nameColumn, string newValue)
{
using (PersonContex pc = new PersonContex())
{
Person person = new Person()
{
Id = idObject
};
pc.People.Attach(person);
if (nameColumn == "Name")
{
person.Name = newValue;
}
if (nameColumn == "Age")
{
int newAge = Int32.Parse(newValue);
person.Age = newAge;
}
pc.SaveChanges();
}
}
