public frmPlayerInfo(ActiveCenter tag) { InitializeComponent(); ActiveCenter center = tag; lblName.Text = center.Name; lblPlayerPoints.Text = center.Points.ToString(); lblPlayerRebounds.Text = Convert.ToString(center.OffRebounds + center.DefRebounds); lblPlayerAssists.Text = center.Assists.ToString(); lblPlayerPER.Text = center.Per.ToString(); lblPlayerOffRating.Text = center.OffRating.ToString(); lblPlayerDefRating.Text = center.DefRating.ToString(); lblAge.Text = center.Age.ToString(); lblExperience.Text = center.YearsExp.ToString() + " Years"; lblYearDrafted.Text = center.DraftYear.ToString(); lblTeam.Text = center.ReturnTeam(); // use of ITeam CenterPictures cPics = ShowCenterPic; // delegate assignment cPics.Invoke(center); var embed = "<html><head>" + "<meta http-equiv=\"x-ua-compatible\" content=\"ie=edge\"/>" + "</head><body>" + "<iframe width=\"640\" src=\"{0}\"" + "frameborder = \"0\" allow = \"autoplay; encrypted-media\" allowfullscreen></iframe>" + "</body></html>"; var url = center.VideoLink.ToString(); this.browser.DocumentText = string.Format(embed, url); }
void ShowCenterPic(ActiveCenter center) { if (center.PlayerID == 1) { pbxPlayer.Image = Resources.Resource1.Demarcus_Cousins; } else if (center.PlayerID == 2) { pbxPlayer.Image = Resources.Resource1.Rudy_Gobert; } else if (center.PlayerID == 3) { pbxPlayer.Image = Resources.Resource1.Anthony_Davis; } else if (center.PlayerID == 4) { pbxPlayer.Image = Resources.Resource1.Pau_Gasol; } else if (center.PlayerID == 5) { pbxPlayer.Image = Resources.Resource1.KAT; } else if (center.PlayerID == 6) { pbxPlayer.Image = Resources.Resource1.Al_Horford; } else if (center.PlayerID == 7) { pbxPlayer.Image = Resources.Resource1.Joel_Embiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiid; } else if (center.PlayerID == 8) { pbxPlayer.Image = Resources.Resource1.Nikola_Jokic; } else if (center.PlayerID == 9) { pbxPlayer.Image = Resources.Resource1.Kristaps; } else if (center.PlayerID == 10) { pbxPlayer.Image = Resources.Resource1.Marc_Gasol; } else if (center.PlayerID == 11) { pbxPlayer.Image = Resources.Resource1.Steven_Adams; } else if (center.PlayerID == 12) { pbxPlayer.Image = Resources.Resource1.Clint_Capela; } }
// Methods to create players from DB private void LoadActiveCenters() { i = 0; // initialize counter variable // open DB using (connection = new SqlConnection(connectionString)) { connection.Open(); sqlCommand = "SELECT * FROM ActiveCenters"; // SQL Query using (command = new SqlCommand(sqlCommand, connection)) using (dataReader = command.ExecuteReader()) // execute sql command { // Active Center Constructor variables int playerID, jerseyNum, draftYear, age, yearsExp, weight; string name, height, college, team, videoLink; double points, assists, freethrowPercent, twoPointPercent, threePointPercent, per, offRating, defRating, defRebounds, offRebounds, blocks; // Active Center Ordinals to recieve column values from Active Centers Table int playerIDOrdinal, jerseyNumOrdinal, draftYearOrdinal, ageOrdinal, yearsExpOrdinal, nameOrdinal, heightOrdinal, collegeOrdinal, teamOrdinal, videoLinkOrdinal, pointsOrdinal, assistsOrdinal, freethrowPercentOrdinal, twoPointPercentOrdinal, threePointPercentOrdinal, perOrdinal, offRatingOrdinal, defRatingOrdinal, defReboundsOrdinal, offReboundsOrdinal, blocksOrdinal, weightOrdinal; // get Ordinal DB values playerIDOrdinal = dataReader.GetOrdinal("PlayerID"); nameOrdinal = dataReader.GetOrdinal("Player Name"); jerseyNumOrdinal = dataReader.GetOrdinal("JerseyNumber"); heightOrdinal = dataReader.GetOrdinal("Height"); draftYearOrdinal = dataReader.GetOrdinal("DraftYear"); weightOrdinal = dataReader.GetOrdinal("Weight"); collegeOrdinal = dataReader.GetOrdinal("College "); pointsOrdinal = dataReader.GetOrdinal("PPG"); assistsOrdinal = dataReader.GetOrdinal("Assists"); freethrowPercentOrdinal = dataReader.GetOrdinal("Freethrow %"); twoPointPercentOrdinal = dataReader.GetOrdinal("2 Point %"); threePointPercentOrdinal = dataReader.GetOrdinal("3 Point % "); perOrdinal = dataReader.GetOrdinal("PER"); offRatingOrdinal = dataReader.GetOrdinal("Offensive Rating"); defRatingOrdinal = dataReader.GetOrdinal("Defensive Rating"); ageOrdinal = dataReader.GetOrdinal("age"); blocksOrdinal = dataReader.GetOrdinal("Blocks"); offReboundsOrdinal = dataReader.GetOrdinal("Offensive Rebounds"); defReboundsOrdinal = dataReader.GetOrdinal("Defensive Rebounds"); yearsExpOrdinal = dataReader.GetOrdinal("Years Exp"); teamOrdinal = dataReader.GetOrdinal("Team"); videoLinkOrdinal = dataReader.GetOrdinal("Video Link"); while (dataReader.Read()) { // convert ordinal values to constructor variables playerID = dataReader.GetInt32(playerIDOrdinal); jerseyNum = dataReader.GetInt32(jerseyNumOrdinal); draftYear = dataReader.GetInt32(draftYearOrdinal); age = dataReader.GetInt32(ageOrdinal); yearsExp = dataReader.GetInt32(yearsExpOrdinal); name = dataReader.GetString(nameOrdinal); height = dataReader.GetString(heightOrdinal); college = dataReader.GetString(collegeOrdinal); team = dataReader.GetString(teamOrdinal); videoLink = dataReader.GetString(videoLinkOrdinal); points = dataReader.GetDouble(pointsOrdinal); assists = dataReader.GetDouble(assistsOrdinal); freethrowPercent = dataReader.GetDouble(freethrowPercentOrdinal); twoPointPercent = dataReader.GetDouble(twoPointPercentOrdinal); threePointPercent = dataReader.GetDouble(threePointPercentOrdinal); per = dataReader.GetDouble(perOrdinal); offRating = dataReader.GetDouble(offRatingOrdinal); defRating = dataReader.GetDouble(defRatingOrdinal); defRebounds = dataReader.GetDouble(defReboundsOrdinal); offRebounds = dataReader.GetDouble(offReboundsOrdinal); blocks = dataReader.GetDouble(blocksOrdinal); weight = dataReader.GetInt32(weightOrdinal); // instantiate new player currentCenters[i] = new ActiveCenter(playerID, name, jerseyNum, height, draftYear, weight, college, points, assists, freethrowPercent, twoPointPercent, threePointPercent, per, offRating, defRating, age, blocks, offRebounds, defRebounds, yearsExp, team, videoLink); i++; } } } }