public AddCourseView()
{
InitializeComponent();
Teachers = new ObservableCollection <Teacher>(VirtualCollegeContext.GetAllTeachers());
}
public MainWindow()
{
InitializeComponent();
displayGrades.Text = "";
using (var myDB = new VirtualCollegeContext())
{
var addresses = myDB.Addresses.ToList();
var studs = myDB.Users.OfType <Student>().ToList();
var teachers = myDB.Users.OfType <Teacher>().ToList();
var courses = myDB.Courses.ToList();
var lessons = myDB.Lessons.ToList();
#region Students
//var premierEleve = new Student()
//{
// FirstName = "Maxime",
// LastName = "Dennery",
// Gender = "Male",
// BirthDate = new DateTime(2000, 3, 6),
// Address = addresses.Find(a => a.AddressId == 1),
// EmailAddress = "*****@*****.**",
// Fees = 10800,
// Password = "******"
//};
//studs.Add(premierEleve);
//var secondEleve = new Student()
//{
// FirstName = "Christophe",
// LastName = "Nguyen",
// Gender = "Male",
// BirthDate = new DateTime(2000, 12, 10),
// Address = addresses.Find(a => a.AddressId == 6),
// EmailAddress = "*****@*****.**",
// Fees = 10800,
// Password = "******"
//};
//studs.Add(secondEleve);
//var troisisemeEleve = new Student()
//{
// FirstName = "Gwen",
// LastName = "Marek",
// Gender = "Female",
// BirthDate = new DateTime(2005, 1, 5),
// Address = addresses.Find(a => a.AddressId == 3),
// EmailAddress = "*****@*****.**",
// Fees = 10800,
// Password = "******"
//};
//studs.Add(troisisemeEleve);
//var quatriemeEleve = new Student()
//{
// FirstName = "Rémi",
// LastName = "Lombard",
// Gender = "Male",
// BirthDate = new DateTime(2000, 4, 17),
// Address = addresses.Find(a => a.AddressId == 1),
// EmailAddress = "*****@*****.**",
// Fees = 10800,
// Password = "******"
//};
//studs.Add(quatriemeEleve);
//myDB.Users.AddRange(studs);
#endregion
#region Teachers
//var firstProf = new Teacher()
//{
// FirstName = "Walter",
// LastName = "perreti",
// Gender = "Male",
// BirthDate = new DateTime(1972, 01, 10),
// Address = addresses.Find(a => a.AddressId == 2),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//teachers.Add(firstProf);
//var secondPorf = new Teacher()
//{
// FirstName = "Olivier",
// LastName = "Zanette",
// Gender = "Male",
// BirthDate = new DateTime(1977, 01, 10),
// Address = addresses.Find(a => a.AddressId == 3),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//teachers.Add(secondPorf);
//var terreur = new Teacher()
//{
// FirstName = "Noémie",
// LastName = "Thaï",
// Gender = "Female",
// BirthDate = new DateTime(1988, 7, 14),
// Address = addresses.Find(a => a.AddressId == 5),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//teachers.Add(terreur);
//myDB.Users.AddRange(teachers);
#endregion
#region Admins
//var superAdmin = new Administrator()
//{
// FirstName = "Pascal",
// LastName = "Brouaye",
// Gender = "Male",
// BirthDate = new DateTime(1972, 01, 10),
// Address = addresses.Find(a => a.AddressId == 6),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//myDB.Users.Add(superAdmin);
#endregion
#region Courses
//var maths = new Course()
//{
// Title = "Mathematics",
// Credits = 30,
// ReferentTeacher = teachers.FirstOrDefault(t => t.LastName == "Thaï")
//};
//courses.Add(maths);
//var meca = new Course()
//{
// Title = "Mecatronnics",
// Credits = 15,
// ReferentTeacher = teachers.FirstOrDefault(t => t.LastName.Contains("reti"))
//};
//courses.Add(meca);
//var elec = new Course()
//{
// Title = "Electricity",
// Credits = 30,
// ReferentTeacher = teachers.FirstOrDefault(t => t.LastName == "Zanette")
//};
//courses.Add(elec);
//courses.Find(c => c.Title == "Mecatronnics").Teachers = new List<Teacher>() { teachers.Find(t => t.LastName == "Zanette" || t.LastName.Contains("rreti")) };
//courses.Find(c => c.Title == "Electricity").Teachers = new List<Teacher>() { teachers.Find(t => t.LastName == "Zanette" || t.LastName.Contains("rreti")) };
//courses.Find(c => c.Title == "Mathematics").Teachers = new List<Teacher>() { teachers.Find(t => t.LastName == "Thaï") };
//myDB.Courses.AddRange(courses);
#endregion
#region Lessons
//var firstLesson = new Lesson()
//{
// Course = courses.FirstOrDefault(c => c.Title == "Electricity"),
// Day = "Tuesday",
// Hour = "08:15",
// Duration = "03:00",
// RoomName = "L309",
// Teacher = courses.FirstOrDefault(c => c.Title == "Electricity").Teachers.FirstOrDefault(t => t.LastName == "Zanette")
//};
//firstLesson.Students.Add(studs.FirstOrDefault(s => s.FirstName == "Gwen"));
//firstLesson.EnrollStudent(studs.FirstOrDefault(s=>s.FirstName=="Christophe")); // Enrolls l'élève qui s'appelle Christophe
//foreach (var s in studs.FindAll(s => s.Address == addresses.Find(a => a.Country == "Colombia"))) myDB.Lessons.FirstOrDefault(l => l.Day == "Tuesday").Students.Add(s);
//myDB.Lessons.Add(firstLesson);
#endregion
#region Grades
var grades = new List <Grade>();
var firstGrade = new Grade()
{
Course = courses.Find(c => c.Title == "Mathematics"),
Coefficient = 1,
ExamName = "CC1",
Mark = 60,
Student = myDB.Users.OfType <Student>().FirstOrDefault(s => s.FirstName == "Rémi")
};
grades.Add(firstGrade);
var secondGrade = new Grade()
{
Course = courses.Find(c => c.Title == "Mecatronnics"),
Coefficient = 2,
ExamName = "Online quizz #1",
Mark = 92.75m,
Student = myDB.Users.OfType <Student>().FirstOrDefault(s => s.FirstName == "Christophe")
};
grades.Add(secondGrade);
var thirdGrade = new Grade()
{
Course = courses.Find(c => c.Title == "Mecatronnics"),
Coefficient = 2,
ExamName = "Online quizz #1",
Mark = 12.25m,
Student = myDB.Users.OfType <Student>().FirstOrDefault(s => s.FirstName == "Maxime")
};
grades.Add(thirdGrade);
myDB.Grades.AddRange(grades);
#endregion
myDB.SaveChanges();
var u = myDB.Users.OfType <Student>().ToList().FindAll(s => s.Grades.Count != 0);
foreach (var p in u)
{
displayGrades.Text += p.GradesInfo + "\n\n";
}
//foreach (var s in myDB.Users.OfType<Student>().ToList().FindAll(s => s.Grades != null)) displayGrades.Text += s.GradesInfo;
}
}
private void deleteCourseButton_Click(object sender, RoutedEventArgs e)
{
VirtualCollegeContext.RemoveCourse(SelectedCourse);
Courses = new ObservableCollection <Course>(VirtualCollegeContext.GetAllCourses());
}
private void addGradeButton_Click(object sender, RoutedEventArgs e)
{
new AddGradeView(SelectedCourse).ShowDialog();
Grades = new ObservableCollection <Grade>(VirtualCollegeContext.GetAllGrades(SelectedCourse));
}
private void GetCoursesThatMatch(string _searchBoxValue) // Not implemented yet
{
Courses = new ObservableCollection <Course>(VirtualCollegeContext.GetAllCoursesThatMatchTitle(_searchBoxValue));
}
private void allGradesOfCourse_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
new EditGradeView(SelectedGrade).ShowDialog();
VirtualCollegeContext.UpdateGrade(SelectedGrade);
}
private void GetStudentsThatMatch(string _searchBoxValue)
{
Students = new ObservableCollection <Student>(VirtualCollegeContext.GetAllStudentsThatMatchFullName(_searchBoxValue));
}
private void GetStudentsThatMatch(string _searchBoxValue) // Needs optimization
{
LoggedInStudent = new ObservableCollection <Student>(VirtualCollegeContext.GetAllStudentsThatMatchFullName(_searchBoxValue))[0];
}
private void GetAllCourses()
{
Courses = new ObservableCollection <Course>(VirtualCollegeContext.GetAllCourses());
}
private void GetAllLessons()
{
Lessons = new ObservableCollection <Lesson>(VirtualCollegeContext.GetAllLessons());
}
private void GetAllUsers()
{
Students = new ObservableCollection <Student>(VirtualCollegeContext.GetAllStudents());
Teachers = new ObservableCollection <Teacher>(VirtualCollegeContext.GetAllTeachers());
}
public PeopleController(VirtualCollegeContext _context)
{
personSupervisor = new PersonSupervisor(_context);
context = _context;
}
public LoginView()
{
InitializeComponent();
userLoginInput.Focus();
using (var myDB = new VirtualCollegeContext())
{
#region Get Tables
var addresses = myDB.Addresses.ToList();
var studs = myDB.Users.
Include("Lessons").
Include("PresentLessons").
OfType <Student>().
ToList();
var teachers = myDB.Users.
Include("Courses").
OfType <Teacher>().ToList();
var courses = myDB.Courses.
Include("Teachers").
ToList();
var lessons = myDB.Lessons.
Include("Students").
Include("PresentStudents").
ToList();
var grades = myDB.Grades.ToList();
var payments = myDB.Payments.ToList();
#endregion
#region Initial inputs
#region Students
//myDB.Addresses.Add(new Address()
//{
// AddressLine1 = "31 bvd Troussel",
// AddressLine2 = "Building A, M08",
// City = "Conflans",
// State = "Yvelines",
// Postcode = "78700",
// Country = "France"
//});
//var studs = new List<Student>();
//var premierEleve = new Student()
//{
// FirstName = "Maxime",
// LastName = "Dennery",
// Gender = "Male",
// BirthDate = new DateTime(2000, 3, 6),
// Address = addresses.Find(a => a.AddressId == 1),
// EmailAddress = "2",
// Fees = 10800,
// Password = "******"
//};
//studs.Add(premierEleve);
//var secondEleve = new Student()
//{
// FirstName = "Christophe",
// LastName = "Nguyen",
// Gender = "Male",
// BirthDate = new DateTime(2000, 12, 10),
// Address = addresses.Find(a => a.AddressId == 6),
// EmailAddress = "*****@*****.**",
// Fees = 7600,
// Password = "******"
//};
//studs.Add(secondEleve);
//var troisisemeEleve = new Student()
//{
// FirstName = "Gwendoline",
// LastName = "Marek",
// Gender = "Female",
// BirthDate = new DateTime(2000, 1, 5),
// Address = addresses.Find(a => a.AddressId == 3),
// EmailAddress = "*****@*****.**",
// Fees = 12500,
// Password = "******"
//};
//studs.Add(troisisemeEleve);
//var quatriemeEleve = new Student()
//{
// FirstName = "Rémi",
// LastName = "Lombard",
// Gender = "Male",
// BirthDate = new DateTime(2000, 4, 17),
// Address = addresses.Find(a => a.AddressId == 1),
// EmailAddress = "*****@*****.**",
// Fees = 10800,
// Password = "******"
//};
//studs.Add(quatriemeEleve);
//myDB.Users.AddRange(studs);
#endregion
#region Teachers
//var teachers = new List<Teacher>();
//var firstProf = new Teacher()
//{
// FirstName = "Walter",
// LastName = "Perreti",
// Gender = "Male",
// BirthDate = new DateTime(1972, 01, 10),
// Address = addresses.Find(a => a.AddressId == 2),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//teachers.Add(firstProf);
//var secondProf = new Teacher()
//{
// FirstName = "Olivier",
// LastName = "Zanette",
// Gender = "Male",
// BirthDate = new DateTime(1977, 01, 10),
// Address = addresses.Find(a => a.AddressId == 3),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//teachers.Add(secondProf);
//var terreur = new Teacher()
//{
// FirstName = "Marie-Noémie",
// LastName = "Thaï",
// Gender = "Female",
// BirthDate = new DateTime(1988, 7, 14),
// Address = addresses.Find(a => a.AddressId == 5),
// EmailAddress = "*****@*****.**",
// Password = "******"
//};
//teachers.Add(terreur);
//myDB.Users.AddRange(teachers);
#endregion
#region Admins
//var superAdmin = new Administrator()
//{
// FirstName = "Pascal",
// LastName = "Brouaye",
// Gender = "Male",
// BirthDate = new DateTime(1972, 01, 10),
// Address = addresses.Find(a => a.AddressId == 6),
// EmailAddress = "1",
// Password = "******"
//};
//myDB.Users.Add(superAdmin);
#endregion
#region Courses
//var courses = new List<Course>();
//var maths = new Course()
//{
// Title = "Mathematics",
// Credits = 30,
// ReferentTeacher = teachers.FirstOrDefault(t => t.LastName == "Thaï")
//};
//courses.Add(maths);
//var meca = new Course()
//{
// Title = "Mecatronnics",
// Credits = 15,
// ReferentTeacher = teachers.FirstOrDefault(t => t.LastName.Contains("reti"))
//};
//courses.Add(meca);
//var elec = new Course()
//{
// Title = "Electricity",
// Credits = 30,
// ReferentTeacher = teachers.FirstOrDefault(t => t.LastName == "Zanette")
//};
//courses.Add(elec);
//courses.Find(c => c.Title == "Mecatronnics").Teachers = new List<Teacher>() { teachers.Find(t => t.LastName == "Zanette" || t.LastName.Contains("rreti")) };
//courses.Find(c => c.Title == "Electricity").Teachers = new List<Teacher>() { teachers.Find(t => t.LastName == "Zanette" || t.LastName.Contains("rreti")) };
//courses.Find(c => c.Title == "Mathematics").Teachers = new List<Teacher>() { teachers.Find(t => t.LastName == "Thaï") };
//myDB.Courses.AddRange(courses);
#endregion
#region Lessons
//var lessons = new List<Lesson>();
//var firstLesson = new Lesson()
//{
// Course = courses.FirstOrDefault(c => c.Title == "Electricity"),
// Day = "Tuesday",
// Hour = "08:15",
// Duration = "03:00",
// RoomName = "L309",
// Teacher = courses.FirstOrDefault(c => c.Title == "Electricity").Teachers.FirstOrDefault(t => t.LastName == "Zanette")
//};
//lessons.Add(firstLesson);
//var secondLesson = new Lesson()
//{
// Course = courses.FirstOrDefault(c => c.Title.Contains("Math")),
// Day = "Friday",
// Hour = "16:30",
// Duration = "02:30",
// RoomName = "E256",
// Teacher = courses.FirstOrDefault(c => c.Title.Contains("Math")).Teachers.FirstOrDefault(t => t.LastName == "Thaï")
//};
//lessons.Add(secondLesson);
//myDB.Lessons.AddRange(lessons);
//myDB.SaveChanges();
//lessons.Find(l => l.LessonId == 1).Teacher = teachers.Find(c => c.LastName == "Zanette");
//var a = studs.FindAll(s => s.UserId == 2 || s.UserId == 3);
//foreach (var s in a)
//{
// lessons.Find(l => l.LessonId == 1).Students.Add(s);
//}
//a = studs.FindAll(s => s.FirstName == "Christophe" || s.LastName == "Dennery" || s.UserId == 1);
//foreach (var s in a)
//{
// lessons.Find(l => l.LessonId == 2).Students.Add(s);
//}
#endregion
#region Grades
//var grades = new List<Grade>();
//var firstGrade = new Grade()
//{
// Course = courses.Find(c => c.Title == "Mathematics"),
// Coefficient = 1,
// ExamName = "Test 1",
// Mark = 60,
// Student = myDB.Users.OfType<Student>().FirstOrDefault(s => s.FirstName == "Rémi")
//};
//grades.Add(firstGrade);
//var secondGrade = new Grade()
//{
// Course = courses.Find(c => c.Title == "Mecatronnics"),
// Coefficient = 2,
// ExamName = "Online quizz #1",
// Mark = 92.75m,
// Student = myDB.Users.OfType<Student>().FirstOrDefault(s => s.FirstName == "Christophe")
//};
//grades.Add(secondGrade);
//var thirdGrade = new Grade()
//{
// Course = courses.Find(c => c.Title == "Mecatronnics"),
// Coefficient = 2,
// ExamName = "Online quizz #1",
// Mark = 12.25m,
// Student = myDB.Users.OfType<Student>().FirstOrDefault(s => s.FirstName == "Maxime")
//};
//grades.Add(thirdGrade);
//var fourthGrade = new Grade()
//{
// Course = courses.Find(c => c.Title == "Mecatronnics"),
// Coefficient = 2,
// ExamName = "Online quizz #2",
// Mark = 64,
// Student = myDB.Users.OfType<Student>().FirstOrDefault(s => s.FirstName == "Maxime")
//};
//grades.Add(fourthGrade);
//myDB.Grades.AddRange(grades);
//myDB.Grades.Add(new Grade()
//{
// Course = courses.Find(c => c.CourseId == 2),
// ExamName = "Test Exam to delete",
// Mark = 52,
// Coefficient = 3,
// Student = studs.Find(s => s.UserId == 1)
//});
#endregion
#region Course Test
//List<Teacher> teachersThatCanTeach = new List<Teacher>()
//{
// teachers.Find(x => x.FirstName == "Marie-Noémie"),
// teachers.Find(x => x.FirstName == "Walter")
//};
//Course newCourse = new Course()
//{
// Title = "Espaces Vect",
// Credits = 5,
// ReferentTeacher = teachers.Find(x => x.FirstName == "Marie-Noémie")
//};
//foreach (Teacher item in teachersThatCanTeach)
//{
// newCourse.Teachers.Add(item);
//}
//myDB.Courses.Add(newCourse);
#endregion
#endregion
var foo = VirtualCollegeContext.StudentIsPresent(studs.Find(s => s.UserId == 1), lessons.Find(l => l.LessonId == 1));
myDB.SaveChanges();
}
}
private void GetAllCoursesOfStudent()
{
Courses = new ObservableCollection <Course>(VirtualCollegeContext.GetAllCourses(LoggedInStudent));
}
private void GetLessonsThatMatch(string _searchBoxValue)
{
Lessons = new ObservableCollection <Lesson>(VirtualCollegeContext.GetAllLessonsThatMatchTitle(_searchBoxValue));
}
private void GetAllGradesSelectedStudent() // Sets the grades to display to the grades of this student in this course
{
SelectedGrades = new ObservableCollection <Grade>(VirtualCollegeContext.GetAllGradesFromStudent(SelectedCourse, LoggedInStudent));
}
private void addCourseButton_Click(object sender, RoutedEventArgs e)
{
new AddCourseView().ShowDialog();
Courses = new ObservableCollection <Course>(VirtualCollegeContext.GetAllCourses());
}
private void GetTeachersThatMatch(string _searchBoxValue) // Not implemented yet
{
Teachers = new ObservableCollection <Teacher>(VirtualCollegeContext.GetAllTeachersThatMatchFullName(_searchBoxValue));
}
protected SupervisorBase(VirtualCollegeContext context)
{
this.context = context;
}
//private void SetViews()
//{
// if (SelectedCourse.Lessons == null) lessonsGrid.Visibility = Visibility.Collapsed;
// if (SelectedCourse.AllCourseGrades.Count == 0) gradesGrid.Visibility = Visibility.Collapsed;
//}
private void allLessonsOfCourse_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
new EditLessonView(SelectedLesson).ShowDialog();
VirtualCollegeContext.UpdateLesson(SelectedLesson);
// UPDATE
}
public EditLessonView(Lesson _inputLesson)
{
InitializeComponent();
LessonToEdit = _inputLesson;
Students = new ObservableCollection <Student>(VirtualCollegeContext.GetAllStudents());
}
public EditCourseView(Course _courseToEdit)
{
InitializeComponent();
CourseToEdit = _courseToEdit;
Teachers = new ObservableCollection <Teacher>(VirtualCollegeContext.GetAllTeachers());
}
private void addTeacherButton_Click(object sender, RoutedEventArgs e)
{
new AddTeacherView().ShowDialog();
Teachers = new ObservableCollection <Teacher>(VirtualCollegeContext.GetAllTeachers());
}
