/// <summary> /// Inserts new lecturer and subject after validating all data is correct /// </summary> private void btnAddLecturerAndSub_Click(object sender, EventArgs e) { var item = SubjectList.FirstOrDefault( o => o.SubjectName.Equals(tbNewSubName.Text, StringComparison.OrdinalIgnoreCase)); if (!CheckLecturerBlanks() || string.IsNullOrWhiteSpace(tbNewSubName.Text)) { MessageBox.Show("Please Ensure All Lecturer Fields And A New Subject Name Are Filled In."); } else if (item != null) { MessageBox.Show("This Subject Name Already Exists, Please Change It And Try Again."); } else { Lecturer l = new Lecturer(); { l.LecturerID = tbNewLecturerId.Text; l.FirstName = tbNEwLecturerFname.Text; l.LastName = tbNewLecturerLname.Text; l.Email = tbNewLecturerEmail.Text; l.Phone = tbNewLecturerPhoneNo.Text; l.Address = tbNewLecturerAddress.Text; l.DateEntered = DateTime.Now; } Subject sub = new Subject(); { sub.SubjectName = tbNewSubName.Text; sub.SubjectID = tbNewSubID.Text; sub.LecturerID = tbNewLecturerId.Text; } if (!_db.InsertLecturer(l)) { MessageBox.Show("Neither Lecturer or Subject Added Because The Following Error Occurred: " + "\n" + _db.ErrorMessage); ResetLecturer(); ResetSubject(); } else { int count = _db.InsertNewSubject(sub); if (count == -1) //An error has occurred { MessageBox.Show("Lecturer Added." + "\n" + "\n" + "New Subject Not Added Because The Following Error Occurred: " + _db.ErrorMessage); //warn of error ResetLecturer(); ResetSubject(); } else { MessageBox.Show("New Lecturer and Subject Added."); ResetLecturer(); ResetSubject(); } } } }
partial void UpdateLecturer(Lecturer instance);
partial void DeleteLecturer(Lecturer instance);
partial void InsertLecturer(Lecturer instance);