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