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