private void button1_Click(object sender, EventArgs e) { Select_Instructor_Result ins = ent.Select_Instructor(instructorID).First(); int deptID = int.Parse(ins.Department_ID.ToString()); Student std = new Student(); if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "") { std.Fname = textBox2.Text; std.Lname = textBox1.Text; std.Address = textBox3.Text; std.DoB = Convert.ToDateTime(textBox4.Text); std.DeptId = deptID; ent.Students.Add(std); MessageBox.Show("ADDED"); ent.SaveChanges(); loadStudentData(); } else { MessageBox.Show("PLEASE ENTER FULL DATA"); } //ent.Insert_Student() }
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(); }
// 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 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 button1_Click(object sender, EventArgs e) { if (comboBox1.Text != "" && comboBox2.Text != "" && textBox1.Text != "") { Course crs = new Course(); crs.CrsName = textBox1.Text; var myins = ent.Instructors.Where(i => i.InsName == comboBox2.Text).Select(i => i).First(); crs.Instructors.Add(myins); ent.Courses.Add(crs); ent.SaveChanges(); MessageBox.Show("ADDED"); var courses = ent.Courses.Select(d => new { d.CrsId, d.CrsName }).ToList(); dataGridView1.DataSource = courses; } else { MessageBox.Show("PLEASE ENTER VALID DATA"); } }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.Text != "" && comboBox2.Text != "" && textBox2.Text != "") { var crsName = comboBox2.Text; var myCourse = ent.Courses.Where(d => d.CrsName == crsName).Select(d => d).First(); Topic mytopic = new Topic(); mytopic.CrsId = myCourse.CrsId; mytopic.Topname = textBox2.Text; ent.Topics.Add(mytopic); ent.SaveChanges(); MessageBox.Show("ADDED"); comboBox1.Text = comboBox2.Text = textBox2.Text = ""; var topics = ent.Topics.Select(d => new { d.TopId, d.Topname, d.Course.CrsName }).ToList(); dataGridView1.DataSource = topics; } else { MessageBox.Show("PLEASE ENTER DATA"); } }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.Text != "" && comboBox2.Text != "" && textBox2.Text != "") { var deptName = comboBox1.SelectedItem.ToString(); var mydept = ent.Departments.Where(d => d.DeptName == deptName).Select(d => d).First(); int insid = int.Parse(comboBox2.Text.ToString()); string insname = textBox2.Text; Instructor myins = new Instructor(); myins.InsId = insid; myins.InsName = insname; myins.DeptId = mydept.DeptId; ent.Instructors.Add(myins); ent.SaveChanges(); MessageBox.Show("ADDED"); var instructors = ent.Instructors.Select(d => new { d.InsId, d.InsName, d.DeptId }).ToList(); dataGridView1.DataSource = instructors; } else { MessageBox.Show("PLEASE ENTER THE FULL DATA"); } }
// 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 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; }
// 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); }