private void login(int id)
{
OnlineExam ent = new OnlineExam();
try
{
var dept = (from d in ent.Departments select d).ToList();
bool isManager = false;
foreach (var item in dept)
{
if (id == item.MangerId)
{
isManager = true;
}
}
if (!isManager)
{
MessageBox.Show("Access Denaied", "Error");
return;
}
Manager_Home_Form manager_Home = new Manager_Home_Form(id);
this.Close();
manager_Home.Show();
}
catch (Exception)
{
MessageBox.Show("Not Authroized", "Access Denaied");
}
}
private void ShowStudentGrades_Load(object sender, EventArgs e)
{
OnlineExam exam = new OnlineExam();
var grades = exam.getStudnetGrades(studentID);
dataGridView1.DataSource = grades.ToList();
}
private void questionInfo(int qid)
{
OnlineExam ent = new OnlineExam();
// select Question by ID
var quest = (from q in ent.Questions
where q.QuesId == qid
select q).First();
// Show Quest Info
qcont.Text = quest.Qcontent.Trim();
qdegree.Value = (int)quest.Degree;
qmodel.Text = quest.Answer.Trim();
// Check Type Of Quest To select Display Method
if (quest.Type.ToLower().Trim() == "tf")
{
// case 1: TF
// don't need ans group
comboBox3.SelectedIndex = 1;
}
else if (quest.Type.ToLower().Trim() == "mcq")
{
comboBox3.SelectedIndex = 0;
List <string> chList = new List <string>(4);
ansGroup.Show();
var choices = ent.Select_MCQ_Question(quest.QuesId).ToList();
TextBox[] textBoxes = { ansA, ansB, ansC, ansD };
for (int i = 0; i < choices.Count; i++)
{
textBoxes[i].Text = choices[i].body;
}
}
viewAnswerGroup();
}
// Delete
private void button3_Click(object sender, EventArgs e)
{
int examId = 0;
if (comboBox1.SelectedItem != null)
{
examId = int.Parse(comboBox1.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("There Is No Exam Selected");
return;
}
OnlineExam ent = new OnlineExam();
var exam = (from ex in ent.Exams
where ex.Enumber == examId
select ex).First();
int crsId = (int)exam.CrsId;
ent.Exams.Remove(exam);
ent.SaveChanges();
comboBox1.Text = comboBox2.Text = string.Empty;
loadCourse();
loadExams(crsId);
}
private void deleteQuestion()
{
int questId = 0;
if (comboBox2.SelectedItem != null)
{
questId = int.Parse(comboBox2.Text.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("Please select course id", "Waring");
return;
}
OnlineExam ent = new OnlineExam();
var ques = (from q in ent.Questions
where q.QuesId == questId
select q).First();
int courseId = (int)ques.CrsId;
try
{
ent.Delete_Question(questId);
}
catch (Exception)
{
}
loadCourse();
loadQuestions(courseId);
}
private void insertChoicesForQuestById(int questID)
{
OnlineExam ent = new OnlineExam();
if (!isChoiceDataValid())
{
MessageBox.Show("Please Enter All Data Rrequired", "Waring");
return;
}
Dictionary <string, TextBox> choices = new Dictionary <string, TextBox>(4);
choices.Add("a", ansA);
choices.Add("b", ansB);
choices.Add("c", ansC);
choices.Add("d", ansD);
foreach (var item in choices)
{
Ques_Choices ques_Choices = new Ques_Choices()
{
QuesId = questID,
choices = item.Key,
body = item.Value.Text.Trim()
};
ent.Ques_Choices.Add(ques_Choices);
}
ent.SaveChanges();
ansA.Text = ansB.Text = ansC.Text = ansD.Text = string.Empty;
}
private void deletePrevGradeIfExist()
{
OnlineExam exam = new OnlineExam();
var msg = exam.deletePrevGrade(studentID, examID);
exam.SaveChanges();
}
private void Manager_Home_Form_Load(object sender, EventArgs e)
{
OnlineExam ent = new OnlineExam();
var inst = (from n in ent.Instructors where n.InsId == managerID select n).First();
label2.Text = inst.InsId.ToString();
label4.Text = inst.InsName;
}
private void button2_Click(object sender, EventArgs e)
{
int questID = 0;
int crsID = 0;
if (comboBox2.SelectedItem != null)
{
questID = int.Parse(comboBox2.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("Please select quest id", "Waring");
}
if (comboBox1.SelectedItem != null)
{
crsID = int.Parse(comboBox1.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("Please select course id", "Waring");
return;
}
if (!isQuestDataValid())
{
MessageBox.Show("Please Enter Valid Data", "Waring");
return;
}
string qbody = qcont.Text.Trim();
int qdeg = (int)qdegree.Value;
string modelAns = qmodel.Text.Trim();
OnlineExam ent = new OnlineExam();
var quest = (from q in ent.Questions
where q.QuesId == questID
select q).First();
quest.Qcontent = qbody;
quest.Answer = modelAns;
quest.Degree = qdeg;
if (quest.Type.ToLower().Trim() == "mcq")
{
updateChoice(questID);
}
ent.SaveChanges();
loadCourse();
loadQuestions(crsID);
questionInfo(questID);
qcont.Text = qmodel.Text = string.Empty;
qdegree.Value = 1;
comboBox3.Text = string.Empty;
}
private void Courses_List_Load(object sender, EventArgs e)
{
OnlineExam ent = new OnlineExam();
var student = (from s in ent.Students
where s.Sid == studentID
select s).First();
var list = ent.getCoursesByDeptID(student.DeptId).ToList();
dataGridView1.DataSource = list;
}
private void loadCourse()
{
OnlineExam ent = new OnlineExam();
var crs = ent.getInsCourses(instructorID);
comboBox1.Items.Clear();
foreach (var item in crs)
{
comboBox1.Items.Add($"{item.CrsId}, {item.CrsName}");
}
}
private void checkIfNotFirstExam()
{
try
{
OnlineExam exam = new OnlineExam();
var msg = exam.deleteStudentExam(studentID, examID);
}
catch (Exception)
{
return;
}
}
private void Instructor_operations_Load(object sender, EventArgs e)
{
OnlineExam ent = new OnlineExam();
var inst = ent.Select_Instructor(instructorID).First();
var dept = (from d in ent.Departments
where d.DeptId == inst.Department_ID
select d).First();
label2.Text = inst.Instructor_ID.ToString();
label4.Text = inst.Instructor_name;
label6.Text = dept.DeptName;
}
private bool isNumberOfTFRange(int crsId, int numOfTF)
{
OnlineExam online = new OnlineExam();
var mcqList = from mcq in online.Questions
where mcq.CrsId == crsId && mcq.Type == "mcq"
select mcq;
if (numOfTF > mcqList.Count())
{
return(true);
}
return(false);
}
// add
private void button1_Click(object sender, EventArgs e)
{
OnlineExam ent = new OnlineExam();
int crsId = 0;
string desc = textBox2.Text;
if (comboBox2.SelectedItem != null)
{
crsId = int.Parse(comboBox2.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("invalid Course ID entred", "Waring");
return;
}
int nMcq = (int)numericUpDown1.Value;
if (isNumberOfMcqOutOfRange(crsId, nMcq))
{
MessageBox.Show("The Number Is out of Range\nplease go and insert more Question to Continue", "Waring");
return;
}
int nTF = (int)numericUpDown2.Value;
if (isNumberOfTFRange(crsId, nTF))
{
MessageBox.Show("The Number Is out of Range\nplease go and insert more Question to Continue", "Waring");
return;
}
int duration = (int)numericUpDown3.Value;
Exam exam = new Exam()
{
CrsId = crsId,
Edescription = desc,
NumOfMcq = nMcq,
NumOfTF = nTF,
Eduration = duration,
Edate = DateTime.Now
};
ent.Exams.Add(exam);
ent.SaveChanges();
comboBox1.Text = comboBox2.Text = textBox2.Text = string.Empty;
numericUpDown1.Value = numericUpDown2.Value = numericUpDown3.Value = 0;
loadCourse();
loadExams(crsId);
}
private void LoadCoureses()
{
OnlineExam ent = new OnlineExam();
var student = (from s in ent.Students
where s.Sid == studentID
select s).First();
var Courses = ent.getCoursesByDeptID(student.DeptId);
listBox1.Items.Clear();
foreach (var item in Courses)
{
listBox1.Items.Add(item.CrsName);
}
}
private void StudentDashbord_Load(object sender, EventArgs e)
{
OnlineExam ent = new OnlineExam();
var student = ent.Select_Student(id).First();
IDValue.Text = student.Student_ID.ToString();
NameValue.Text = student.Student_Name;
addressValue.Text = student.Home_City;
var deptName = (from d in ent.Departments
where d.DeptId == student.Department_ID
select d).First();
dept.Text = deptName.DeptName;
}
private void loadExams(int crsID)
{
OnlineExam ent = new OnlineExam();
var exams = from ex in ent.Exams
where ex.CrsId == crsID
select ex;
dataGridView1.DataSource = exams.ToList();
comboBox1.Items.Clear();
foreach (var item in exams)
{
string exam = $"{item.Enumber}, {item.Edescription}";
comboBox1.Items.Add(exam);
}
}
private void loadSingleExamInfo(int examId)
{
OnlineExam ent = new OnlineExam();
var exam = (from e in ent.Exams
where e.Enumber == examId
select e).First();
// desc
textBox2.Text = exam.Edescription;
// number of Mcq
numericUpDown1.Value = (int)exam.NumOfMcq;
// number of Tf
numericUpDown2.Value = (int)exam.NumOfTF;
// duration
numericUpDown3.Value = (int)exam.Eduration;
}
private void loadQuestions(int crsID)
{
OnlineExam ent = new OnlineExam();
var quesList = from q in ent.Questions
where q.CrsId == crsID
select q;
dataGridView1.DataSource = quesList.ToList();
comboBox2.Items.Clear();
foreach (var item in quesList)
{
string ques = $"{item.QuesId}, {item.Type}";
comboBox2.Items.Add(ques);
}
}
private void loadExam()
{
OnlineExam ent = new OnlineExam();
/// Generate Exam Quesstions
var examQuestions = ent.generateExam(examID);
examBody = examQuestions.ToList();
StudentAnswersSheet = new Dictionary <int, string>(examBody.Count);
// show Exam Info
var exam = (from e in ent.Exams
where e.Enumber == examID
select e).First();
examNameValue.Text = exam.Edescription.Trim();
timerValue.Text = exam.Eduration.ToString() + 'M';
}
private void login(int id, string name)
{
OnlineExam ent = new OnlineExam();
try
{
var student = (from s in ent.Students
where s.Sid == id && s.Fname == name
select s).First();
this.Close();
StudentDashbord dashbord = new StudentDashbord(student.Sid);
dashbord.Show();
}
catch (Exception)
{
MessageBox.Show("Not Authroized", "Access Denaied");
}
}
private void login(int id, string name)
{
OnlineExam ent = new OnlineExam();
try
{
var inst = (from s in ent.Instructors
where s.InsId == id && s.InsName == name
select s).First();
this.Close();
Instructor_operations instructor = new Instructor_operations(inst.InsId);
this.Close();
instructor.Show();
}
catch (Exception)
{
MessageBox.Show("Not Authroized", "Access Denaied");
}
}
private void updateChoice(int QuestID)
{
OnlineExam ent = new OnlineExam();
if (!isChoiceDataValid())
{
MessageBox.Show("Please Enter All Data Rrequired", "Waring");
return;
}
var chlist = ent.Select_MCQ_Question(QuestID).ToList();
chlist[0].body = ansA.Text;
chlist[1].body = ansB.Text;
chlist[2].body = ansC.Text;
chlist[3].body = ansD.Text;
ent.SaveChanges();
ansA.Text = ansB.Text = ansC.Text = ansD.Text = string.Empty;
}
private void loadMcqChoices(int questionID)
{
flowLayoutPanel2.Controls.Clear();
flowLayoutPanel2.FlowDirection = FlowDirection.TopDown;
OnlineExam onlineExam = new OnlineExam();
var ques_Choices = from c in onlineExam.Ques_Choices
where c.QuesId == questionID
select c;
foreach (var item in ques_Choices)
{
RadioButton radio = new RadioButton();
string answer = $"{item.choices}) {item.body}";
radio.Text = answer;
radio.Size = new Size(200, 40);
radio.Font = new Font("Microsoft Sans Serif", 16);
radio.CheckedChanged += new System.EventHandler(getAnswer);
flowLayoutPanel2.Controls.Add(radio);
}
}
private void button1_Click(object sender, EventArgs e)
{
int crsID = 0;
if (comboBox1.SelectedItem != null)
{
crsID = int.Parse(comboBox1.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("Please select course id", "Waring");
return;
}
if (!isQuestDataValid())
{
MessageBox.Show("Please Enter Valid Data", "Waring");
return;
}
string qbody = qcont.Text.Trim();
string qtype = comboBox3.SelectedItem.ToString();
int qdeg = (int)qdegree.Value;
string modelAns = qmodel.Text.Trim();
OnlineExam ent = new OnlineExam();
var last = ent.insertQuest(qtype, qdeg, qbody, modelAns, crsID).First();
////////////////////////////////////////////////////////////////////
if (last.Type.ToLower() == "mcq")
{
insertChoicesForQuestById(last.QuesId);
}
loadCourse();
loadQuestions(crsID);
qcont.Text = qmodel.Text = string.Empty;
qdegree.Value = 1;
comboBox3.Text = string.Empty;
}
private void finish_Click(object sender, EventArgs e)
{
OnlineExam exam = new OnlineExam();
checkIfNotFirstExam();
foreach (var item in StudentAnswersSheet)
{
exam.Insert_Std_Answer(studentID, examID, item.Key, item.Value);
}
var res = exam.Calc_Student_Exam_Grade(studentID, examID).First();
deletePrevGradeIfExist();
exam.saveStudentGrade(studentID, examID, res.grade);
MessageBox.Show($"Your Grade {res.grade}, and Degree {res.student_answer_degrees}", "Your Resault");
StudentDashbord dashbord = new StudentDashbord(studentID);
this.Close();
dashbord.Show();
}
private void loadAvialbleExams(string cname)
{
OnlineExam ent = new OnlineExam();
var course = ent.Select_Course_byName(cname).First();
int cid = course.Course_ID;
var exames = from ex in ent.Exams
where ex.CrsId == cid
select ex;
if (exames.Count() == 0)
{
flowLayoutPanel1.Controls.Clear();
comboBox1.Items.Clear();
comboBox1.Text = string.Empty;
Label nolabel = new Label();
nolabel.Text = "There Is No Exams Available";
nolabel.Size = new Size(350, 30);
nolabel.ForeColor = Color.FromArgb(239, 155, 25);
nolabel.Font = new Font("Microsoft Sans Serif", 18);
flowLayoutPanel1.Controls.Add(nolabel);
ExamID = -1;
StartButtonStatus();
}
else
{
flowLayoutPanel1.Controls.Clear();
comboBox1.Items.Clear();
foreach (var item in exames)
{
string exam = $"{item.Enumber}, {item.Edescription}";
comboBox1.Items.Add(exam);
}
}
}
// update
private void Update_Click(object sender, EventArgs e)
{
int examId = 0;
int crsId = 0;
OnlineExam ent = new OnlineExam();
if (comboBox2.SelectedItem != null)
{
crsId = int.Parse(comboBox2.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("invalid Course ID entred", "Waring");
return;
}
if (comboBox1.SelectedItem != null)
{
examId = int.Parse(comboBox1.SelectedItem.ToString().Split(',')[0]);
}
else
{
MessageBox.Show("There Is No Exam Selected");
return;
}
if (!isDataValid())
{
MessageBox.Show("There is Data Is Missing", "Waring");
return;
}
string desc = textBox2.Text;
int nMcq = (int)numericUpDown1.Value;
if (isNumberOfMcqOutOfRange(crsId, nMcq))
{
MessageBox.Show("The Number Is out of Range\nplease go and insert more Question to Continue", "Waring");
return;
}
int nTF = (int)numericUpDown2.Value;
if (isNumberOfTFRange(crsId, nTF))
{
MessageBox.Show("The Number Is out of Range\nplease go and insert more Question to Continue", "Waring");
return;
}
int duration = (int)numericUpDown3.Value;
if (duration < 10)
{
MessageBox.Show("Mim Duration is 10 Min");
return;
}
var exam = (from ex in ent.Exams
where ex.Enumber == examId
select ex).First();
exam.Edescription = desc;
exam.Eduration = duration;
exam.NumOfMcq = nMcq;
exam.NumOfTF = nTF;
ent.SaveChanges();
comboBox1.Text = comboBox2.Text = textBox2.Text = string.Empty;
numericUpDown1.Value = numericUpDown2.Value = numericUpDown3.Value = 0;
loadCourse();
loadExams(crsId);
}
