public PlInfoForm(int id_player)
{
InitializeComponent();
this.id_player = id_player;
ObjectInfoSystem.Player player = new ObjectInfoSystem.Player();
DB db = new DB();
MySqlCommand command = new MySqlCommand("SELECT * FROM players WHERE Id = @i_p", db.getConnection());
command.Parameters.Add("@i_p", MySqlDbType.Int32).Value = id_player;
db.openConnection();
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
name.Text = reader["first_name"].ToString();
lastName.Text = reader["last_name"].ToString();
dateOfBirth.Text = reader["date_of_birth"].ToString().Substring(0, 10);
nationality.Text = reader["nationality"].ToString();
workFoot.Text = reader["work_foot"].ToString();
position.Text = reader["positions"].ToString();
goals.Text = reader["goals"].ToString();
assists.Text = reader["assists"].ToString();
yellowCards.Text = reader["yellow_cards"].ToString();
redCards.Text = reader["red_cards"].ToString();
}
reader.Close();
}
public TeamInfoForm(int id_club, string login_user)
{
InitializeComponent();
team_id = id_club;
this.login_user = login_user;
ObjectInfoSystem.Club team = new ObjectInfoSystem.Club();
DB db = new DB();
MySqlCommand download_logo = new MySqlCommand("SELECT Logo FROM teams_logo WHERE team_id = @t_i", db.getConnection());
download_logo.Parameters.Add("@t_i", MySqlDbType.VarChar).Value = id_club;
db.openConnection();
MySqlDataReader reader = download_logo.ExecuteReader();
if (reader.Read())
{
byte[] image = (byte[])reader["Logo"];
if (image == null)
{
TeamLogo.Image = null;
}
else
{
MemoryStream mstream = new MemoryStream(image);
TeamLogo.Image = System.Drawing.Image.FromStream(mstream);
}
}
reader.Close();
MySqlCommand command = new MySqlCommand("SELECT * FROM `clubs` WHERE `Id` = @i_c", db.getConnection());
command.Parameters.Add("@i_c", MySqlDbType.VarChar).Value = id_club;
db.openConnection();
reader = command.ExecuteReader();
if (reader.Read())
{
team.club_info = reader["team_name"].ToString();
team.club_location = reader["club_location"].ToString();
team.creator_id = Int32.Parse(reader["Creator_id"].ToString());
team.captain_id = Int32.Parse(reader["captain_id"].ToString());
team.top_scorer_id = Int32.Parse(reader["top_scorer_id"].ToString());
team.rudest_player_id = Int32.Parse(reader["rudest_player_id"].ToString());
team.coach_id = Int32.Parse(reader["coach_id"].ToString());
team.goals_scored = Int32.Parse(reader["goals_scored"].ToString());
team.goals_conceded = Int32.Parse(reader["goals_conceded"].ToString());
team.winning_mathes = Int32.Parse(reader["winning_matches"].ToString());
team.loses_mathes = Int32.Parse(reader["losing_matches"].ToString());
team_id = Int32.Parse(reader["Id"].ToString());
team_manager_id = Int32.Parse(reader["Creator_id"].ToString());
}
reader.Close();
ObjectInfoSystem.User club_manager = new ObjectInfoSystem.User();
command = new MySqlCommand("SELECT * FROM `users` WHERE `Id` = @c_m", db.getConnection());
command.Parameters.Add("@c_m", MySqlDbType.VarChar).Value = team.creator_id;
reader = command.ExecuteReader();
if (reader.Read())
{
club_manager.first_name = reader["First_name"].ToString();
club_manager.last_name = reader["Last_name"].ToString();
club_manager.phone = reader["phone"].ToString();
club_manager.email = reader["email"].ToString();
}
reader.Close();
ClubManagerLabel.Text = club_manager.first_name + " " + club_manager.last_name +
"\n" + club_manager.phone + "\n" + club_manager.email;
ObjectInfoSystem.Coach coach = new ObjectInfoSystem.Coach();
command = new MySqlCommand("SELECT * FROM `coaches` WHERE `Id` = @c_i", db.getConnection());
command.Parameters.Add("@c_i", MySqlDbType.VarChar).Value = team.coach_id;
reader = command.ExecuteReader();
if (reader.Read())
{
coach.first_name = reader["first_name"].ToString();
coach.last_name = reader["last_name"].ToString();
coach.nationality = reader["nationality"].ToString();
coach.date_of_birth = reader["date_of_birth"].ToString().Substring(0, 10);
}
reader.Close();
HeadCoachLabel.Text = coach.first_name + " " + coach.last_name + "\n" + coach.nationality + "\n" + coach.date_of_birth;
ObjectInfoSystem.Player captain = new ObjectInfoSystem.Player();
command = new MySqlCommand("SELECT * FROM `players` WHERE `Id` = @c_i", db.getConnection());
command.Parameters.Add("@c_i", MySqlDbType.VarChar).Value = team.captain_id;
reader = command.ExecuteReader();
if (reader.Read())
{
captain.first_name = reader["first_name"].ToString();
captain.last_name = reader["last_name"].ToString();
captain.nationality = reader["nationality"].ToString();
captain.positions = reader["positions"].ToString();
captain.work_foot = Char.Parse(reader["work_foot"].ToString());
captain.date_of_birth = reader["date_of_birth"].ToString().Substring(0, 10);
/* captain.yellow_cards = Int32.Parse(reader["yellow_cards"].ToString());
* captain.red_cards = Int32.Parse(reader["red_cards"].ToString());
* captain.goals_scored = Int32.Parse(reader["goal_scored"].ToString());
* captain.asissts = Int32.Parse(reader["assists"].ToString());*/
}
ClubCaptainLabel.Text = captain.first_name + " " + captain.last_name +
"\n" + captain.nationality + "\n" + captain.positions + "\n" + captain.work_foot + "\n" +
captain.date_of_birth;
reader.Close();
ObjectInfoSystem.Player top_scorer = new ObjectInfoSystem.Player();
command = new MySqlCommand("SELECT * FROM `players` WHERE `Id` = @t_s", db.getConnection());
command.Parameters.Add("@t_s", MySqlDbType.VarChar).Value = team.top_scorer_id;
reader = command.ExecuteReader();
if (reader.Read())
{
top_scorer.first_name = reader["first_name"].ToString();
top_scorer.last_name = reader["last_name"].ToString();
top_scorer.nationality = reader["nationality"].ToString();
top_scorer.positions = reader["positions"].ToString();
top_scorer.work_foot = Char.Parse(reader["work_foot"].ToString());
top_scorer.goals_scored = Int32.Parse(reader["goals"].ToString());
//top_scorer.date_of_birth = reader["date_of_birth"].ToString();
/* captain.yellow_cards = Int32.Parse(reader["yellow_cards"].ToString());
* captain.red_cards = Int32.Parse(reader["red_cards"].ToString());
* captain.asissts = Int32.Parse(reader["assists"].ToString());*/
}
BestScorerLabel.Text = top_scorer.first_name + " " + top_scorer.last_name +
"\n" + top_scorer.nationality + "\n" + top_scorer.positions + "\n" + top_scorer.work_foot + "\n" +
top_scorer.date_of_birth + " Голов забил: " + top_scorer.goals_scored;
TeamsGoalScoredLabel.Text = "Голов забито: " + team.goals_scored;
TeamsGoalConcededLabel.Text = "Голов пропущено: " + team.goals_conceded;
TeamsWinnsLabel.Text = "Побед:" + team.winning_mathes;
TeamsLosesLabel.Text = "Поражений: " + team.loses_mathes;
reader.Close();
db.closeConnection();
}
