public IActionResult UploadProcessingFiles()
{
return(View(new UploadProcessingFilesViewModel()
{
UploadFileTypes = ExcelLoanServices.GetUploadFileTypes().Select(m => new SelectListItem()
{
Text = m.Description, Value = m.ID.ToString()
}).ToList()
}));
}
public IActionResult UploadMapperFile()
{
var viewModel = new UploadFileViewModel();
viewModel.UploadFileTypes = ExcelLoanServices.GetUploadFileTypes().Select(m => new SelectListItem()
{
Text = m.Description, Value = m.ID.ToString()
}).ToList();
return(View(viewModel));
}
public IActionResult MapperFileList()
{
UploadFIleListViewModel fileList = new UploadFIleListViewModel
{
FileList = ExcelLoanServices.GetFileList().ToList()
};
return(View(fileList));
}
public async Task <IActionResult> UploadProcessingFiles(UploadProcessingFilesViewModel model)
{
try
{
ExcelLoanServices.UploadProcessingFiles(model, _hostingEnvironment.WebRootPath);
return(RedirectToAction("Index", "ExcelLoan"));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Error", new { ErrorMessage = ex.Message }));
}
}
public IActionResult AddFileType(UploadFileTypeViewModel model)
{
try
{
ExcelLoanServices.AddUploadFileType(model, _hostingEnvironment.WebRootPath);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Error", new { ErrorMessage = ex.Message }));
}
}
public IActionResult ImportMaping(int Id)
{
try
{
ExcelLoanServices.ImportMapping(Id);
return(RedirectToAction("MapperFileList", "ExcelLoan"));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Errors", new { ErrorMessage = ex.Message }));
}
}
public IActionResult Index()
{
// Get files List From Path
//var data=ExcelLoanServices.ReadExcelFileData(filesList, _hostingEnvironment.WebRootPath,new PersonTest().GetType());
//ExcelLoanServices.ReadFile(filesList,_hostingEnvironment.WebRootPath);
return(View(new FolderFileListViewModel
{
FileListModels = ExcelLoanServices.GetFileListByTypes(_hostingEnvironment.WebRootPath)
}));
}
public IActionResult ReadFiles()
{
try
{
var filesList = ExcelLoanServices.GetFileListByTypes(_hostingEnvironment.WebRootPath);
//var data = ExcelLoanServices.ReadExcelFileData(filesList, _hostingEnvironment.WebRootPath, new PersonTest().GetType());
ExcelLoanServices.ReadFile(filesList, _hostingEnvironment.WebRootPath);
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }));
}
}
public IActionResult UploadMapperFile(UploadFileViewModel model)
{
try
{
if (ExcelLoanServices.SaveExcelFileToDatabase(model))
{
return(RedirectToAction("MapperFileList", "ExcelLoan"));
}
else
{
return(View(model));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
