// Button 'Save' private void buttonNewGuestConfirm_Click(object sender, EventArgs e) { Boolean roomexists = false; Boolean roomvalid = false; int roomid; int roomtypeid = Convert.ToInt32(comboBoxRoomType.SelectedValue); // Check if the point entered is numeric if (Int32.TryParse(textBoxRoomid.Text, out roomid)) { roomvalid = true; if (DBGetData.GetFloorplanRoomExists(roomid) > 0) { roomexists = true; MessageBox.Show("Room number already exists, select a different number."); } } else { MessageBox.Show("Only numbers (0-9) are allowed in the room number."); } // Execute save if (!roomexists && roomvalid) { DBSetData.FloorplanRoomAdd(roomid, roomtypeid); // Close form this.Close(); floorplanForm.LoadDataRoom(); floorplanForm.Refresh(); new StatusMessage("Room with number " + roomid + " is added to the database."); } }
// Button 'Save' private void buttonNewRoomConfirm_Click(object sender, EventArgs e) { if (comboBoxRoomType.SelectedIndex > -1) { // Execute save int roomtypeid = Convert.ToInt32(comboBoxRoomType.SelectedValue); DBSetData.FloorplanRoomEdit(roomid, roomtypeid); // Close form this.Close(); floorplanForm.LoadDataRoom(); floorplanForm.Refresh(); new StatusMessage("Room with number " + roomid + " is updated in the database."); } }