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