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