public async Task <IActionResult> AddFiles(ExcelFileViewModel fileViewModel)
{
if (!ModelState.IsValid)
{
return(View("LoadNewWeatherAcrchives", fileViewModel));
}
foreach (var formFile in fileViewModel.ExcelFiles)
{
try
{
if (formFile.Length > 0)
{
using (var stream = new MemoryStream())
{
await formFile.CopyToAsync(stream);
fileViewModel.ReadFromExcel(stream, _dbConnection);
}
}
}
catch (Exception e)
{
ModelState.AddModelError(formFile.FileName, $"{formFile.FileName} : {e.Message}");
}
}
return(View("LoadNewWeatherAcrchives", fileViewModel));
}
public ActionResult ConfigureRatingEngine(HttpPostedFileBase excelConfigFile)
{
if (excelConfigFile != null && excelConfigFile.ContentLength > 0)
{
var path = @"~/ExcelConfig/config_file.xlsx";
path = System.Web.HttpContext.Current.Server.MapPath(path);
excelConfigFile.SaveAs(path);
ExcelFileViewModel e = new ExcelFileViewModel();
e.Path = path;
return(View("PolicyForm", e));
}
return(View("Index"));
}
