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 fillLabdates()
{
List <lab> labsList = labsDbset.GetAll();
labsList.ForEach(labs => {
DateTime tmpDate = new DateTime(2020, 05, 15, 15, 00, 00);
labDateCount.ForEach(labDate => {
labdate tmpLabdate = new labdate {
date = tmpDate
};
labsDbset.AddLabdate(tmpLabdate, labsList.IndexOf(labs) + 1);
tmpDate = tmpDate.AddDays(7);
});
});
}
private void fillLabdates()
{
List <lab> labsList = labsDbset.GetAll();
labsList.ForEach(labs => {
DateTime tmpDate = new DateTime(2020, 05, 15, 15, 00, 00);
labDateCount.ForEach(labDate => {
labdate tmpLabdate = new labdate {
date = tmpDate
};
labsDbset.AddLabdate(tmpLabdate, labsList.IndexOf(labs) + 1);
tmpDate = tmpDate.AddDays(7);
Console.WriteLine($"fill Lab {labsList.IndexOf(labs) + 1} with labdate {tmpDate}");
});
});
Console.WriteLine("- - - - - - - Finished - - - - -");
}
public ObservableCollection <Course> GetAllCourses()
{
ObservableCollection <Course> AllCourses = new ObservableCollection <Course>();
List <course> tempList = CourseContext.GetAll();
foreach (course course in tempList)
{
AllCourses.Add(ConvertCourse(course));
}
return(AllCourses);
}
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 - - - - -");
}
