/// <summary> /// James Heim /// Created 2019-04-12 /// /// Assign the guest to the room in the selected ViewModel. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnAssign_Click(object sender, RoutedEventArgs e) { SelectedVM = (VMRoomRoomReservation)dgAvailableRooms.SelectedItem; if (SelectedVM != null) { var result = _roomReservationManager.AddGuestAssignment( _guestId, SelectedVM.RoomReservationID); if (result == true) { // Assigned the Guest successfully. DialogResult = true; } else { // Failed for some reason. MessageBox.Show("Error assigning Guest to room."); DialogResult = false; SelectedVM = null; } } }
public List <VMRoomRoomReservation> SelectAvailableVMRoomRoomReservations(int reservationId) { List <VMRoomRoomReservation> vmRooms = new List <VMRoomRoomReservation>(); var conn = DBConnection.GetDbConnection(); var cmdText = @"sp_select_room_roomreservation_viewmodel_by_reservation_id"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ReservationID", reservationId); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var vmRoom = new VMRoomRoomReservation() { ReservationID = reservationId }; vmRoom.RoomReservationID = reader.GetInt32(0); vmRoom.RoomID = reader.GetInt32(1); vmRoom.RoomNumber = reader.GetInt32(2); vmRoom.BuildingName = reader.GetString(3); vmRoom.CurrentlyAssigned = reader.GetInt32(4); vmRoom.Capacity = reader.GetInt32(5); // Dates are nullable. if (reader.IsDBNull(6)) { vmRoom.CheckInDate = null; } else { vmRoom.CheckInDate = reader.GetDateTime(6); } if (reader.IsDBNull(7)) { vmRoom.CheckOutDate = null; } else { vmRoom.CheckOutDate = reader.GetDateTime(7); } vmRooms.Add(vmRoom); } } } catch (Exception) { throw; } finally { conn.Close(); } return(vmRooms); }