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