static void Main(string[] args)
{
var c = new CreateData();
var db = new DabDBContext();
var a = new DummyData();
var v = new Views(db);
bool loop = true;
Console.WriteLine("----------------------------------------------------------------------------------------");
Console.WriteLine("Welcome to DabAflevering, for investigating the database use the following commands:");
Console.WriteLine("----------------------------------------------------------------------------------------");
while (loop == true)
{
Console.WriteLine("Press 1 to view data");
Console.WriteLine("Press 2 To add Dummy Data");
Console.WriteLine("Press 3 to create new data");
Console.WriteLine("Press 4 to exit program");
Console.WriteLine("----------------------------------------------------------------------------------------");
var input = Console.ReadLine();
switch (input)
{
case "1":
v.ViewsSwitcher();
Console.Clear();
break;
case "2":
Console.Clear();
a.InsertDummyData();
break;
case "3":
c.CreateDataHandler(db);
db.SaveChanges();
Console.Clear();
break;
case "4":
Console.WriteLine("----------------------------------------------------------------------------------------");
Console.WriteLine("Bye bye!");
Console.WriteLine("----------------------------------------------------------------------------------------");
loop = false;
break;
}
}
}
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();
}