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++;
}
}
}
}
