public EmployeesController(IEmployeeService employeeService, ImageService imageService, IExcelExporter employeeExporter, ITrainingService trainingService)
{
_employeeService = employeeService;
_imageService = imageService;
_employeeExporter = employeeExporter;
_trainingService = trainingService;
}
/// <summary>
/// Exports the data supplied to an excel workbook
/// </summary>
/// <param name="rowData">The data to be exported to the workbook</param>
/// <param name="formatter"></param>
public void WriteDataToExport(IEnumerable<IEnumerable<Cell>> rowData, CellFormatter formatter, ExcelFileType excelFileType)
{
if (excelFileType == ExcelFileType.XLS)
{
ExcelExporter = new ExcelXlsExporter();
}
ExcelExporter.WriteDataToExport(rowData, formatter, "Sheet 1");
}
/// <summary>
/// Exports the data supplied to an excel workbook
/// </summary>
/// <param name="rowData">The data to be exported to the workbook</param>
/// <param name="formatter"></param>
public void WriteDataToExport(IEnumerable <IEnumerable <Cell> > rowData, CellFormatter formatter, ExcelFileType excelFileType)
{
if (excelFileType == ExcelFileType.XLS)
{
ExcelExporter = new ExcelXlsExporter();
}
ExcelExporter.WriteDataToExport(rowData, formatter, "Sheet 1");
}
public FileContentResult ListExcel(IDbConnection connection, ListRequest request,
[FromServices] IExcelExporter exporter)
{
var data = List(connection, request).Entities;
var bytes = exporter.Export(data, typeof(Columns.ProductColumns), request.ExportColumns);
return(ExcelContentResult.Create(bytes, "ProductList_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss", CultureInfo.InvariantCulture) + ".xlsx"));
}
public ExcelIEService(IDbService dbService, IExcelIEDomainService excelIEDomainService, ICapPublisher capPublisher, IRedisOperation redis, IExcelExporter IExcelExporter, IOss oss, ILogger <ExcelIEService> logger)
{
_dbService = dbService;
_excelIEDomainService = excelIEDomainService;
_capPublisher = capPublisher;
_redis = redis;
_iExcelExporter = IExcelExporter;
_oss = oss;
_logger = logger;
}
public PcoEnderecoController(IVisitaEnderecoPcoRepository visitaEnderecoPcoRepository,
ILotePcoRepository lotePcoRepository, BDNVTContext context, IExcelExporter exporter,
IPijamaGasNaturalPymeRepository pijamaGasNaturalPymeRepository, IZonaRepository zonaRepository)
{
_visitaEnderecoPcoRepository = visitaEnderecoPcoRepository;
_lotePcoRepository = lotePcoRepository;
_context = context;
_exporter = exporter;
this.pijamaGasNaturalPymeRepository = pijamaGasNaturalPymeRepository;
this.zonaRepository = zonaRepository;
}
public LotePorClienteController(BDNVTContext context, IHostingEnvironment he,
IAreaRepository areaRepository, ILoteRepository loteRepository,
ICondominioLoteAtivo condominioRepository, IMotivoRejeicao motivoRejeicaoRepository,
IExcelExporter exportaExcelLotePorCliente)
{
_context = context;
_hostingEnvironment = he;
_areaRepository = areaRepository;
_loteRepository = loteRepository;
_condominioRepository = condominioRepository;
_motivoRejeicaoRepository = motivoRejeicaoRepository;
_exportaExcelLotePorCliente = exportaExcelLotePorCliente;
}
public PaymentManager(
IWebHostEnvironment env,
IAppFolders appFolders,
IObjectMapper objectMapper,
ILocalizationManager localizationManager,
IExcelExporter excelExporter,
RoleManager roleManager,
UserManager userManager,
TenantManager tenantManager,
AccountingManager accountingManager)
: base(env, appFolders, objectMapper, roleManager, userManager, tenantManager, excelExporter, localizationManager)
{
try
{
#region Declaration
_accountingManager = accountingManager;
#endregion
}
catch (Exception ex)
{
Log.Error(nameof(PaymentManager), ex);
}
}
public PaymentController(
IRepository <Role> roleRepository,
IAppNotifier appNotifier,
IRealTimeCommunicator realtimeService,
IPlexformNotifier plexformNotifier,
ICoreEmailer plexformEmailer,
IWebHostEnvironment env,
IAppFolders appFolders,
IObjectMapper objectMapper,
ILocalizationManager localizationManager,
IExcelExporter excelExporter,
BizUserManager bizUser,
UserManager userManager,
TenantManager tenantManager,
AccountingManager accountingManager,
PaymentManager paymentManager
) : base(roleRepository, appNotifier, env, appFolders, objectMapper, tenantManager, excelExporter, localizationManager)
{
try
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
#region Declaration
Log = NullLogger.Instance;
_realtimeService = realtimeService;
_plexformNotifier = plexformNotifier;
_localizationManager = localizationManager;
_accountingManager = accountingManager;
_paymentManager = paymentManager;
#endregion
}
catch (Exception ex)
{
Log.Error(nameof(PaymentController), ex);
}
}
public TrainingController(ITrainingService trainingService, IExcelExporter trainingExporter)
{
_trainingService = trainingService;
_trainingExporter = trainingExporter;
}
public ExcelOperator(IExcelImporter excelImporter, IExcelExporter excelExporter)
{
ExcelImporter = excelImporter;
ExcelExporter = excelExporter;
}
public SimulationResultViewModel(IEnumerable<ISectionViewModel> sections, IExcelExporter<SimulationResultViewModel> excelExporter)
{
this.Sections = sections;
this.ExportToExcelCommand = excelExporter.GetExportCommand(this);
}
public EmployeesController(IEmployeeService employeeService, ImageService imageService, IExcelExporter employeeExporter)
{
_employeeService = employeeService;
_imageService = imageService;
_employeeExporter = employeeExporter;
}
public DataSetWrapper(IExcelExporter excelExporter)
{
_excelExporter = excelExporter;
this.DataSet = new List <Gesture>();
}
public ProjectController(IProjectService projectService, IExcelExporter projectExporter)
{
_projectService = projectService;
_projectExporter = projectExporter;
}
public VisitaPcoController(IVisitaPcoRepository visitaPcoRepository, IExcelExporter exporter)
{
_visitaPcoRepository = visitaPcoRepository;
_exporter = exporter;
}
public PositionsController(IPositionService positionService, IExcelExporter positionExporter)
{
_positionService = positionService;
_positionExporter = positionExporter;
}
public ExcelExportCommand(IFactory factrory)
{
_excelExporter = factrory.CreateExcelExporter();
}
public ExporterTest()
{
Exporter = new DefaultExcelExporter();
}
public HomeController(IntervalDataManager intervalDataManager, IExcelExporter excelExporter)
{
this.intervalDataManager = intervalDataManager;
this.excelExporter = excelExporter;
}
public void SetUp()
{
_excelCreator = new ExcelCreator();
_excelExporter = new ExcelExporter(_excelCreator);
}
public ExcelExportService(IDatatableConverter datatableConverter, IExcelExporter excelExporter)
{
_dataTableConverter = datatableConverter;
_excelExporter = excelExporter;
}
public ScoreCardController(IScoreCardFactory scoreCardFactory, IExcelExporter exporter, ILoggerFactory logger) : base(logger)
{
_scoreCardFactory = scoreCardFactory;
_exporter = exporter;
}
