private void Window_Loaded(object sender, RoutedEventArgs e)
{
ExaminationEntities1 ex = new ExaminationEntities1();
var insObj = ex.selectFromInstructor(instructor_id).FirstOrDefault();
this.instructorName.Text += $"{insObj.ins_FName} {insObj.ins_LName}";
}
private void SaveAnswers()
{
List <string> stdAnswers = new List <string>();
stdAnswers.AddRange(CurrentExam.Questions.Select(a => a.StudentAnswer));
string StudentAnswers = ReorderStudentAnswers(stdAnswers);
ex = new ExaminationEntities1();
string ExamStatus = ex.ExamAnswers(StudentID, ExamID, StudentAnswers).First();
if (ExamStatus == "ExamSaved")
{
string CorrectionStatus = ex.examCorrection(ExamID, StudentID, CourseID).First();
if (CorrectionStatus == "Correction is done successfully")
{
MessageBox.Show(CorrectionStatus, "Alert", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show(CorrectionStatus, "Alert", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show(ExamStatus, "Alert", MessageBoxButton.OK, MessageBoxImage.Error);
}
this.Close();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ExaminationEntities1 db = new ExaminationEntities1();
Ins_Crs_Grid.ItemsSource = db.CoursesByInstructor(instructor_id);
var insObj = db.selectFromInstructor(instructor_id).FirstOrDefault();
this.instructorName.Text += $"{insObj.ins_FName} {insObj.ins_LName}";
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ex = new ExaminationEntities1();
subjectCombo.ItemsSource = ex.courseList(_stdId);
examCombo.ItemsSource = ex.examsList(_stdId, _courseId);
var stdObj = ex.selectStudents().Where(s => s.std_Id == _stdId).FirstOrDefault();
this.studetName.Text += $"{stdObj.std_FName} {stdObj.std_LName}";
}
private void TakeExam(object sender, RoutedEventArgs e)
{
ExaminationEntities1 ex = new ExaminationEntities1();
frm_ExamList tx = new frm_ExamList(_stdId);
this.Close();
tx.Show();
}
public frm_ExamList(int _stdID)
{
InitializeComponent();
StudentID = _stdID;
ex = new ExaminationEntities1();
ExamList = ex.GetUnsolvedExams(StudentID).ToList();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
db = new ExaminationEntities1();
combox_crs.ItemsSource = db.CoursesByInstructor(instructor_id);
var InsName = db.selectFromInstructor(instructor_id).FirstOrDefault();
string FullName = $"{InsName.ins_FName} {InsName.ins_LName}";
this.insName.Text += FullName;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ex = new ExaminationEntities1();
std_result.ItemsSource = ex.GetSudentGrades(_stdId);
StudentGradeResults.ItemsSource = ex.GetSudentGrades(_stdId).Select(p => new { Subject = p.crs_Name, Grade = p.grade }).ToList();
var stdObj = ex.selectStudents().Where(s => s.std_Id == _stdId).FirstOrDefault();
this.studentName.Text += $"{stdObj.std_FName} {stdObj.std_LName}";
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ExaminationEntities1 ex = new ExaminationEntities1();
var s1 = ex.GetStudents(_stdId).FirstOrDefault();
this.name.Text = s1.std_FName + " " + s1.std_LName;
this.id.Text = s1.std_Id.ToString();
this.intake.Text = "Intake_41";
this.branch.Text = "Smart Village";
this.track.Text = "SD";
this.studentName.Text += s1.std_FName + " " + s1.std_LName;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ex = new ExaminationEntities1();
dg_UnsolvedExams.ItemsSource = ex.GetUnsolvedExamsNames(StudentID);
var stdName = ex.selectStudents().Where(s => s.std_Id == StudentID).FirstOrDefault();
string studName = $"{stdName.std_FName} {stdName.std_LName}";
this.studentName.Text += studName;
/*dg_UnsolvedExams.Columns[0].Width = 100;
* dg_UnsolvedExams.Columns[1].Width = 300;
* dg_UnsolvedExams.Columns[2].Width = 150;
* dg_UnsolvedExams.Columns[3].Width = 120;*/
}
public cls_Exam(int exmID)
{
ExaminationEntities1 ex = new ExaminationEntities1();
List <GetExam_Result> exm = ex.GetExam(exmID).ToList();
QuestionsBeforeShuffling = new List <GetExam_Result>();
QuestionsBeforeShuffling.AddRange(exm);
exm.Shuffle <GetExam_Result>();
Questions = new List <cls_Question>();
foreach (var item in exm)
{
Questions.Add(new cls_Question(item.qDescription, item.qChoice));
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ex = new ExaminationEntities1();
CoursesTopicsList.ItemsSource = ex.topicsPerCourse();
if (_insIDl != 0)
{
Course_Topics.ItemsSource = ex.CoursesByInstructor(_insIDl).Select(p => new { p.crs_Id, crs_Name = p.crs_name });
var InsName = ex.selectFromInstructor(_insIDl).FirstOrDefault();
string instName = $"{InsName.ins_FName} {InsName.ins_LName}";
this.fullName.Text += instName;
}
if (_studentId != 0)
{
Course_Topics.ItemsSource = ex.courseList(_studentId);
var stdName = ex.selectStudents().Where(s => s.std_Id == _studentId).FirstOrDefault();
string studName = $"{stdName.std_FName} {stdName.std_LName}";
this.fullName.Text += studName;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
ExaminationEntities1 ex = new ExaminationEntities1();
StdEmailCbx.ItemsSource = ex.selectStudents();
}