public void DeleteWord(string word)
{
Words wordToDelete = _anagramsContext.Words.SingleOrDefault(w => w.Word == word);
_anagramsContext.Remove <Words>(wordToDelete);
_anagramsContext.SaveChanges();
}
public void AddUserLog(UserLog userLog, string word)
{
Words wordSearched = _dbContext.Words.FirstOrDefault(w => w.Word == word);
_dbContext.UserLog.Add(userLog);
_dbContext.SaveChanges();
}
public void SaveUserSearch(string ip, long time, string sortedWord, string originalWord)
{
var sortedWordID = anagramEntities.CachedWords.Where(x => x.Word == sortedWord).Select(x => x.Id).FirstOrDefault();
var recordToSave = new UserLogs {
UserIp = ip, CachedWordId = sortedWordID, Word = originalWord, SearchTime = (int)time
};
anagramEntities.UserLogs.Add(recordToSave);
anagramEntities.SaveChanges();
}
public void WriteCachedWord(string word, List <string> anagrams)
{
var wordToSave = new CachedWords {
Word = word
};
_anagramEntities.CachedWords.Add(wordToSave);
_anagramEntities.SaveChanges();
var wordId = wordToSave.Id;
foreach (var anagram in anagrams)
{
var anagramToSave = new CachedAnagrams {
WordId = wordId, Anagram = anagram
};
_anagramEntities.CachedAnagrams.Add(anagramToSave);
}
_anagramEntities.SaveChanges();
}
public void UpdateAnagramsCache(string word, List <WordModel> anagrams)
{
foreach (WordModel anagram in anagrams)
{
_dbContext.Add(new CachedWords()
{
Word = word, Id = anagram.Id
});
}
_dbContext.SaveChanges();
}
