public Group(Teacher teacher, ClassDetails group, Classroom desiredRoom, List<Classroom> alternativeRooms) { this.mTeacher = teacher; this.mGroup = group; this.mDesiredRoom = desiredRoom; this.mRoom = desiredRoom; this.mAlternativeRooms = alternativeRooms; }
public Curriculum(int id, Subject aSubject, Class aClass, ClassDetails aGroup, Teacher aTeacher, int hoursPerWeek) { this.mID = id; this.mSubject = aSubject; this.mClass = aClass; this.mGroup = aGroup; this.mTeacher = aTeacher; this.mHoursPerWeek = hoursPerWeek; this.mHourLenght = Utility.HourLenght.NoMatter; }
private void ImportClasses(ref OleDbConnection connection) { string DetailsSelect = "SELECT [cd].[Class] AS [Class], " + "[cd].Group AS [Group], " + "[cd].[ClassType] AS [ClassTypeID], " + "cd.[BasicClass] AS [BasicClassID], " + "cd.[ClassEdform] AS [EducationFormID]" + "FROM [Class Details] cd"; OleDbCommand DetailsQuery = new OleDbCommand(DetailsSelect, connection); List<ClassDetails> AllDetails = new List<ClassDetails> { }; using (OleDbDataReader DetailsReader = DetailsQuery.ExecuteReader()) { while (DetailsReader.Read()) { ClassDetails d = new ClassDetails(int.Parse(DetailsReader["Class"].ToString()), int.Parse(DetailsReader["Group"].ToString()), this.mTypes.Single(x => x.ID == int.Parse(DetailsReader["ClassTypeID"].ToString())).ShallowCopy(), this.mBasicClasses.Single(x => x.ID == int.Parse(DetailsReader["BasicClassID"].ToString())).ShallowCopy(), this.mEducationForms.Single(x => x.ID == int.Parse(DetailsReader["EducationFormID"].ToString())).ShallowCopy()); AllDetails.Add(d); } } string ClassesSelect = "SELECT [cc].[Class ID] AS [ID], [p].[Paralell class Name] AS [Division], [cc].[Class No] AS [Number] FROM [Code Class] AS [cc] LEFT JOIN [Code Paralell class] AS [p] ON [cc].[Class No] = [p].[Paralell class ID]"; OleDbCommand ClassesQuery = new OleDbCommand(ClassesSelect, connection); using (OleDbDataReader ClassesReader = ClassesQuery.ExecuteReader()) { while (ClassesReader.Read()) { BasicClass bc = this.mBasicClasses.Single(x => x.ID == int.Parse(ClassesReader["Number"].ToString())); int id = int.Parse(ClassesReader["ID"].ToString()); List<ClassDetails> details = AllDetails.Where(x => x.ID == id).ToList(); Class c = new Class(id, ClassesReader["Division"].ToString(), bc); foreach (var item in details) { item.SetDetailed(c); } c.SetDetails(details); c.ShortName = c.Name; this.mClasses.Add(c); } } }