public ActionResult UploadToStaging(UploadStagingModel model) { if (ModelState.IsValid) { if (model.attachment.ContentLength > 0) { string fileName = Path.GetFileName(model.attachment.FileName); string path = Path.Combine(Server.MapPath("~/App_Data/CSVUploads"), fileName); Data_Loading_Tool.Database.FileAccess fileAccess = new Data_Loading_Tool.Database.FileAccess(); fileAccess.writeCSVtoDisk(model, path); StagingDataAccess dataAccess = new StagingDataAccess(); dataAccess.updateTableFromCSV(path, model.StagingTableID, model.UniqueUploadRef, model.UnpivotData, model.FirstUpload, model.GeographyColumn); TempData["SuccessMessage"] = "The Data was uploaded successfully"; return(RedirectToAction("Index")); } } List <Breadcrumb> trail = new List <Breadcrumb>(); trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Staging Index", Action = "Index", Controller = "Staging", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Upload to Staging", isCurrent = true }); model.Breadcrumbs = trail; return(View(model)); }
public ActionResult UploadToStaging(UploadStagingModel model) { if (ModelState.IsValid) { if (model.attachment.ContentLength > 0) { string fileName = Path.GetFileName(model.attachment.FileName); string path = Path.Combine(Server.MapPath("~/App_Data/CSVUploads"), fileName); Data_Loading_Tool.Database.FileAccess fileAccess = new Data_Loading_Tool.Database.FileAccess(); fileAccess.writeCSVtoDisk(model, path); StagingDataAccess dataAccess = new StagingDataAccess(); dataAccess.updateTableFromCSV(path, model.StagingTableID, model.UniqueUploadRef, model.UnpivotData, model.FirstUpload, model.GeographyColumn); TempData["SuccessMessage"] = "The Data was uploaded successfully"; return RedirectToAction("Index"); } } List<Breadcrumb> trail = new List<Breadcrumb>(); trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Staging Index", Action = "Index", Controller = "Staging", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Upload to Staging", isCurrent = true }); model.Breadcrumbs = trail; return View(model); }