public static IList<Person> Consultar()
{
SchoolEntities schoolContext = new SchoolEntities();
var personQuery = from prs in schoolContext.People
orderby prs.FirstName
select prs;
return personQuery.ToList<Person>();
}
public static void Excluir(Person person)
{
SchoolEntities schoolContext = new SchoolEntities();
var personQuery = from prs in schoolContext.People
where prs.PersonID == person.PersonID
select prs;
foreach (Person p in personQuery)
{
schoolContext.DeleteObject(p);
}
schoolContext.SaveChanges();
}
public static void Alterar(Person person)
{
SchoolEntities schoolContext = new SchoolEntities();
var queryPerson = (from prs in schoolContext.People
where prs.PersonID == person.PersonID
select prs).Single<Person>();
queryPerson.LastName = person.LastName;
queryPerson.FirstName = person.FirstName;
queryPerson.HireDate = person.HireDate;
queryPerson.EnrollmentDate = person.EnrollmentDate;
schoolContext.SaveChanges();
}
public static void Incluir(Person person)
{
SchoolEntities schoolContext = new SchoolEntities();
schoolContext.People.AddObject(person);
schoolContext.SaveChanges();
}
