static void Main(string[] args)
{
CustomerDAC customerDAC = new CustomerDAC();
CustomerDTO customerDTO = new CustomerDTO();
EntityConverter.FillDTOFromEntity(customerDAC.GetCustomerByEmailAddress("*****@*****.**"), customerDTO);
Customer customer = new Customer();
EntityConverter.FillEntityFromDTO(customerDTO, customer);
}
public EntityBase PopulateEntity(SqlDataReader reader)
{
Customer customer = new Customer();
if (!reader.IsDBNull(ord_CustomerID)) customer.CustomerID = reader.GetInt32(ord_CustomerID);
if (!reader.IsDBNull(ord_FirstName)) customer.FirstName = reader.GetString(ord_FirstName);
if (!reader.IsDBNull(ord_LastName)) customer.LastName = reader.GetString(ord_LastName);
if (!reader.IsDBNull(ord_Age)) customer.Age = reader.GetInt32(ord_Age);
if (!reader.IsDBNull(ord_EmailAddress)) customer.EmailAddress = reader.GetString(ord_EmailAddress);
return customer;
}
public Customer GetCustomerByEmailAddress(string emailAddress)
{
Customer customer = new Customer();
try
{
SqlCommand command = GetDbSprocCommand(StoredProcedures.GETCUSTOMER_BY_EMAILADDRESS);
command.Parameters.Add(CreateParameter("@EmailAddress", emailAddress));
customer = GetSingleEntity<Customer>(ref command);
}
catch (Exception ex)
{
throw new DataAccessException("An exception occurred while fetching customer using their Email address", ex);
}
return customer;
}