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 <DatabaseModel.Bot> InsertAsync(DatabaseModel.Bot bot) { var query = _botQueries.InsertReturnsId(bot); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.Bot(bot.SteamId, bot.Name, id)); }
public async Task <DatabaseModel.Item> InsertAsync(DatabaseModel.Item item) { var query = _itemQueries.InsertReturnsId(item); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.Item(item.AssetId, item.DescriptionId, item.LocationId, item.OwnerId, item.ReleaseTime, id)); }
public async Task <DatabaseModel.User> InsertAsync(DatabaseModel.User user) { var query = _userQueries.InsertReturnsId(user); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.User(user.SteamId, user.Name, user.ImageUrl, user.TradeLink, user.Created, user.LastActive, user.SuspendedFromQuote, user.Quote, id)); }
public async Task <DatabaseModel.Level> Add(DatabaseModel.Level level) { var query = _levelQueries.CreteNewLevel(level); var res = await _databaseConnection.ExecuteScalarAsync(query); var insertId = (int)res; return(new DatabaseModel.Level(level.Name, level.Chat, level.Ticket, level.Admin, insertId)); }
public async Task <DatabaseModel.ItemInOfferTransaction> InsertAsync(DatabaseModel.ItemInOfferTransaction itemInOfferTransaction) { var query = _itemInOfferTransactionQueries.InsertReturnsId(itemInOfferTransaction); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.ItemInOfferTransaction( itemInOfferTransaction.OfferTransactionId, itemInOfferTransaction.ItemDescriptionId, itemInOfferTransaction.AssetId, itemInOfferTransaction.Value, id )); }
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)); }
public async Task <DatabaseModel.ItemDescription> InsertAsync(DatabaseModel.ItemDescription itemDescription) { var query = _itemDescriptionQueries.InsertReturnsId(itemDescription); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.ItemDescription( itemDescription.Name, itemDescription.Value, itemDescription.AppId, itemDescription.ContextId, itemDescription.ImageUrl, itemDescription.Valid, id )); }
public async Task <DatabaseModel.RakeItem> InsertAsync(DatabaseModel.RakeItem rakeItem) { var query = _rakeItemQueries.InsertReturnsId(rakeItem); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.RakeItem ( rakeItem.AssetId, rakeItem.DescriptionId, rakeItem.LocationId, rakeItem.Received, rakeItem.MatchId, rakeItem.GameModeId, rakeItem.IsSold, id )); }
public async Task <int> Add(string steamId, int levelId) { var query = _staffQueries.AddStaff(steamId, levelId); return((int)await _databaseConnection.ExecuteScalarAsync(query)); }