public override async Task Import(ImportVM datiImport) { var f = new FileInfo(datiImport.FilePath); using (var reader = new StreamReader(f.OpenRead())) { bool isPrimaRigaIntestazione = datiImport.IsPrimaRigaIntestazione; var properties = GetReadWriteProperties(); while (!reader.EndOfStream) { var line = await reader.ReadLineAsync(); if (isPrimaRigaIntestazione) { isPrimaRigaIntestazione = false; } else { var values = line.Split(datiImport.SeparatoreCsv); T model = (T)Activator.CreateInstance(typeof(T)); for (int i = 0; i < values.Length; i++) { var propName = datiImport.Colonne[i]; var item = values[i]; SetData(model, properties, propName, item); } Aggiungi(model); } } await Salva(); } }
public ActionResult Create(ImportVM v) { if (ModelState.IsValid) { Import a = new Import(); int max = (from c in db.Imports orderby c.ImportID descending select c.ImportID).FirstOrDefault(); a.ImportID = max + 1; a.ImportNo = v.ImportNo; if (a.ImportDate == null) { a.ImportDate = Convert.ToDateTime(v.ImportDate); } a.Consignor = v.Agent; a.FlightNo = v.FlightNo; a.MAWBNO = v.MAWBNo; a.TotPackage = v.Package; a.StatedWeight = v.Weight; a.Pieces = v.Pieces; db.Imports.Add(a); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully added Import Data."; return(RedirectToAction("Index")); } return(View()); }
public override async Task Import(ImportVM datiImport) { using (var p = new ExcelPackage(new FileInfo(datiImport.FilePath))) { var ws = p.Workbook.Worksheets.First(); var riga = 1; if (datiImport.IsPrimaRigaIntestazione) { riga++; } var properties = GetReadWriteProperties(); for (int r = riga; r < ws.Dimension.Rows; r++) { T model = (T)Activator.CreateInstance(typeof(T)); for (int c = 1; c < ws.Dimension.Columns; c++) { var propName = datiImport.Colonne[c - 1]; var item = ws.GetValue(r, c); SetData(model, properties, propName, item); } Aggiungi(model); } await Salva(); } }
public IActionResult Import(int testId) { var viewModel = new ImportVM() { TestId = testId }; return(View(viewModel)); }
/// <summary> /// Import theo nhóm danh mục /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Import(int id) { ImportVM model = new ImportVM(); DM_NHOMDANHMUCBusiness = Get <DM_NHOMDANHMUCBusiness>(); model.DanhMuc = DM_NHOMDANHMUCBusiness.Find(id); model.PathTemplate = Path.Combine(HostUpload, WebConfigurationManager.AppSettings["ImportDanhMucTemplate"]); return(View(model)); }
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")); }
public abstract Task Import(ImportVM datiImport);