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); } } }
private void roomButton_Click(object sender, RoutedEventArgs e) { //hide all other windows SQLQuery mSQLQuery = new SQLQuery(); mRoom = mSQLQuery.roomToLinkedList(mSQLQuery.getRoomByStaffID(GlobalVariables.globalStaff.id)).ElementAt(0); roomName.Content = "Room" + " " + Convert.ToString(mRoom.number); childRow.Clear(); children.Children.Clear(); childList = mSQLQuery.childToLinkedList(mSQLQuery.getChildByRoomID(mRoom.id)); showPendingChildren(); this.profile.Visibility = Visibility.Hidden; this.feedbackPanel.Visibility = Visibility.Hidden; //show room grid this.room.Visibility = Visibility.Visible; }