public bool TrygramExists(Trygram trygram)
{
var b = _context.Trygrams.Any(t => t.Key == trygram.Key);
_context.Database.CloseConnection();
return(b);
}
public async Task UpdateTrygramAsync(Trygram trygram)
{
_context.Trygrams.Update(trygram);
await _context.SaveChangesAsync();
await _context.Database.CloseConnectionAsync();
}
public async Task ParseAndPersistAsync(string title, string input)
{
var stringList = splitString(input);
for (int i = 0; i < stringList.Count - 2; i++)
{
var trygram = new Trygram
{
Title = title,
Key = (stringList[i] + " " + stringList[i + 1]),
Values = new List <TrygramValues>()
};
var value = new TrygramValues {
Value = stringList[i + 2]
};
trygram.Values.Add(value);
if (_trygramRepository.TrygramExists(trygram))
{
var trygramToUpdate = _trygramRepository.GetTrygramByKey(trygram.Key);
if (trygramToUpdate.Values is null)
{
trygramToUpdate.Values = new List <TrygramValues>();
}
trygramToUpdate.Values.Add(value);
await _trygramRepository.UpdateTrygramAsync(trygramToUpdate);
}
else
{
await _trygramRepository.AddTrygramAsync(trygram);
}
}
}
public async Task AddTrygramAsync(Trygram trygram)
{
await _context.Trygrams.AddAsync(trygram);
await _context.SaveChangesAsync();
await _context.Database.CloseConnectionAsync();
}
public async Task UpdateTrygramAsync(Trygram trygram)
{
_context.Trygrams.Update(trygram);
await _context.SaveChangesAsync();
}
public async Task AddTrygramAsync(Trygram trygram)
{
await _context.Trygrams.AddAsync(trygram);
await _context.SaveChangesAsync();
}
public bool TrygramExists(Trygram trygram)
{
return(_context.Trygrams.Any(t => t.Key == trygram.Key));
}
