public ActionResult TeachersContent(int school, int year) { // get subjects var subjects = repository.GetSchoolSubjects(school).OrderBy(x => x.name); var viewmodel = new List <SubjectTeacher>(); foreach (var entry in subjects) { var subject = entry; var subjectTeacher = db.subject_teachers.Where(x => x.year == year && x.subjectid == subject.id); var model = new SubjectTeacher() { subjectid = subject.id, subjectname = subject.name }; foreach (var teacher in subjectTeacher.GroupBy(x => x.user)) { var subjectentry = new SubjectTeacherEntry(); subjectentry.teachername = teacher.Key.ToName(); foreach (var klass in teacher.OrderBy(x => x.school_class.name)) { subjectentry.AllocatedClasses.Add(new IdName(klass.classid, klass.school_class.name)); } model.teachers.Add(subjectentry); } viewmodel.Add(model); } return(View(viewmodel)); }
public JsonResult UpdateTeacherProfile(EditProfileTeacher Data) { ResultInfo <string> ResultInfo = new ResultInfo <string>() { Status = false, Description = "Failed|Login" }; if (Data != null) { SubjectTeacher PageObj = new SubjectTeacher(); // Data.JoiningDate = Convert.ToDateTime(Data.JoiningDate); ResultInfo.Info = PageObj.UpdateTeacherProfile(Data); if (ResultInfo.Info.Split('!')[0] == "Success") { ResultInfo.Description = "Success!Update Successfull"; ResultInfo.Status = true; } else { ResultInfo.Description = "Failed!Process Failed"; ResultInfo.Status = false; } } return(Json(ResultInfo, JsonRequestBehavior.AllowGet)); }
protected void setData() { if (!this.boxFirstName.IsEmptyOrWhiteSpace) { this.TheTeacher.FirstName = this.boxFirstName.Text; } if (!this.boxLastName.IsEmptyOrWhiteSpace) { this.TheTeacher.LastName = this.boxLastName.Text; } if (this.times != null) { for (int i = 0; i < this.TheTeacher.TimeTeachers.Count; i++) { this.TheTeacher.TimeTeachers[i].Active = false; } foreach (UniversityHoldingTime uht in this.times) { if (this.TheTeacher.TimeTeachers.Where(t => t.UniversityHoldingTime.HoldingTimeID == uht.HoldingTimeID).Count() == 0) { TimeTeacher tt = new TimeTeacher(); tt.Teacher = this.TheTeacher; tt.UniversityHoldingTime = taali.UniversityHoldingTimes.Where(t => t.HoldingTimeID == uht.HoldingTimeID).Single(); tt.Active = true; this.TheTeacher.TimeTeachers.Add(tt); } else { this.TheTeacher.TimeTeachers.Where(t => t.UniversityHoldingTime.HoldingTimeID == uht.HoldingTimeID).First().Active = true; } } } if (this.times != null) { for (int i = 0; i < this.TheTeacher.SubjectTeachers.Count; i++) { this.TheTeacher.SubjectTeachers[i].Active = false; } foreach (Subject s in this.subjects) { if (this.TheTeacher.SubjectTeachers.Where(ss => ss.Subject.SubjectID == s.SubjectID).Count() == 0) { SubjectTeacher st = new SubjectTeacher(); st.Teacher = this.TheTeacher; st.Subject = taali.Subjects.Where(ss => ss.SubjectID == s.SubjectID).Single(); st.Active = true; this.TheTeacher.SubjectTeachers.Add(st); } else { this.TheTeacher.SubjectTeachers.Where(ss => ss.Subject.SubjectID == s.SubjectID).First().Active = true; } } } }
private void BTNDelete_Click(object sender, RoutedEventArgs e) { MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("سوف يتم مسح هذاالعنصر؟", "تأكيد الحذف ", System.Windows.MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { try { SubjectTeacher subjectTeacher = DGPlanShow.SelectedItem as SubjectTeacher; SubjectTeacher subject = (from p in context.SubjectTeachers where p.Id == subjectTeacher.Id select p).Single(); context.SubjectTeachers.Remove(subject); context.SaveChanges(); loadData(); } catch (Exception) { MessageBox.Show("يوجد خطأ تأكد من البيانات و حاول مرة اخري"); } } else { MessageBox.Show("لاتقلق لم تمسح اي بيانات"); } }
public async Task <ActionResult <SubjectTeacher> > AddSubjectTeacher(SubjectTeacher subjectTeacher) { if (ModelState.IsValid) { var ET = await _teacherRepo.AddSubjectTeacher(subjectTeacher); if (ET != null) { return(Ok(ET)); } } return(NotFound()); }
public async Task <Unit> Handle(SubjectTeacherCreateCommand request, CancellationToken cancellationToken) { var subjectTeacher = new SubjectTeacher { SubjectId = request.SubjectId, TeacherId = request.TeacherId }; context.SubjectTeachers.Add(subjectTeacher); await context.SaveChangesAsync(cancellationToken); return(Unit.Value); }
private void BTNEdit_Click(object sender, RoutedEventArgs e) { try { SubjectTeacher subjectTeacher = DGPlanShow.SelectedItem as SubjectTeacher; SubjectTeacher subject = (from p in context.SubjectTeachers where p.Id == subjectTeacher.Id select p).Single(); context.SaveChanges(); loadData(); } catch (Exception) { MessageBox.Show("يوجد خطأ تأكد من البيانات و حاول مرة اخري"); }; }
public JsonResult EditProfile(long TID) { ResultInfo <EditProfileTeacher> ResultInfo = new ResultInfo <EditProfileTeacher>() { Status = false, Description = "Failed|Login" }; SubjectTeacher PageObj = new SubjectTeacher(); ResultInfo.Info = PageObj.EditProfile(TID); if (ResultInfo.Info != null) { ResultInfo.Description = "Success| Get Details "; ResultInfo.Status = true; } return(Json(ResultInfo, JsonRequestBehavior.AllowGet)); }
public ActionResult TeachersEdit(long subject, int year, int school) { // get active teachers var teachers = repository.GetUsers() .Where(x => (x.usergroup == (int)UserGroup.TEACHER || x.usergroup == (int)UserGroup.HEAD) && x.schoolid.HasValue && x.schoolid.Value == school && x.employments.Count != 0 && x.employments.Any(y => y.start_date.HasValue && y.start_date.Value.Year <= year && (!y.end_date.HasValue || y.end_date.Value.Year >= year))) .OrderBy(x => x.name) .Select(x => new IdName() { id = x.id.ToString(), name = x.ToName(false) }); var s = repository.GetSchoolSubject(subject); var viewmodel = new SubjectTeacher(); viewmodel.subjectid = s.id; viewmodel.subjectname = s.name; var subjects = db.subject_teachers.Where(x => x.subjectid == subject); if (!subjects.Any()) { // nothing var subjectentry = new SubjectTeacherEntry(); subjectentry.teachers = teachers.Select(x => new SelectListItem() { Text = x.name, Value = x.id }); subjectentry.classes = db.school_classes .Where(x => x.schoolid == school) .OrderBy(x => x.name) .Select(x => new SelectListItem() { Text = x.name, Value = x.id.ToString() }); viewmodel.teachers.Add(subjectentry); } else { foreach (var teacher in subjects.GroupBy(x => x.user)) { var subjectentry = new SubjectTeacherEntry(); subjectentry.classes = db.school_classes .Where(x => x.schoolid == school) .OrderBy(x => x.name) .Select(x => new SelectListItem() { Text = x.name, Value = x.id.ToString() }); IGrouping <user, subject_teacher> teacher1 = teacher; subjectentry.teachers = teachers.Select(x => new SelectListItem() { Text = x.name, Value = x.id, Selected = x.id == teacher1.Key.id.ToString() }); foreach (var klass in teacher.OrderBy(x => x.school_class.name)) { subjectentry.AllocatedClasses.Add(new IdName(klass.classid, klass.school_class.name)); } viewmodel.teachers.Add(subjectentry); } } return(View(viewmodel)); }
protected override void Seed(MyDatabase context) { // Μain Entities Seeding #region Courses' seeding ========================== Course c1 = new Course() { Title = "BootCamp 1", Description = "C#", Type = Entities.Type.Part_Time, StartDate = new DateTime(2019, 11, 11), EndDate = new DateTime(2020, 06, 11), Fee = 900D }; Course c2 = new Course() { Title = "BootCamp 2", Description = "Java", Type = Entities.Type.Full_Time, StartDate = new DateTime(2019, 11, 11), EndDate = new DateTime(2020, 03, 11), Fee = 900D }; Course c3 = new Course() { Title = "BootCamp 3", Description = "Python", Type = Entities.Type.Full_Time, StartDate = new DateTime(2020, 1, 1), EndDate = new DateTime(2020, 06, 1), Fee = 1500D }; #endregion #region Subjects' seeding ========================== Subject su1 = new Subject() { Title = "HTML & C#", PhotoURL = "#", CourseId = 1 }; Subject su2 = new Subject() { Title = "JS & C#", PhotoURL = "#", CourseId = 1 }; Subject su3 = new Subject() { Title = "C# Architecture", PhotoURL = "#", CourseId = 1 }; Subject su4 = new Subject() { Title = "Java Architecture", PhotoURL = "#", CourseId = 2 }; Subject su5 = new Subject() { Title = "Python Architecture", PhotoURL = "#", CourseId = 3 }; Subject su6 = new Subject() { Title = "HTML & java", PhotoURL = "#", CourseId = 2 }; Subject su7 = new Subject() { Title = "JS & java", PhotoURL = "#", CourseId = 2 }; Subject su8 = new Subject() { Title = "C# Entity", PhotoURL = "#", CourseId = 1 }; Subject su9 = new Subject() { Title = "Java & Algorithms", PhotoURL = "#", CourseId = 2 }; Subject su10 = new Subject() { Title = "C# - MVC", PhotoURL = "#", CourseId = 1 }; Subject su11 = new Subject() { Title = "Java - A full java system", PhotoURL = "#", CourseId = 2 }; Subject su12 = new Subject() { Title = "Python - A full application", PhotoURL = "#", CourseId = 3 }; //////// Subject.Cource=Course; //////su1.Course = c1; //////su2.Course = c1; //////su3.Course = c1; //////su8.Course = c1; //////su10.Course = c1; //////su4.Course = c2; //////su6.Course = c2; //////su7.Course = c2; //////su9.Course = c2; //////su11.Course = c2; //////su5.Course = c3; //////su12.Course = c3; #endregion #region Teachers' seeding ========================== Teacher t1 = new Teacher() { LastName = "Gatsos", FirstName = "Hektor", Email = "*****@*****.**", Salary = 50000, Telephone = "1234567891" }; Teacher t2 = new Teacher() { LastName = "Pasparakis", FirstName = "Giorgos", Email = "*****@*****.**", Salary = 90000, Telephone = "1234567892" }; Teacher t3 = new Teacher() { LastName = "Tzelepidis", FirstName = "Basilis", Email = "*****@*****.**", Salary = 30000, Telephone = "1234567893" }; Teacher t4 = new Teacher() { LastName = "Panou", FirstName = "Panos", Email = "*****@*****.**", Salary = 40000, Telephone = "1234567894" }; Teacher t5 = new Teacher() { LastName = "Minaidis", FirstName = "Georgios", Email = "*****@*****.**", Salary = 45000, Telephone = "1234567895" }; #endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #region SubjectTeachers======================= SubjectTeacher suT1 = new SubjectTeacher() { Subject = su1, Teacher = t1 }; SubjectTeacher suT2 = new SubjectTeacher() { Subject = su2, Teacher = t1 }; SubjectTeacher suT3 = new SubjectTeacher() { Subject = su3, Teacher = t1 }; SubjectTeacher suT8 = new SubjectTeacher() { Subject = su8, Teacher = t1 }; SubjectTeacher suT10 = new SubjectTeacher() { Subject = su10, Teacher = t1 }; t1.SubjectTeachers = new List <SubjectTeacher>() { suT1, suT2, suT3, suT8, suT10 }; SubjectTeacher suT4 = new SubjectTeacher() { Subject = su4, Teacher = t2 }; SubjectTeacher suT6 = new SubjectTeacher() { Subject = su6, Teacher = t2 }; SubjectTeacher suT7 = new SubjectTeacher() { Subject = su7, Teacher = t2 }; SubjectTeacher suT9 = new SubjectTeacher() { Subject = su9, Teacher = t2 }; SubjectTeacher suT11 = new SubjectTeacher() { Subject = su11, Teacher = t2 }; t2.SubjectTeachers = new List <SubjectTeacher>() { suT4, suT6, suT7, suT9, suT11 }; SubjectTeacher suT5 = new SubjectTeacher() { Subject = su5, Teacher = t3 }; SubjectTeacher suT12 = new SubjectTeacher() { Subject = su12, Teacher = t3 }; t3.SubjectTeachers = new List <SubjectTeacher>() { suT5, suT12 }; SubjectTeacher suT13 = new SubjectTeacher() { Subject = su5, Teacher = t4 }; SubjectTeacher suT14 = new SubjectTeacher() { Subject = su12, Teacher = t4 }; t4.SubjectTeachers = new List <SubjectTeacher>() { suT13, suT14 }; SubjectTeacher suT15 = new SubjectTeacher() { Subject = su1, Teacher = t5 }; SubjectTeacher suT16 = new SubjectTeacher() { Subject = su2, Teacher = t5 }; t5.SubjectTeachers = new List <SubjectTeacher>() { suT15, suT16 }; ////su1.Teachers = new List<Teacher>() { t1, t2, t3, t4, t5 }; #endregion #region Students' seeding ========================== Student s1 = new Student() { LastName = "Parisi", FirstName = "Eleni", Email = "*****@*****.**", Telephone = "1234567810" }; Student s2 = new Student() { LastName = "Periklidis", FirstName = "Mixalis", Email = "*****@*****.**", Telephone = "1234567811" }; Student s3 = new Student() { LastName = "Papadopoulos", FirstName = "Vaso", Email = "*****@*****.**", Telephone = "1234567812" }; Student s4 = new Student() { LastName = "Kanellis", FirstName = "Stathis", Email = "*****@*****.**", Telephone = "1234567813" }; Student s5 = new Student() { LastName = "katrakis", FirstName = "Thanos", Email = "*****@*****.**", Telephone = "1234567814" }; Student s6 = new Student() { LastName = "Veggos", FirstName = "Thanasis", Email = "*****@*****.**", Telephone = "1234567815" }; Student s7 = new Student() { LastName = "Papatrexas", FirstName = "Athanasios", Email = "*****@*****.**", Telephone = "1234567816" }; Student s8 = new Student() { LastName = "Elefsiniotis", FirstName = "Giannis", Email = "*****@*****.**", Telephone = "1234567817" }; Student s9 = new Student() { LastName = "Saris", FirstName = "Ioannis", Email = "*****@*****.**", Telephone = "1234567818" }; Student s10 = new Student() { LastName = "Poulakos", FirstName = "Giorgos", Email = "*****@*****.**", Telephone = "1234567819" }; Student s11 = new Student() { LastName = "Vlaxogiannis", FirstName = "Xenofontas", Email = "*****@*****.**", Telephone = "1234567820" }; Student s12 = new Student() { LastName = "Sakarakas", FirstName = "Panagiotis", Email = "*****@*****.**", Telephone = "1234567821" }; Student s13 = new Student() { LastName = "Karowich", FirstName = "Karolos", Email = "*****@*****.**", Telephone = "1234567822" }; Student s14 = new Student() { LastName = "Kuriakou", FirstName = "Adam", Email = "*****@*****.**", Telephone = "1234567823" }; Student s15 = new Student() { LastName = "Papandreou", FirstName = "Albi", Email = "*****@*****.**", Telephone = "1234567824" }; Student s16 = new Student() { LastName = "Perikleoys", FirstName = "Alex", Email = "*****@*****.**", Telephone = "1234567825" }; Student s17 = new Student() { LastName = "Kontodimas", FirstName = "Bagggelis", Email = "*****@*****.**", Telephone = "1234567826" }; Student s18 = new Student() { LastName = "Makrys", FirstName = "Xristos", Email = "*****@*****.**", Telephone = "1234567827" }; Student s19 = new Student() { LastName = "Sxoinas", FirstName = "Dionusis", Email = "*****@*****.**", Telephone = "1234567828" }; Student s20 = new Student() { LastName = "Xatzixristou", FirstName = "Maria", Email = "*****@*****.**", Telephone = "1234567829" }; Student s21 = new Student() { LastName = "Fotiou", FirstName = "Fotis", Email = "*****@*****.**", Telephone = "1234567830" }; Student s22 = new Student() { LastName = "Karampas", FirstName = "Takis", Email = "*****@*****.**", Telephone = "1234567831" }; Student s23 = new Student() { LastName = "Telopoulos", FirstName = "Periklis", Email = "*****@*****.**", Telephone = "1234567832" }; Student s24 = new Student() { LastName = "Katsaros", FirstName = "Kosta", Email = "*****@*****.**", Telephone = "1234567833" }; Student s25 = new Student() { LastName = "Dimitriou", FirstName = "Dimitris", Email = "*****@*****.**", Telephone = "1234567834" }; Student s26 = new Student() { LastName = "Katerinaki", FirstName = "Katerina", Email = "*****@*****.**", Telephone = "1234567835" }; Student s27 = new Student() { LastName = "Sofianou", FirstName = "Sofia", Email = "*****@*****.**", Telephone = "1234567836" }; Student s28 = new Student() { LastName = "Karakosta", FirstName = "Mairi", Email = "*****@*****.**", Telephone = "1234567837" }; Student s29 = new Student() { LastName = "Marikaki", FirstName = "Meni", Email = "*****@*****.**", Telephone = "1234567838" }; Student s30 = new Student() { LastName = "Lyraki", FirstName = "Lina", Email = "*****@*****.**", Telephone = "1234567839" }; #endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #region StudentCourses============================== CourseStudent cs1 = new CourseStudent() { Course = c1, Student = s1, IsFeePayed = true }; CourseStudent cs2 = new CourseStudent() { Course = c1, Student = s2, IsFeePayed = true }; CourseStudent cs3 = new CourseStudent() { Course = c1, Student = s3, IsFeePayed = true }; CourseStudent cs4 = new CourseStudent() { Course = c1, Student = s4, IsFeePayed = true }; CourseStudent cs5 = new CourseStudent() { Course = c1, Student = s5, IsFeePayed = false }; CourseStudent cs6 = new CourseStudent() { Course = c1, Student = s6, IsFeePayed = true }; CourseStudent cs7 = new CourseStudent() { Course = c1, Student = s7, IsFeePayed = false }; CourseStudent cs8 = new CourseStudent() { Course = c1, Student = s8, IsFeePayed = true }; CourseStudent cs9 = new CourseStudent() { Course = c1, Student = s9, IsFeePayed = false }; CourseStudent cs10 = new CourseStudent() { Course = c1, Student = s10, IsFeePayed = false }; CourseStudent cs11 = new CourseStudent() { Course = c1, Student = s11, IsFeePayed = false }; CourseStudent cs12 = new CourseStudent() { Course = c1, Student = s12, IsFeePayed = false }; CourseStudent cs13 = new CourseStudent() { Course = c1, Student = s13, IsFeePayed = true }; CourseStudent cs14 = new CourseStudent() { Course = c1, Student = s14, IsFeePayed = true }; CourseStudent cs15 = new CourseStudent() { Course = c1, Student = s15, IsFeePayed = false }; CourseStudent cs16 = new CourseStudent() { Course = c1, Student = s16, IsFeePayed = true }; CourseStudent cs17 = new CourseStudent() { Course = c1, Student = s17, IsFeePayed = false }; CourseStudent cs18 = new CourseStudent() { Course = c1, Student = s18, IsFeePayed = true }; CourseStudent cs19 = new CourseStudent() { Course = c1, Student = s19, IsFeePayed = false }; CourseStudent cs20 = new CourseStudent() { Course = c1, Student = s20, IsFeePayed = false }; CourseStudent cs21 = new CourseStudent() { Course = c1, Student = s21, IsFeePayed = false }; CourseStudent cs22 = new CourseStudent() { Course = c1, Student = s22, IsFeePayed = false }; CourseStudent cs23 = new CourseStudent() { Course = c1, Student = s23, IsFeePayed = true }; CourseStudent cs24 = new CourseStudent() { Course = c1, Student = s24, IsFeePayed = true }; CourseStudent cs25 = new CourseStudent() { Course = c1, Student = s25, IsFeePayed = false }; CourseStudent cs26 = new CourseStudent() { Course = c1, Student = s26, IsFeePayed = true }; CourseStudent cs27 = new CourseStudent() { Course = c1, Student = s27, IsFeePayed = false }; CourseStudent cs28 = new CourseStudent() { Course = c1, Student = s28, IsFeePayed = true }; CourseStudent cs29 = new CourseStudent() { Course = c1, Student = s29, IsFeePayed = false }; c1.CourseStudents = new List <CourseStudent>() { cs1, cs2, cs3, cs4, cs5, cs6, cs7, cs8, cs9, cs10, cs11, cs12, cs13, cs14, cs15, cs16, cs17, cs18, cs19, cs20, cs21, cs22, cs23, cs24, cs25, cs26, cs27, cs28, cs29 }; CourseStudent cs31 = new CourseStudent() { Course = c2, Student = s2, IsFeePayed = true }; CourseStudent cs32 = new CourseStudent() { Course = c2, Student = s3, IsFeePayed = false }; CourseStudent cs33 = new CourseStudent() { Course = c2, Student = s12, IsFeePayed = true }; CourseStudent cs34 = new CourseStudent() { Course = c2, Student = s13, IsFeePayed = true }; CourseStudent cs35 = new CourseStudent() { Course = c2, Student = s22, IsFeePayed = false }; CourseStudent cs36 = new CourseStudent() { Course = c2, Student = s23, IsFeePayed = true }; c2.CourseStudents = new List <CourseStudent>() { cs31, cs32, cs33, cs34, cs35, cs36 }; CourseStudent cs30 = new CourseStudent() { Course = c3, Student = s9, IsFeePayed = false }; CourseStudent cs37 = new CourseStudent() { Course = c3, Student = s3, IsFeePayed = false }; CourseStudent cs38 = new CourseStudent() { Course = c3, Student = s13, IsFeePayed = true }; CourseStudent cs39 = new CourseStudent() { Course = c3, Student = s23, IsFeePayed = true }; c3.CourseStudents = new List <CourseStudent>() { cs30, cs37, cs38, cs39 }; // s1.Courses = new List<Course>() { c1 }; //s2.Courses = new List<Course>() { c1, c2 }; //s3.Courses = new List<Course>() { c1, c2, c3 }; //s4.Courses = new List<Course>() { c1 }; //s5.Courses = new List<Course>() { c1 }; //s6.Courses = new List<Course>() { c1 }; //s7.Courses = new List<Course>() { c1 }; //s8.Courses = new List<Course>() { c1 }; //s9.Courses = new List<Course>() { c1 }; //s10.Courses = new List<Course>() { c1 }; //s11.Courses = new List<Course>() { c1 }; //s12.Courses = new List<Course>() { c1, c2 }; //s13.Courses = new List<Course>() { c1, c2, c3 }; //s14.Courses = new List<Course>() { c1 }; //s15.Courses = new List<Course>() { c1 }; //s16.Courses = new List<Course>() { c1 }; //s17.Courses = new List<Course>() { c1 }; //s18.Courses = new List<Course>() { c1 }; //s19.Courses = new List<Course>() { c1 }; //s20.Courses = new List<Course>() { c3 }; //s21.Courses = new List<Course>() { c1 }; //s22.Courses = new List<Course>() { c1, c2 }; //s23.Courses = new List<Course>() { c1, c2, c3 }; //s24.Courses = new List<Course>() { c1 }; //s25.Courses = new List<Course>() { c1 }; //s26.Courses = new List<Course>() { c1 }; //s27.Courses = new List<Course>() { c1 }; //s28.Courses = new List<Course>() { c1 }; //s29.Courses = new List<Course>() { c1 }; //s30.Courses = new List<Course>() { c3 }; #endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ //TO BEA ADDED #region Assignments' seeding ========================== //Assignment a1 = new Assignment() { Title = "First C# Assignment", SubDate = new DateTime(2020, 04, 02) }; //Assignment a2 = new Assignment() { Title = "First Java Assignment" }; //Assignment a3 = new Assignment() { Title = "First Python Assignment" }; //Assignment a4 = new Assignment() { Title = "Functionlity to HTML" }; //Assignment a5 = new Assignment() { Title = "Provide Structure to WebSites" }; //Assignment a6 = new Assignment() { Title = "Well presented data with Java" }; //Assignment a7 = new Assignment() { Title = "Java & Javascript" }; //Assignment a8 = new Assignment() { Title = "Entity Assignment" }; //Assignment a9 = new Assignment() { Title = "Assignment - Java & Algorithms" }; //Assignment a10 = new Assignment() { Title = "MVC project" }; //Assignment a11 = new Assignment() { Title = " Java Team Project" }; //Assignment a12 = new Assignment() { Title = "Python - Team Project" }; //a1.Subject = su3; //a2.Subject = su4; #endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #region Marks' seeding ====================== ////Για το assignment 1 (tou c1, s3 pou to exoun oloi oi mathites) //Mark m1 = new Mark() {StudentId = 1, AssignmentMark = 60 }; //Mark m2 = new Mark() {StudentId = 2, AssignmentMark = 61 }; //Mark m3 = new Mark() {StudentId = 3, AssignmentMark = 62 }; //Mark m4 = new Mark() {StudentId = 4, AssignmentMark = 63 }; //Mark m5 = new Mark() {StudentId = 5, AssignmentMark = 64 }; //Mark m6 = new Mark() {StudentId = 6, AssignmentMark = 65 }; //Mark m7 = new Mark() {StudentId = 7, AssignmentMark = 66 }; //Mark m8 = new Mark() {StudentId = 8, AssignmentMark = 67 }; //Mark m9 = new Mark() {StudentId = 9, AssignmentMark = 68 }; //Mark m10 = new Mark() {StudentId = 10 , AssignmentMark = 60 }; //Mark m11 = new Mark() {StudentId = 11 , AssignmentMark = 60 }; //Mark m12 = new Mark() {StudentId = 12 , AssignmentMark = 60 }; //Mark m13 = new Mark() {StudentId = 13 , AssignmentMark = 60 }; //Mark m14 = new Mark() {StudentId = 14 , AssignmentMark = 60 }; //Mark m15 = new Mark() {StudentId = 15 , AssignmentMark = 60 }; //Mark m16 = new Mark() {StudentId = 16 , AssignmentMark = 60 }; //Mark m17 = new Mark() {StudentId = 17 , AssignmentMark = 60 }; //Mark m18 = new Mark() {StudentId = 18 , AssignmentMark = 60 }; //Mark m19 = new Mark() {StudentId = 19 , AssignmentMark = 60 }; //Mark m20 = new Mark() {StudentId = 20 , AssignmentMark = 60 }; //Mark m21 = new Mark() {StudentId = 21 , AssignmentMark = 60 }; //Mark m22 = new Mark() {StudentId = 22 , AssignmentMark = 60 }; //Mark m23 = new Mark() {StudentId = 23 , AssignmentMark = 60 }; //Mark m24 = new Mark() {StudentId = 24 , AssignmentMark = 60 }; //Mark m25 = new Mark() {StudentId = 25 , AssignmentMark = 60 }; //Mark m26 = new Mark() {StudentId = 26 , AssignmentMark = 60 }; //Mark m27 = new Mark() {StudentId = 27 , AssignmentMark = 60 }; //Mark m28 = new Mark() {StudentId = 28 , AssignmentMark = 60 }; //Mark m29 = new Mark() {StudentId = 29 , AssignmentMark = 60 }; //Mark m30 = new Mark() {StudentId = 30 , AssignmentMark = 60 }; ////Για το assignment 2 (tou c2, s4 pou to exoun 6 mathites) //Mark m31 = new Mark() {StudentId = 2, AssignmentMark = 70 }; //Mark m32 = new Mark() {StudentId = 3, AssignmentMark = 71 }; //Mark m33 = new Mark() {StudentId = 12, AssignmentMark = 82 }; //Mark m34 = new Mark() {StudentId = 13, AssignmentMark = 83 }; //Mark m35 = new Mark() {StudentId = 22, AssignmentMark = 84 }; //Mark m36 = new Mark() {StudentId = 23, AssignmentMark = 85 }; ////Για το assignment 3 (tou c3, s5 pou to exoun 3 mathites) //Mark m37 = new Mark() {StudentId = 3, AssignmentMark = 66 }; //Mark m38 = new Mark() {StudentId = 13, AssignmentMark = 67 }; //Mark m39 = new Mark() {StudentId = 23, AssignmentMark = 68 }; ////Για το assignment 4 (tou c1, s2 pou to exoun oloi oi mathites) //Mark m40 = new Mark() {StudentId = 1 , AssignmentMark = 70 }; //Mark m41 = new Mark() {StudentId = 2 , AssignmentMark = 74 }; //Mark m42 = new Mark() {StudentId = 3 , AssignmentMark = 74 }; //Mark m43 = new Mark() {StudentId = 4 , AssignmentMark = 74 }; //Mark m44 = new Mark() {StudentId = 5 , AssignmentMark = 74 }; //Mark m45 = new Mark() {StudentId = 6 , AssignmentMark = 74 }; //Mark m46 = new Mark() {StudentId = 7 , AssignmentMark = 99 }; //Mark m47 = new Mark() {StudentId = 8 , AssignmentMark = 99 }; //Mark m48 = new Mark() {StudentId = 9 , AssignmentMark = 99 }; //Mark m49 = new Mark() {StudentId = 10 , AssignmentMark = 78 }; //Mark m50 = new Mark() {StudentId = 11 , AssignmentMark = 78 }; //Mark m51 = new Mark() {StudentId = 12 , AssignmentMark = 78 }; //Mark m52 = new Mark() {StudentId = 13 , AssignmentMark = 90 }; //Mark m53 = new Mark() {StudentId = 14 , AssignmentMark = 90 }; //Mark m54 = new Mark() {StudentId = 15 , AssignmentMark = 90 }; //Mark m55 = new Mark() {StudentId = 16 , AssignmentMark = 90 }; //Mark m56 = new Mark() {StudentId = 17 , AssignmentMark = 96 }; //Mark m57 = new Mark() {StudentId = 18 , AssignmentMark = 96 }; //Mark m58 = new Mark() {StudentId = 19 , AssignmentMark = 64 }; //Mark m59 = new Mark() {StudentId = 20 , AssignmentMark = 74 }; //Mark m60 = new Mark() {StudentId = 21 , AssignmentMark = 74 }; //Mark m61 = new Mark() {StudentId = 22 , AssignmentMark = 74 }; //Mark m62 = new Mark() {StudentId = 23 , AssignmentMark = 74 }; //Mark m63 = new Mark() {StudentId = 24 , AssignmentMark = 64 }; //Mark m64 = new Mark() {StudentId = 25 , AssignmentMark = 64 }; //Mark m65 = new Mark() {StudentId = 26 , AssignmentMark = 70 }; //Mark m66 = new Mark() {StudentId = 27 , AssignmentMark = 80 }; //Mark m67 = new Mark() {StudentId = 28 , AssignmentMark = 70 }; //Mark m68 = new Mark() {StudentId = 29 , AssignmentMark = 100 }; //Mark m69 = new Mark() {StudentId = 30 , AssignmentMark = 70 }; #endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #region Συσχετισεις============================ ////ASSIGNMENT'S NAVIGATION RELATED PROPERTIES //a1.Marks = new List<Mark>() { m1, m2, m3, m4, m5, m6, m7, m8, m9, m10, m11, m12, m13, m14, m15, m16, m17, m18, m19, m20, m21, m22, m23, m24, m25, m26, m27, m28, m29, m30 }; //a2.Marks = new List<Mark>() { m31, m32, m33, m34, m35, m36 }; //a3.Marks = new List<Mark>() { m37, m38, m39 }; //a4.Marks = new List<Mark>() { m40, m41, m42, m43, m44, m45, m46, m47, m48, m49, m50, m51, m52, m53, m54, m55, m56, m57, m58, m59, m60, m61, m62, m63, m64, m65, m66, m67, m68, m69 }; //// to be continued-----!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1!!!!!!!!!!!!!!!!!!!!! ////a5.Marks = ////a6.Marks = ////a7.Marks = ////a8.Marks = ////a9.Marks = ////a10.Marks = ////a11.Marks = ////a12.Marks = //a1.Subject = su3; //a2.Subject = su4; //a3.Subject = su5; //a4.Subject = su2; //a5.Subject = su1; //a6.Subject = su6; //a7.Subject = su7; //a8.Subject = su8; //a9.Subject = su9; //a10.Subject = su10; //a11.Subject = su11; //a12.Subject = su12; //// Subject.Assignment=Assignment; //su1.Assignment = a5; // su2.Assignment = a4; // su3.Assignment = a1; // su4.Assignment = a2; // su5.Assignment = a3; //su6.Assignment = a6; //su7.Assignment = a7; //su8.Assignment = a8; //su9.Assignment = a9; //su10.Assignment = a10; //su11.Assignment = a11; //su12.Assignment = a12; #endregion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ context.Courses.AddOrUpdate(x => x.Title, c1, c2, c3); context.Subjects.AddOrUpdate(x => x.Title, su1, su2, su3, su4, su5, su6, su7, su8, su9, su10, su11, su12); context.Teachers.AddOrUpdate(x => x.FirstName, t1, t2, t3, t4, t5); context.Students.AddOrUpdate(x => x.LastName, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16, s17, s18, s19, s20, s21, s22, s23, s24, s25, s26, s27, s28, s29, s30); //context.Assignments.AddOrUpdate(x => x.Title, a1); //context.Assignments.AddOrUpdate(x => x.Title, a1, a2, a3, a4, a5, a6, a7, a8, a8, a9, a10, a11, a12); context.SaveChanges(); }