public static Listener GetListener(String listenerId)
{
if (ListenerCache.ContainsKey(listenerId))
{
return(ListenerCache[listenerId]);
}
;
var listener = DapperUtil.QueryFirst <Listener>(@"
SELECT
ListenerId
,Name
,Color
,Author
,AccountName
FROM
Listener
WHERE
ListenerId = @ListenerId
;
" , new {
ListenerId = listenerId,
});
ListenerCache[listenerId] = listener;
return(listener);
}
public static Room GetRoom(String roomId)
{
var result = DapperUtil.QueryFirst <Room>(@"
SELECT
RoomId
,Author
,Title
,Description
,Tags
,IdVisible
,AnonymousOnly
,StartTime
,ListenerCount
FROM
Room
WHERE
RoomId = @RoomId
;
" , new {
RoomId = roomId,
});
return(result);
}
public static Account GetAccount(String accountName)
{
if (AccountCache.ContainsKey(accountName))
{
return(AccountCache[accountName]);
}
var account = DapperUtil.QueryFirst <Account>(@"
SELECT
AccountName
,Account.Color
FROM
Account
WHERE
AccountName = @AccountName
;
" , new {
AccountName = accountName,
});
AccountCache[accountName] = account;
return(account);
}
