public async Task<Roulette> GetRoulette(string id) { SqlCommand cmd = null; Roulette roulette = null; SqlDataReader reader = null; try { cmd = new SqlCommand("select * from Roulette where Roulette_Id = @id", Connection); cmd.Parameters.AddWithValue("@id", id); Connection.Open(); reader = await cmd.ExecuteReaderAsync(); if(await reader.ReadAsync()) { roulette = SqlConvertUtils.ReadRoulette(reader); } reader.Close(); } catch (Exception) { return null; } finally { if (Connection.State == System.Data.ConnectionState.Open) Connection.Close(); } return roulette; }
public async Task<List<Bet>> GetBetsFromRoulette(string roulette_id) { SqlCommand cmd = null; SqlDataReader reader = null; List<Bet> betList = new List<Bet>(); Bet bet = null; try { cmd = new SqlCommand("select * from Bet where Roulette_Id = @roulette_id", Connection); cmd.Parameters.AddWithValue("@roulette_id", roulette_id); Connection.Open(); reader = await cmd.ExecuteReaderAsync(); while (await reader.ReadAsync()) { bet = SqlConvertUtils.ReadBet(reader); betList.Add(bet); } reader.Close(); } catch (Exception) { } finally { if (Connection.State == System.Data.ConnectionState.Open) Connection.Close(); } return betList; }
public async Task<User> AuthUser(User user) { SqlCommand cmd = null; SqlDataReader reader = null; try { cmd = new SqlCommand("select * from BetUser where User_Name = @user AND User_Password= @pass", Connection); cmd.Parameters.AddWithValue("@user", user.User_Name); cmd.Parameters.AddWithValue("@pass", user.User_Password); Connection.Open(); reader = await cmd.ExecuteReaderAsync(); if (await reader.ReadAsync()) { user = SqlConvertUtils.ReadUser(reader); } reader.Close(); } catch (Exception) { return null; } finally { if (Connection.State == System.Data.ConnectionState.Open) Connection.Close(); } return user; }
public async Task<List<Roulette>> GetRouletteList() { SqlCommand cmd = null; SqlDataReader reader = null; List<Roulette> rouletteList = new List<Roulette>(); try { cmd = new SqlCommand("select * from Roulette", Connection); Connection.Open(); reader = await cmd.ExecuteReaderAsync(); while (await reader.ReadAsync()) { rouletteList.Add(SqlConvertUtils.ReadRoulette(reader)); } reader.Close(); } catch (Exception) { } finally { if (Connection.State == System.Data.ConnectionState.Open) Connection.Close(); } return rouletteList; }