private void btnInsert_Click(object sender, EventArgs e)
{
string crsname = cmboxcrs.SelectedItem.ToString();
Course crs = (from obj in db.Courses
where obj.crsName == crsname
select obj).Distinct().FirstOrDefault();
Question ques = new Question();
//
QuesType quest = new QuesType();
ques.question1 = txtQues.Text;
//
quest.type = comboBoxType.Text;
ques.grade = int.Parse(txtGrade.Text);
ques.crsID = crs.crsID;
ques.correctChoice = textCorrrectChoice.Text;
db.Questions.Add(ques);
db.QuesTypes.Add(quest);
db.SaveChanges();
txtGrade.Text = txtQues.Text = txtQuesD.Text = cmboxcrs.Text = comboBoxType.Text = textCorrrectChoice.Text = string.Empty;
cmboxcrs.Items.Clear();
comboBoxType.Items.Clear();
fillDataGridView();
fillCombobox();
fillcourseType();
MessageBox.Show("Question Added Successfully");
}
private void btnInsert_Click(object sender, EventArgs e)
{
string FullName = "";
string fName = "";
string lName = "";
if (cmboxStudent.SelectedItem != null)
{
FullName = cmboxStudent.SelectedItem.ToString();
int pos = FullName.IndexOf(" ");
fName = FullName.Substring(0, pos);
lName = FullName.Substring(pos + 1);
}
Student std = (from obj in db.Students
where obj.fName == fName && obj.lName == lName
select obj).Distinct().FirstOrDefault();
string crsName = cmboxCourse.SelectedItem.ToString();
Course crs = (from obj in db.Courses
where obj.crsName == crsName
select obj).Distinct().FirstOrDefault();
stdCourse stdCrs = new stdCourse();
stdCrs.crsID = crs.crsID;
stdCrs.stdID = std.stdID;
stdCrs.stdCrsCode = 1000;
db.stdCourses.Add(stdCrs);
db.SaveChanges();
cmboxCourse.Text = cmboxStudent.Text = string.Empty;
cmboxStudent.Items.Clear();
cmboxCourse.Items.Clear();
cmboxCourseSearch.Items.Clear();
fillComboboxCrs();
fillComboboxStd();
fillDataGridView();
}
private void btnInsert_Click(object sender, EventArgs e)
{
string FullName = "";
string fName = "";
string lName = "";
if (cmboxMGRS.SelectedItem != null)
{
FullName = cmboxMGRS.SelectedItem.ToString();
int pos = FullName.IndexOf(" ");
fName = FullName.Substring(0, pos);
lName = FullName.Substring(pos + 1);
}
Instructor instructor = (from obj in db.Instructors
where obj.fName == fName && obj.lName == lName
select obj).Distinct().FirstOrDefault();
Department dept = new Department();
dept.deptName = txtDeptName.Text;
if (cmboxMGRS.SelectedItem != null)
{
dept.instID = instructor.instID;
}
db.Departments.Add(dept);
db.SaveChanges();
txtDeptID.Text = txtDeptName.Text = cmboxMGRS.Text = string.Empty;
cmboxMGRS.Items.Clear();
MessageBox.Show("Department Saved Correctlly");
fillDataGridView();
fillCombobox();
}
private void btnInsert_Click_1(object sender, EventArgs e)
{
if (txtChoiceName.Text != string.Empty && cmboxQuestions.Text != string.Empty)
{
string questionName = cmboxQuestions.SelectedItem.ToString();
Question question = (from obj in entities.Questions
where obj.question1 == questionName
select obj).Distinct().FirstOrDefault();
Choice c1 = new Choice();
c1.choice1 = txtChoiceName.Text;
c1.quesID = question.questionID;
entities.Choices.Add(c1);
entities.SaveChanges();
MessageBox.Show("Saved");
cmboxQuestions.Text = txtChoiceID.Text =
txtChoiceName.Text = string.Empty;
cmboxQuestions.Items.Clear();
fillCombobox();
fillGrid();
}
else
{
MessageBox.Show("Choose your Answer plz");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
Course crs = new Course();
crs.crsName = txtCrsName.Text;
crs.duration = txtCrsDuration.Text;
db.Courses.Add(crs);
db.SaveChanges();
txtCrsName.Text = txtCrsDuration.Text = txtCrsID.Text = string.Empty;
MessageBox.Show("Course Saved Correctlly");
fillDataGridView();
}
private void button1_Click(object sender, EventArgs e)
{
string crsName = cmboxCourse.SelectedItem.ToString();
var ex = (from obj in db.Exams
join obj1 in db.Questions
on obj.quesID equals obj1.questionID
join obj2 in db.Courses
on obj1.crsID equals obj2.crsID
where obj2.crsName == crsName
select new
{
obj.examName
}).Distinct().FirstOrDefault();
if (ex == null)
{
//MessageBox.Show("exam not found");
db.ExamGenerations(crsName);
db.SaveChanges();
MessageBox.Show("Exam Generated Succefully");
}
else
{
MessageBox.Show("This course had exam");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string question = lblQues.Text;
int qId = (from Q in db.Questions
where Q.question1 == question
select Q.questionID).Distinct().FirstOrDefault();
Exam ex = (from E in db.Exams
where E.quesID == qId
select E).Distinct().FirstOrDefault();
db.ExamAnswerss(StdID, ex.examNumber, cmboxAnswers.SelectedItem.ToString(), qId);
db.SaveChanges();
db.examCorrections(StdID, ex.examNumber, qId);
db.SaveChanges();
MessageBox.Show("your Answer saved successfuly");
}
private void btnDelete_Click(object sender, EventArgs e)
{
//if ((int)comboBox1.SelectedValue != -1)
//{
// int courseID = (int)comboBox1.SelectedValue;
string crsName = comboBox1.SelectedItem.ToString();
Course course = (from obj in db.Courses
where obj.crsName == crsName
select obj).Distinct().FirstOrDefault();
db.SP_DeleteCrsById(course.crsID);
db.SaveChanges();
comboBox1.SelectedIndex = 0;
txtCourseDuration.Text = txtCourseName.Text = string.Empty;
MessageBox.Show("Course Deleted !!!");
// this.ParentForm.Refresh();
//}
}
private void btnInsert_Click(object sender, EventArgs e)
{
string crsName = cmboxCourses.SelectedItem.ToString();
Course course = (from obj in db.Courses
where obj.crsName == crsName
select obj).Distinct().FirstOrDefault();
Topic topic = new Topic();
topic.topicName = txtTopicName.Text;
topic.crsID = course.crsID;
db.Topics.Add(topic);
db.SaveChanges();
txtTopicName.Text = cmboxCourses.Text = txtTopicID.Text = string.Empty;
cmboxCourses.Items.Clear();
MessageBox.Show("Course Saved Correctlly");
fillDataGridView();
fillCombobox();
}
private void btnInsert_Click(object sender, EventArgs e)
{
string deptName = cmboxDepartment.SelectedItem.ToString();
Department department = (from obj in db.Departments
where obj.deptName == deptName
select obj).Distinct().FirstOrDefault();
Instructor inst = new Instructor();
inst.fName = txtFName.Text;
inst.lName = txtLName.Text;
inst.deptID = department.deptID;
inst.instUserName = txtUserName.Text;
inst.instPassword = txtPassword.Text;
db.Instructors.Add(inst);
db.SaveChanges();
txtFName.Text = txtInstID.Text = txtUserName.Text = txtPassword.Text = txtLName.Text = cmboxDepartment.Text = string.Empty;
cmboxDepartment.Items.Clear();
fillDataGridView();
fillCombobox();
}
private void btnSave_Click(object sender, EventArgs e)
{
//db.SP_CrsInsert(txtCourseName.Text, txtCourseDuration.Text);
Course crs = new Course();
crs.crsName = txtCourseName.Text;
crs.duration = txtCourseDuration.Text;
db.Courses.Add(crs);
db.SaveChanges();
MessageBox.Show("Course Saved Correctlly");
}
private void btnInsert_Click(object sender, EventArgs e)
{
string FullName = "";
string fName = "";
string lName = "";
if (cmboxInstructor.SelectedItem != null)
{
FullName = cmboxInstructor.SelectedItem.ToString();
int pos = FullName.IndexOf(" ");
fName = FullName.Substring(0, pos);
lName = FullName.Substring(pos + 1);
}
var instructor = (from obj in db.Instructors
where obj.fName == fName && obj.lName == lName
select new {
obj.instID
}).FirstOrDefault();
string crsName = cmboxCourse.SelectedItem.ToString();
Course crs = (from obj in db.Courses
where obj.crsName == crsName
select obj).Distinct().FirstOrDefault();
instCourse instCourse = new instCourse();
instCourse.crsID = crs.crsID;
instCourse.instID = instructor.instID;
instCourse.insCrsCode = 1000;
db.instCourses.Add(instCourse);
db.SaveChanges();
cmboxCourse.Text = cmboxInstructor.Text = string.Empty;
cmboxInstructor.Items.Clear();
cmboxCourse.Items.Clear();
cmboxCourseSearch.Items.Clear();
fillComboboxCrs();
fillComboboxInst();
fillDataGridView();
}
private void btnInsert_Click(object sender, EventArgs e)
{
string deptName = cmboxDepartment.SelectedItem.ToString();
Department department = (from obj in db.Departments
where obj.deptName == deptName
select obj).Distinct().FirstOrDefault();
Student std = new Student();
std.fName = txtFName.Text;
std.lName = txtLName.Text;
std.phone = txtPhone.Text;
std.address = txtAddress.Text;
std.email = txtEmail.Text;
std.deptID = department.deptID;
std.stdUserName = txtUserName.Text;
std.stdPassword = txtPassword.Text;
db.Students.Add(std);
db.SaveChanges();
txtFName.Text = txtStdID.Text = txtLName.Text = txtEmail.Text
= txtPhone.Text = txtAddress.Text = txtPassword.Text = txtUserName.Text = cmboxDepartment.Text = string.Empty;
cmboxDepartment.Items.Clear();
fillDataGridView();
fillCombobox();
}