public ActionResult ImportStudents(HttpPostedFileBase file)
{
string path = null;
string url = null;
List<CSVStudent> StudentsToDisplay = new List<CSVStudent>();
try
{
if (file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
path = AppDomain.CurrentDomain.BaseDirectory + "upload\\" + fileName;
file.SaveAs(path);
using (var sr = new StreamReader(path))
{
var reader = new CsvReader(sr);
reader.Configuration.Delimiter = "\t";
reader.Configuration.IgnoreHeaderWhiteSpace = true;
var records = reader.GetRecords<CSVStudent>().ToList();
try
{
var result = "";
//move data to the database etl.student
//then run the stored procedure that copies data from etl.student to samsjacksonville.student
var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString);
StudentRepository snm = new StudentRepository(connection);
result = snm.ImportStudents(records);
if (result == "success")
{
url = this.Request.UrlReferrer.AbsolutePath + "/?error=fileloaded";
return Redirect(url);
}
else
{
//do something else here.
url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile";
return Redirect(url);
}
}
catch (Exception ex)
{
url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile";
return Redirect(url);
}
}
}
else
{
url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile";
return Redirect(url);
}
}
catch
{
url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile";
return Redirect(url);
}
}