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