public frmPlayerInfo(ActiveFoward tag)
{
InitializeComponent();
ActiveFoward foward = tag;
lblName.Text = foward.Name;
lblPlayerPoints.Text = foward.Points.ToString();
lblPlayerRebounds.Text = foward.Rebounds.ToString();
lblPlayerAssists.Text = foward.Assists.ToString();
lblPlayerPER.Text = foward.Per.ToString();
lblPlayerOffRating.Text = foward.OffRating.ToString();
lblPlayerDefRating.Text = foward.DefRating.ToString();
lblAge.Text = foward.Age.ToString();
lblExperience.Text = foward.YearsExp.ToString() + " Years";
lblYearDrafted.Text = foward.DraftYear.ToString();
lblTeam.Text = foward.Team.ToString();
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 = foward.VideoLink.ToString();
this.browser.DocumentText = string.Format(embed, url);
FowardPictures fPics = ShowFowardPic; // delegate assignment
fPics.Invoke(foward);
}
private void LoadActiveFowards()
{
i = 0;
using (connection = new SqlConnection(connectionString))
{
connection.Open();
sqlCommand = "SELECT * FROM ActiveFowards";
using (command = new SqlCommand(sqlCommand, connection))
using (dataReader = command.ExecuteReader())
{
// 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, blocks, steals, turnovers, rebounds;
// 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,
blocksOrdinal, weightOrdinal, stealsOrdinal, turnoversOrdinal, reboundsOrdinal;
// 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");
yearsExpOrdinal = dataReader.GetOrdinal("Years Exp");
teamOrdinal = dataReader.GetOrdinal("Team");
videoLinkOrdinal = dataReader.GetOrdinal("Video Link");
stealsOrdinal = dataReader.GetOrdinal("Steals");
turnoversOrdinal = dataReader.GetOrdinal("Turnovers");
reboundsOrdinal = dataReader.GetOrdinal("Rebounds");
// counter variable for list index
int i = 0;
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);
blocks = dataReader.GetDouble(blocksOrdinal);
weight = dataReader.GetInt32(weightOrdinal);
steals = dataReader.GetDouble(stealsOrdinal);
rebounds = dataReader.GetDouble(reboundsOrdinal);
turnovers = dataReader.GetDouble(turnoversOrdinal);
currentFowards[i] = new ActiveFoward(playerID, name, jerseyNum, height, draftYear, weight, college, points, rebounds, assists,
freethrowPercent, twoPointPercent, threePointPercent, per, offRating, defRating, age, steals, turnovers, blocks, yearsExp, team,
videoLink);
i++;
}
}
}
}
void ShowFowardPic(ActiveFoward foward)
{
if (foward.PlayerID == 39)
{
pbxPlayer.Image = Resources.Resource1.Kevin_Durant;
}
else if (foward.PlayerID == 40)
{
pbxPlayer.Image = Resources.Resource1.Draymond_Green;
}
else if (foward.PlayerID == 41)
{
pbxPlayer.Image = Resources.Resource1.Paul_George;
}
else if (foward.PlayerID == 42)
{
pbxPlayer.Image = Resources.Resource1.Carmelo_Anthony;
}
else if (foward.PlayerID == 43)
{
pbxPlayer.Image = Resources.Resource1.Lamarcus_Aldridge;
}
else if (foward.PlayerID == 44)
{
pbxPlayer.Image = Resources.Resource1.Kawhi_Leonard;
}
else if (foward.PlayerID == 45)
{
pbxPlayer.Image = Resources.Resource1.Gordon_Hayward;
}
else if (foward.PlayerID == 46)
{
pbxPlayer.Image = Resources.Resource1.Jason_Tatum;
}
else if (foward.PlayerID == 47)
{
pbxPlayer.Image = Resources.Resource1.Ben_Simmons;
}
else if (foward.PlayerID == 48)
{
pbxPlayer.Image = Resources.Resource1.Lebron_James;
}
else if (foward.PlayerID == 49)
{
pbxPlayer.Image = Resources.Resource1.Kevin_Love;
}
else if (foward.PlayerID == 50)
{
pbxPlayer.Image = Resources.Resource1.GreekFreek;
}
else if (foward.PlayerID == 51)
{
pbxPlayer.Image = Resources.Resource1.Blake_Griffin;
}
else if (foward.PlayerID == 52)
{
pbxPlayer.Image = Resources.Resource1.Paul_Millsap;
}
else if (foward.PlayerID == 53)
{
pbxPlayer.Image = Resources.Resource1.Vince_Carter;
}
else if (foward.PlayerID == 54)
{
pbxPlayer.Image = Resources.Resource1.Dirk;
}
else if (foward.PlayerID == 55)
{
pbxPlayer.Image = Resources.Resource1.Nicolas_Batum;
}
else if (foward.PlayerID == 56)
{
pbxPlayer.Image = Resources.Resource1.Andre_Iguodala;
}
}
