public task GetTaskOfTaskDone(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <taskdone> dbsetTaskDone = context.Set <taskdone>();
var tD = dbsetTaskDone.Find(id);
context.Entry(tD).Reference(s => s.task).Load();
context.SaveChanges();
return(tD.task);
}
}
public lab GetLabOfTask(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <task> dbsetTask = context.Set <task>();
var task = dbsetTask.Find(id);
context.Entry(task).Reference(s => s.lab).Load();
context.SaveChanges();
return(task.lab);
}
}
public List <taskdone> GetTaskDonesOfTask(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <task> dbsetTask = context.Set <task>();
var task = dbsetTask.Find(id);
context.Entry(task).Collection(s => s.taskdones).Load();
context.SaveChanges();
return(task.taskdones.ToList());
}
}
public labdate GetLabdateOfPresent(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <present> dbsetPresent = context.Set <present>();
present presentTmp = dbsetPresent.Find(id);
context.Entry(presentTmp).Reference(s => s.labdate).Load();
context.SaveChanges();
return(presentTmp.labdate);
}
}
public student GetStudentOfPresent(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <present> dbsetPresent = context.Set <present>();
present presentTmp = dbsetPresent.Find(id);
context.Entry(presentTmp).Reference(s => s.student).Load();
context.SaveChanges();
return(presentTmp.student);
}
}
public List <present> GetPresentsOfLabdate(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <labdate> dbsetLabdate = context.Set <labdate>();
labdate labdateTmp = dbsetLabdate.Find(id);
context.Entry(labdateTmp).Collection(s => s.presents).Load();
context.SaveChanges();
return(labdateTmp.presents.ToList());
}
}
public List <present> GetPresentsOfStudent(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <student> dbset = context.Set <student>();
var model = dbset.Find(id);
context.Entry(model).Collection(s => s.presents).Load();
context.SaveChanges();
return(model.presents.ToList());
}
}
public lab GetLabOfLabdate(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <labdate> dbsetLabdate = context.Set <labdate>();
labdate labdateTmp = dbsetLabdate.Find(id);
context.Entry(labdateTmp).Reference(s => s.lab).Load();
context.SaveChanges();
return(labdateTmp.lab);
}
}
public List <student> GetStudentsOfLab(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <lab> dbsetLab = context.Set <lab>();
lab labTmp = dbsetLab.Find(id);
context.Entry(labTmp).Collection(s => s.students).Load();
context.SaveChanges();
return(labTmp.students.ToList());
}
}
public course GetCourseOfLab(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <lab> dbsetLab = context.Set <lab>();
lab labTmp = dbsetLab.Find(id);
context.Entry(labTmp).Reference(s => s.course).Load();
context.SaveChanges();
return(labTmp.course);
}
}
public List <course> GetCoursesOfLectruer(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <lecturer> dbsetLectruer = context.Set <lecturer>();
lecturer lecturerTmp = dbsetLectruer.Find(id);
context.Entry(lecturerTmp).Collection(s => s.courses).Load(); // loads Courses collection
context.SaveChanges();
return(lecturerTmp.courses.ToList());
}
}
public List <lecturer> GetLecturerOfCourse(int id)
{
using (se02team06 context = new se02team06()) {
DbSet <course> dbsetCourse = context.Set <course>();
course courseTmp = dbsetCourse.Find(id);
context.Entry(courseTmp).Collection(s => s.lecturers).Load();
context.SaveChanges();
return(courseTmp.lecturers.ToList());
}
}
public void Update(int id, T entry)
{
using (se02team06 context = new se02team06()) {
try {
DbSet <T> dbset = context.Set <T>();
var old = dbset.Find(id);
context.Entry(old).CurrentValues.SetValues(entry);
context.SaveChanges();
} catch (DbUpdateException e) {
Console.WriteLine("object with this id does not exist", e);
} catch (Exception e) {
Console.WriteLine(e);
}
}
}