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