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