public async Task <List <Game> > GetAllGames()
{
var result = new List <Game>();
using (var cn = new SqlConnection(Settings.Default.DefaultConnection))
{
await cn.OpenAsync();
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "usp_GetAllGames";
using (var dr = await cmd.ExecuteReaderAsync())
{
while (await dr.ReadAsync())
{
var game = Game.LoadFromState((string)dr["State"]);
result.Add(game);
}
}
}
}
return(result);
}
public async Task <Game> LoadGame(Guid gameID)
{
using (var cn = new SqlConnection(Settings.Default.DefaultConnection))
{
await cn.OpenAsync();
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "usp_LoadGame";
cmd.Parameters.AddWithValue("ID", gameID);
using (var dr = await cmd.ExecuteReaderAsync())
{
if (!await dr.ReadAsync())
{
return(null);
}
return(Game.LoadFromState((string)dr["State"]));
}
}
}
}
