public virtual async Task <T> CreateAsync <T>(T entity) where T : BaseBE, new()
{
entity.CreateDate = DateTime.Now;
entity.ModifyDate = DateTime.Now;
await _dbContext.Set <T>().AddAsync(entity);
await _dbContext.SaveChangesAsync(true);
return(entity);
}
public async Task <IActionResult> Delete(int id)
{
Definition definition = await _context.Definitions.FirstOrDefaultAsync(x => x.Id == id);
if (definition != null)
{
if (definition.AuthorUsername.Equals(User.Identity.Name))
{
_context.Definitions.Remove(definition);
await _context.SaveChangesAsync();
}
}
return(RedirectToAction("Profile", "Account", new { user = User.Identity.Name }));
}
public async Task <int> AddWordsToDictionary(Stream wordStream)
{
int wordsAdded = 0;
// Dictionary corresponding to the to-be-added wordlist
ActiveDictionary addDictionary;
try
{
addDictionary = Loader.LoadDictionary(wordStream);
}
catch (FileLoadException)
{
// Empty, Abort
return(0);
}
// Dictionary corresponding to the in-database wordlist
var dbDictionary = context.GetWordDictionaryForContext();
var lettersToUpdate = addDictionary.GetAllDictionaryLetters().Select(dl => dl.Letter).ToList();
// Get the actual entities from the DB
List <Letter> letters =
await context.Letters.Where(letter => lettersToUpdate.Contains(letter.Character))
.OrderBy(letter => letter.Character)
.ToListAsync();
try
{
foreach (var letter in letters)
{
var addTheseWords = addDictionary.GetDictionaryWordsStartingWith(letter.Character)
.Select(word => new Word()
{
TheWord = word, Letter = letter
});
wordsAdded += context.AddWordEntities(addTheseWords);
}
}
finally
{
await context.SaveChangesAsync();
}
// Changes must be saved prior to getting updated states. fml -.-
try
{
foreach (var letter in letters)
{
// Update Letter Statistics
var updatedLetterStats = DictionaryLetter.InitializeDictionaryLetter(letter.Character, dbDictionary);
letter.AverageCharacters = updatedLetterStats.AverageCharacterCount;
letter.CountBeginningWith = updatedLetterStats.NumberWordsBeginningWith;
letter.CountEndingWith = updatedLetterStats.NumberWordsEndingWith;
context.Letters.Update(letter);
}
}
finally
{
await context.SaveChangesAsync();
}
return(wordsAdded);
}