public List <object> GetGroupsForParentSubgroup(Subgroup parentSubgroup) { var groups = from group_1 in context.Group where group_1.SUBGROUP_ID == parentSubgroup.ID select group_1; return(groups.ToList <object>()); }
public List <SubjectDefinition> GetSubjectsForYear(Subgroup subgroup) { var subjects = from subject in context.SubjectDefinition where subject.MAJOR_ID == subgroup.MAJOR_ID && subject.YEAR_OF_STUDY == subgroup.YEAR_OF_STUDY select subject; return(subjects.ToList()); }
public List <SubjectDefinition> GetSubjectsForYearIncludingSemesterType(Subgroup subgroup) { int semesterTypeDvId = (int)semesterBehavior.GetActiveSemester().SEMESTER_TYPE_DV_ID; var subjects = from subject in context.SubjectDefinition where subject.MAJOR_ID == subgroup.MAJOR_ID && subject.YEAR_OF_STUDY == subgroup.YEAR_OF_STUDY && subject.SEMESTER_TYPE_DV_ID == semesterTypeDvId select subject; return(subjects.ToList()); }
public List <Subgroup> GetSubgroupsForParentSubgroup(Subgroup parentSubgroup) { int activeSemesterID = new Semester(context).GetActiveSemester().ID; var subgroups = from subgroup in context.Subgroup where subgroup.MAJOR_ID == parentSubgroup.MAJOR_ID && subgroup.SEMESTER_ID == activeSemesterID && subgroup.SUBGROUP_ID == parentSubgroup.ID select subgroup; return(subgroups.ToList()); }
public TreeViewData(serverDBEntities context, Department department) { this.context = context; majorBehavior = new Major(context); subgroupBehavior = new Subgroup(context); groupBehavior = new Group(context); departmentBehavior = new Department(context); locationBehavior = new Location(context); roomBehavior = new Room(context); initializeGroupList(department); }
public List <Classes> GetListForSubgroup_S2(Subgroup subgroup, Week week) { var oddClassesList = from classes in context.Classes join classesGroup in context.ClassesGroup on classes.ID equals classesGroup.Classes_ID join classesWeek in context.ClassesWeek on classes.ID equals classesWeek.Classes_ID join group_g in context.Group on classesGroup.Group_ID equals group_g.ID join subgroup_s1 in context.Subgroup on group_g.SUBGROUP_ID equals subgroup_s1.ID where subgroup_s1.ID == subgroup.ID && /*(classes.CLASSESS_TYPE_DV_ID == 42 || classes.CLASSESS_TYPE_DV_ID == 43)*/ (classes.SCOPE_LEVEL == (int)SchedulerGroupType.SUBGROUP_S1 || classes.SCOPE_LEVEL == (int)SchedulerGroupType.SUBGROUP_S2) && // wykład lub ćwiczenia classesWeek.Week_ID == week.ID select new ClassesWithClassesGroup_ClassesId { Classes = classes, ClassesGroup_ClassesId = classesGroup.Classes_ID }; List <Classes> classesList = GetDistinctClassesForSubgroup(oddClassesList.ToList()); return(classesList); }
public Major(serverDBEntities context) { this.context = context; subgroupBehavior = new Subgroup(context); }
public Semester(serverDBEntities context) { this.context = context; this.subgroupBehavior = new Subgroup(context); }