protected void OnSelectTournament(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ConnectionString); connection.Open(); if (!String.IsNullOrEmpty(tournament_list.SelectedValue)) { var golfers = GolferService.ListActive(Convert.ToInt32(tournament_list.SelectedValue)); golfer_list.DataSource = golfers; golfer_list.DataBind(); golfer_list.Items.Insert(0, ""); golfer_list.SelectedIndex = 0; } connection.Close(); BindGrids(); }
protected void BindData() { var golfers = GolferService.ListActive(); golfer_grid.DataSource = golfers; golfer_grid.DataBind(); using (var db = new FantasyGolfContext()) { var tours = from x in db.Tour where x.IsActive == true orderby x.Name select x; tour_list.DataSource = tours.ToList(); tour_list.DataBind(); tour_list.Items.Insert(0, ""); tour_list.SelectedIndex = 0; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (base.IsLeagueSelected) { //load up values //SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ConnectionString); //connection.Open(); //var tournaments = connection.Query<Tournament>("Tournament_List", new { LeagueId = base.CurrentLeague }, commandType: CommandType.StoredProcedure); using (var db = new FantasyGolfContext()) { var tournaments = TournamentService.List(this.CurrentLeagueId); tournament_list.DataSource = tournaments; tournament_list.DataBind(); tournament_list.Items.Insert(0, ""); tournament_list.SelectedIndex = 0; //var users = connection.Query<RonsHouse.FantasyGolf.Model.User>("LeagueUser_List", new { LeagueId = base.CurrentLeague }, commandType: CommandType.StoredProcedure); var users = UserService.List(this.CurrentLeagueId); user_list.DataSource = users; user_list.DataBind(); user_list.Items.Insert(0, ""); user_list.SelectedIndex = 0; //var golfers = connection.Query<Golfer>("select *, LastName + ', ' + FirstName as Name from Golfer order by LastName"); var golfers = GolferService.ListActive(); golfer_list.DataSource = golfers; golfer_list.DataBind(); golfer_list.Items.Insert(0, ""); golfer_list.SelectedIndex = 0; } } message_label_panel.Visible = false; } }
protected void OnDataBoundUserPicks(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DropDownList golfer_list = (DropDownList)e.Row.FindControl("golfer_list"); golfer_list.DataSource = GolferService.ListActive(); //hopefully the caching works golfer_list.DataBind(); golfer_list.Items.Insert(0, "-- Choose a Golfer --"); //get current pick (if any) int tournamentId = Convert.ToInt32(((HiddenField)e.Row.FindControl("userpick_hidden")).Value); int userId = Convert.ToInt32(user_list.SelectedValue); var pick = UserPickService.Get(userId, tournamentId); //should get all on page load and search through collection (too many db calls) try { if (pick != null) { golfer_list.SelectedValue = pick.GolferId.ToString(); } } catch { } } }