public static List<Person> GetByUserId(Guid userId)
{
List<Person> personList = new List<Person>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetPersonByUserIdCommand objectCommand = new GetPersonByUserIdCommand(objectConnection))
{
objectCommand.UserId = userId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return personList;
}
using (PersonSqlDataReader objectSqlDataReader = new PersonSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Person person = objectSqlDataReader.Person;
personList.Add(person);
}
}
}
}
}
return personList;
}
public static Person GetByPersonId(Guid personId)
{
Person person = new Person();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetPersonByPersonIdCommand objectCommand = new GetPersonByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = personId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return person;
}
using (PersonSqlDataReader objectSqlDataReader = new PersonSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
person = objectSqlDataReader.Person;
}
}
}
}
}
return person;
}