public ConnectionRecordRoom GetConnectionRecordRoomByConnectionRecordId(int connectionRecordId, Guid roomId)
{
try
{
ConnectionRecordRoom t;
using (IDataContext ctx = DataContext.Instance())
{
var rooms = ctx.ExecuteQuery<ConnectionRecordRoom>(CommandType.Text,
string.Format(
"select top 1 * from {0}{1}DnnChat_ConnectionRecordRooms where ConnectionRecordId = '{2}' and RoomId = '{3}'",
_databaseOwner,
_objectQualifier,
connectionRecordId, roomId)).ToList();
if (rooms.Any())
{
t = rooms[0];
}
else
return null;
}
return t;
}
catch (Exception exc)
{
return null;
}
}