C# (CSharp) ExcelComunication.DataTableToBankAccount Exemples

Exemple #1

        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"));
        }