public void can_export_customers_to_xlsx()
{
var customers = new List <Customer>
{
new Customer
{
Active = true,
AffiliateId = 0,
CreatedOnUtc = new DateTime(2010, 01, 04),
CustomerGuid = Guid.NewGuid(),
Email = "*****@*****.**",
Username = "******",
IsTaxExempt = true,
VendorId = 0
}
};
var excelData = _exportManager.ExportCustomersToXlsx(customers);
var worksheet = GetWorksheets(excelData);
var manager = GetPropertyManager <Customer>(worksheet);
manager.ReadFromXlsx(worksheet, 2);
var customer = customers.First();
var ignore = new List <string> {
"Id", "ExternalAuthenticationRecords", "CustomerRoles", "ShoppingCartItems",
"ReturnRequests", "BillingAddress", "ShippingAddress", "Addresses", "AdminComment",
"EmailToRevalidate", "HasShoppingCartItems", "RequireReLogin", "FailedLoginAttempts",
"CannotLoginUntilDateUtc", "Deleted", "IsSystemAccount", "SystemName", "LastIpAddress",
"LastLoginDateUtc", "LastActivityDateUtc", "RegisteredInStoreId"
};
AreAllObjectPropertiesPresent(customer, manager, ignore.ToArray());
PropertiesShouldEqual(customer, manager, new Dictionary <string, string>());
}
public async Task <IActionResult> ExportExcelAll(CustomerListModel model)
{
var customers = await _customerService.GetAllCustomers(
customerRoleIds : model.SearchCustomerRoleIds.ToArray(),
email : model.SearchEmail,
username : model.SearchUsername,
firstName : model.SearchFirstName,
lastName : model.SearchLastName,
company : model.SearchCompany,
phone : model.SearchPhone,
zipPostalCode : model.SearchZipPostalCode,
loadOnlyWithShoppingCart : false);
try
{
byte[] bytes = _exportManager.ExportCustomersToXlsx(customers);
return(File(bytes, "text/xls", "customers.xlsx"));
}
catch (Exception exc)
{
ErrorNotification(exc);
return(RedirectToAction("List"));
}
}
public void CanExportCustomersToXlsx()
{
var customers = _customerService.GetAllCustomers();
var excelData = _exportManager.ExportCustomersToXlsx(customers);
var worksheet = GetWorksheets(excelData);
var manager = GetPropertyManager <Customer>(worksheet);
manager.ReadFromXlsx(worksheet, 2);
var customer = customers.First();
var ignore = new List <string> {
"Id", "ExternalAuthenticationRecords", "CustomerRoles", "ShoppingCartItems",
"ReturnRequests", "BillingAddress", "ShippingAddress", "Addresses", "AdminComment",
"EmailToRevalidate", "HasShoppingCartItems", "RequireReLogin", "FailedLoginAttempts",
"CannotLoginUntilDateUtc", "Deleted", "IsSystemAccount", "SystemName", "LastIpAddress",
"LastLoginDateUtc", "LastActivityDateUtc", "RegisteredInStoreId", "BillingAddressId", "ShippingAddressId",
"CustomerCustomerRoleMappings", "CustomerAddressMappings", "EntityCacheKey"
};
AreAllObjectPropertiesPresent(customer, manager, ignore.ToArray());
PropertiesShouldEqual(customer, manager, new Dictionary <string, string>());
}
/// <summary>
/// Export customer list to XLSX
/// </summary>
/// <param name="customers">Customers</param>
public byte[] ExportCustomersToXlsx(IList <Customer> customers)
{
return(_exportManager.ExportCustomersToXlsx(customers));
}