public DataUploadController(ApplicationUserManager userManager, IUploadManager uploadMgr, IServiceManager servMgr, IExcelProcessor excel)
{
_uploadMgr = uploadMgr;
_servMgr = servMgr;
_excel = excel;
_userManager = userManager;
}
public DataUploadController(ApplicationUserManager userManager, IUploadManager uploadMgr, IVoterManager votMgr, IExcelProcessor excel)
{
_uploadMgr = uploadMgr;
_votMgr = votMgr;
_excel = excel;
_userManager = userManager;
}
private string LookupExcel(string value)
{
IExcelProcessor xlProcessor = null;
try {
var type = typeof(IExcelProcessor);
IEnumerable <Type> types = AppDomain.CurrentDomain.GetAssemblies()
.SelectMany(s => s.GetTypes())
.Where(p => type.IsAssignableFrom(p));
foreach (Type t in types)
{
if (!t.IsAbstract && !t.IsInterface)
{
xlProcessor = (IExcelProcessor)Activator.CreateInstance(t);
}
}
if (xlProcessor == null)
{
return(value);
}
return(xlProcessor.Lookup(value, dataFile, excelLookupSheet, excelKeyColumn, excelValueColumn));
} catch (Exception ex) {
Console.WriteLine(ex.Message);
return(value);
}
}
public IExcelProcessor getExcelInstance()
{
if (object.Equals(null, _excelProcessor))
{
_excelProcessor = new AsposeExcel();
}
return(_excelProcessor);
}
public IExcelProcessor getExcelInstance()
{
if (object.Equals(null, _excelProcessor))
{
if (this.library == UsedLibrary.Aspose)
{
_excelProcessor = new AsposeExcel();
}
else if (this.library == UsedLibrary.Spire)
{
_excelProcessor = new SpireExcel();
}
else if (this.library == UsedLibrary.GemboxSpreadSheet)
{
_excelProcessor = new GemboxSpreadSheetExcel();
}
}
return(_excelProcessor);
}
public UploadManager(IDataRepository db, IExcelProcessor excel, IVoterManager votgr)
{
_db = db;
_excel = excel;
_votgr = votgr;
}
public ServerController(IServerManager servMgr, IExcelProcessor excel)
{
_servMgr = servMgr;
_excel = excel;
}
public ServerManager(ApplicationDbContext context, IExcelProcessor excel)
{
_context = context;
_excel = excel;
}
// private readonly UserManager<ApplicationUser> _applicationUser;
public VoterController(IVoterManager votMgr, IExcelProcessor excel)
{
_votMgr = votMgr;
_excel = excel;
//_applicationUser = user;
}
//private UserManager<ApplicationUser> _usermanager;
public VoterManager(ApplicationDbContext context, IExcelProcessor excel)
{
_context = context;
_excel = excel;
// _usermanager = usermanager;
}
public NPoiExcelProvider(IFileUtils fileUtils, IExcelProcessor processor)
{
_fileUtils = fileUtils ?? throw new ArgumentNullException(nameof(fileUtils));
_processor = processor ?? throw new ArgumentNullException(nameof(processor));
}
public UploadManager(IDataRepository db, IExcelProcessor excel)
{
_db = db;
_excel = excel;
}
public OrderHandler(IExcelProcessor processor)
{
_processor = processor;
}
public UploadManager(IDataRepository db, IExcelProcessor excel, IServiceManager servMgr)
{
_db = db;
_excel = excel;
_servMgr = servMgr;
}
public ExcelTestRunner(IExcelProcessor excelUtil)
{
_excelUtil = excelUtil;
}
