public ActionResult BulkLoad()
{
var students = new List<Student>();
var _bulkLoadService = new BulkLoadService();
_bulkLoadService.Load(students);
return View();
}
public ActionResult UploadCoursesFile()
{
if (Request.Files.Count > 0)
{
var courses = new List<Course>();
HttpPostedFileBase file = Request.Files[0];
var reader = new StreamReader(file.InputStream);
do
{
string line = reader.ReadLine();
var values = line.Split('|');
if (values.Count() == 2)
{
var course = new Course { Code = values[0], Name = values[1] };
courses.Add(course);
}
} while (reader.Peek() != -1);
reader.Close();
var _bulkLoadService = new BulkLoadService();
_bulkLoadService.Load(courses);
}
return RedirectToAction("Index");
}
public ActionResult UploadStudentsFile()
{
if (Request.Files.Count > 0)
{
var students = new List<Student>();
validCourses = db.Courses.ToList();
HttpPostedFileBase file = Request.Files[0];
var reader = new StreamReader(file.InputStream);
do
{
string line = reader.ReadLine();
var studentInfo = line.Split('|');
if (studentInfo.Count() == 4)
{
var student = new Student
{
ExternalId = int.Parse(studentInfo[0]),
FirstName = studentInfo[1],
LastName = studentInfo[2]
};
var enrollementInfo = studentInfo[3].Split(',');
if (enrollementInfo.Length > 0)
{
student.Enrollments = new List<Enrollment>();
foreach (var enrollementItem in enrollementInfo)
{
var enrollement = PraseEnrollement(enrollementItem);
if (enrollement != null)
{
student.Enrollments.Add(enrollement);
}
}
}
students.Add(student);
}
} while (reader.Peek() != -1);
reader.Close();
var _bulkLoadService = new BulkLoadService();
_bulkLoadService.Load(students);
}
return RedirectToAction("Index");
}