public async Task <StartBetDTO> ValidBetByUserIdAsync(BetDTO betUser)
{
StartBetDTO startBet = new StartBetDTO();
using (SqlConnection connection = new SqlConnection(BaseContext.GetParameterConnection()))
{
await connection.OpenAsync();
string sql = string.Format(Querys.QueryValidBetByUserId, betUser.UserId, betUser.UserId, betUser.RouletteId);
SqlCommand command = new SqlCommand(sql, connection);
using (SqlDataReader dataReader = await command.ExecuteReaderAsync())
{
startBet = await SetDataValidBetByUserId(dataReader);
}
await connection.CloseAsync();
}
return(startBet);
}
private async Task <StartBetDTO> SetDataValidBetByUserId(SqlDataReader dataReader)
{
StartBetDTO startBet = new StartBetDTO();
while (await dataReader.ReadAsync())
{
startBet = new StartBetDTO
{
StartRouletteId = !dataReader.IsDBNull(Constant.AttributeStartRouletteId) ?
Convert.ToInt32(dataReader[Constant.AttributeStartRouletteId]) : 0,
UserId = !dataReader.IsDBNull(Constant.AttributeUserId) ?
Convert.ToInt32(dataReader[Constant.AttributeUserId]) : 0,
RouletteId = !dataReader.IsDBNull(Constant.AttributeRouletteId) ?
Convert.ToInt32(dataReader[Constant.AttributeRouletteId]) : 0,
UserMoney = !dataReader.IsDBNull(Constant.AttributeMoney) ?
Convert.ToDouble(dataReader[Constant.AttributeMoney]) : 0
};
}
return(startBet);
}
public async Task <ResultGameDTO> ValidBetByUserIdAsync(BetDTO betUser)
{
ResultGameDTO result = new ResultGameDTO();
UserGameInformation = await this.iBetRouletteDAL.ValidBetByUserIdAsync(betUser);
if (UserGameInformation.RouletteId == 0 || UserGameInformation.RouletteId == null)
{
result.IsError = true;
result.Message = Messages.ErrorClosedRoulettes;
return(result);
}
if (UserGameInformation.UserMoney < betUser.BetMoney)
{
result.IsError = true;
result.Message = Messages.ErrorInsufficientBalance;
return(result);
}
return(result);
}
