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