public async Task <List <InboundTransaction> > GetNonSecuredTransactions()
{
using (var context = new NxtContext())
{
return(await context.InboundTransactions.Where(t => t.Status != TransactionStatus.Secured).ToListAsync());
}
}
public async Task <List <InboundTransaction> > GetInboundTransactions(IEnumerable <long> transactionIds)
{
using (var context = new NxtContext())
{
return(await context.InboundTransactions.Where(t => transactionIds.Contains(t.TransactionId)).ToListAsync());
}
}
public async Task <InboundTransaction> GetInboundTransaction(long transactionId)
{
using (var context = new NxtContext())
{
return(await context.InboundTransactions.SingleOrDefaultAsync(t => t.TransactionId == transactionId));
}
}
public async Task AddInboundTransaction(InboundTransaction transaction)
{
using (var context = new NxtContext())
{
context.InboundTransactions.Add(transaction);
await context.SaveChangesAsync();
}
}
public async Task UpdateBlockchainStatus(BlockchainStatus blockchainStatus)
{
using (var context = new NxtContext())
{
context.BlockchainStatus.Attach(blockchainStatus);
context.Entry(blockchainStatus).State = EntityState.Modified;
await context.SaveChangesAsync();
}
}
public async Task UpdateTransactionStatus(long transactionId, TransactionStatus status)
{
using (var context = new NxtContext())
{
var dbTransaction = await context.InboundTransactions.SingleAsync(t => t.TransactionId == transactionId);
dbTransaction.Status = status;
await context.SaveChangesAsync();
}
}
public async Task <BlockchainStatus> GetBlockchainStatus()
{
using (var context = new NxtContext())
{
var blockchainStatus = await context.BlockchainStatus.SingleAsync();
// Workaround to get datetime values into utc kind
blockchainStatus.LastKnownBlockTimestamp = ConvertToUtc(blockchainStatus.LastKnownBlockTimestamp);
blockchainStatus.LastConfirmedBlockTimestamp = ConvertToUtc(blockchainStatus.LastConfirmedBlockTimestamp);
blockchainStatus.LastSecureBlockTimestamp = ConvertToUtc(blockchainStatus.LastSecureBlockTimestamp);
return(blockchainStatus);
}
}
