private void PunishButton_Click(object sender, RoutedEventArgs e) { StudentDisplay currentStudent = GetCurrentStudent(sender); MainWindow window = GlobalFunction.GetMainWindow(); window._addFrame.Navigate(new AddPunishment(currentStudent.ID)); }
private void DetailsButton_Click(object sender, RoutedEventArgs e) { StudentDisplay currentStudent = GetCurrentStudent(sender); MainWindow window = GlobalFunction.GetMainWindow(); window._mainFrame.Navigate(new StudentDetailsPage(currentStudent.ID)); }
private void DownvotesButton_Click(object sender, RoutedEventArgs e) { StudentDisplay currentStudent = GetCurrentStudent(sender); MainWindow window = GlobalFunction.GetMainWindow(); window._addFrame.Navigate(new AddVote(false, currentStudent)); //StudentsShared.AddVotesToDb(currentStudent.ID, false, "Downvote rapide"); //int currentDownvoteCount = int.Parse(currentStudent.DownvotesCount); //currentDownvoteCount++; //currentStudent.DownvotesCount = currentDownvoteCount.ToString(); }
private void RetrieveLastHomeworkButton_Click(object sender, RoutedEventArgs e) { StudentDisplay currentStudent = (StudentDisplay)((FrameworkElement)sender).DataContext; using SQLiteCommand cmd = GlobalFunction.OpenDbConnection(); cmd.CommandText = "UPDATE homeworks SET retrieveDate = @retrieveDate WHERE homeworkId = @id"; cmd.Parameters.AddWithValue("id", currentStudent.LastHomeWorkId); int currentTimestamp = (int)new DateTimeOffset(DateTime.Now).ToUnixTimeSeconds(); cmd.Parameters.AddWithValue("retrieveDate", currentTimestamp); cmd.Prepare(); cmd.ExecuteNonQuery(); currentStudent.LastHomeworkStatusColor = "Green"; currentStudent.LastHomeworkStatusText = GlobalVariable.specialCharacter["CheckMark"]; currentStudent.HomeworkButtonEnabled = false; }
private void ReadStudentsData(List <int> studentIdList) { foreach (int studentId in studentIdList) { using SQLiteCommand cmd = GlobalFunction.OpenDbConnection(); //Handle classroom name List <int> classroomIdList = Database.Get.Classroom.AllIDFromStudentID(studentId); List <string> classroomNameList = new List <string>(); foreach (int classroomId in classroomIdList) { classroomNameList.Add(Database.Get.Classroom.NameFromID(classroomId)); } string classroomName = String.Join(", ", classroomNameList.ToArray()); string[] studentName = Database.Get.Student.NameFromID(studentId); //Handle homework List <HomeworkInfo> homeworkList = GetAllHomeworks(studentId); HomeworkInfo lastHomework = GetLastHomework(homeworkList); bool lastHomeworkButtonEnabled = false; string lastHomeworkStatus = GlobalVariable.specialCharacter["CheckMark"]; string lastHomeworkColor = "Green"; if (lastHomework.retrieveDate == 0 && lastHomework.creationDate != 0) { lastHomeworkButtonEnabled = true; lastHomeworkStatus = GlobalVariable.specialCharacter["Cross"]; lastHomeworkColor = "Red"; } //Handle note List <NoteInfo> notesList = GetAllNotes(studentId); NoteInfo lastNotes = GetLastNote(notesList); //Handle votes List <VotesInfo> upvotesList = Database.Get.Vote.AllFromStudentId(studentId, true); List <VotesInfo> downvotesList = Database.Get.Vote.AllFromStudentId(studentId, false); string average = ""; List <GradeInfo> gradesList = Database.Get.Grade.AllFromStudentId(studentId); if (gradesList.Count == 0) { average = "20/20"; } else { float[] gradesArray = new float[gradesList.Count]; int[] coeffArray = new int[gradesList.Count]; for (int i = 0; i < gradesList.Count; i++) { gradesArray[i] = gradesList[i].Grade; coeffArray[i] = gradesList[i].Coeff; } int coeffSum = coeffArray.Sum(); float[] gradesCoeffMultiply = new float[gradesList.Count]; for (int i = 0; i < gradesList.Count; i++) { gradesCoeffMultiply[i] = gradesArray[i] * coeffArray[i]; } float gradesCoefMultiplySum = gradesCoeffMultiply.Sum(); float averageFloat = gradesCoefMultiplySum / coeffSum; average = averageFloat.ToString() + "/20"; } StudentDisplay studentDisplay = new StudentDisplay() { ID = studentId, Name = studentName[1] + " " + studentName[0], ClassroomName = classroomName, HomeworkButtonEnabled = lastHomeworkButtonEnabled, LastHomeworkStatusText = lastHomeworkStatus, LastHomeworkStatusColor = lastHomeworkColor, LastHomeWorkId = lastHomework.homeworkId, Note = lastNotes.content ?? "Aucune note", Average = average, UpvotesCount = upvotesList.Count.ToString(), DownvotesCount = downvotesList.Count.ToString() }; studentsCollection.Add(studentDisplay); } }