public async Task GetItemCount()
{
var toInsert1 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction9.Id, _setup.ItemDescription1.Id, "assetId4871",
new decimal(14.45));
var toInsert2 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction9.Id, _setup.ItemDescription1.Id, "assetId4872",
new decimal(14.45));
var toInsert3 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction9.Id, _setup.ItemDescription1.Id, "assetId4873",
new decimal(14.45));
var toInsert4 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction9.Id, _setup.ItemDescription1.Id, "assetId4874",
new decimal(14.45));
var toInsert5 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction9.Id, _setup.ItemDescription1.Id, "assetId8464",
new decimal(14.45));
await _itemInOfferTransactionRepoService.InsertAsync(toInsert1);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert2);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert3);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert4);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert5);
var nr = await _itemInOfferTransactionRepoService.GetItemCountInOffer(_setup.OfferTransaction9.Id);
Assert.Equal(5, nr);
}
public async Task InsertItemsInOfferSuccess()
{
var toInsert = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction1.Id, _setup.ItemDescription1.Id, "assetId4474",
new decimal(14.45));
var res = await _itemInOfferTransactionRepoService.InsertAsync(toInsert);
Assert.True(res.Id > 0);
}
private async Task <OfferData> CreateTransactionOfferAsync
(
List <Item> itemsInOfferRequest,
DatabaseModel.Bot bot,
DatabaseModel.User owner,
bool isDeposit
)
{
var listOfNames = itemsInOfferRequest.Select(item => item.MarketHashName).ToList();
var itemsDesc = await _itemDescRepoServcice.FindAsync(listOfNames);
var databaseItems = new List <DatabaseModel.Item>();
var itemsInOffer = new List <DatabaseModel.ItemInOfferTransaction>();
decimal sumOfItems = 0;
foreach (var item in itemsInOfferRequest)
{
DatabaseModel.ItemDescription itemDesc;
try
{
itemDesc = itemsDesc.First(i => i.Name == item.MarketHashName);
}
catch (System.Exception e)
{
var ex = new SteamMarketNameFuckupException(item.MarketHashName, e);
ex.Data.Add("marketHashName", item.MarketHashName);
ex.Data.Add("itemDescriptions", itemsDesc);
_logService.Critical(ex);
throw ex;
}
var steamLockTime = DateTimeOffset.Now;
if (item.AppId == 730)
{
steamLockTime = steamLockTime.Add(_steamLock);
}
databaseItems.Add(new DatabaseModel.Item(item.AssetId, itemDesc.Id, bot.Id, owner.Id, steamLockTime));
sumOfItems += itemDesc.Value;
var itemInOffer = new DatabaseModel.ItemInOfferTransaction(int.MinValue, itemDesc.Id, item.AssetId, itemDesc.Value);
itemsInOffer.Add(itemInOffer);
}
var offer = new DatabaseModel.OfferTransaction(owner.Id, bot.Id, sumOfItems, isDeposit, null, DateTime.Now);
return(new OfferData
{
Items = databaseItems,
ItemsInOffer = itemsInOffer,
OfferTransactions = offer
});
}
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 SqlQuery InsertReturnsId(DatabaseModel.ItemInOfferTransaction itemInOfferTransaction)
{
var dict = new Dictionary<string, object>
{
{"@offerTransId", itemInOfferTransaction.OfferTransactionId},
{"@itemDescId", itemInOfferTransaction.ItemDescriptionId},
{"@assetId", itemInOfferTransaction.AssetId},
{"@value", itemInOfferTransaction.Value}
};
return new SqlQuery(
"INSERT INTO [ItemInOfferTransaction] (OfferTransactionId, ItemDescriptionId,AssetId, Value) OUTPUT INSERTED.Id VALUES (@offerTransId,@itemDescId,@assetId,@value);",
dict);
}
public async Task RemovedAllItemsWithOfferId()
{
var toInsert1 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction8.Id, _setup.ItemDescription1.Id, "assetId4471",
new decimal(14.45));
var toInsert2 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction8.Id, _setup.ItemDescription1.Id, "assetId4472",
new decimal(14.45));
var toInsert3 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction8.Id, _setup.ItemDescription1.Id, "assetId4473",
new decimal(14.45));
var toInsert4 = new DatabaseModel.ItemInOfferTransaction(_setup.OfferTransaction8.Id, _setup.ItemDescription1.Id, "assetId4474",
new decimal(14.45));
await _itemInOfferTransactionRepoService.InsertAsync(toInsert1);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert2);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert3);
await _itemInOfferTransactionRepoService.InsertAsync(toInsert4);
var nr = await _itemInOfferTransactionRepoService.Remove(_setup.OfferTransaction8.Id);
Assert.Equal(4, nr);
}
public SqlQuery Insert(DatabaseModel.ItemInOfferTransaction itemInOfferTransaction)
{
return InsertRange(new List<DatabaseModel.ItemInOfferTransaction> {itemInOfferTransaction});
}
