public void TranslateSAToLoadStudentSchedule(SubjectAssignment sab, StudentSchedule sa)
{
sa.GradeSection = sab.GradeSection;
sa.Section = sab.Section;
sa.GradeLevel = sab.GradeLevel;
sa.Class = sab.Class;
sa.Room = sab.Room;
sa.RoomCode = sab.RoomCode;
sa.Subject = sab.Subject;
sa.Teacher = sab.Teacher;
sa.TeacherName = sab.TeacherName;
sa.Timeslot = sab.Timeslot;
sa.Timestart = sab.Timestart;
sa.TimeEnd = sab.TimeEnd;
sa.Days = sab.Days;
sa.Deactivated = sab.Deactivated;
sa.GradeSectionCode = sab.GradeSectionCode;
sa.RoomId = sab.RoomId;
sa.SubjectCode = sab.SubjectCode;
sa.SY = sab.SY;
sa.TeacherId = sab.TeacherId;
sa.TimeSlotCode = sab.TimeSlotCode;
sa.SubjectInfo = sa.SubjectInfo;
sa.SubjectDescription = sa.SubjectDescription;
}
public void TranslateScheduleToLoad(SubjectAssignment sa, TeacherLoad tl)
{
tl.GradeSection = sa.GradeSection;
tl.Section = sa.Section;
tl.GradeLevel = sa.GradeLevel;
tl.Class = sa.Class;
tl.Room = sa.Room;
tl.RoomCode = sa.RoomCode;
tl.Subject = sa.Subject;
tl.Teacher = sa.Teacher;
tl.TeacherName = sa.TeacherName;
tl.Timeslot = sa.Timeslot;
tl.Timestart = sa.Timestart;
tl.TimeEnd = sa.TimeEnd;
tl.Days = sa.Days;
tl.Deactivated = sa.Deactivated;
tl.GradeSectionCode = sa.GradeSectionCode;
tl.RoomId = sa.RoomId;
tl.SubjectCode = sa.SubjectCode;
tl.SY = sa.SY;
tl.TeacherId = sa.TeacherId;
tl.TimeSlotCode = sa.TimeSlotCode;
tl.SubjectInfo = sa.SubjectInfo;
tl.SubjectDescription = sa.SubjectDescription;
}
private void UpdateTeacherSubjects(string[] selectedSubjects, Teacher teacherToUpdate)
{
if (selectedSubjects == null)
{
teacherToUpdate.SubjectAssignments = new List <SubjectAssignment>();
return;
}
var selectedSubjectsHS = new HashSet <string>(selectedSubjects);
var teacherSubjects = new HashSet <int>
(teacherToUpdate.SubjectAssignments.Select(c => c.Subject.SubjectID));
foreach (var subject in _context.Subjects.GetAll())
{
if (selectedSubjectsHS.Contains(subject.SubjectID.ToString()))
{
if (!teacherSubjects.Contains(subject.SubjectID))
{
teacherToUpdate.SubjectAssignments.Add(new SubjectAssignment {
TeacherID = teacherToUpdate.ID, SubjectID = subject.SubjectID
});
}
}
else
{
if (teacherSubjects.Contains(subject.SubjectID))
{
SubjectAssignment subjectToRemove = teacherToUpdate.SubjectAssignments.FirstOrDefault(i => i.SubjectID == subject.SubjectID);
_context.Subjects.Delete(subjectToRemove.SubjectID);
}
}
}
}
public ActionResult DeleteConfirmed(string id)
{
SubjectAssignment subjectassignment = db.SubjectAssignments.Find(id);
db.SubjectAssignments.Remove(subjectassignment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool CreateSchedules(SubjectAssignment subjectAssignment, string message)
{
Boolean ret = false;;
SubjectAssignmentBDO sabdo = new SubjectAssignmentBDO();
TranslateScheduleToScheduleBDO(subjectAssignment, sabdo);
ret = schedLogic.CreateSchedule(ref sabdo, ref message);
return(ret);
}
public void TranslateScheduleToScheduleBDO(SubjectAssignment schedule, SubjectAssignmentBDO sabdo)
{
sabdo.Deactivated = false;
sabdo.GradeSectionCode = schedule.GradeSectionCode;
sabdo.RoomId = schedule.RoomId;
sabdo.SubjectAssignmentsID = schedule.SubjectAssignmentsID;
sabdo.SubjectCode = schedule.SubjectCode;
sabdo.SY = schedule.SY;
sabdo.TeacherId = schedule.TeacherId;
sabdo.TimeSlotCode = schedule.TimeSlotCode;
}
public ActionResult Edit([Bind(Include = "StudentID,SubjectId")] SubjectAssignment subjectassignment)
{
if (ModelState.IsValid)
{
db.Entry(subjectassignment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", subjectassignment.StudentID);
ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "SubjectName", subjectassignment.SubjectId);
return(View(subjectassignment));
}
// GET: /SubjectAssignment/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectAssignment subjectassignment = db.SubjectAssignments.Find(id);
if (subjectassignment == null)
{
return(HttpNotFound());
}
return(View(subjectassignment));
}
public List <SubjectAssignment> GetAllSchedulesbySection(int iGradeSection, string sy)
{
List <SubjectAssignmentBDO> schedules = new List <SubjectAssignmentBDO>();
schedules = schedLogic.GetAllSchedulesbySection(iGradeSection);
List <SubjectAssignment> s = new List <SubjectAssignment>();
foreach (SubjectAssignmentBDO sched in schedules)
{
SubjectAssignment sa = new SubjectAssignment();
TranslateScheduleBDOToSchedule(sched, sa);
s.Add(sa);
}
return(s);
}
// GET: /SubjectAssignment/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectAssignment subjectassignment = db.SubjectAssignments.Find(id);
if (subjectassignment == null)
{
return(HttpNotFound());
}
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", subjectassignment.StudentID);
ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "SubjectName", subjectassignment.SubjectId);
return(View(subjectassignment));
}
public IActionResult Create([Bind("FirstMidName,LastName,PositionAssignments")] Teacher teacher, string[] selectedSubjects)
{
if (selectedSubjects != null)
{
teacher.SubjectAssignments = new List <SubjectAssignment>();
foreach (var subject in selectedSubjects)
{
var subjectToAdd = new SubjectAssignment {
TeacherID = teacher.ID, SubjectID = int.Parse(subject)
};
teacher.SubjectAssignments.Add(subjectToAdd);
}
}
if (ModelState.IsValid)
{
_context.Teachers.Add(teacher);
_context.Save();
return(RedirectToAction(nameof(Index)));
}
PopulateAssignedSubjectData(teacher);
return(View(teacher));
}
public List <SubjectAssignment> GetRightSchedule(int Rank, string gradeLevel)
{
List <SubjectAssignment> schList = new List <SubjectAssignment>();
List <SubjectAssignmentBDO> gradeschedList = new List <SubjectAssignmentBDO>();
gradeschedList = schedLogic.GetScheduleForGradeLevel(gradeLevel);
List <SubjectAssignment> sectionSched = new List <SubjectAssignment>();
foreach (SubjectAssignmentBDO sab in gradeschedList)
{
SubjectAssignment sa = new SubjectAssignment();
TranslateScheduleBDOToSchedule(sab, sa);
schList.Add(sa);
}
int div = Rank / 20;
div++;
sectionSched = schList.FindAll(item => item.Class == div);
return(sectionSched);
}
public async Task <IActionResult> Create([Bind("FirstName,HireDate,LastName,RoomAssignment")] Teacher teacher, string[] selectedSubjects)
{
if (selectedSubjects != null)
{
teacher.SubjectAssignments = new List <SubjectAssignment>();
foreach (var subject in selectedSubjects)
{
var subjectToAdd = new SubjectAssignment {
TeacherID = teacher.TeacherID, SubjectID = int.Parse(subject)
};
teacher.SubjectAssignments.Add(subjectToAdd);
}
}
if (ModelState.IsValid)
{
_context.Add(teacher);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
PopulateRelatedSubject(teacher);
return(View(teacher));
}
public static void Initialize(StuyDbContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var students = new Student[]
{
new Student {
FirstName = "Shreya", LastName = "Shukla", EnrollmentDate = DateTime.Parse("2020-01-01")
},
new Student {
FirstName = "Bobby", LastName = "Smith", EnrollmentDate = DateTime.Parse("2020-01-01")
},
new Student {
FirstName = "John", LastName = "Doe", EnrollmentDate = DateTime.Parse("2020-01-01")
},
new Student {
FirstName = "Tom", LastName = "Mathew", EnrollmentDate = DateTime.Parse("2019-01-01")
},
new Student {
FirstName = "Dan", LastName = "Pauli", EnrollmentDate = DateTime.Parse("2016-01-01")
},
new Student {
FirstName = "Joe", LastName = "Gregor", EnrollmentDate = DateTime.Parse("2017-01-01")
},
new Student {
FirstName = "Laura", LastName = "Newman", EnrollmentDate = DateTime.Parse("2019-01-01")
},
new Student {
FirstName = "Nina", LastName = "Thomas", EnrollmentDate = DateTime.Parse("2018-01-01")
}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var teachers = new Teacher[]
{
new Teacher {
FirstName = "Sally", LastName = "Xu",
JoinDate = DateTime.Parse("2001-01-11")
},
new Teacher {
FirstName = "Lara", LastName = "Bose",
JoinDate = DateTime.Parse("2002-05-16")
},
new Teacher {
FirstName = "Diana", LastName = "Heden",
JoinDate = DateTime.Parse("2010-01-08")
},
new Teacher {
FirstName = "Raj", LastName = "Patel",
JoinDate = DateTime.Parse("2015-02-10")
},
new Teacher {
FirstName = "Roger", LastName = "Lee",
JoinDate = DateTime.Parse("2008-01-09")
}
};
foreach (Teacher i in teachers)
{
context.Teachers.Add(i);
}
context.SaveChanges();
var departments = new Department[]
{
new Department {
Name = "English", TeacherID = teachers.Single(i => i.LastName == "Xu").TeacherID
},
new Department {
Name = "Mathematics", TeacherID = teachers.Single(i => i.LastName == "Bose").TeacherID
},
new Department {
Name = "Engineering", TeacherID = teachers.Single(i => i.LastName == "Heden").TeacherID
},
new Department {
Name = "Biology", TeacherID = teachers.Single(i => i.LastName == "Patel").TeacherID
},
new Department {
Name = "Botany", TeacherID = teachers.Single(i => i.LastName == "Lee").TeacherID
}
};
foreach (Department d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
var subjects = new Subject[]
{
new Subject {
SubjectID = 1050, Title = "Chemistry", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID
},
new Subject {
SubjectID = 4022, Title = "Micro Biology", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Biology").DepartmentID
},
new Subject {
SubjectID = 4041, Title = "Life Sciences", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Biology").DepartmentID
},
new Subject {
SubjectID = 1045, Title = "Calculus", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Subject {
SubjectID = 3141, Title = "Algebra2", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Subject {
SubjectID = 2021, Title = "Creative Writng", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
new Subject {
SubjectID = 2042, Title = "Literature", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
};
foreach (Subject c in subjects)
{
context.Subjects.Add(c);
}
context.SaveChanges();
var roomAssignments = new RoomAssignment[]
{
new RoomAssignment {
TeacherID = teachers.Single(i => i.LastName == "Xu").TeacherID,
Room = "Room 101"
},
new RoomAssignment {
TeacherID = teachers.Single(i => i.LastName == "Bose").TeacherID,
Room = "Room 102"
},
new RoomAssignment {
TeacherID = teachers.Single(i => i.LastName == "Heden").TeacherID,
Room = "Room 305"
},
new RoomAssignment {
TeacherID = teachers.Single(i => i.LastName == "Patel").TeacherID,
Room = "Room 202"
},
new RoomAssignment {
TeacherID = teachers.Single(i => i.LastName == "Lee").TeacherID,
Room = "Room 301"
},
};
foreach (RoomAssignment o in roomAssignments)
{
context.RoomAssignments.Add(o);
}
context.SaveChanges();
var subjectAssignments = new SubjectAssignment[]
{
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Patel").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Heden").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Micro Biology").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Lee").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Life Sciences").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Lee").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Calculus").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Bose").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Algebra2").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Bose").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Creative Writng").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Xu").TeacherID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Literature").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Xu").TeacherID
},
};
foreach (SubjectAssignment ci in subjectAssignments)
{
context.SubjectAssignments.Add(ci);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
StudentID = students.Single(s => s.LastName == "Shukla").StudentID,
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
Score = 95
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Shukla").StudentID,
SubjectID = subjects.Single(c => c.Title == "Micro Biology").SubjectID,
Score = 90
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Shukla").StudentID,
SubjectID = subjects.Single(c => c.Title == "Life Sciences").SubjectID,
Score = 88
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Smith").StudentID,
SubjectID = subjects.Single(c => c.Title == "Calculus").SubjectID,
Score = 96
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Smith").StudentID,
SubjectID = subjects.Single(c => c.Title == "Algebra2").SubjectID,
Score = 78
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Smith").StudentID,
SubjectID = subjects.Single(c => c.Title == "Creative Writng").SubjectID,
Score = 86
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Doe").StudentID,
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
Score = 85
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Doe").StudentID,
SubjectID = subjects.Single(c => c.Title == "Micro Biology").SubjectID,
Score = 77
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Mathew").StudentID,
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
Score = 88
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Pauli").StudentID,
SubjectID = subjects.Single(c => c.Title == "Creative Writng").SubjectID,
Score = 94
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Newman").StudentID,
SubjectID = subjects.Single(c => c.Title == "Literature").SubjectID,
Score = 83
}
};
foreach (Enrollment e in enrollments)
{
var enrollmentInDataBase = context.Enrollments.Where(
s =>
s.Student.StudentID == e.StudentID &&
s.Subject.SubjectID == e.SubjectID).SingleOrDefault();
if (enrollmentInDataBase == null)
{
context.Enrollments.Add(e);
}
}
context.SaveChanges();
}
private void btnAddSchedule_Click(object sender, EventArgs e)
{
if (cmbGradeLevel.Text != string.Empty && cmbSection.Text != string.Empty && cmbTimeslot.Text != string.Empty &&
cmbSubject.Text != string.Empty && cmbTeacher.Text != string.Empty && cmbRoom.Text != string.Empty)
{
Timeslot t = new Timeslot();
t = timeslots.Find(x => x.TimeSlotCode == cmbTimeslot.SelectedValue.ToString());
GradeSection gs = new GradeSection();
gs = sections.Find(x => x.GradeSectionCode == sectioncode);
Subject su = new Subject();
su = subjects.Find(x => x.SubjectCode == cmbSubject.SelectedValue.ToString());
Room rm = new Room();
rm = rooms.Find(x => x.RoomId == Int32.Parse(cmbRoom.SelectedValue.ToString()));
Teacher tc = new Teacher();
tc = teachers.Find(x => x.TeacherId == cmbTeacher.SelectedValue.ToString());
SubjectAssignment sa = new SubjectAssignment();
sa.GradeLevel = cmbGradeLevel.SelectedValue.ToString() ;
sa.TeacherName = cmbTeacher.Text;
sa.SY = currentSY;
sa.Subject = su;
sa.SubjectCode = su.SubjectCode;
sa.TimeslotInfo = t.TimeSlotInfo;
sa.TimeSlotCode = t.TimeSlotCode;
sa.Room = rm;
sa.RoomId = rm.RoomId;
sa.RoomCode = rm.RoomCode;
sa.Teacher = tc;
sa.TeacherId = tc.TeacherId;
sa.Section = section;
sa.GradeSection = gs;
sa.GradeSectionCode = gs.GradeSectionCode;
sa.Timeslot = t;
sa.Timestart = t.TimeStart;
sa.TimeEnd = t.TimeEnd;
sa.Days = t.Days;
sa.Deactivated = false;
createdSchedule.Add(sa);
schedules.Add(sa);
LoadSchedules();
}
}
private void btnAddSchedule_Click(object sender, EventArgs e)
{
if (cmbGradeLevel.Text != string.Empty && cmbSection.Text != string.Empty && cmbTimeslot.Text != string.Empty &&
cmbSubject.Text != string.Empty && cmbTeacher.Text != string.Empty && cmbRoom.Text != string.Empty)
{
Timeslot t = new Timeslot();
t = timeslots.Find(x => x.TimeSlotCode == cmbTimeslot.SelectedValue.ToString());
GradeSection gs = new GradeSection();
gs = sections.Find(x => x.GradeSectionCode == sectioncode);
Subject su = new Subject();
su = subjects.Find(x => x.SubjectCode == cmbSubject.SelectedValue.ToString());
Room rm = new Room();
rm = rooms.Find(x => x.RoomId == Int32.Parse(cmbRoom.SelectedValue.ToString()));
Teacher tc = new Teacher();
tc = teachers.Find(x => x.TeacherId == cmbTeacher.SelectedValue.ToString());
SubjectAssignment sa = new SubjectAssignment();
sa.GradeLevel = cmbGradeLevel.SelectedValue.ToString();
sa.TeacherName = cmbTeacher.Text;
sa.SY = currentSY;
sa.Subject = su;
sa.SubjectCode = su.SubjectCode;
sa.SubjectDescription = su.Description;
sa.TimeslotInfo = t.TimeSlotInfo;
sa.TimeSlotCode = t.TimeSlotCode;
sa.Room = rm;
sa.RoomId = rm.RoomId;
sa.RoomCode = rm.RoomCode;
sa.Teacher = tc;
sa.TeacherId = tc.TeacherId;
sa.Section = section;
sa.GradeSection = gs;
sa.GradeSectionCode = gs.GradeSectionCode;
sa.Timeslot = t;
sa.Timestart = t.TimeStart;
sa.TimeEnd = t.TimeEnd;
sa.Days = t.Days;
sa.Deactivated = false;
createdSchedule.Add(sa);
schedules.Add(sa);
cmbTimeslot.DataSource = null;
availTimeSlot.RemoveAll(x => x.TimeSlotCode == t.TimeSlotCode);
if (availTimeSlot.Count > 0)
{
cmbTimeslot.DataSource = availTimeSlot;
cmbTimeslot.SelectedIndex = 0;
cmbTimeslot.Refresh();
}
else
{
cmbTimeslot.Enabled = false;
}
gvSchedule.DataSource = null;
gvSchedule.DataSource = schedules.FindAll(x => x.GradeSectionCode == sectioncode);
gvSchedule.Refresh();
// LoadSchedules();
}
}
public void TranslateScheduleBDOToSchedule(SubjectAssignmentBDO sabdo, SubjectAssignment sched)
{
GradeSectionService gs = new GradeSectionService();
GradeSection g = new GradeSection();
gs.TranslateGradeSectionBDOToGradeSection(sabdo.GradeSection, g);
sched.GradeSection = g;
sched.Section = g.Section;
sched.GradeLevel = g.GradeLevel;
sched.Class = (int)g.Class;
RoomService rs = new RoomService();
Room r = new Room();
rs.TranslateRoomBDOtoRoomDTO(sabdo.Room, r);
sched.Room = r;
sched.RoomCode = r.RoomCode;
SubjectService ss = new SubjectService();
Subject s = new Subject();
ss.TranslateSubjectBDOToSubject(sabdo.Subject, s);
sched.Subject = s;
TeacherService ts = new TeacherService();
Teacher t = new Teacher();
ts.TranslateTeacherBDOToTeacherDTO(sabdo.Teacher, t);
sched.Teacher = t;
if (t.MiddleName == String.Empty)
{
sched.TeacherName = t.LastName + ", " + t.FirstName;
}
else
{
sched.TeacherName = t.LastName + ", " + t.FirstName + " " + t.MiddleName.Substring(0, 1) + ".";
}
TimeslotService times = new TimeslotService();
Timeslot time = new Timeslot();
times.TranslateTimeslotBDOToTimeslotDTo(sabdo.Timeslot, time);
sched.Timeslot = time;
sched.Timestart = time.TimeStart;
sched.TimeEnd = time.TimeEnd;
sched.Days = time.Days;
sched.Deactivated = sabdo.Deactivated;
sched.GradeSectionCode = sabdo.GradeSectionCode;
sched.RoomId = sabdo.RoomId;
sched.SubjectAssignmentsID = sabdo.SubjectAssignmentsID;
sched.SubjectCode = sabdo.SubjectCode;
sched.SY = sabdo.SY;
sched.TeacherId = sabdo.TeacherId;
sched.TimeSlotCode = sabdo.TimeSlotCode;
sched.TimeslotInfo = time.Days + " " + time.TimeStart + "-" + time.TimeEnd;
sched.SubjectInfo = sabdo.SubjectCode + " " + sched.Section + " " + sched.TimeslotInfo;
sched.SubjectDescription = s.Description;
}
public static void Initialize(SchoolContext context)
{
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var teachers = new Teacher[]
{
new Teacher {
FirstMidName = "Kim", LastName = "Abercrombie"
},
new Teacher {
FirstMidName = "Fadi", LastName = "Fakhouri"
},
new Teacher {
FirstMidName = "Roger", LastName = "Harui"
},
new Teacher {
FirstMidName = "Candace", LastName = "Kapoor"
},
new Teacher {
FirstMidName = "Roger", LastName = "Zheng"
}
};
foreach (Teacher i in teachers)
{
context.Teachers.Add(i);
}
context.SaveChanges();
var schoolclasses = new SchoolClass[]
{
new SchoolClass {
Name = "1A",
TeacherID = teachers.Single(i => i.LastName == "Abercrombie").ID
},
new SchoolClass {
Name = "2Б",
TeacherID = teachers.Single(i => i.LastName == "Fakhouri").ID
},
new SchoolClass {
Name = "3В",
TeacherID = teachers.Single(i => i.LastName == "Harui").ID
},
new SchoolClass {
Name = "4Г",
TeacherID = teachers.Single(i => i.LastName == "Kapoor").ID
}
};
foreach (SchoolClass d in schoolclasses)
{
context.SchoolClasses.Add(d);
}
context.SaveChanges();
var students = new Student[]
{
new Student {
FirstMidName = "Carson", LastName = "Alexander", Birthday = DateTime.Parse("2010-09-01"), Sex = "male", StudentsClassID = schoolclasses.Single(i => i.Name == "1A").SchoolClassID,
EnrollmentDate = DateTime.Parse("2010-09-01")
},
new Student {
FirstMidName = "Meredith", LastName = "Alonso", Birthday = DateTime.Parse("2010-09-01"), Sex = "male", StudentsClassID = schoolclasses.Single(i => i.Name == "2Б").SchoolClassID,
EnrollmentDate = DateTime.Parse("2012-09-01")
},
new Student {
FirstMidName = "Arturo", LastName = "Anand", Birthday = DateTime.Parse("2010-09-01"), Sex = "male", StudentsClassID = schoolclasses.Single(i => i.Name == "3В").SchoolClassID,
EnrollmentDate = DateTime.Parse("2013-09-01")
},
new Student {
FirstMidName = "Gytis", LastName = "Barzdukas", Birthday = DateTime.Parse("2010-09-01"), Sex = "male", StudentsClassID = schoolclasses.Single(i => i.Name == "4Г").SchoolClassID,
EnrollmentDate = DateTime.Parse("2012-09-01")
},
new Student {
FirstMidName = "Yan", LastName = "Li", Birthday = DateTime.Parse("2010-09-01"), Sex = "male", StudentsClassID = schoolclasses.Single(i => i.Name == "4Г").SchoolClassID,
EnrollmentDate = DateTime.Parse("2012-09-01")
},
new Student {
FirstMidName = "Peggy", LastName = "Justice", Birthday = DateTime.Parse("2010-09-01"), Sex = "male", StudentsClassID = schoolclasses.Single(i => i.Name == "1A").SchoolClassID,
EnrollmentDate = DateTime.Parse("2011-09-01")
},
new Student {
FirstMidName = "Laura", LastName = "Norman", Birthday = DateTime.Parse("2010-09-01"), Sex = "female", StudentsClassID = schoolclasses.Single(i => i.Name == "1A").SchoolClassID,
EnrollmentDate = DateTime.Parse("2013-09-01")
},
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var subjects = new Subject[]
{
new Subject {
SubjectID = 1050, Title = "Chemistry",
SchoolClassID = schoolclasses.Single(s => s.Name == "1A").SchoolClassID
},
new Subject {
SubjectID = 4022, Title = "Microeconomics",
SchoolClassID = schoolclasses.Single(s => s.Name == "1A").SchoolClassID
},
new Subject {
SubjectID = 4041, Title = "Macroeconomics",
SchoolClassID = schoolclasses.Single(s => s.Name == "1A").SchoolClassID
},
new Subject {
SubjectID = 1045, Title = "Calculus",
SchoolClassID = schoolclasses.Single(s => s.Name == "1A").SchoolClassID
},
new Subject {
SubjectID = 3141, Title = "Trigonometry",
SchoolClassID = schoolclasses.Single(s => s.Name == "2Б").SchoolClassID
},
new Subject {
SubjectID = 2021, Title = "Composition",
SchoolClassID = schoolclasses.Single(s => s.Name == "3В").SchoolClassID
},
new Subject {
SubjectID = 2042, Title = "Literature",
SchoolClassID = schoolclasses.Single(s => s.Name == "4Г").SchoolClassID
},
};
foreach (Subject c in subjects)
{
context.Subjects.Add(c);
}
context.SaveChanges();
var positionAssignments = new PositionAssignment[]
{
new PositionAssignment {
TeacherID = teachers.Single(i => i.LastName == "Fakhouri").ID,
Position = "Director"
},
new PositionAssignment {
TeacherID = teachers.Single(i => i.LastName == "Harui").ID,
Position = "HeadTeacher"
},
new PositionAssignment {
TeacherID = teachers.Single(i => i.LastName == "Kapoor").ID,
Position = "Teacher"
},
};
foreach (PositionAssignment o in positionAssignments)
{
context.PositionAssignments.Add(o);
}
context.SaveChanges();
var subjectTeachers = new SubjectAssignment[]
{
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Kapoor").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Harui").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Microeconomics").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Zheng").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Macroeconomics").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Zheng").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Calculus").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Fakhouri").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Trigonometry").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Harui").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Composition").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Abercrombie").ID
},
new SubjectAssignment {
SubjectID = subjects.Single(c => c.Title == "Literature").SubjectID,
TeacherID = teachers.Single(i => i.LastName == "Abercrombie").ID
},
};
foreach (SubjectAssignment ci in subjectTeachers)
{
context.SubjectAssignments.Add(ci);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alexander").ID,
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alexander").ID,
SubjectID = subjects.Single(c => c.Title == "Microeconomics").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alexander").ID,
SubjectID = subjects.Single(c => c.Title == "Macroeconomics").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alonso").ID,
SubjectID = subjects.Single(c => c.Title == "Calculus").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alonso").ID,
SubjectID = subjects.Single(c => c.Title == "Trigonometry").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Alonso").ID,
SubjectID = subjects.Single(c => c.Title == "Composition").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Anand").ID,
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Anand").ID,
SubjectID = subjects.Single(c => c.Title == "Microeconomics").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Barzdukas").ID,
SubjectID = subjects.Single(c => c.Title == "Chemistry").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Li").ID,
SubjectID = subjects.Single(c => c.Title == "Composition").SubjectID,
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Justice").ID,
SubjectID = subjects.Single(c => c.Title == "Literature").SubjectID,
}
};
foreach (Enrollment e in enrollments)
{
var enrollmentInDataBase = context.Enrollments.SingleOrDefault(s => s.Student.ID == e.StudentID &&
s.Subject.SubjectID == e.SubjectID);
if (enrollmentInDataBase == null)
{
context.Enrollments.Add(e);
}
}
context.SaveChanges();
}
