/// <summary>
/// Deletes a guest from the database
/// </summary>
/// <param name="conn">Open connection to the database</param>
/// <param name="guest">Guest being deleted from the database</param>
public static void DeleteGuest(SqlConnection conn, Int32 guestId)
{
try
{
sql.SqlCommand cmd = new sql.SqlCommand("DeleteGuest", conn);
cmd.Parameters.AddWithValue("GuestId", DbType.Int32, guestId);
cmd.ExecuteNonQuery();
}
catch (System.Exception e)
{
throw new DeleteSqlDbObjectException("Could not delete guest", e);
}
}
/// <summary>
/// Updates a guest in the database
/// </summary>
/// <param name="conn">Open connection to the database</param>
/// <param name="inviteId">Unique identifier of the invite the guest is a member of</param>
/// <param name="guest">Guest being updated in the database</param>
public static void UpdateGuest(SqlConnection conn, Int32 inviteId, Business.Guest guest)
{
try
{
sql.SqlCommand cmd = new sql.SqlCommand("UpdateGuest", conn);
cmd.Parameters.AddRange(guest.GetParametersForStoredProcedure(inviteId, true));
cmd.ExecuteNonQuery();
}
catch (System.Exception e)
{
throw new UpdateSqlDbObjectException("Could not update guest", e);
}
}
/// <summary>
/// Sets the room ID of the guest with the specified unique identifier
/// </summary>
/// <param name="conn">Open connection to the database</param>
/// <param name="guestId">Unique identifier of the guest</param>
/// <param name="roomId">Unique identifier of the room</param>
public static void SetGuestRoomId(SqlConnection conn, Int32 guestId, Int32?roomId)
{
try
{
sql.SqlCommand cmd = new sql.SqlCommand("SetGuestRoomId", conn);
cmd.Parameters.AddWithValue("GuestId", DbType.Int32, guestId);
cmd.Parameters.AddWithValue("RoomId", DbType.Int32, roomId);
cmd.ExecuteNonQuery();
}
catch (System.Exception e)
{
throw new UpdateSqlDbObjectException("Could not set guest room ID", e);
}
}