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