Christoc.Modules.DnnChat.Components.RoomController.GetRoom C# (CSharp) Метод

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

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