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);
}
}
}
