public async Task <IActionResult> Import(ImportVM formFile) { TempData["url"] = "bankacount"; // upload var filePath = Path.GetTempFileName(); using (var stream = new FileStream(filePath, FileMode.Create)) { await formFile.Myfile.CopyToAsync(stream); } var list = ExcelComunication.DataTableToBankAccount(ExcelComunication.ExcelToDataTable(filePath)); _context.BankAccount.AddRange(list); await _context.SaveChangesAsync(); await _context.Database.ExecuteSqlCommandAsync("modify_banks_transaction"); return(RedirectToAction("Index")); }