private void take_exam(object sender, RoutedEventArgs e) { if (selectedExamId > 0) { rel_exam_student ess = (from es in contect3.rel_exam_student where es.ExamCode == selectedExamId && es.StuId == userID select es).First(); ess.Taken = true; contect3.SaveChanges(); getQuestionsOfExam = (from Q in contect3.questions join E in contect3.exam_qusetion on Q.QustCode equals E.Question_Id where E.Exam_Id == selectedExamId select Q).ToList(); QCounter = getQuestionsOfExam.Count(); // getting the first question question questionIndex = getQuestionsOfExam.ElementAt(i); string QuestionContent = ""; if (questionIndex.type == "text") { var Question = (from qs in contect3.textquestions where qs.QustCode == questionIndex.QustCode select qs).FirstOrDefault(); QuestionContent = Question.question; CurrentQuestion = "text"; Canvas.SetZIndex(textAnswer, ++z); } if (questionIndex.type == "MSQ") { QuestionContent = (from qs in contect3.multichoices where qs.QustCode == questionIndex.QustCode select qs.question).FirstOrDefault(); List <string> choise = (from choisse in contect3.msqmultivalues where choisse.MCQCode == (from qs in contect3.multichoices where qs.QustCode == questionIndex.QustCode select qs.MCQCode).FirstOrDefault() select choisse.ModelAnswer).ToList(); A.Content = choise.ElementAt(0); B.Content = choise.ElementAt(1); C.Content = choise.ElementAt(2); D.Content = choise.ElementAt(3); CurrentQuestion = "mcq"; Canvas.SetZIndex(msqAnswer, ++z); } if (questionIndex.type == "true&false") { QuestionContent = (from qs in contect3.qtruefalses where qs.QustCode == questionIndex.QustCode select qs.question).FirstOrDefault(); CurrentQuestion = "tf"; Canvas.SetZIndex(tfAnswer, ++z); } question.Content = QuestionContent; Canvas.SetZIndex(stuQuestion, ++z); } else { MessageBox.Show("Get Out"); } }
private void submit_exam(object sender, RoutedEventArgs e) { try { 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>(); foreach (var item in questions) { question qus = new question { QustCode = item.IDeas, type = item.Type }; DBquestions.Add(qus); Exams_questions.Add(new exam_qusetion { Question_Id = item.IDeas, Grade = item.Degree }); } 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 }); 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("Please Enter a valid Information"); } }
private void addcourse_Click(object sender, RoutedEventArgs e) { try { corseadd newcourse = new corseadd(); newcourse.Name = coursename.Text.ToString(); newcourse.MaxDegree = 100; newcourse.instructorName = instructorcourse.SelectedItem.ToString(); instructor newins = context3.instructors.Where(em => em.FirstName == newcourse.instructorName).FirstOrDefault(); rel_instructor_cource newcourseinstructor = new rel_instructor_cource(); course newCourseAdd = new course(); newCourseAdd.Name = coursename.Text.ToString(); newCourseAdd.MinDegree = 50; newCourseAdd.MaxDegree = 100; newCourseAdd.Description = coursename.Text.ToString() + "is important"; context3.courses.Add(newCourseAdd); context3.SaveChanges(); newcourseinstructor.CourseId = newCourseAdd.CourseId; newcourseinstructor.InsId = newins.InsId; newcourseinstructor.Year = DateTime.Now; context3.rel_instructor_cource.Add(newcourseinstructor); context3.SaveChanges(); coursess.Items.Add(newcourse); } catch (Exception f) { MessageBox.Show("Invalid Inputs"); } }