public MainWindow() { months = new List <string> { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }; user = new TutoringDB.CurrentUser(); readUser = new TutoringDB.TutorDatabaseEntities(); readUser.CurrentUsers.Load(); var userList = from i in readUser.CurrentUsers select i; user = userList.FirstOrDefault(); InitializeComponent(); finished = true; monthLabel.Content = months.FirstOrDefault(w => w == DateTime.Today.ToString("MMMM")); selectedMonth = DateTime.Today.Month; currYear = DateTime.Today.Year; calendarMonth = (MonthCounter)DateTime.Today.Month; nextButton.Click += (o, e) => refreshCalendar(1); prevButton.Click += (o, e) => refreshCalendar(2); Notifications = new ObservableCollection <Notification>(); NotificationCommand = new RelayCommand <object>(onNotificationClicked); //readUser.TutorTuteeNotifications.Load(); //var nots = from i in readUser.TutorTuteeNotifications // where i.Tutee.Username == user.UserName || i.Tutor.UserName == user.UserName // select i; //foreach (var not in nots) Notifications.Add(new Notification(not.Message, not.Type, (int)not.targetId)); //if (Notifications.Count == 0) //{ // Notifications.Add(new Notification("Nothing here!", "empty", -1)); //} //else Notifications.Add(new Notification("Clear", "clear", -1)); //NotificationsList.ItemsSource = Notifications; refreshNotifications(); DataContext = this; }
public Week() { Width = SystemParameters.WorkArea.Width; Height = SystemParameters.WorkArea.Height; WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen; finished = true; selectedDate = DateTime.Today; user = new TutoringDB.CurrentUser(); readUser = new TutoringDB.TutorDatabaseEntities(); readUser.CurrentUsers.Load(); var userList = from i in readUser.CurrentUsers select i; user = userList.FirstOrDefault(); InitializeComponent(); Notifications = new ObservableCollection <Notification>(); NotificationCommand = new RelayCommand <object>(onNotificationClicked); readUser.TutorTuteeNotifications.Where(not => not.Tutee.Username == user.UserName || not.Tutor.UserName == user.UserName).Load(); var nots = from i in readUser.TutorTuteeNotifications where i.Tutee.Username == user.UserName || i.Tutor.UserName == user.UserName select i; foreach (var not in nots) { Notifications.Add(new Notification(not.Message, not.Type, (int)not.targetId)); } if (Notifications.Count == 0) { Notifications.Add(new Notification("Nothing here!", "empty", -1)); } else { Notifications.Add(new Notification("Clear", "clear", -1)); } NotificationsList.ItemsSource = Notifications; nextButton.Click += (o, e) => refreshWeek(7); prevButton.Click += (o, e) => refreshWeek(-7); }
private void submitButton_Click(object sender, RoutedEventArgs e) { if (oldPasswordBox.Password == "" || newPasswordBox.Password == "") { info.WrongOldPassword = "******"; } else { TutoringDB.TutorDatabaseEntities userCreds = new TutoringDB.TutorDatabaseEntities(); bool correctOldPassword = (userCreds.Tutors.Any(userF => userF.UserName == user.UserName && userF.Password == oldPasswordBox.Password) || userCreds.Tutees.Any(userF => userF.Username == user.UserName && userF.Password == oldPasswordBox.Password) || userCreds.Faculties.Any(userF => userF.Username == user.UserName && userF.Password == oldPasswordBox.Password)); if (correctOldPassword) { info.WrongOldPassword = "******"; if (user.Type.ToLower().Contains("tutee")) { userCreds.Tutees.Where(userT => userT.Username == user.UserName) .FirstOrDefault().Password = newPasswordBox.Password; } else if (user.Type.ToLower().Contains("tutor")) { userCreds.Tutors.Where(userT => userT.UserName == user.UserName) .FirstOrDefault().Password = newPasswordBox.Password; } else { userCreds.Faculties.Where(userT => userT.Username == user.UserName) .FirstOrDefault().Password = newPasswordBox.Password; } userCreds.SaveChanges(); } else { info.WrongOldPassword = "******"; } } DataContext = info; }
private void addButton_Click(object sender, RoutedEventArgs e) { TutoringDB.TutorDatabaseEntities db = new TutoringDB.TutorDatabaseEntities(); db.Tutees.Load(); db.Tutors.Load(); db.Faculties.Load(); int numTutees = db.Tutees.Count(); //Error Checking if (firstNameTextBox.Text != "" && lastNameTextBox.Text != "" && usernameTextBox.Text != "" && passwordTextBox.Text != "" && (yearTextBox.Text == "1" || yearTextBox.Text == "2" || yearTextBox.Text == "3" || yearTextBox.Text == "4") && emailTextBox.Text != "" ) { TutoringDB.Tutee temp = new TutoringDB.Tutee(); temp.FirstName = firstNameTextBox.Text; temp.LastName = lastNameTextBox.Text; temp.Username = usernameTextBox.Text; temp.Password = passwordTextBox.Text; temp.Year = Convert.ToInt32(yearTextBox.Text); temp.Email = emailTextBox.Text; db.Tutees.Add(temp); db.SaveChanges(); this.Close(); Label1.Text = ""; } else { Label1.Text = "Completely fill out form"; } }
public AccountInfo() { //Get the current user user = new TutoringDB.CurrentUser(); readUser = new TutoringDB.TutorDatabaseEntities(); readUser.CurrentUsers.Load(); user = readUser.CurrentUsers.FirstOrDefault(); TutoringDB.TutorDatabaseEntities tutorSchedule = new TutoringDB.TutorDatabaseEntities(); if (user.Type.ToLower().Contains("tutee")) { tutorSchedule.Tutees .Where(userF => (userF.Username == user.UserName)) .Load(); var userList = from i in tutorSchedule.Tutees where i.Username == user.UserName select i; var tuteeUser = userList.FirstOrDefault(); info.UserFullName = tuteeUser.FirstName + " " + tuteeUser.LastName; info.UserUsernameValue = tuteeUser.Username; info.UserYearValue = tuteeUser.Year.ToString(); info.UserApprovedValue = "No"; } else if (user.Type.ToLower().Contains("tutor")) { tutorSchedule.Tutors .Where(userF => (userF.UserName == user.UserName)) .Load(); var userList = from i in tutorSchedule.Tutors where i.UserName == user.UserName select i; var tutorUser = userList.FirstOrDefault(); info.UserFullName = tutorUser.FirstName + " " + tutorUser.LastName; info.UserUsernameValue = tutorUser.UserName; info.UserYearValue = tutorUser.Year.ToString(); info.UserApprovedValue = tutorUser.Authorized.ToString(); } else { tutorSchedule.Faculties .Where(fac => fac.Username == user.UserName) .Load(); var userList = from i in tutorSchedule.Faculties where i.Username == user.UserName select i; var facultyUser = userList.FirstOrDefault(); info.UserFullName = facultyUser.First_Name + " " + facultyUser.LastName; info.UserUsernameValue = facultyUser.Username; info.UserYearValue = "Not applicable"; info.UserApprovedValue = "Can approve or deny requests to tutor"; } info.WrongOldPassword = ""; DataContext = info; InitializeComponent(); }
private void fillFacultyButton_Click(object sender, EventArgs e) { TutoringDB.TutorDatabaseEntities db = new TutoringDB.TutorDatabaseEntities(); db.Faculties.Load(); db.Courses.Load(); db.FacultyCourses.Load(); //Clear database first foreach (TutoringDB.FacultyCours f in db.FacultyCourses) { db.FacultyCourses.Remove(f); } foreach (TutoringDB.Cours fc in db.Courses) { db.Courses.Remove(fc); } foreach (TutoringDB.Faculty f in db.Faculties) { db.Faculties.Remove(f); } db.SaveChanges(); TutoringDB.Faculty tempFaculty = new TutoringDB.Faculty(); TutoringDB.Cours tempCourse = new TutoringDB.Cours(); TutoringDB.FacultyCours tempFacultyCourse = new TutoringDB.FacultyCours(); //Read file line-by-line and load into database foreach (string line in File.ReadLines(@"courses-fall16.txt")) { db.Faculties.Load(); //Fill Course Fields var pieces = line.Split('\t'); tempCourse.CourseNumber = pieces[0]; tempCourse.CourseName = pieces[1]; var code = pieces[0].Split(' '); tempCourse.Department = code[0]; db.Courses.Add(tempCourse); //Fill Faculty Fields tempFaculty.Username = tempFaculty.First_Name = pieces[2]; tempFaculty.Password = tempFaculty.LastName = pieces[3]; tempFaculty.Email = pieces[2] + pieces[3] + "@coe.edu"; var temps = db.Faculties.Where(i => i.First_Name == tempFaculty.First_Name && i.LastName == tempFaculty.LastName); if (temps.Count() == 0) { db.Faculties.Add(tempFaculty); tempFacultyCourse.Faculty = tempFaculty; tempFacultyCourse.Cours = tempCourse; db.FacultyCourses.Add(tempFacultyCourse); db.SaveChanges(); } else { var first = from i in db.Faculties where i.Email == tempFaculty.Email select i; tempFacultyCourse.FacultyId = first.FirstOrDefault().Id; tempFacultyCourse.Cours = tempCourse; db.FacultyCourses.Add(tempFacultyCourse); db.SaveChanges(); } } MessageBox.Show("Successfully Loaded."); }
private void clearButton_Click(object sender, EventArgs e) { TutoringDB.TutorDatabaseEntities db = new TutoringDB.TutorDatabaseEntities(); db.TutorTuteeCourseAppointments.Load(); foreach (var i in db.TutorTuteeCourseAppointments) { db.TutorTuteeCourseAppointments.Remove(i); } db.TutorTuteeNotifications.Load(); foreach (var i in db.TutorTuteeNotifications) { db.TutorTuteeNotifications.Remove(i); } db.TutorConfirmationRequests.Load(); foreach (var i in db.TutorConfirmationRequests) { db.TutorConfirmationRequests.Remove(i); } db.TutorCourses.Load(); foreach (var i in db.TutorCourses) { db.TutorCourses.Remove(i); } db.TutorBusyTimes.Load(); foreach (var i in db.TutorBusyTimes) { db.TutorBusyTimes.Remove(i); } db.FacultyCourses.Load(); foreach (var i in db.FacultyCourses) { db.FacultyCourses.Remove(i); } db.TuteeBusyTimes.Load(); foreach (var i in db.TuteeBusyTimes) { db.TuteeBusyTimes.Remove(i); } db.Appointments.Load(); foreach (var i in db.Appointments) { db.Appointments.Remove(i); } db.BaseSchedules.Load(); foreach (var i in db.BaseSchedules) { db.BaseSchedules.Remove(i); } db.BusyTimes.Load(); foreach (var i in db.BusyTimes) { db.BusyTimes.Remove(i); } db.Courses.Load(); foreach (var i in db.Courses) { db.Courses.Remove(i); } db.CurrentUsers.Load(); foreach (var i in db.CurrentUsers) { db.CurrentUsers.Remove(i); } db.Faculties.Load(); foreach (var i in db.Faculties) { db.Faculties.Remove(i); } db.StartEnds.Load(); foreach (var i in db.StartEnds) { db.StartEnds.Remove(i); } db.Tutees.Load(); foreach (var i in db.Tutees) { db.Tutees.Remove(i); } db.Tutors.Load(); foreach (var i in db.Tutors) { db.Tutors.Remove(i); } db.SaveChanges(); MessageBox.Show("Successfully Cleared."); }
private void fillTutorsTutees_Click(object sender, EventArgs e) { TutoringDB.TutorDatabaseEntities db = new TutoringDB.TutorDatabaseEntities(); db.Tutors.Load(); db.Tutees.Load(); db.TutorCourses.Load(); //Clear database first foreach (TutoringDB.Tutor t in db.Tutors) { db.Tutors.Remove(t); } foreach (TutoringDB.Tutee f in db.Tutees) { db.Tutees.Remove(f); } foreach (TutoringDB.TutorCourse tc in db.TutorCourses) { db.TutorCourses.Remove(tc); } db.SaveChanges(); TutoringDB.Tutor tempTutor = new TutoringDB.Tutor(); TutoringDB.Tutee tempTutee = new TutoringDB.Tutee(); //Fill Tutors foreach (string line in File.ReadLines(@"fakeTutors.csv")) { db.Tutors.Load(); db.Tutees.Load(); db.TutorCourses.Load(); var split = line.Split('|'); tempTutor.FirstName = split[0]; tempTutor.LastName = split[1]; tempTutor.UserName = split[2]; tempTutor.Password = split[3]; tempTutor.Email = split[4]; Random year = new Random(); tempTutor.Year = year.Next(1, 4); db.Tutors.Add(tempTutor); //Randomly matches tutors with courses Random rnd = new Random(); int limit = rnd.Next(4); db.SaveChanges(); db.Courses.Load(); //var courselist = db.Courses.Local; //for (int i = 0; i< limit; i++) //{ // int max = db.Courses.Count(); // tempTutorCourse.Cours = courselist[rnd.Next(0,max)]; // tempTutorCourse.TutorId = tempTutor.Id+1; // db.TutorCourses.Add(tempTutorCourse); //} //db.SaveChanges(); } //Fill Tutees foreach (string line in File.ReadLines(@"fakeTutees.csv")) { db.Tutors.Load(); db.Tutees.Load(); db.TutorCourses.Load(); var split = line.Split('|'); tempTutee.FirstName = split[0]; tempTutee.LastName = split[1]; tempTutee.Username = split[2]; tempTutee.Password = split[3]; tempTutee.Email = split[4]; Random year = new Random(); tempTutee.Year = year.Next(1, 4); db.Tutees.Add(tempTutee); db.SaveChanges(); } List <TutoringDB.TutorCourse> tcList = new List <TutoringDB.TutorCourse>(); db.Courses.Load(); db.Tutors.Load(); var tutorlist = db.Tutors.Local.ToList(); var courselist = db.Courses.Local.ToList(); int index = 0; foreach (TutoringDB.Cours c in courselist) { Random rnd = new Random(); int lim = rnd.Next(2, 5); for (int i = 0; i < lim; i++) { TutoringDB.TutorCourse tempTutorCourse = new TutoringDB.TutorCourse(); tempTutorCourse.Cours = c; tempTutorCourse.Tutor = tutorlist[index % tutorlist.Count()]; index++; tcList.Add(tempTutorCourse); } } for (int i = 0; i < tcList.Count; i++) { db.TutorCourses.Load(); db.TutorCourses.Add(tcList.ElementAt(i)); db.SaveChanges(); } db.SaveChanges(); MessageBox.Show("Successfully Loaded."); }