protected void Fetch_Click(object sender, EventArgs e) { if (List01.SelectedIndex == 0) { MessageLabel.Text = "Select a category to view its products"; } else { try { PlayerController sysmgr = new PlayerController(); List <Player> info = null; info = sysmgr.Player_GetByTeam(int.Parse(List01.SelectedValue)); info.Sort((x, y) => x.LastName.CompareTo(y.LastName)); PlayerList.DataSource = info; PlayerList.DataBind(); PlayerList.DataSource = info; PlayerList.DataBind(); } catch (Exception ex) { MessageLabel.Text = ex.Message; } } }
private void loadAllPlayersDDL() { DTO_Player[] players = WebSiteManager.GetAllPlayers(); List <string> playerNames = new List <string>(); playerNames.Add("Select Player"); Session["AllPlayers"] = players; foreach (DTO_Player pl in players) { playerNames.Add(pl.FirstName + " " + pl.LastName); } PlayerList.DataSource = playerNames; PlayerList.DataBind(); }
// get current logged in account player names for and load them into drop drop-down-list private void loadLoggedInUserPlayers() { DTO_ACCOUNT loggedInAccount = (DTO_ACCOUNT)(Session[WebSiteManager.LOGGEDIN_ACCOUNT_SESSION]); DTO_Player[] loggedInAccountPlayers = loggedInAccount.players; List <ListItem> loggedInAccountPlayersNames = new List <ListItem>(); for (int i = 0; i < loggedInAccountPlayers.Length; i++) { loggedInAccountPlayersNames.Add(new ListItem(loggedInAccountPlayers[i].FirstName + " " + loggedInAccountPlayers[i].LastName)); } PlayerList.DataSource = loggedInAccountPlayersNames; PlayerList.DataBind(); PlayerList2.DataSource = loggedInAccountPlayersNames; PlayerList2.DataBind(); }
protected void BindPlayerList() { try { PlayerController sysmgr = new PlayerController(); List <Player> info = sysmgr.Player_List(); info.Sort((x, y) => x.FullName.CompareTo(y.FullName)); PlayerList.DataSource = info; PlayerList.DataTextField = "FullName"; PlayerList.DataValueField = "PlayerID"; PlayerList.DataBind(); PlayerList.Items.Insert(0, "Select a player"); } catch (Exception ex) { errormsgs.Add(GetInnerException(ex).ToString()); LoadMessageDisplay(errormsgs, "alert alert-danger"); } }
protected void BindPlayerList() { try { // Here this will be similar to using the ObjectDataSource except now we're doing this more in the code behind instead of the web form // This is considered better for bigger projects PlayerController playerController = new PlayerController(); List<Player> playerInfo = null; playerInfo = playerController.Player_List(); playerInfo.Sort((x, y) => x.FullName.CompareTo(y.FullName)); PlayerList.DataSource = playerInfo; PlayerList.DataTextField = nameof(Player.FullName); PlayerList.DataValueField = nameof(Player.PlayerID); PlayerList.DataBind(); PlayerList.Items.Insert(0, "Select a player..."); } catch (Exception ex) { Message.Visible = true; Message.Text = ex.Message; } }
private void BindPlayers() { int clubId = (int)Session["ClubDetailsId"]; SqlCommand command = new SqlCommand(); command.CommandText = "SelectPlayers"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("RegID", SqlDbType.Int); command.Parameters["RegID"].Value = clubId; DataConnection myConnection = new DataConnection(); try { PlayerList.DataSource = myConnection.ExecuteCommand(command); PlayerList.DataKeyNames = new string[] { "PlayerName" }; PlayerList.DataBind(); } finally { myConnection.CloseConection(); } }
protected void Fetch_Click(object sender, EventArgs e) { if (TeamList.SelectedIndex == 0) { MessageLabel.Text = "Select a team to view its players."; Coach.Text = ""; AssistantCoach.Text = ""; Wins.Text = ""; Losses.Text = ""; } else { try { PlayerController playerController = new PlayerController(); List <Players> listOfPlayers = null; listOfPlayers = playerController.FindByID(int.Parse(TeamList.SelectedValue)); listOfPlayers.Sort((x, y) => x.PlayerName.CompareTo(y.PlayerName)); PlayerList.DataSource = listOfPlayers; PlayerList.DataBind(); TeamController teamController = new TeamController(); Teams teamInfo = null; teamInfo = teamController.Teams_FindByID(int.Parse(TeamList.SelectedValue)); Coach.Text = teamInfo.Coach; AssistantCoach.Text = teamInfo.AssistantCoach; Wins.Text = teamInfo.Wins.ToString(); Losses.Text = teamInfo.Losses.ToString(); } catch (Exception ex) { MessageLabel.Text = ex.Message; } } }
protected void Fetch_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(TeamList.Text)) { MessageLabel.Text = "No team selected"; } else { int teamid = 0; if (int.TryParse(TeamList.Text, out teamid)) { if (teamid > 0) { TeamController sysmgr = new TeamController(); Team info = null; info = sysmgr.Teams_FindByID(teamid); if (info == null) { MessageLabel.Text = "Team not found."; Coach.Text = ""; AssistantCoach.Text = ""; Wins.Text = ""; Losses.Text = ""; } else { Coach.Text = info.Coach.ToString(); AssistantCoach.Text = info.AssistantCoach.ToString(); if (info.Wins == null) { Wins.Text = "0"; } else { Wins.Text = info.Wins.ToString(); } if (info.Losses == null) { Losses.Text = "0"; } else { Losses.Text = info.Losses.ToString(); } } //} //catch(Exception ex) //{ // MessageLabel.Text = ex.Message; //} } else { MessageLabel.Text = "Team id must be greater than 0"; } } else { MessageLabel.Text = "Team id must be a number."; } } if (TeamList.SelectedIndex == 0) { MessageLabel.Text = "Please select a team"; } else { try { PlayerController sysmgr = new PlayerController(); List <Player> info = null; info = sysmgr.Player_GetByTeam(int.Parse(TeamList.SelectedValue)); info.Sort((x, y) => x.FullName.CompareTo(y.FullName)); PlayerList.DataSource = info; PlayerList.DataBind(); } catch (Exception ex) { MessageLabel.Text = ex.Message; } } }