public Room GetRoom(string roomName)
{
Room r;
using (IDataContext ctx = DataContext.Instance())
{
var rooms = ctx.ExecuteQuery<Room>(CommandType.Text,
string.Format(
"select top 1 * from {0}{1}DnnChat_Rooms where RoomName = '{2}' and Enabled=1",
_databaseOwner,
_objectQualifier,
roomName)).ToList();
if (rooms.Any())
{
r = rooms[0];
}
else
return null;
}
return r;
}
RoomController::GetRoom ( System.Guid roomId, int moduleId ) : |
protected void ddlRooms_OnSelectedIndexChanged(object sender, EventArgs e) { divRoomSettings.Visible = true; //TODO: load the room into the edit interface. var rc = new RoomController(); if (ddlRooms.SelectedValue != "-1") { var r = rc.GetRoom(new Guid(ddlRooms.SelectedValue), ModuleId); if (r != null) { txtRoomId.Text = r.RoomId.ToString(); txtRoomName.Text = r.RoomName; txtRoomDescription.Text = r.RoomDescription; txtRoomPassword.Text = r.RoomPassword; txtRoomWelcome.Text = r.RoomWelcome; chkPrivateRoom.Checked = r.Private; chkEnabled.Checked = r.Enabled; } } }