public virtual async Task <IActionResult> ExportXlsx() { if (!await _permissionService.AuthorizeAsync(StandardPermissionProvider.ManageManufacturers)) { return(AccessDeniedView()); } try { var bytes = await _exportManager.ExportManufacturersToXlsxAsync((await _manufacturerService.GetAllManufacturersAsync(showHidden: true)).Where(p => !p.Deleted)); return(File(bytes, MimeTypes.TextXlsx, "manufacturers.xlsx")); } catch (Exception exc) { await _notificationService.ErrorNotificationAsync(exc); return(RedirectToAction("List")); } }
public async Task CanExportManufacturersXlsx() { var manufacturers = await _manufacturerService.GetAllManufacturersAsync(); var excelData = await _exportManager.ExportManufacturersToXlsxAsync(manufacturers); var worksheet = GetWorksheets(excelData); var manager = GetPropertyManager <Manufacturer>(worksheet); manager.ReadFromXlsx(worksheet, 2); var manufacturer = manufacturers.First(); var ignore = new List <string> { "Picture", "EntityCacheKey", "PictureId", "SubjectToAcl", "LimitedToStores", "Deleted", "CreatedOnUtc", "UpdatedOnUtc", "AppliedDiscounts", "DiscountManufacturerMappings" }; AreAllObjectPropertiesPresent(manufacturer, manager, ignore.ToArray()); PropertiesShouldEqual(manufacturer, manager, new Dictionary <string, string>()); manager.GetProperties.First(p => p.PropertyName == "Picture").PropertyValue.Should().NotBeNull(); }