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