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