public void CreateNewHelpRequestAssignment(DabDBContext db)
{
var student = db.Set <StudentEntity>().ToList();
int i = 0;
foreach (var x in student)
{
Console.WriteLine(
" Nr:" + i + "\n" +
" Student ID " + x.AuId + "\n" +
" Student Name: " + x.Name);
i++;
}
Console.WriteLine("Type Nr of the user to request help:");
int id = Convert.ToInt32(Console.ReadLine());
var shadow = db.Set <AssignmentStudentEntity>().ToList();
var assignment = db.Set <AssignmentEntity>().ToList();
i = 0;
foreach (var x in assignment)
{
Console.WriteLine(
" Nr:" + i + "\n" +
" Exercise Id: " + x.AssignmentId);
i++;
}
Console.WriteLine("Type Nr of the exercise you want help with:");
int assId = Convert.ToInt32(Console.ReadLine());
shadow[assId].NeedHelp = true;
}
public void CreateNewHelpRequestExercise(DabDBContext db)
{
var student = db.Set <StudentEntity>().ToList();
int i = 0;
foreach (var x in student)
{
Console.WriteLine(
" Nr: " + i +
" Student ID " + x.AuId +
" Student Name: " + x.Name);
i++;
}
Console.WriteLine("Type Nr of the user to request help:");
int id = Convert.ToInt32(Console.ReadLine());
var exercise = db.Set <ExerciseEntity>().ToList();
i = 0;
foreach (var x in exercise)
{
Console.WriteLine(
" Nr:" + i +
" Exercise Name: " + x.Lecture);
i++;
}
Console.WriteLine("Type Nr of the exercise you want help with:");
int exeid = Convert.ToInt32(Console.ReadLine());
exercise[exeid].Student.Name = student[id].Name;
Console.WriteLine("Write where you want help:");
exercise[exeid].HelpWhere = Console.ReadLine();
}
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);
}
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();
}
public Views(DabDBContext db)
{
_db = db;
StudentEntity student = new StudentEntity();
}
public void CreateDataHandler(DabDBContext db)
{
bool leave = false;
while (!leave)
{
Console.WriteLine("Press a key to create different objects");
Console.WriteLine("1 for student, 2 for teacher");
Console.WriteLine("3 for Exercise, 4 for Assignment, 5 for Course");
Console.WriteLine("6 for help with exercise, 7 for help with assignment");
Console.WriteLine("Any other key to go back");
Console.WriteLine("----------------------------------------------------------------------------------------");
var input = Console.ReadLine();
switch (input)
{
case "1":
CreateNewStudent(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
case "2":
CreateNewTeacher(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
case "3":
CreateNewExecersise(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
case "4":
CreateNewAssignment(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
case "5":
CreateNewCourse(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
case "6":
CreateNewHelpRequestExercise(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
case "7":
CreateNewHelpRequestAssignment(db);
Console.Clear();
Console.WriteLine("Created!");
Console.WriteLine("----------------------------------------------------------------------------------------");
break;
default:
leave = true;
break;
}
}
}