private void submitRoomButton_Click(object sender, RoutedEventArgs e) { //check for empty entries if (roomNumberTextBox.Text.Length == 0) { MessageBox.Show("Please enter a room number", "Faild to submit", MessageBoxButton.OK, MessageBoxImage.None); } if (roomStaffIDTextBox.Text.Length == 0) { MessageBox.Show("Please enter staff id", "Faild to submit", MessageBoxButton.OK, MessageBoxImage.None); } else { SQLQuery mSQLQuery = new SQLQuery(); bool canEnter = true; Room mRoom; DataTable dtStaffID = mSQLQuery.getStaffByID(Convert.ToInt64(roomStaffIDTextBox.Text)); DataTable dtRoomNo = mSQLQuery.getRoomByNumber(Convert.ToInt32(roomNumberTextBox.Text)); //check for room number entry if (dtRoomNo.Rows.Count != 0) { MessageBox.Show("Room number already exists!", "Faild to submit", MessageBoxButton.OK, MessageBoxImage.None); canEnter = false; } dtRoomNo = mSQLQuery.getRoomByStaffID(Convert.ToInt64(roomStaffIDTextBox.Text)); //check for staff id entry if (dtStaffID.Rows.Count == 0 || Convert.ToInt32(dtStaffID.Rows[0]["staffIsPending"]) == 1 || dtRoomNo.Rows.Count != 0) { MessageBox.Show("Staff ID doesn't exist!", "Faild to submit", MessageBoxButton.OK, MessageBoxImage.None); canEnter = false; } if (canEnter) { mRoom = new Room(-1, Convert.ToInt32(roomNumberTextBox.Text), Convert.ToInt64(roomStaffIDTextBox.Text)); mSQLQuery.insertRoomData(mRoom); MessageBox.Show("Room added successfully!", "Submission Done!", MessageBoxButton.OK, MessageBoxImage.None); } } }