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;
}
