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