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 <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 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 <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 <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 labdate AddLabdate(labdate labdate, int id)
{
using (se02team06 context = new se02team06()) {
DbSet <labdate> dbsetLabdate = context.Set <labdate>();
labdate.lab_labID = id;
labdate tmpLabdate = dbsetLabdate.Add(labdate);
context.SaveChanges();
return(tmpLabdate);
}
}
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 void AddStudToLab(student student, lab lab)
{
using (se02team06 context = new se02team06()) {
DbSet <student> dbsetStudent = context.Set <student>();
DbSet <lab> dbsetLab = context.Set <lab>();
var tmpStud = dbsetStudent.Find(student.studentID);
var tmpLab = dbsetLab.Find(lab.labID);
tmpStud.labs.Add(tmpLab);
context.SaveChanges();
}
}
public void AddLecturerToCourse(int lecturerID, int courseID)
{
using (se02team06 context = new se02team06()) {
DbSet <lecturer> dbsetLecturer = context.Set <lecturer>();
DbSet <course> dbsetCourse = context.Set <course>();
var tmpLec = dbsetLecturer.Find(lecturerID);
var tmpCourse = dbsetCourse.Find(courseID);
tmpLec.courses.Add(tmpCourse);
context.SaveChanges();
}
}
public lab AddLab(lab lab, int id)
{
using (se02team06 context = new se02team06()) {
DbSet <lab> dbsetLab = context.Set <lab>();
DbSet <course> dbsetCourse = context.Set <course>();
lab.course_courseID = id;
lab tmplab = dbsetLab.Add(lab);
context.SaveChanges();
return(tmplab);
}
}
public T GetById(int id)
{
using (se02team06 context = new se02team06()) {
try {
DbSet <T> dbset = context.Set <T>();
return(dbset.Find(id));
} catch (Exception e) {
Console.WriteLine(e);
return(default(T));
}
}
}
public List <T> AddMany(List <T> entityList)
{
using (se02team06 context = new se02team06()) {
DbSet <T> dbset2 = context.Set <T>();
foreach (T item in entityList)
{
dbset2.Add(item);
}
context.SaveChanges();
return(entityList);
}
}
public void Remove(int id)
{
using (se02team06 context = new se02team06()) {
try {
DbSet <T> dbset = context.Set <T>();
dbset.Remove(dbset.Find(id));
context.SaveChanges();
} catch (ArgumentNullException e) {
Console.WriteLine("object with this id does not exist", e);
} catch (Exception e) {
Console.WriteLine(e);
}
}
}
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);
}
}
}
public void RemoveAll()
{
using (se02team06 context = new se02team06()) {
try {
DbSet <T> dbset = context.Set <T>();
List <T> entityList = GetAll();
foreach (var item in entityList)
{
dbset.Attach(item);
dbset.Remove(item);
}
context.SaveChanges();
} catch (Exception e) {
Console.WriteLine("{0}Exception", e);
}
}
}
public void setIncrementBack(string table, int incNum)
{
using (se02team06 context = new se02team06()) {
context.Database.ExecuteSqlCommand($"ALTER TABLE {table} AUTO_INCREMENT = {incNum}");
}
}
public List <T> GetAll()
{
using (se02team06 context = new se02team06()) {
return(context.Set <T>().ToList());
}
}
