public static List<Customer> GetCustomerByPersonEmail(string personEmail)
{
List<Customer> customerList = new List<Customer>();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCustomerByPersonEmailCommand objectCommand = new GetCustomerByPersonEmailCommand(objectConnection))
{
objectCommand.PersonEmail = personEmail;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return customerList;
}
using (CustomerSqlDataReader objectSqlDataReader = new CustomerSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
Customer customer = objectSqlDataReader.Customer;
customerList.Add(customer);
}
}
}
}
}
return customerList;
}
public static Customer GetCustomerByPersonId(Guid personId)
{
Customer customer = new Customer();
using (ObjectConnection objectConnection = new ObjectConnection())
{
using (GetCustomerByPersonIdCommand objectCommand = new GetCustomerByPersonIdCommand(objectConnection))
{
objectCommand.PersonId = personId;
objectConnection.Open();
using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader())
{
if (!sqlDataReader.HasRows)
{
return customer;
}
using (CustomerSqlDataReader objectSqlDataReader = new CustomerSqlDataReader(sqlDataReader))
{
while (objectSqlDataReader.Read())
{
customer = objectSqlDataReader.Customer;
}
}
}
}
}
return customer;
}
