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