public List <Semesters> getSemesters(int studentId) { using (var db = new NTR2013Entities()) { List <Registrations> list = db.Registrations.Where(r => r.StudentID == studentId).ToList(); List <Semesters> result = new List <Semesters>(); foreach (Registrations r in list) { Realisations realisation = db.Realisations.Find(r.RealisationID); bool semesterFlag = false; foreach (Semesters s in result) { if (s.SemesterID == realisation.SemesterID) { semesterFlag = true; break; } } if (!semesterFlag) { var original = db.Semesters.Find(realisation.SemesterID); result.Add(new Semesters { SemesterID = original.SemesterID, Name = original.Name, TimeStamp = original.TimeStamp, Realisations = null }); } } return(result); } }
public Realisations createRealisation(int subjectId, int semesterId) { using (var db = new NTR2013Entities()) { var realisation = new Realisations { SubjectID = subjectId, SemesterID = semesterId }; db.Realisations.Add(realisation); db.SaveChanges(); return realisation; } }
public Realisations createRealisation(int subjectId, int semesterId) { using (var db = new NTR2013Entities()) { var realisation = new Realisations { SubjectID = subjectId, SemesterID = semesterId }; db.Realisations.Add(realisation); db.SaveChanges(); return(realisation); } }