public long Import(IEnumerable <ChatMessage> messages) { long count; lock (LockObj) { LockObj.LockMessage = MiscTools.GetCurrentMethod(); var chatLogs = messages.Select(message => new ChatLog { Flags = "C_IMPORT", SentAt = message.SentAt, MessageType = MessageTypes.ChatMessage, ChannelId = message.Channel.Identifier, Channel = message.Channel.Name, SenderId = message.Sender.DbUser?.Id, Nick = message.Sender.Nickname, Message = message.Body }); count = SqlConnector.InsertMultiple(chatLogs); } LockObj.LockMessage = "None"; return(count); }
public void IncrementWords(Dictionary <string, int> usages) { lock (LockObj) { LockObj.LockMessage = MiscTools.GetCurrentMethod(); SqlConnector.Words.Delete(w => true); //var currentUsages = SqlConnector.Words.Select( w => w); var rows = usages.Select(pair => new UsedWord { Word = pair.Key, Uses = pair.Value }).OrderByDescending(w => w.Uses); SqlConnector.InsertMultiple(rows); LockObj.LockMessage = "None"; } }