public int GetQueueOrder(int memberID, int roomID)
{
int value = 0;
RoomMember member = new RoomMember();
member.LoadByPrimaryKey(memberID, roomID);
RoomMember order = new RoomMember();
order.GetMaxQueueOrderByRoomID(roomID);
if (member.IsColumnNull("QueueOrder"))
{
member.QueueOrder = Convert.ToInt32(order.GetColumn("MaxQueueOrder")) + 1;
value = member.QueueOrder;
}
else
member.SetColumnNull("QueueOrder");
member.Save();
return value;
}