public async Task RemoveAllMessagesAsync()
{
using (var context = new PushMessagesContext())
{
await context.Database.ExecuteSqlCommandAsync("TRUNCATE TABLE RqPricingForUpsert").ConfigureAwait(false);
}
}
public async Task CreateAsync(RqPricingForUpsertRecord rqPricingForUpsertRecord, CancellationToken cancellationToken)
{
if (rqPricingForUpsertRecord == null)
{
throw new ArgumentNullException(nameof(rqPricingForUpsertRecord));
}
using (var context = new PushMessagesContext())
{
context.RqPricingForUpsert.Add(rqPricingForUpsertRecord);
await context.SaveChangesAsync(cancellationToken).ConfigureAwait(false);
}
}
public async Task <IEnumerable <RqPricingForUpsertRecord> > GetAllByGenerationIdAsync(int generationId)
{
if (generationId <= 0)
{
throw new ArgumentOutOfRangeException(nameof(generationId));
}
IEnumerable <RqPricingForUpsertRecord> messages;
using (var context = new PushMessagesContext())
{
messages = await context.RqPricingForUpsert.Where(x => x.GenerationId == generationId).ToListAsync().ConfigureAwait(false);
}
return(messages);
}
