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"));
}
public async Task <IActionResult> Import(ImportVM formFile)
{
var batch = _context.OriginalListing.OrderByDescending(v => v.Batch).Where(c => c.Year == formFile.Year).FirstOrDefault()?.Batch ?? 0;
batch++;
// upload
var filePath = Path.GetTempFileName();
using (var stream = new FileStream(filePath, FileMode.Create))
{
await formFile.Myfile.CopyToAsync(stream);
}
var list = ExcelComunication.DataTableTooriginal_listing(ExcelComunication.ExcelToDataTable(filePath), formFile.Year, batch);
_context.OriginalListing.AddRange(list);
await _context.SaveChangesAsync();
await _context.Database.ExecuteSqlCommandAsync("init_transaction");
return(RedirectToAction("Index"));
}