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));
}
