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);
}
}
public void AddBet(BetContract bet)
{
var lot = Service.GetLots().FirstOrDefault(p => p.Id == bet.Lot);
if (lot == null || lot.Finished)
{
throw new Exception("Лот несуществует, либо завершён");
}
Service.CreateBet(bet);
}
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);
}
}
