public ActionResult Create(Student student)
{
if (ModelState.IsValid)
{
context.Students.Add(student);
context.SaveChanges();
return RedirectToAction("Index");
}
return View(student);
}
public static Student FindOrMake(this DbSet<Student> students, string membershipNumber, string forename, string surname, DbContext ctx)
{
var student = students.FirstOrDefault(s => s.MembershipNumber == membershipNumber);
if (student == null) {
student = new Student() {
MembershipNumber = membershipNumber,
Forename = forename,
Surname = surname
};
students.Add(student);
ctx.SaveChanges();
}
return (student);
}
static void ImportStageOne(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
{
if (row.AttendedStageOne) {
ImportPlay(context, student, s1, row.StageOneTerm, row.StageOneYear, String.Empty, String.Empty, String.Empty, String.Empty, row.StageOneActor);
}
}
static void ImportReplay(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
{
if (row.AttendedReplay) {
ImportPlay(context, student, rp, row.ReplayTerm, row.ReplayYear, row.ReplayProduction, row.ReplayPlay, row.ReplayDramaturg, row.ReplayDirector, row.ReplayActor1,
row.ReplayActor2, row.ReplayActor3);
}
}
static void ImportPlaymakingOne(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
{
if (row.AttendedPm1) {
ImportPlay(context, student, pm1, row.PlaymakingOneTerm, row.PlaymakingOneYear, row.PlaymakingOneProduction, row.PlaymakingOnePlay, row.PlaymakingOneDramaturg, row.PlaymakingOneDirector,
row.PlaymakingOneActor1, row.PlaymakingOneActor2, row.PlaymakingOneActor3);
//var term = context.Terms.FindOrMake(row.PlaymakingOneTerm);
//var course = context.Courses.FindOrMake(pm1, term, row.PlaymakingOneYear);
//if (course != null) {
// var attendance = new CourseAttendance() {
// Student = student,
// Course = course,
// Completed = true
// };
// Production production = context.Productions.FindOrMake(row.PlaymakingOneProduction);
// if (!String.IsNullOrWhiteSpace(row.PlaymakingOnePlay)) {
// var play = new Play() {
// Student = student,
// Title = row.PlaymakingOnePlay
// };
// if (production != null) play.Production = production;
// attendance.Play = play;
// student.Plays.Add(play);
// AddPlayVolunteer(context, play, row.PlaymakingOneDramaturg, Jobs.Dramaturg);
// AddPlayVolunteer(context, play, row.PlaymakingOneDirector, Jobs.Director);
// AddPlayVolunteer(context, play, row.PlaymakingOneActor1, Jobs.Actor);
// AddPlayVolunteer(context, play, row.PlaymakingOneActor2, Jobs.Actor);
// AddPlayVolunteer(context, play, row.PlaymakingOneActor3, Jobs.Actor);
// } else {
// AddCourseVolunteer(context, course, row.PlaymakingOneDramaturg, Jobs.Dramaturg);
// AddCourseVolunteer(context, course, row.PlaymakingOneActor1, Jobs.Actor);
// AddCourseVolunteer(context, course, row.PlaymakingOneActor2, Jobs.Actor);
// AddCourseVolunteer(context, course, row.PlaymakingOneActor3, Jobs.Actor);
// AddCourseVolunteer(context, course, row.PlaymakingOneDirector, Jobs.Director);
// }
// student.CourseAttendances.Add(attendance);
}
}
static void ImportPlayback(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
{
if (row.AttendedPlayback) {
ImportPlay(context, student, pb, "Playback", row.PlaybackYear, row.PlaybackProduction, row.PlaybackPlay, row.PlaybackDramaturg, row.PlaybackDirector,
row.PlaybackActor
);
}
}
static object ImportPlay(SceneCRM context, Student student, CourseType courseType, string termName, string termYear, string productionName, string playName,
string dramaturg, string director, params string[] actors)
{
object returnValue = null;
var term = context.Terms.FindOrMake(termName, context);
var course = context.Courses.FindOrMake(courseType, term, termYear, context);
if (course != null) {
var attendance = new CourseAttendance() {
Student = student,
Course = course,
Completed = true
};
Production production = context.Productions.FindOrMake(productionName, context);
if (!String.IsNullOrWhiteSpace(playName)) {
var play = new Play() {
Student = student,
Title = playName
};
if (production != null) play.Production = production;
attendance.Play = play;
student.Plays.Add(play);
AddPlayVolunteer(context, play, dramaturg, Jobs.Dramaturg);
AddPlayVolunteer(context, play, director, Jobs.Director);
foreach (var actor in actors) {
AddPlayVolunteer(context, play, actor, Jobs.Actor);
}
returnValue = play;
} else {
AddCourseVolunteer(context, course, dramaturg, Jobs.Dramaturg);
AddCourseVolunteer(context, course, director, Jobs.Director);
foreach (var actor in actors) {
AddCourseVolunteer(context, course, actor, Jobs.Actor);
}
returnValue = course;
}
student.CourseAttendances.Add(attendance);
}
return(returnValue);
}
static void ImportOneOnOne(SceneCRM context, Student student, ChildrenProductionsSpreadsheet.Row row)
{
if (row.AttendedOneOnOne) {
ImportPlay(context, student, oneOnOne, row.OneonOneTerm, row.OneonOneYear, row.OneonOneProduction, row.OneonOnePlay, row.OneonOneWriter, row.OneonOneDirector, row.OneonOneActor);
}
}
public ActionResult Edit(Student student)
{
if (ModelState.IsValid)
{
context.Entry(student).State = EntityState.Modified;
context.SaveChanges();
return RedirectToAction("Index");
}
return View(student);
}
