public async Task <DatabaseModel.OfferTransaction> InsertAsync(DatabaseModel.OfferTransaction offerTransaction, ITransactionWrapper transactionWrapper = null) { var query = _offerTransationQueries.InsertReturnsId(offerTransaction); int id; if (transactionWrapper != null) { id = await transactionWrapper.ExecuteSqlCommand <int>(query); } else { id = (int)await _databaseConnection.ExecuteScalarAsync(query); } return(new DatabaseModel.OfferTransaction( offerTransaction.UserId, offerTransaction.BotId, offerTransaction.TotalValue, offerTransaction.IsDeposit, offerTransaction.SteamOfferId, offerTransaction.Accepted, id )); }
public async Task InsertAsync(List <DatabaseModel.ItemInOfferTransaction> itemInOfferTransactions, ITransactionWrapper transactionWrapper = null) { var query = _itemInOfferTransactionQueries.InsertRange(itemInOfferTransactions); if (transactionWrapper != null) { await transactionWrapper.ExecuteSqlCommand(query); return; } await _databaseConnection.ExecuteNonQueryAsync(query); }
public async Task <DatabaseModel.Bet> InsertAsync(DatabaseModel.Bet bet, ITransactionWrapper transactionWrapper = null) { var query = _betQueries.InsertReturnsId(bet); if (transactionWrapper != null) { var idFromTrans = await transactionWrapper.ExecuteSqlCommand <int>(query); return(new DatabaseModel.Bet(bet.UserId, bet.MatchId, bet.GameModeId, bet.Created, idFromTrans)); } var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.Bet(bet.UserId, bet.MatchId, bet.GameModeId, bet.Created, id)); }