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