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_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 submit_exam(object sender, RoutedEventArgs e) { try { CourseNName = IstuctorCourse.SelectedItem.ToString(); DateTime dateofExam = ExamDate.DisplayDate; int munites = 0; string[] number = ExamTime.Text.Split(':', ','); if (number.Length == 1) { munites = 0; } else if (number.Length > 1) { munites = int.Parse(number[1]); } else { MessageBox.Show("please enter the time of exam"); } var hour = int.Parse(number[0]) + int.Parse(duration.Text.ToString()); DateTime examDateTimeBegin = new DateTime(dateofExam.Year, dateofExam.Month, dateofExam.Day, int.Parse(number[0]), munites, 0); //TimeSpan examDateTimeBegin = new TimeSpan(examDateTime.Day, int.Parse(number[0]), munites, 0); DateTime examDateTimeEnd = new DateTime(examDateTimeBegin.Year, examDateTimeBegin.Month, examDateTimeBegin.Day, hour, munites, 0); if (int.Parse(sumOfQuestionGrades.Text) == ExamDegree && examDateTimeBegin != null && SelectedQuestionsss.Count > 0 && int.Parse(duration.Text.ToString()) > 0) { //the questions that selected to the exam List <Quesition> questions = new List <Quesition>(); questions.AddRange(QuestionWithGrades.Where(r => SelectedQuestionsss.Contains(r.IDeas))); //this list to match from question in class i made to put to the class //the entity framework has made (the elements is added in the foreach t7t) List <exam_qusetion> Exams_questions = new List <exam_qusetion>(); //the course of the question //List<course_question> course_qus = new List<course_question>(); //course_qus.Add(new course_question { Course_ID = 1, Qust_codr = 4 }); //getting the course ID of the selected course var courseId = (from courseID in context2.courses where courseID.Name == CourseNName select courseID.CourseId).FirstOrDefault(); List <question> DBquestions = new List <question>(); List <exam_qusetion> DBquesRel = new List <exam_qusetion>(); foreach (var item in questions) { question qus = new question { QustCode = item.IDeas, type = item.Type }; //DBquestions.Add(qus); exam_qusetion rel = new exam_qusetion { Grade = item.Degree, question = qus }; //DBquesRel.Add(rel); Exams_questions.Add(rel); } List <course_exam> courseOfExam = new List <course_exam>(); var exams = new exam() { Name = CourseNName, Type = comboBoxofexamType.SelectedItem.ToString(), //must be exam of corrective Date = examDateTimeBegin, EndTime = examDateTimeEnd, MaxDegree = (short)ExamDegree, course_exam = courseOfExam, exam_qusetion = Exams_questions, }; context2.exams.Add(exams); context2.course_exam.Add(new course_exam { Course_Id = courseId, exam = exams }); context2.SaveChanges(); MessageBox.Show("Exam Has been Added"); /* ExamDegree // this is the degree of the exam * IstuctorCourse // this is the course of the exam * comboBoxofexamType // this combo box is the * Exams_questions // this is the list of quetions * examDateTimeBegin // this is the begin time for exam * examDateTimeEnd //this is the end time for the exam */ } else { totalQgrade.Visibility = Visibility.Visible; } } catch (Exception eee) { MessageBox.Show(eee.ToString()); } }