public async Task <BetsResults_Wrapper> CloseRoulette(IdRoulette_Wrapper IdRoulette) { WinnerNumber_Wrapper Winner = await _closeBetsRepository.CloseRoulette(IdRoulette).ConfigureAwait(false); ICollection <Bets_Wrapper> bets = await GetBets(IdRoulette).ConfigureAwait(false); BetsResults_Wrapper Results = await GetsWinners(Winner, bets).ConfigureAwait(false); Results.IdRoullete = IdRoulette.IdRoulette; return(Results); }
public async Task <ActionResult> CloseRoulette([FromBody] IdRoulette_Wrapper IdRoulette) { try { var IdBet = await _closeBetsBusiness.CloseRoulette(IdRoulette).ConfigureAwait(false); return(Ok(IdBet)); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public async Task <ActionResult> OpenRoulette([FromBody] IdRoulette_Wrapper OpenRoulette) { try { var RouletteOpen = await _businessOpenRoulette.OpenRoulette(OpenRoulette).ConfigureAwait(false); return(Ok(RouletteOpen)); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public async Task <ICollection <Bets_Wrapper> > getBets(IdRoulette_Wrapper IdRoulette) { var connectionString = _configuration.GetConnectionString("develop"); if (string.IsNullOrEmpty(connectionString)) { throw new ArgumentException("No connection string in config.json"); } await using (var con = new SqlConnection(connectionString)) { await using (var cmd = new SqlCommand("[SP_getsRouletteBets]", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IdRoulette", IdRoulette.IdRoulette); con.Open(); var reader = await cmd.ExecuteReaderAsync().ConfigureAwait(false); ICollection <Bets_Wrapper> Bets = new List <Bets_Wrapper>(); while (reader.Read()) { Bets_Wrapper Bet = new Bets_Wrapper(); Bet.IdRoulette = (long)(await reader.IsDBNullAsync("IdRoulette") ? 0 : reader["IdRoulette"]); Bet.IdBet = (long)(await reader.IsDBNullAsync("IdBet") ? 0 : reader["IdBet"]); Bet.IdUser = (String)(await reader.IsDBNullAsync("IdUser") ? null : reader["IdUser"]); Bet.BetValue = (int)(await reader.IsDBNullAsync("BetValue") ? 0 : Int32.Parse(reader["BetValue"].ToString())); Bet.BetNumber = (int)(await reader.IsDBNullAsync("BetNumber") ? 0 : Int32.Parse(reader["BetNumber"].ToString())); Bet.BetColor = (short)(await reader.IsDBNullAsync("BetColor") ? 0 : Int16.Parse(reader["BetColor"].ToString())); Bet.IsColorBet = (bool)(await reader.IsDBNullAsync("IsColorBet") ? 0 : reader["IsColorBet"]); Bet.DateBet = (DateTime)(await reader.IsDBNullAsync("DateBet") ? DateTime.Now : reader["DateBet"]);; Bets.Add(Bet); } return(Bets); } } }
public async Task <IdRoulette_Wrapper> CreateRoulette() { var connectionString = _configuration.GetConnectionString("develop"); if (string.IsNullOrEmpty(connectionString)) { throw new ArgumentException("No connection string in config.json"); } await using (var con = new SqlConnection(connectionString)) { await using (var cmd = new SqlCommand("[SP_InsertRoulette]", con)) { cmd.CommandType = CommandType.StoredProcedure; con.Open(); var reader = await cmd.ExecuteScalarAsync().ConfigureAwait(false); IdRoulette_Wrapper IdRoulette = new IdRoulette_Wrapper(); IdRoulette.idRoulette = Int64.Parse(reader.ToString()); return(IdRoulette); } } }
public async Task <bool> OpenRoulette(IdRoulette_Wrapper Roulette) { var RouletteOpen = await _openRouletteRepository.OpenRoulete(Roulette).ConfigureAwait(false); return(RouletteOpen); }
public async Task <ICollection <Bets_Wrapper> > GetBets(IdRoulette_Wrapper IdRoulette) { ICollection <Bets_Wrapper> Bets = await _closeBetsRepository.getBets(IdRoulette).ConfigureAwait(false); return(Bets); }
public async Task <IdRoulette_Wrapper> CreateRoulette() { IdRoulette_Wrapper IdRoulette = await _createRouletteRepository.CreateRoulette().ConfigureAwait(false); return(IdRoulette); }