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