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(); }