public async Task SaveGame(Game 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_SaveGame";
cmd.Parameters.AddWithValue("ID", game.ID);
cmd.Parameters.AddWithValue("RedPlayerID", game.RedPlayerID);
cmd.Parameters.AddWithValue("YellowPlayerID", game.YellowPlayerID);
cmd.Parameters.AddWithValue("State", game.AsState());
await cmd.ExecuteNonQueryAsync();
}
}
}
