public static List <TStudentCourse> LoadData(int StudentID, TCourse course, out string error)
{
List <TStudentCourse> StudentCourses = new List <TStudentCourse>();
List <TSubject> Subjects = new List <TSubject>();
error = string.Empty;
try
{
using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring))
{
StudentCourses = (from sc in db.StudentCourses where sc.StudentsID == StudentID select new TStudentCourse(sc)).ToList();
Subjects = (from s in db.Subjects where s.CompulsoryDiscipline == false select new TSubject(s)).ToList();
var ls = Subjects.Where(i => StudentCourses.Where(p => p.SubjectsID == i.ID).Count() == 0).ToList();
var subjCourse = db.SubjectCourses.Where(i => i.CourseiD == course.ID).ToList();
ls = ls.Where(i => subjCourse.Select(p => p.SubjectID).Contains(i.ID)).ToList();
var specialities = db.SubjectSpecialities.Where(i => ls.Select(k => k.ID).Contains(i.SubjectID)).ToList();
var studSpecs = db.StudentSpecialities.Where(i => i.CourseID == course.ID).ToList();
foreach (var l in ls)
{
var s = new TStudentCourse(l, course);
StudentCourses.Add(s);
}
}
}
catch (Exception ex)
{
error = ex.Message;
}
return(StudentCourses);
}
public TStudentCourse(TSubject s, TCourse stc)
{
this.Subject = s;
this.Course = stc;
this.Selected = false;
}