public void CreateNewCourse(DabDBContext db) { CourseEntity course = new CourseEntity(); Console.WriteLine("Write name of course:"); course.Name = Console.ReadLine(); db.Add(course); }
public void CreateNewAssignment(DabDBContext db) { AssignmentEntity assignment = new AssignmentEntity(); Console.WriteLine("Write Nr of the Asssignment:"); assignment.AssignmentId = Convert.ToInt32(Console.ReadLine()); db.Add(assignment); }
public void CreateNewTeacher(DabDBContext db) { TeacherEntity teacher = new TeacherEntity(); Console.WriteLine("Write teacher name:"); teacher.Name = Console.ReadLine(); db.Add(teacher); }
public void CreateNewStudent(DabDBContext db) { StudentEntity student = new StudentEntity(); Console.WriteLine("Write student name:"); student.Name = Console.ReadLine(); db.Add(student); }
public void CreateNewExecersise(DabDBContext db) { ExerciseEntity exercise = new ExerciseEntity(); Console.WriteLine("Write Nr of the exercise:"); exercise.Number = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Write name of lecture"); exercise.Lecture = Console.ReadLine(); db.Add(exercise); }
public void InsertDummyData() { using var db = new DabDBContext(); TeacherEntity teacher1 = new TeacherEntity(); teacher1.Name = "Henrik Kirk"; db.Add(teacher1); TeacherEntity teacher2 = new TeacherEntity(); teacher2.Name = "S�ren"; db.Add(teacher2); TeacherEntity teacher3 = new TeacherEntity(); teacher3.Name = "Michael"; db.Add(teacher3); TeacherEntity teacher4 = new TeacherEntity(); teacher4.Name = "Lars"; db.Add(teacher4); StudentEntity student1 = new StudentEntity(); student1.Name = "Sebastian"; db.Add(student1); StudentEntity student2 = new StudentEntity(); student2.Name = "Tobias"; db.Add(student2); StudentEntity student0 = new StudentEntity(); student0.Name = "Gustav"; db.Add(student0); AssignmentEntity assignment1 = new AssignmentEntity(); assignment1.Teacher = teacher2; db.Add(assignment1); AssignmentEntity assignment2 = new AssignmentEntity(); assignment2.Teacher = teacher2; db.Add(assignment2); AssignmentEntity assignment3 = new AssignmentEntity(); assignment3.Teacher = teacher3; db.Add(assignment3); CourseEntity course = new CourseEntity() { Name = "Databaser", Assignments = new List <AssignmentEntity> { new AssignmentEntity { Teacher = teacher1 }, assignment1, assignment2 }, Teachers = new List <TeacherEntity>() { teacher1, teacher2 } }; CourseEntity course3 = new CourseEntity() { Name = "MMLS", Assignments = new List <AssignmentEntity> { new AssignmentEntity { Teacher = teacher3 } }, Teachers = new List <TeacherEntity>() { teacher4 } }; db.Add(course3); CourseEntity course2 = new CourseEntity() { Name = "SWD", Assignments = new List <AssignmentEntity> { new AssignmentEntity { Teacher = teacher1 }, assignment3 }, Teachers = new List <TeacherEntity>() { teacher3 } }; db.Add(course2); ExerciseEntity exercise1 = new ExerciseEntity(); exercise1.Number = 2; exercise1.Lecture = "3 EF core"; exercise1.Teacher = teacher1; exercise1.Student = student1; exercise1.HelpWhere = "Ex 3.1"; exercise1.Course = course; db.Add(exercise1); ExerciseEntity exercise2 = new ExerciseEntity(); exercise2.Number = 5; exercise2.Lecture = "5 EF core"; exercise2.Teacher = teacher1; exercise2.Student = student1; exercise2.HelpWhere = "Side 2"; exercise2.Course = course; db.Add(exercise2); ExerciseEntity exercise3 = new ExerciseEntity(); exercise3.Number = 1; exercise3.Lecture = "Design patterns"; exercise3.Teacher = teacher3; exercise3.Student = student0; exercise3.HelpWhere = "Det hele"; exercise3.Course = course2; db.Add(exercise3); ExerciseEntity exercise4 = new ExerciseEntity(); exercise4.Number = 4; exercise4.Lecture = "Functional Programming"; exercise4.Teacher = teacher1; exercise4.Student = student0; exercise4.Course = course2; db.Add(exercise4); ExerciseEntity exercise5 = new ExerciseEntity(); exercise5.Number = 5; exercise5.Lecture = "Some math"; exercise5.Teacher = teacher4; exercise5.Student = student2; exercise5.Course = course3; db.Add(exercise5); StudentCourseEntity joinedStudCourse = new StudentCourseEntity() { Students = student0, Courses = course, }; db.Add(joinedStudCourse); joinedStudCourse = new StudentCourseEntity() { Students = student1, Courses = course, }; db.Add(joinedStudCourse); joinedStudCourse = new StudentCourseEntity() { Students = student2, Courses = course, }; var testAss = new AssignmentStudentEntity() { Students = student0, Assignments = assignment1, }; db.Add(joinedStudCourse); db.SaveChanges(); }