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;
}
public static Entities.Person ToEntity(BusinessObject.Person businessObject)
{
if (businessObject == null)
return null;
Entities.Person entity = new Entities.Person
{
PersonEmail = businessObject.EmailAddress,
PersonFirstName = businessObject.FirstName,
PersonLastName = businessObject.LastName,
PersonId = businessObject.PersonId,
PersonPhone = businessObject.PhoneNumber,
PersonTypeId = (int)businessObject.PersonType
};
return entity;
}
public static Entities.Person ToEntity(BusinessObject.Person businessObject)
{
if (businessObject == null)
{
return(null);
}
Entities.Person entity = new Entities.Person
{
PersonEmail = businessObject.EmailAddress,
PersonFirstName = businessObject.FirstName,
PersonLastName = businessObject.LastName,
PersonId = businessObject.PersonId,
PersonPhone = businessObject.PhoneNumber,
PersonTypeId = (int)businessObject.PersonType
};
return(entity);
}
public static BusinessObject.Person ToBusinessObject(Entities.Person entity)
{
if (entity == null)
{
return(null);
}
Enumeration.PersonType personType = (Enumeration.PersonType)entity.PersonTypeId;
BusinessObject.Person businessObject = new BusinessObject.Person
{
EmailAddress = entity.PersonEmail,
FirstName = entity.PersonFirstName,
LastName = entity.PersonLastName,
PersonId = entity.PersonId,
PhoneNumber = entity.PersonPhone,
PersonType = personType
};
return(businessObject);
}
public static int UpdateByPersonId(Person person)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (UpdatePersonByPersonIdCommand objectCommand = new UpdatePersonByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = person.PersonId;
objectCommand.PersonFirstName = person.PersonFirstName;
objectCommand.PersonLastName = person.PersonLastName;
objectCommand.PersonPhone = person.PersonPhone;
objectCommand.PersonEmail = person.PersonEmail;
objectCommand.PersonTypeId = person.PersonTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
public static int Insert(Person person)
{
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (InsertPersonCommand objectCommand = new InsertPersonCommand(objectConnection))
{
objectCommand.PersonId = (person.PersonId != Guid.Empty) ? person.PersonId : new Guid();
objectCommand.PersonFirstName = person.PersonFirstName;
objectCommand.PersonLastName = person.PersonLastName;
objectCommand.PersonPhone = person.PersonPhone;
objectCommand.PersonEmail = person.PersonEmail;
objectCommand.PersonTypeId = person.PersonTypeId;
objectConnection.Open();
objectCommand.ExecuteNonQuery();
return objectCommand.ReturnValue;
}
}
}
