// Update
private void Update_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("Enter your StudentId");
}
else
{
try
{
using (Online_Exame ent = new Online_Exame())
{
var ins = ent.Instractors.Find(ins_id);
int Ins_dept = (int)ins.Dept_id;
Student student = ent.Students.Find(int.Parse(comboBox1.Text));
ent.UpdateStudent(student.St_id, txtFname.Text, txtLname.Text,
txtaddress.Text, int.Parse(txtage.Text), txtEmail.Text, Ins_dept);
comboBox1.Text = txtFname.Text = txtLname.Text = txtEmail.Text = txtage.Text
= txtaddress.Text = string.Empty;
MessageBox.Show("Updated successfully");
loadDataGrid();
}
}
catch (NullReferenceException)
{
MessageBox.Show("Incorrect ID");
}
catch (FormatException)
{
MessageBox.Show("Invaild Format");
}
}
}
//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;
}
Online_Exame ent = new Online_Exame();
var exam = (from ex in ent.Exams
where ex.Ex_id == examId
select ex).First();
comboBox1.Text = comboBox2.Text = textBox1.Text = string.Empty;
numericUpDown1.Value = numericUpDown2.Value = numericUpDown3.Value = 0;
int crsId = (int)exam.C_id;
ent.Exams.Remove(exam);
ent.SaveChanges();
loadCourses();
loadExam(crsId);
}
private void loadEaxam(int cId)
{
Online_Exame exam = new Online_Exame();
var course = from c in exam.courses where c.C_id == cId select c;
var exames = from ex in exam.Exams
where ex.C_id == 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(55, 187, 77);
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 exams = $"{item.Ex_id}, {item.Ex_Des}";
comboBox1.Items.Add(exams);
}
}
}
// Search
private void Search_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("Enter your TopicId");
}
else
{
try
{
using (Online_Exame ent = new Online_Exame())
{
var Topic = ent.Topics.Find(int.Parse(comboBox1.Text));
textBox1.Text = Topic.Name;
}
}
catch (InvalidOperationException)
{
MessageBox.Show("Incorrect ID");
}
catch (FormatException)
{
MessageBox.Show("Incorrect ID");
}
}
}
private void loadQuestion(int index)
{
flowLayoutPanel2.FlowDirection = FlowDirection.TopDown;
Online_Exame ex = new Online_Exame();
currentIndex = index;
ButtonsStates();
flowLayoutPanel2.Controls.Clear();
getExam_Question_Result q = list[index];
labelQuestion.Text = $"{index + 1}) {q.Qustion}";
NumQuest.Text = $"{index + 1} / {list.Count}";
var choices = from c in ex.Choices
where c.Quset_id == q.Quest_Id
select c;
foreach (var item in choices)
{
RadioButton radio = new RadioButton();
radio.CheckedChanged += new System.EventHandler(getAnswer);
string answer = item.ch_id + ") " + item.choices;
radio.Text = answer;
radio.Size = new Size(200, 20);
flowLayoutPanel2.Controls.Add(radio);
}
}
//--login buuton
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Please enter your Id");
}
else
{
try
{
inputId = int.Parse(textBox1.Text);
Online_Exame ent = new Online_Exame();
var item = (from d in ent.Departments
where d.Dept_manger == inputId
select d).First();
this.Close();
MangerHome mn = new MangerHome();
mn.Show();
}
catch (InvalidOperationException)
{
MessageBox.Show("Incorrect ID");
}
catch (FormatException)
{
MessageBox.Show("Incorrect ID");
}
}
}
// Search
private void Search_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("Enter your StudentId");
}
else
{
try
{
using (Online_Exame ent = new Online_Exame())
{
Student student = ent.Students.Find(int.Parse(comboBox1.Text));
txtFname.Text = student.St_fname;
txtLname.Text = student.St_lname;
txtEmail.Text = student.Email;
txtage.Text = student.Age.ToString();
txtaddress.Text = student.Address;
}
}
catch (InvalidOperationException)
{
MessageBox.Show("Incorrect ID");
}
catch (FormatException)
{
MessageBox.Show("Incorrect ID");
}
}
}
private void insertChoicesForQuestById(int questID)
{
Online_Exame ent = new Online_Exame();
if (!isChoiceDataValid())
{
MessageBox.Show("Please Enter All Data Rrequired", "Waring");
return;
}
TextBox[] ch = { ans1, ans2, ans3, ans4 };
for (int i = 0; i < ch.Length; i++)
{
Choice chois = new Choice()
{
ch_id = i,
Quset_id = questID,
choices = ch[i].Text
};
ent.Choices.Add(chois);
}
ent.SaveChanges();
ans1.Text = ans2.Text = ans3.Text = ans4.Text = string.Empty;
}
//--- add course
private void button1_Click(object sender, EventArgs e)
{
comboBox1.Text = string.Empty;
try
{
using (Online_Exame ent = new Online_Exame())
{
ent.InsertNewCourse(textBox1.Text);
ent.SaveChanges();
MessageBox.Show("Added Successfully");
Courses.Items.Clear();
Instructors.Items.Clear();
label7.Text = comboBox1.Text = comboBox3.Text = textBox1.Text = string.Empty;
LoadCourses();
}
}
catch (FormatException)
{
MessageBox.Show("Please complete the information");
}
catch (InvalidOperationException)
{
MessageBox.Show("Invalid Information");
}
}
private void Course_List_Load(object sender, EventArgs e)
{
Online_Exame exam = new Online_Exame();
var grade = exam.Examresults(stdId);
dataGridView1.DataSource = grade;
}
private void finish_Click(object sender, EventArgs e)
{
Online_Exame ex = new Online_Exame();
IfStdExameExestBefor();
foreach (var item in StudentAnswers)
{
//var msg = ex.NewStudentExam(studentID, item.Key, examID, 0, item.Value);
Student_Exam se = new Student_Exam()
{
St_id = studentID,
Ex_id = examID,
Q_id = item.Key,
Result = 0,
St_answer = item.Value
};
ex.Student_Exam.Add(se);
ex.SaveChanges();
}
ex.ExamCorrection(studentID, examID);
var res = ex.ExamRes(studentID, examID).First();
MessageBox.Show($"your grade {res}");
StudentDashbord std = new StudentDashbord(studentID);
this.Close();
std.Show();
}
// Delete
private void Delete_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("Enter your StudentId");
}
else
{
try
{
using (Online_Exame ent = new Online_Exame())
{
Student student = ent.Students.Find(int.Parse(comboBox1.Text));
//ent.deleteStudent(student.St_id);
ent.Students.Remove(student);
ent.SaveChanges();
MessageBox.Show("Deleted Successfully");
load();
loadDataGrid();
}
}
catch (NullReferenceException)
{
MessageBox.Show("Incorrect ID");
}
catch (FormatException)
{
MessageBox.Show("Invaild Format");
}
}
}
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 = textBox1.Text.Trim();
int qdeg = (int)numericUpDown1.Value;
int modelAns = int.Parse(textBox2.Text.Trim());
Online_Exame ent = new Online_Exame();
var quest = (from q in ent.Questions
where q.Quest_id == questID
select q).First();
quest.Qustion = qbody;
quest.CorectAnswer = modelAns;
quest.Grade = qdeg;
if (quest.Type.ToLower().Trim() == "mcq")
{
updateChoice(questID);
}
ent.SaveChanges();
LoadCourses();
loadQuestions(crsID);
questionInfo(questID);
textBox1.Text = textBox2.Text = string.Empty;
ans1.Text = ans2.Text = ans3.Text = ans4.Text = string.Empty;
numericUpDown1.Value = 1;
comboBox3.Text = string.Empty;
}
// display department instructors in grid view
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
int deptId = (int)comboBox1.SelectedItem;
using (Online_Exame ent = new Online_Exame())
{
dataGridView1.DataSource = ent.Get_instructor_by_deptId(deptId);
}
}
private void examDetails(int exId)
{
Online_Exame exam = new Online_Exame();
var data = (from e in exam.Exams where e.Ex_id == exId select e).First();
textBox1.Text = data.Ex_Des;
numericUpDown1.Value = int.Parse(data.T_F.ToString());
numericUpDown2.Value = int.Parse(data.MC.ToString());
numericUpDown3.Value = int.Parse(data.Duration.ToString());
}
private void loadCourses()
{
comboBox2.Items.Clear();
Online_Exame exam = new Online_Exame();
var cour = exam.getInsCourses(inst);
foreach (var item in cour)
{
comboBox2.Items.Add($"{item.C_id} , {item.C_name}");
}
}
//function to load Dept ids
private void LoadDepartments()
{
comboBox1.Items.Clear();
Online_Exame ent = new Online_Exame();
var deptids = from v in ent.Departments
select v.Dept_id;
foreach (var i in deptids)
{
comboBox1.Items.Add(i);
}
}
// display choosen instructor information
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
int insId = (int)comboBox2.SelectedItem;
Online_Exame ent = new Online_Exame();
var item = (from d in ent.Instractors
where d.Ins_id == insId
select d).First();
textBox1.Text = item.Ins_fname;
textBox2.Text = item.Ins_lname;
comboBox1.SelectedItem = item.Dept_id;
}
// Add
private void Add_Click(object sender, EventArgs e)
{
if (txtFname.Text == "")
{
MessageBox.Show("Please enter your Fname");
}
else if (txtLname.Text == "")
{
MessageBox.Show("Please enter your Lname");
}
else if (txtEmail.Text == "")
{
MessageBox.Show("Please enter your Email");
}
else if (txtage.Text == "")
{
MessageBox.Show("Please enter your Age");
}
else if (txtaddress.Text == "")
{
MessageBox.Show("Please enter your Address");
}
else
{
try
{
using (Online_Exame ent = new Online_Exame())
{
var ins = ent.Instractors.Find(ins_id);
int Ins_dept = (int)ins.Dept_id;
/* ent.insertNewStudent(txtFname.Text, txtLname.Text,
* txtaddress.Text, int.Parse(txtage.Text), txtEmail.Text, Ins_dept);*/
Student std = new Student();
std.St_fname = txtFname.Text;
std.St_lname = txtLname.Text;
std.Address = txtaddress.Text;
std.Age = int.Parse(txtage.Text);
std.Email = txtEmail.Text;
std.Dept_id = Ins_dept;
ent.Students.Add(std);
ent.SaveChanges();
MessageBox.Show("Added Successfully");
load();
loadDataGrid();
}
}
catch (FormatException)
{
MessageBox.Show("Invalid format");
}
}
}
public void load()
{
using (Online_Exame ent = new Online_Exame())
{
comboBox2.Items.Clear();
var crs = ent.getInstractor_Course(ins_id).ToList();
foreach (var item in crs)
{
comboBox2.Items.Add(item);
}
}
}
private void LoadCourses()
{
comboBox1.Items.Clear();
Online_Exame ent = new Online_Exame();
var crsid = from v in ent.courses
select v.C_id;
foreach (var i in crsid)
{
comboBox1.Items.Add(i);
}
}
//function to load instructor ids
private void Loadinstructor()
{
dataGridView1.DataSource = null;
comboBox2.Items.Clear();
Online_Exame ent = new Online_Exame();
var insids = from v in ent.Instractors
select v.Ins_id;
foreach (var i in insids)
{
comboBox2.Items.Add(i);
}
}
//----- on form load fill combo boxes
private void MangeCourses_Load(object sender, EventArgs e)
{
Online_Exame ent = new Online_Exame();
LoadCourses();
var insnames = from v in ent.Instractors
select v.Ins_fname + " " + v.Ins_lname;
foreach (var i in insnames)
{
comboBox3.Items.Add(i);
}
}
public StudentDashbord(int id)
{
InitializeComponent();
this.id = id;
Online_Exame exam = new Online_Exame();
var student = (from s in exam.Students
where s.St_id == id
select s).First();
label2.Text = student.St_id.ToString();
label3.Text = student.St_fname + ' ' + student.St_lname;
label5.Text = student.Address;
}
private void LoadCourses()
{
Online_Exame exam = new Online_Exame();
var std = (from s in exam.Instractors where s.Ins_id == inst select s).First();
var course = exam.getCoursesByDeptID(std.Dept_id).ToList();
foreach (var item in course)
{
string cour = item.C_id + "," + item.C_name;
comboBox1.Items.Add(cour);
}
}
private void LoadCourses()
{
Online_Exame exam = new Online_Exame();
var std = (from s in exam.Students where s.St_id == stdID select s).First();
var course = exam.getCoursesByDeptID(std.Dept_id).ToList();
foreach (var item in course)
{
string cour = item.C_id + "," + item.C_name;
listBox1.Items.Add(cour);
}
}
private void IfStdExameExestBefor()
{
try
{
Online_Exame ex = new Online_Exame();
var msg = ex.deleteStudentExam(studentID, examID);
ex.SaveChanges();
}
catch (Exception)
{
return;
}
}
public InstructorOperation(int id)
{
InitializeComponent();
this.inst = id;
Online_Exame exam = new Online_Exame();
var student = (from s in exam.Instractors
where s.Ins_id == id
select s).First();
label2.Text = student.Ins_id.ToString();
label4.Text = student.Ins_fname + ' ' + student.Ins_lname;
label5.Text = student.Dept_id.ToString();
}
private void LoadExam()
{
Online_Exame exams = new Online_Exame();
var examQuest = exams.getExam_Question(examID);
list = examQuest.ToList();
StudentAnswers = new Dictionary <int, string>(list.Count);
// show Exam details
var examInfo = (from e in exams.Exams where e.Ex_id == examID select e).First();
label1.Text = examInfo.Ex_Des.Trim();
label2.Text = examInfo.Duration.ToString() + "M";
}
private void Login(int id, string email)
{
try
{
Online_Exame exam = new Online_Exame();
var std = (from s in exam.Students where s.St_id == id & s.Email == email select s).First();
StudentDashbord Student = new StudentDashbord(std.St_id);
Student.Show();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Not Autho");
}
}
