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 btnDelete_Click(object sender, EventArgs e)
{
int Id = Convert.ToInt32(txtID.Text);
//string FullName = "";
//string fName = "";
//if (cmboxStudent.SelectedItem != null)
//{
// FullName = cmboxStudent.SelectedItem.ToString();
// int pos = FullName.IndexOf(" ");
// fName = FullName.Substring(0, pos);
//}
//Instructor instructor = (from obj in db.Instructors
// where obj.fName == fName
// 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 = (from obj in db.stdCourses
where obj.ID == Id
select obj).FirstOrDefault();
db.stdCourses.Remove(stdCrs);
db.SaveChanges();
txtID.Text = cmboxCourse.Text = cmboxStudent.Text = string.Empty;
cmboxStudent.Items.Clear();
cmboxCourse.Items.Clear();
cmboxCourseSearch.Items.Clear();
fillDataGridView();
fillComboboxCrs();
fillComboboxStd();
}
