private void SaveStudentToDatabase() { if (studentInfo.IsExist) { // Update student data database.Update("UPDATE students SET fullname='" + studentInfo.Name + "',sex='" + studentInfo.Sex + "',course='" + studentInfo.Course + "',year=" + studentInfo.Year + ",fingerprint='" + fingerprint.SerializeData(studentInfo.Lastfinger) + "',status='Registered' WHERE student_id=" + studentInfo.StudentId + ""); } else { // Insert student data database.Insert("INSERT INTO students(student_id, fullname, sex, course, year, fingerprint, status) VALUES (" + studentInfo.StudentId + ",'" + studentInfo.Name + "','" + studentInfo.Sex + "','" + studentInfo.Course + "'," + studentInfo.Year + ",'" + fingerprint.SerializeData(studentInfo.Lastfinger) + "','Registered')"); } }
private void btn_submit_Click(object sender, RoutedEventArgs e) { if (txtBox_fname.Text == "" || txtBox_lname.Text == "" || txtBox_position.Text == "" || txtBox_username.Text == "" || firstFinger == null || secondFinger == null) { MessageBox.Show("Please complete the registration.", "Registration Info", MessageBoxButton.OK, MessageBoxImage.Exclamation); } else { SubmitForm(txtBox_fname.Text, txtBox_lname.Text, txtBox_mname.Text, txtBox_position.Text, txtBox_username.Text, fingerprintReader.SerializeData(secondFinger)); } }