public void Salvar(ArrayList arrPerson, string operacao) { Person person = new Person(); if (operacao == "incluir") { person.FirstName = Convert.ToString(arrPerson[0]); person.LastName = Convert.ToString(arrPerson[1]); person.HireDate = Convert.ToDateTime(arrPerson[2]); person.EnrollmentDate = Convert.ToDateTime(arrPerson[3]); PersonDAO.Incluir(person); } else { person.PersonID = Convert.ToInt32(arrPerson[0]); person.FirstName = Convert.ToString(arrPerson[1]); person.LastName = Convert.ToString(arrPerson[2]); person.HireDate = Convert.ToDateTime(arrPerson[3]); person.EnrollmentDate = Convert.ToDateTime(arrPerson[4]); if (operacao == "alterar") { PersonDAO.Alterar(person); } else { PersonDAO.Excluir(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(); }
private void FixupPerson(Person previousValue) { if (previousValue != null && ReferenceEquals(previousValue.OfficeAssignment, this)) { previousValue.OfficeAssignment = null; } if (Person != null) { Person.OfficeAssignment = this; if (InstructorID != Person.PersonID) { InstructorID = Person.PersonID; } } }
private void FixupPerson(Person previousValue) { if (previousValue != null && previousValue.StudentGrades.Contains(this)) { previousValue.StudentGrades.Remove(this); } if (Person != null) { if (!Person.StudentGrades.Contains(this)) { Person.StudentGrades.Add(this); } if (StudentID != Person.PersonID) { StudentID = Person.PersonID; } } }
public static void Incluir(Person person) { SchoolEntities schoolContext = new SchoolEntities(); schoolContext.People.AddObject(person); schoolContext.SaveChanges(); }