protected void grd_students_RowCommand(object sender, GridViewCommandEventArgs e)
{
int _studentId = int.Parse(e.CommandArgument.ToString());
string _actionName = e.CommandName;
if (_actionName == "DeleteStudent")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Student _student = _context.Students.Where(a => a.St_Id == _studentId).FirstOrDefault();
if (_student.Exams.Count == 0 && _student.Stud_Course.Count == 0)
{
_context.Students.Remove(_student);
_context.SaveChanges();
show_students();
lbl_meesage.Text = "";
}
else
{
lbl_meesage.Text = "Student " + _student.St_Fname + " Can't be deleted !";
}
}
else if (_actionName == "EditCurrentStudent")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Student _student = _context.Students.Where(a => a.St_Id == _studentId).FirstOrDefault();
txt_fname.Text = _student.St_Fname;
txt_lname.Text = _student.St_Lname;
txt_age.Text = _student.St_Age.ToString();
txt_address.Text = _student.St_Address;
ddl_dept.SelectedValue = _student.Dept_Id.ToString();
btn_save.Text = "Update";
st_hidden_id.Value = _studentId.ToString();
}
}
protected void grd_topics_RowCommand(object sender, GridViewCommandEventArgs e)
{
int _TopicId = int.Parse(e.CommandArgument.ToString());
string _actionName = e.CommandName;
if (_actionName == "DeleteTopic")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Topic _Topic = _context.Topics.Where(a => a.Top_Id == _TopicId).FirstOrDefault();
_context.Topics.Remove(_Topic);
_context.SaveChanges();
show_topics();
}
else if (_actionName == "EditCurrentTopic")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Topic _Topic = _context.Topics.Where(a => a.Top_Id == _TopicId).FirstOrDefault();
txt_topic_id.Text = _Topic.Top_Id.ToString();
txt_topic_name.Text = _Topic.Top_Name;
ddl_coursename.SelectedValue = _Topic.Crs_Id.ToString();
btn_save_topic.Text = "Update";
Topic_Hidden_id.Value = _TopicId.ToString();
}
}
protected void grd_Questions_RowCommand(object sender, GridViewCommandEventArgs e)
{
int _QuestionId = int.Parse(e.CommandArgument.ToString());
string _actionName = e.CommandName;
if (_actionName == "DeleteQuestion")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Question _Question = _context.Questions.Where(a => a.Qstn_Id == _QuestionId).FirstOrDefault();
if (_Question.Choices.Count == 0 && _Question.Exam_Question.Count == 0)
{
_context.Questions.Remove(_Question);
_context.SaveChanges();
show_Questions();
}
else
{
lbl_msg_q.Text = "this Question can't be deleted";
}
}
else if (_actionName == "EditCurrentQuestion")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Question _Question = _context.Questions.Where(a => a.Qstn_Id == _QuestionId).FirstOrDefault();
txt_qid.Text = _Question.Qstn_Id.ToString();
txt_qtext.Text = _Question.Qstn_Text;
txt_qtype.Text = _Question.Qstn_Type;
txt_qanswer.Text = _Question.Qstn_Answer;
ddl_courses.SelectedValue = _Question.Crs_Id.ToString();
btn_save_Q.Text = "Update";
Q_hidden_id.Value = _QuestionId.ToString();
}
}
protected void btn_save_topic_Click(object sender, EventArgs e)
{
if (btn_save_topic.Text == "Save")
{
Topic new_topic = new Topic();
new_topic.Top_Id = int.Parse(txt_topic_id.Text);
new_topic.Top_Name = txt_topic_name.Text;
new_topic.Crs_Id = int.Parse(ddl_coursename.SelectedValue);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
_container.Topics.Add(new_topic);
_container.SaveChanges();
show_courses();
show_topics();
clear_all();
}
else
{
int Topic_Id = int.Parse(Topic_Hidden_id.Value);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
Topic topic_update = _container.Topics.Where(a => a.Top_Id == Topic_Id).FirstOrDefault();
topic_update.Top_Id = int.Parse(txt_topic_id.Text);
topic_update.Top_Name = txt_topic_name.Text;
topic_update.Crs_Id = int.Parse(ddl_coursename.SelectedValue);
_container.SaveChanges();
show_topics();
clear_all();
btn_save_topic.Text = "Save";
}
}
protected void grd_instructors_RowCommand(object sender, GridViewCommandEventArgs e)
{
int _InstructorId = int.Parse(e.CommandArgument.ToString());
string _actionName = e.CommandName;
if (_actionName == "DeleteInstructor")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Instructor _Instructor = _context.Instructors.Where(a => a.Ins_Id == _InstructorId).FirstOrDefault();
if (_Instructor.Ins_Course.Count == 0)
{
_context.Instructors.Remove(_Instructor);
_context.SaveChanges();
show_instructors();
}
else
{
lbl_msg_instructor.Text = "instructor" + _Instructor.Ins_Name + "can't be deleted";
}
}
else if (_actionName == "EditCurrentInstructor")
{
OnlineExamsProjectDBEntities _context = new OnlineExamsProjectDBEntities();
Instructor _Instructor = _context.Instructors.Where(a => a.Ins_Id == _InstructorId).FirstOrDefault();
txt_ins_id.Text = _Instructor.Ins_Id.ToString();
txt_ins_name.Text = _Instructor.Ins_Name;
txt_ins_degree.Text = _Instructor.Ins_Degree;
txt_ins_salary.Text = _Instructor.Salary.ToString();
ddl_department.SelectedValue = _Instructor.Dept_Id.ToString();
btn_save_instructor.Text = "Update";
Instructor_Hidden_id.Value = _InstructorId.ToString();
}
}
public void show_departments()
{
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
List <Department> all_departments = _container.Departments.ToList();
ddl_dept.DataSource = all_departments;
ddl_dept.DataBind();
}
public void show_students()
{
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
List <Student> all_students = _container.Students.ToList();
grd_students.DataSource = all_students;
grd_students.DataBind();
}
public void show_topics()
{
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
List <Topic> alltopics = _container.Topics.ToList();
grd_topics.DataSource = alltopics;
grd_topics.DataBind();
}
public void show_courses()
{
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
List <Course> allcourses = _container.Courses.ToList();
ddl_coursename.DataSource = allcourses;
ddl_coursename.DataBind();
}
public void show_Questions()
{
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
List <Question> allQuestions = _container.Questions.ToList();
grd_Questions.DataSource = allQuestions;
grd_Questions.DataBind();
}
public void show_instructors()
{
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
List <Instructor> allinstructors = _container.Instructors.ToList();
grd_instructors.DataSource = allinstructors;
grd_instructors.DataBind();
}
protected void btn_save_Q_Click(object sender, EventArgs e)
{
if (btn_save_Q.Text == "Save")
{
Question new_question = new Question();
new_question.Qstn_Text = txt_qtext.Text;
lbl_Qtype.Text = "";
if (txt_qtype.Text == "MCQ" || txt_qtype.Text == "TFQ")
{
new_question.Qstn_Type = txt_qtype.Text;
}
else
{
lbl_Qtype.Text = "Must be MCQ or TFQ";
}
if (txt_qanswer.Text == "a" || txt_qanswer.Text == "b" ||
txt_qanswer.Text == "c" || txt_qanswer.Text == "d" ||
txt_qanswer.Text == "TRUE" || txt_qanswer.Text == "FALSE")
{
new_question.Qstn_Answer = txt_qanswer.Text;
lbl_Qanswer.Text = "";
}
else
{
lbl_Qanswer.Text = "value must be a,b,c,d,TRUE,FALSE";
}
new_question.Qstn_Id = int.Parse(txt_qid.Text);
new_question.Crs_Id = int.Parse(ddl_courses.SelectedValue);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
_container.Questions.Add(new_question);
_container.SaveChanges();
show_courses();
show_Questions();
clearvalues();
}
else
{
int Question_Id = int.Parse(Q_hidden_id.Value);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
Question Q_update = _container.Questions.Where(a => a.Qstn_Id == Question_Id).FirstOrDefault();
Q_update.Qstn_Text = txt_qtext.Text;
Q_update.Qstn_Type = txt_qtype.Text;
Q_update.Qstn_Answer = txt_qanswer.Text;
_container.SaveChanges();
show_Questions();
clearvalues();
btn_save_Q.Text = "Save";
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (btn_save.Text == "Save")
{
Student new_student = new Student();
new_student.St_Fname = txt_fname.Text;
new_student.St_Lname = txt_lname.Text;
new_student.St_Address = txt_address.Text;
new_student.St_Age = int.Parse(txt_age.Text);
new_student.Dept_Id = int.Parse(ddl_dept.SelectedValue);
//add to DB that object
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
_container.Students.Add(new_student);
_container.SaveChanges();
//to add reload grid view by new data inserted from DB
show_students();
show_departments();
clear_values();
}
else //btn_save.Text == "Update"
{
//when reload ..keep id value in hidden value to update by this id
int student_Id = int.Parse(st_hidden_id.Value);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
Student stu_update = _container.Students.Where(a => a.St_Id == student_Id).FirstOrDefault();
stu_update.St_Fname = txt_fname.Text;
stu_update.St_Lname = txt_lname.Text;
stu_update.St_Age = int.Parse(txt_age.Text);
stu_update.St_Address = txt_address.Text;
_container.SaveChanges();
show_students();
clear_values();
btn_save.Text = "Save";
}
}
protected void btn_save_instructor_Click(object sender, EventArgs e)
{
if (btn_save_instructor.Text == "Save")
{
Instructor new_instructor = new Instructor();
new_instructor.Ins_Name = txt_ins_name.Text;
new_instructor.Ins_Id = int.Parse(txt_ins_id.Text);
new_instructor.Ins_Degree = txt_ins_degree.Text;
new_instructor.Salary = int.Parse(txt_ins_salary.Text);
new_instructor.Dept_Id = int.Parse(ddl_department.SelectedValue);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
_container.Instructors.Add(new_instructor);
_container.SaveChanges();
show_departments();
show_instructors();
clear_ins();
}
else
{
int Instructor_Id = int.Parse(Instructor_Hidden_id.Value);
OnlineExamsProjectDBEntities _container = new OnlineExamsProjectDBEntities();
Instructor Instructor_update = _container.Instructors.Where(a => a.Ins_Id == Instructor_Id).FirstOrDefault();
Instructor_update.Ins_Id = int.Parse(txt_ins_id.Text);
Instructor_update.Ins_Name = txt_ins_name.Text;
Instructor_update.Ins_Degree = txt_ins_degree.Text;
Instructor_update.Salary = int.Parse(txt_ins_salary.Text);
Instructor_update.Dept_Id = int.Parse(ddl_department.SelectedValue);
_container.SaveChanges();
show_instructors();
clear_ins();
btn_save_instructor.Text = "Save";
}
}