public void getStuentExamListView() { List <rel_exam_student> allSubmittedExams = getAllSubmittedStuExams(); List <StudentExamListView> mySlistview = new List <StudentExamListView>(); try { Studentsexams.Items.Clear(); } catch (Exception rt) { } foreach (var item in allSubmittedExams) { StudentExamListView stuExam = new StudentExamListView(); exam exam = (from e in context2.exams where e.ExamCode == item.ExamCode select e).FirstOrDefault(); student stu = (from s in context2.students where s.StuId == item.StuId select s).FirstOrDefault(); string courseName = CourseNName; float grade = 0f; stuExam.ExamCode = exam.ExamCode; stuExam.Name = stu.StuEmail; stuExam.Type = exam.Type; stuExam.Branch = "Not Needed"; stuExam.Intake = 0; stuExam.Grade = grade; stuExam.MinDegree = exam.MinDegree; stuExam.MaxDegree = exam.MaxDegree; stuExam.Date = exam.Date; mySlistview.Add(stuExam); Studentsexams.Items.Add(stuExam); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { try { StudentExamListView StEx = Studentsexams.SelectedItem as StudentExamListView; var studentID = (from u in context2.students where u.StuEmail == StEx.Name select u.StuId).FirstOrDefault(); List <rel_student_qusetion_exam> query = (from sqe in context2.rel_student_qusetion_exam join se in context2.rel_exam_student on sqe.StudentId equals se.StuId where sqe.StudentId == studentID && sqe.ExamCode == StEx.ExamCode && se.Taken == true select sqe).ToList(); foreach (var item in query) { string quetionn = ""; var qtype = (from q in context2.questions where q.QustCode == item.QustCode select q.type).FirstOrDefault(); if (qtype == "text") { quetionn = (from con in context2.textquestions where con.QustCode == item.QustCode select con.question).FirstOrDefault(); } if (qtype == "MSQ") { quetionn = (from con in context2.multichoices where con.QustCode == item.QustCode select con.question).FirstOrDefault(); } if (qtype == "true&false") { quetionn = (from con in context2.qtruefalses where con.QustCode == item.QustCode select con.question).FirstOrDefault(); } QuestionOfSubmittedExam questionToBeViewed = new QuestionOfSubmittedExam(); questionToBeViewed.StudentId = item.StudentId; questionToBeViewed.QustCode = item.QustCode; questionToBeViewed.ExamCode = item.ExamCode; questionToBeViewed.Question = quetionn; questionToBeViewed.Type = qtype; questionToBeViewed.Answer = item.Answer; questionToBeViewed.ModelAnswer = item.ModelAnswer; questionToBeViewed.DegreeMark = item.DegreeMark; submitedQuestions.Items.Add(questionToBeViewed); } Canvas.SetZIndex(AnsweredQuestions, ++z); } catch (Exception fs) { } }
private void exams_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { StudentExamListView selectedExam = exams.SelectedItem as StudentExamListView; selectedExamId = (from exam in contect3.exams where exam.Name == selectedExam.Course select exam.ExamCode).FirstOrDefault(); } catch (Exception er) { } }
private void Button_Click_5(object sender, RoutedEventArgs e) { try { StudentExamListView exa = exams.SelectedItem as StudentExamListView; exam quet = (from t in context2.exams where t.ExamCode == exa.ExamCode select t).FirstOrDefault(); context2.exams.Remove(quet); context2.SaveChanges(); exams.Items.Remove(exa); Canvas.SetZIndex(exampanel, ++z); } catch (Exception dds) { } }
private void examsincourse(object sender, SelectionChangedEventArgs e) { var CourseName = sender as ComboBox; var CourseNName = CourseName.SelectedItem.ToString(); //MessageBox.Show(CourseName.SelectedItem.ToString()); var query = (from Idcourse in context2.courses where Idcourse.Name == CourseNName select Idcourse.CourseId).FirstOrDefault(); var query2 = (from coursee in context2.course_exam where coursee.Course_Id == query select coursee.Exam_Id).ToList(); var query3 = (from exam in context2.exams where query2.Contains(exam.ExamCode) select exam).ToList(); List <StudentExamListView> ListOfClassExams = new List <StudentExamListView>(); foreach (var item in query3) { StudentExamListView ex = new StudentExamListView(); ex.Date = item.Date; ex.Grade = 0; ex.ExamCode = item.ExamCode; ex.MinDegree = item.MinDegree; ex.MaxDegree = item.MaxDegree; ex.Name = item.Name; ex.Type = item.Type; ex.Intake = 0; ex.Branch = ""; ex.Course = ""; ListOfClassExams.Add(ex); } exams.ItemsSource = ListOfClassExams; }
public void getStuentExamListView() { List <exam> allAssignedExams = getAllAssignedExams(); List <exam> allSubmittedExams = getAllSubmittedExams(); List <StudentExamListView> myAlistview = new List <StudentExamListView>(); List <StudentExamListView> mySlistview = new List <StudentExamListView>(); int ITB = (from studenty in contect3.students where studenty.StuId == userID select studenty.ITBid).FirstOrDefault(); int intakeName = (from intak in contect3.intakes where intak.IntakeNo == (from itb in contect3.rel_branch_track_intake where itb.id == ITB select itb.intack).FirstOrDefault() select intak.IntakeNumber).FirstOrDefault(); string BranchName = (from branch in contect3.branches where branch.BranchId == (from itb in contect3.rel_branch_track_intake where itb.id == ITB select itb.branchID).FirstOrDefault() select branch.Name).FirstOrDefault(); foreach (var exam in allAssignedExams) { StudentExamListView stuExam = new StudentExamListView(); string courseName = (from couuse in contect3.courses where couuse.CourseId == ((from ec in contect3.course_exam where ec.Exam_Id == exam.ExamCode select ec.Course_Id).FirstOrDefault()) select couuse.Name).FirstOrDefault(); var gradeQuery = from grrade in contect3.rel_student_qusetion_exam where grrade.ExamCode == selectedExamId && grrade.QustCode == userID select grrade.DegreeMark; float grade = 0f; foreach (var item in gradeQuery) { grade += (float)item; } stuExam.Name = ""; stuExam.Type = exam.Type; stuExam.Course = courseName; stuExam.Branch = BranchName; stuExam.Intake = intakeName; stuExam.Grade = grade; stuExam.MinDegree = exam.MinDegree; stuExam.MaxDegree = exam.MaxDegree; stuExam.Date = exam.Date; myAlistview.Add(stuExam); } foreach (var exam in allSubmittedExams) { StudentExamListView stuExam = new StudentExamListView(); string courseName = (from couuse in contect3.courses where couuse.CourseId == ((from ec in contect3.course_exam where ec.Exam_Id == exam.ExamCode select ec.Course_Id).FirstOrDefault()) select couuse.Name).FirstOrDefault(); var gradeQuery = from grrade in contect3.rel_student_qusetion_exam where grrade.ExamCode == selectedExamId && grrade.QustCode == userID select grrade.DegreeMark; float grade = 0f; foreach (var item in gradeQuery) { grade += (float)item; } stuExam.Name = ""; stuExam.Type = exam.Type; stuExam.Course = courseName; stuExam.Branch = BranchName; stuExam.Intake = intakeName; stuExam.Grade = grade; stuExam.MinDegree = exam.MinDegree; stuExam.MaxDegree = exam.MaxDegree; stuExam.Date = exam.Date; mySlistview.Add(stuExam); } try { exams.Items.Clear(); finishedexams.Items.Clear(); } catch (Exception rt) { } exams.ItemsSource = myAlistview; finishedexams.ItemsSource = mySlistview; }