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