public CSBusiness.CustomerManagement.Address GetAddressById(int addressId)
{
if (addressId == 0)
{
return(null);
}
CSCommerceDataContext context = new CSCommerceDataContext(ConfigHelper.GetDBConnection());
var query = from c in context.Addresses
where c.AddressId == addressId
select c;
var address = query.FirstOrDefault();
CSBusiness.CustomerManagement.Address newAddress = new CSBusiness.CustomerManagement.Address {
AddressId = address.AddressId
};
Security.Encryption.DecryptValues(newAddress);
return(newAddress);
}
public Customer GetCustomerDetails(int customerId)
{
Customer item = new Customer();
item.IsEncrpyed = true;
using (SqlDataReader reader = CustomerDAL.GetCustomerDetails(customerId))
{
while (reader.Read())
{
item.CustomerId = Convert.ToInt32(reader["CustomerId"]);
item.FirstName = reader["FirstName"].ToString();
item.LastName = reader["LastName"].ToString();
item.Email = reader["Email"].ToString();
item.Username = reader["UserName"].ToString();
item.Active = Convert.ToBoolean((reader["Active"]));
item.RegistrationDate = Convert.ToDateTime(reader["CreatedDate"]);
item.UserTypeId = Convert.ToInt32(reader["UserTypeId"]);
}
// go to next result set to populate customer billing Address
reader.NextResult();
while (reader.Read())
{
CSBusiness.CustomerManagement.Address billingAddress = new CSBusiness.CustomerManagement.Address();
billingAddress.IsEncrpyed = true;
billingAddress.AddressId = Convert.ToInt32(reader["BillingAddressId"]);
billingAddress.FirstName = reader["FirstName"].ToString();
billingAddress.LastName = reader["LastName"].ToString();
billingAddress.Address1 = reader["Address1"].ToString();
billingAddress.Address2 = reader["Address2"].ToString();
billingAddress.City = reader["City"].ToString();
billingAddress.PhoneNumber = reader["PhoneNumber"].ToString();
billingAddress.ZipPostalCode = reader["ZipPostalCode"].ToString();
billingAddress.StateProvinceId = Convert.ToInt32(reader["StateProvince"]);
billingAddress.CountryId = Convert.ToInt32(reader["CountryId"]);
item.BillingAddress = billingAddress;
}
// go to next result set to populate customer shipping Address
reader.NextResult();
while (reader.Read())
{
CSBusiness.CustomerManagement.Address shippingAddress = new CSBusiness.CustomerManagement.Address();
shippingAddress.IsEncrpyed = true;
shippingAddress.AddressId = Convert.ToInt32(reader["ShippingAddressId"]);
shippingAddress.FirstName = reader["FirstName"].ToString();
shippingAddress.LastName = reader["LastName"].ToString();
shippingAddress.Address1 = reader["Address1"].ToString();
shippingAddress.Address2 = reader["Address2"].ToString();
shippingAddress.City = reader["City"].ToString();
shippingAddress.PhoneNumber = reader["PhoneNumber"].ToString();
shippingAddress.ZipPostalCode = reader["ZipPostalCode"].ToString();
shippingAddress.StateProvinceId = Convert.ToInt32(reader["StateProvince"]);
shippingAddress.CountryId = Convert.ToInt32(reader["CountryId"]);
item.ShippingAddress = shippingAddress;
}
}
//Decrypy sensitive data before save
Encryption.DecryptValues(item);
return(item);
}