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