/// <summary>
/// Generates the room data.
/// </summary>
/// <param name="roomId">The room identifier.</param>
/// <returns>RoomData.</returns>
internal RoomData GenerateRoomData(uint roomId)
{
if (LoadedRoomData.ContainsKey(roomId))
{
LoadedRoomData[roomId].LastUsed = DateTime.Now;
return(LoadedRoomData[roomId]);
}
var roomData = new RoomData();
if (LoadedRooms.ContainsKey(roomId))
{
return(GetRoom(roomId).RoomData);
}
using (var queryReactor = Plus.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery(string.Format("SELECT * FROM rooms_data WHERE id = {0} LIMIT 1", roomId));
DataRow dataRow = queryReactor.GetRow();
if (dataRow == null)
{
return(null);
}
roomData.Fill(dataRow);
}
LoadedRoomData.TryAdd(roomId, roomData);
return(roomData);
}
public RoomData GenerateRoomData(int RoomId)
{
if (_loadedRoomData.ContainsKey(RoomId))
{
return(_loadedRoomData[RoomId]);
}
var Data = new RoomData();
Room Room;
if (TryGetRoom(RoomId, out Room))
{
return(Room.RoomData);
}
DataRow Row = null;
using (var dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM rooms WHERE id = " + RoomId + " LIMIT 1");
Row = dbClient.GetRow();
}
if (Row == null)
{
return(null);
}
Data.Fill(Row);
if (!_loadedRoomData.ContainsKey(RoomId))
{
_loadedRoomData.TryAdd(RoomId, Data);
}
return(Data);
}
/// <summary>
/// Fetches the room data.
/// </summary>
/// <param name="roomId">The room identifier.</param>
/// <param name="dRow">The d row.</param>
/// <returns>RoomData.</returns>
internal RoomData FetchRoomData(uint roomId, DataRow dRow)
{
if (LoadedRoomData.ContainsKey(roomId))
{
LoadedRoomData[roomId].LastUsed = DateTime.Now;
return(LoadedRoomData[roomId]);
}
var roomData = new RoomData();
roomData.Fill(dRow);
LoadedRoomData.TryAdd(roomId, roomData);
return(roomData);
}
public RoomData FetchRoomData(int RoomId, DataRow dRow)
{
if (_loadedRoomData.ContainsKey(RoomId))
{
return(_loadedRoomData[RoomId]);
}
var data = new RoomData();
data.Fill(dRow);
if (!_loadedRoomData.ContainsKey(RoomId))
{
_loadedRoomData.TryAdd(RoomId, data);
}
return(data);
}
public RoomData GenerateRoomData(int RoomId)
{
if (_loadedRoomData.ContainsKey(RoomId))
{
return((RoomData)_loadedRoomData[RoomId]);
}
RoomData Data = new RoomData();
Room Room;
if (TryGetRoom(RoomId, out Room))
{
return(Room.RoomData);
}
DataRow Row = null;
DataRow RPRow = null;
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM `rooms` WHERE `id` = " + RoomId + " LIMIT 1");
Row = dbClient.getRow();
dbClient.SetQuery("SELECT * FROM `rp_rooms` WHERE `id` = " + RoomId + " LIMIT 1");
RPRow = dbClient.getRow();
}
if (Row == null || RPRow == null)
{
return(null);
}
Data.Fill(Row);
Data.FillRP(RPRow);
if (!_loadedRoomData.ContainsKey(RoomId))
{
_loadedRoomData.TryAdd(RoomId, Data);
}
return(Data);
}
public RoomData FetchRoomData(int RoomId, DataRow dRow, DataRow dRowRP)
{
if (_loadedRoomData.ContainsKey(RoomId))
{
return((RoomData)_loadedRoomData[RoomId]);
}
else
{
RoomData data = new RoomData();
data.Fill(dRow);
data.FillRP(dRowRP);
if (!_loadedRoomData.ContainsKey(RoomId))
{
_loadedRoomData.TryAdd(RoomId, data);
}
return(data);
}
}
public RoomData GenerateRoomData(int RoomId)
{
if (_loadedRoomData.ContainsKey(RoomId))
return (RoomData)_loadedRoomData[RoomId];
RoomData Data = new RoomData();
Room Room;
if (TryGetRoom(RoomId, out Room))
return Room.RoomData;
DataRow Row = null;
using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT * FROM rooms WHERE id = " + RoomId + " LIMIT 1");
Row = dbClient.getRow();
}
if (Row == null)
return null;
Data.Fill(Row);
if (!_loadedRoomData.ContainsKey(RoomId))
_loadedRoomData.TryAdd(RoomId, Data);
return Data;
}
public RoomData FetchRoomData(int RoomId, DataRow dRow)
{
if (_loadedRoomData.ContainsKey(RoomId))
return (RoomData)_loadedRoomData[RoomId];
else
{
RoomData data = new RoomData();
data.Fill(dRow);
if (!_loadedRoomData.ContainsKey(RoomId))
_loadedRoomData.TryAdd(RoomId, data);
return data;
}
}