public ActionResult UploadRoster(AdminDataImport dataImport)
{
ViewBag.UploadResult = true;
if (Request.Files.Count > 0 && Request.Files[0].ContentLength > 0)
{
try
{
var fileExtension = System.IO.Path.GetExtension(dataImport.File.FileName);
if (dataImport.Schema != FileUploadSchema.CSV.ToString())
{
ProcessExcel(dataImport, fileExtension);
}
else
{
ProcessCSV(dataImport.File);
}
}
catch (Exception ex)
{
ViewBag.UploadResult = false;
ViewBag.ErrorMessage = ex.Message;
}
}
return(View("Index"));
}
private void ProcessExcel(AdminDataImport dataImport, string fileExtension)
{
var postedFile = Request.Files[0];
var filePath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, System.IO.Path.GetFileName(postedFile.FileName));
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
postedFile.SaveAs(filePath);
if (dataImport.Schema == FileUploadSchema.Grade.ToString())
{
ExcelImport.UploadGrades(filePath
, fileExtension
, dataImport.CourseId
, dataImport.Deliverable
, CurrentUser.Id);
}
else
{
ExcelImport.UploadSurveys(filePath
, fileExtension
, dataImport.CourseId
, CurrentUser.Id);
}
}