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