internal void SetWinnerBet(BetContract winBet)
{
using (var db = new DataRetriever(_connectionString))
{
db.Execute($"update lots set winneruserid = @BetOwner where id = @Lot", winBet);
db.Execute($"update bets set win = true where id = @Id", winBet);
}
}
protected override void RetrieveInternal()
{
try
{
DataRetriever.Execute(Settings);
if (!AbortFlag)
{
// Process the retrieved logs
Process();
}
else
{
_slotModel.Status = SlotStatus.Offline;
//Logger.Info(Constants.ClientNameFormat, Settings.Name, "Retrieval Aborted...");
}
}
catch (Exception ex)
{
_slotModel.Status = SlotStatus.Offline;
Logger.ErrorFormat(ex, Constants.ClientNameFormat, Settings.Name, ex.Message);
}
finally
{
if (!AbortFlag)
{
OnRetrievalFinished(EventArgs.Empty);
}
}
}
internal void FinishLot(int lotId)
{
using (var db = new DataRetriever(_connectionString))
{
db.Execute(@"update lots set finished = true where id = @lotId", new { lotId });
}
}
internal void SetBetTransactionId(int betId, string transactionid)
{
using (var db = new DataRetriever(_connectionString))
{
db.Execute($"update bets set transactionId = @transactionid where id = @betId", new { betId, transactionid });
}
}
internal void CreateLot(LotContract log)
{
using (var db = new DataRetriever(_connectionString))
{
db.Execute(@"insert into lots (id, Price,
Title,
IdAuthor,
Timeofpost,
Deadline,
Picture) values((select max(id) + 1 from lots), @Price,
@Title,
@IdAuthor,
@Timeofpost,
@Deadline,
@Picture)", log);
}
}
internal void CreateBet(BetContract bet)
{
using (var db = new DataRetriever(_connectionString))
{
db.Execute(@"insert into bets (Id,
BetOwner,
Amount,
Win,
Lot,
transactionid
) values ((select max(id) + 1 from bets),
@BetOwner,
@Amount,
@Win,
@Lot,
@transactionid)", bet);
}
}
