public List <Faculty> GetFaculties(string name) { List <Faculty> faculties = new List <Faculty>(); List <Student> students = new List <Student>(); Faculty faculty = new Faculty(); Dean dean = new Dean(); Adress adress = new Adress(); IEnumerable <DBOFaculty> items = from n in xdoc.Root.Element("departments").Element("faculties").Elements("faculty") where Int32.Parse(n.Element("universityID").Value) == GetDBOUniversityId(name).Id select new DBOFaculty { AdressId = Int32.Parse(n.Element("adressID").Value), Id = Int32.Parse(n.Element("ID").Value), Name = n.Element("name").Value }; foreach (DBOFaculty item in items) { dean = GetDean(item.Id); students = GetStudents(item.Id); adress = GetAdressById(item.AdressId); faculty = new Faculty { Adress = adress, Name = item.Name, Dean = dean }; foreach (Student student in students) { faculty.AddStudent(student); } faculties.Add(faculty); } return(faculties); }
public List <University> GetUniversities() { List <University> universities = new List <University>(); foreach (DBUniversity univ in dbUn) { University university = new University(univ.NameUniversity, GetAdressesByID(int.Parse(univ.AdressID)), GetRector(univ.NameUniversity)); foreach (DBFaculty fc in GetFacultiesByUniversityID(int.Parse(univ.UnID))) { Faculty fac = new Faculty(fc.NameDepartament, GetAdressesByID(fc.AdressID), fc.UniversityName, GetDekanByFacultyID(fc.FacultyID)); foreach (Student st in GetStudentsByFacultyID(fc.FacultyID.ToString())) { fac.AddStudent(st); } university.AddDepartament(fac); } universities.Add(university); } return(universities); }
public List <Faculty> GetFaculties(string nameUniversity) { List <Faculty> faculties = new List <Faculty>(); foreach (DBFaculty facult in GetFacultiesByUniversityID(int.Parse(GetUniversityID(nameUniversity)))) { Faculty faculty = new Faculty(facult.NameDepartament, GetAdressesByID(facult.AdressID), facult.UniversityName, GetDekanByFacultyID(facult.FacultyID)); foreach (Student st in GetStudentsByFacultyID(facult.FacultyID.ToString())) { faculty.AddStudent(st); } faculties.Add(faculty); } return(faculties); }
private List <Faculty> GetFaculties() { List <Faculty> faculties = new List <Faculty>(); foreach (DBFaculty facult in dbFc) { Faculty faculty = new Faculty(facult.NameDepartament, GetAdressesByID(facult.AdressID), facult.UniversityName, GetDekanByFacultyID(facult.FacultyID)); foreach (Student st in GetStudentsByFacultyID(facult.FacultyID.ToString())) { faculty.AddStudent(st); } faculties.Add(faculty); } return(faculties); }
public List <Faculty> GetFaculties(string name) { List <DBOFaculty> listDBOfaculty = GetDBOFaculty(name); List <Faculty> faculties = new List <Faculty>(); Faculty faculty; foreach (DBOFaculty element in listDBOfaculty) { Address address = GetAddress(element.AdressID); Dean dean = GetDean(element.FacultyID); faculty = new Faculty(address, element.Name, dean); List <Student> students = GetStudents(element.FacultyID); foreach (Student student in students) { faculty.AddStudent(student); } faculties.Add(faculty); } return(faculties); }