public void AddWord(Guid sessionId, string word, int count) { using (var dc = ContextFactory.Create()) { var openSession = dc.Sessions.SingleOrDefault(c => c.Id == sessionId && c.IsActive); if (openSession == null) { throw new Exception("Session not found"); } word = word.ToLower(); var wordEntity = dc.Words.Find(sessionId, word); if (wordEntity == null) { wordEntity = new SessionWord() { SessionId = sessionId, Count = Convert.ToInt64(count), Word = word }; dc.Words.Add(wordEntity); } else { wordEntity.Count += Convert.ToInt64(count); } dc.SaveChanges(); } }
private void PopulateDatabase() { _context.SessionCounts.Add(new SessionCount { Id = Guid.Parse("A9EF096F-9FB5-4408-B3FB-FF7F577D7C80"), NumOpen = 1, NumClose = 0 }); _existingSession = new Session() { Id = Guid.NewGuid(), DateCreated = DateTime.UtcNow, Status = 1 }; _context.Sessions.Add(_existingSession); _existingSessionWord = new SessionWord() { SessionId = _existingSession.Id, Word = "vanilla", DateCreated = DateTime.UtcNow.AddDays(-1) }; _context.SessionWords.Add(_existingSessionWord); _existingSessionWordCount = new SessionWordCount() { SessionId = _existingSession.Id, Word = "vanilla", Count = 1, DateCreated = DateTime.UtcNow.AddDays(-1) }; _context.SessionWordCounts.Add(_existingSessionWordCount); _existingWordDateCount = new WordDateCount() { Word = "vanilla", Date = DateTime.UtcNow.AddDays(-1), Count = 1, DateCreated = DateTime.UtcNow.AddDays(-1) }; _context.WordDateCounts.Add(_existingWordDateCount); _context.WorkerJobs.Add(new WorkerJob { ProcessId = 1, StartDate = DateTime.UtcNow.AddDays(-1), EndDate = DateTime.UtcNow.AddDays(-1) }); _context.SaveChanges(); }