private void FillPresent()
{
List <student> studentList = studDbSet.GetAll();
List <labdate> studsLabdatesOfLab = new List <labdate>();
List <labdate> dates = labdatesDbSet.GetAll();
studentList.ForEach(student => {
var index = studentList.IndexOf(student);
labsDbset.GetLabsOfStudent(student.studentID).ForEach(lab => {
studsLabdatesOfLab = dates.Where(l => l.lab_labID == lab.labID).ToList();
});
foreach (var i in studsLabdatesOfLab)
{
present pre = new present {
labdate_labdateID = i.labdateID,
student_studentID = studentList[index].studentID,
note = "war hier",
wasPresent = 0
};
presentDbSet.AddOne(pre);
Console.WriteLine($"student {studentList[index].firstName} has Labdate {i.date}");
}
});
Console.WriteLine("- - - - - - - Finished - - - - -");
}
private void FillTaskDone()
{
List <task> alltasksList = taskDbSet.GetAll();
List <student> studentsList = studDbSet.GetAll();
studentsList.ForEach(student => {
studDbSet.GetLabsOfStudent(student.studentID).ForEach(lab => {
alltasksList.Where(s => s.lab_labID == lab.labID).ToList().ForEach(task => {
taskdone taskDone = new taskdone {
isDone = 1,
student_studentID = student.studentID,
task_taskID = task.taskID
};
taskDoneDbSet.AddOne(taskDone);
});
});
});
}
private void FillTaskDone()
{
List <task> alltasksList = taskDbSet.GetAll();
List <student> studentsList = studDbSet.GetAll();
studentsList.ForEach(student => {
studDbSet.GetLabsOfStudent(student.studentID).ForEach(lab => {
alltasksList.Where(s => s.lab_labID == lab.labID).ToList().ForEach(task => {
taskdone taskDone = new taskdone {
isDone = 1,
student_studentID = student.studentID,
task_taskID = task.taskID
};
taskDoneDbSet.AddOne(taskDone);
Console.WriteLine($"Student {student.firstName} has Lab { lab.labID} and tasks {task.taskNumber}");
});
});
});
Console.WriteLine("- - - - - - - Finished - - - - -");
}
