public bool Save(CourseAssignToTeacher courseAssign) { if (IsCourseAlreadyAssigned(courseAssign.Course_id)) { throw new Exception("Course Already Assigned"); } return courseAssignGateway.Save(courseAssign)>0; }
public int Save(CourseAssignToTeacher courseAssign) { string query = "INSERT INTO t_course_assign_to_teacher VALUES( '" + courseAssign.Teacher_id + "', '" + courseAssign.Course_id + "')"; aSqlConnection.Open(); aSqlCommand = new SqlCommand(query, aSqlConnection); int rowAffected = aSqlCommand.ExecuteNonQuery(); aSqlConnection.Close(); return rowAffected; }
private void saveButton_Click(object sender, EventArgs e) { try { CourseAssignToTeacher courseAssignToTeacher=new CourseAssignToTeacher(); courseAssignToTeacher.Teacher_id = (int) teacherComboBox.SelectedValue; courseAssignToTeacher.Course_id = (int) courseComboBox.SelectedValue; if (courseAssignManager.Save(courseAssignToTeacher)) { MessageBox.Show("Course Assigned to Teacher Successful"); } else { MessageBox.Show("Course Assigned to Teacher Failed"); } } catch (Exception exception) { MessageBox.Show(exception.Message); } }