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 - - - - -"); }