private void name_MouseDown(object sender, MouseButtonEventArgs e)
{
if (idx == 3)
{
aWindow.children2.Visibility = Visibility.Visible;
aWindow.room5.Visibility = Visibility.Visible;
aWindow.roomScrollerView.Visibility = Visibility.Hidden;
aWindow.roomTab1.IsSelected = false;
aWindow.children2.Children.Clear();
SQLQuery mSQLQuery = new SQLQuery();
child = mSQLQuery.childToLinkedList(mSQLQuery.getChildByRoomID(mRoom.id));
LinkedList <Staff> currStaff = mSQLQuery.staffToLinkedList(mSQLQuery.getStaffByID(mRoom.staffID));
if (currStaff.Count == 0)
{
aWindow.childCount.Content = "No Staff";
}
else
{
aWindow.childCount.Content = currStaff.ElementAt(0).firstName;
}
aWindow.childList = child;
aWindow.roomName.Content = "Room " + Convert.ToString(mRoom.number);
aWindow.roomBack.Visibility = Visibility.Visible;
aWindow.showPendingChildren(aWindow.children2);
}
}
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);
}
}
}
