private void FillPlayer() { clsVideos e = new clsVideos(); clsVideosController ec = new clsVideosController(); DataTable dt = new DataTable(); dt = ec.GetAllPlayer(); if (dt.Rows.Count > 0) { ddlPlayer.DataSource = dt; ddlPlayer.DataTextField = "PlayerName"; ddlPlayer.DataValueField = "RegistrationId"; ddlPlayer.DataBind(); ddlPlayer.Items.Insert(0, new ListItem("-- Select --", "0")); } }
private void FillCompetition(int SportID) { clsVideos e = new clsVideos(); clsVideosController ec = new clsVideosController(); DataTable dt = new DataTable(); dt = ec.GetAllCompetition(); if (dt.Rows.Count > 0) { ddlCompetition.DataSource = dt; ddlCompetition.DataTextField = "CompetitionName"; ddlCompetition.DataValueField = "CompetitionId"; ddlCompetition.DataBind(); ddlCompetition.Items.Insert(0, new ListItem("-- Select --", "0")); } }
private void FillClubOwner() { clsVideos e = new clsVideos(); clsVideosController ec = new clsVideosController(); DataTable dt = new DataTable(); dt = ec.FillClubOwnerIDAndClubOwnerName(); if (dt.Rows.Count > 0) { ddlClubOwner.DataSource = dt; ddlClubOwner.DataTextField = "ClubOwnerName"; ddlClubOwner.DataValueField = "ClubOwnersId"; ddlClubOwner.DataBind(); ddlClubOwner.Items.Insert(0, new ListItem("-- Select --", "0")); } }
private void FillTeamMember(int TeamID) { clsVideos e = new clsVideos(); clsVideosController ec = new clsVideosController(); DataTable dt = new DataTable(); dt = ec.GetTeamMemberIDAndTeamMemberName(TeamID); if (dt.Rows.Count > 0) { ddlTeamMember.DataSource = dt; ddlTeamMember.DataTextField = "TeamMemberName"; ddlTeamMember.DataValueField = "TeamMemberID"; ddlTeamMember.DataBind(); ddlTeamMember.Items.Insert(0, new ListItem("-- Select --", "0")); } }
private void FillTeam(int SportID, int ClubID) { clsVideos e = new clsVideos(); clsVideosController ec = new clsVideosController(); DataTable dt = new DataTable(); dt = ec.GetAllTeams(); if (dt.Rows.Count > 0) { ddlTeam.DataSource = dt; ddlTeam.DataTextField = "TeamName"; ddlTeam.DataValueField = "TeamId"; ddlTeam.DataBind(); ddlTeam.Items.Insert(0, new ListItem("-- Select --", "0")); } }
private void FillSeason() { clsVideos e = new clsVideos(); clsVideosController ec = new clsVideosController(); DataTable dt = new DataTable(); dt = ec.GetSeasonIDAndSeasonName(); if (dt.Rows.Count > 0) { ddlSeason.DataSource = dt; ddlSeason.DataTextField = "SeasonName"; ddlSeason.DataValueField = "SeasonID"; ddlSeason.DataBind(); ddlSeason.Items.Insert(0, new ListItem("-- Select --", "0")); } }
protected void ddlAction_SelectedIndexChanged(object sender, EventArgs e) { string str = ((Label)((DropDownList)sender).Parent.FindControl("lblddlActionVideoID")).Text; string ddlSelectedValue = ((DropDownList)sender).SelectedValue; if (ddlSelectedValue == "Edit") { funClearData(); FillSport(); FillCountry(); FillEvent(); FillSeason(); FillCompetition(); FillClub(); FillClubOwner(); FillClubMember(); FillTeam(); FillTeamMember(); FillPlayer(); FillSponsor(); int VideoID = 0; int.TryParse(str, out VideoID); LinkButton btn = sender as LinkButton; clsVideos cs = new clsVideos(); clsVideosController csc = new clsVideosController(); DataTable dt = new DataTable(); dt = csc.GetVideoDataByVideoID(VideoID); if (dt.Rows.Count > 0) { hidRegID.Value = dt.Rows[0]["VideoId"].ToString(); ddlSports.SelectedValue = dt.Rows[0]["SportId"].ToString(); ddlSeason.SelectedValue = dt.Rows[0]["SeasonId"].ToString(); ddlCompetition.SelectedValue = dt.Rows[0]["CompetitionId"].ToString(); ddlClub.SelectedValue = dt.Rows[0]["ClubId"].ToString(); ddlClubOwner.SelectedValue = dt.Rows[0]["ClubOwnersId"].ToString(); ddlClubMember.SelectedValue = dt.Rows[0]["ClubMemberId"].ToString(); ddlTeam.SelectedValue = dt.Rows[0]["TeamId"].ToString(); ddlTeamMember.SelectedValue = dt.Rows[0]["TeamMemberId"].ToString(); ddlPlayer.SelectedValue = dt.Rows[0]["PlayerId"].ToString(); ddlEvent.SelectedValue = dt.Rows[0]["EventId"].ToString(); ddlSponsor.SelectedValue = dt.Rows[0]["SponsorId"].ToString(); ddlCountry.SelectedValue = dt.Rows[0]["CountryID"].ToString(); ddlVideoPriority.SelectedValue = dt.Rows[0]["VideoLevelId"].ToString(); txtVideoTitle.Text = dt.Rows[0]["VideoTitle"].ToString(); txtVideoDesc.Text = dt.Rows[0]["VideoDesc"].ToString(); txtVideoDate.Text = dt.Rows[0]["VideoDate"].ToString(); txtVideoPath.Text = dt.Rows[0]["VideoYouTubeFile"].ToString(); //HtmlGenericControl contentPanel1 = (HtmlGenericControl)this.FindControl("ifmOtherVideoPath"); //contentPanel1.Attributes.Add("src", "/DesktopModules/ThSportSite/" + dt.Rows[0]["VideoOtherFile"].ToString()); //ifmOtherVideoPath.Attributes.Add("src", "/DesktopModules/ThSportSite/" + dt.Rows[0]["VideoOtherFile"].ToString()); ifmOtherVideoPath.InnerHtml = "\\DesktopModules\\ThSportSite\\" + dt.Rows[0]["VideoOtherFile"].ToString(); if (dt.Rows[0]["VideoType"].ToString() == "1") { ddlvideotype.SelectedValue = "YouTube"; divvideopath.Visible = true; divOtherVideoPath.Visible = false; ifmOtherVideoPath.Visible = false; } else { ddlvideotype.SelectedValue = "Other"; divvideopath.Visible = false; divOtherVideoPath.Visible = true; ifmOtherVideoPath.Visible = true; } if (dt.Rows[0]["ActiveFlagId"].ToString() == "1") { ChkIsActive.Checked = true; } else { ChkIsActive.Checked = false; } if (dt.Rows[0]["ShowFlagId"].ToString() == "1") { ChkIsShow.Checked = true; } else { ChkIsShow.Checked = false; } pnlEntryVideo.Visible = true; PnlGridVideo.Visible = false; btnUpdateVideo.Visible = true; btnSaveVideo.Visible = false; } } else if (ddlSelectedValue == "Delete") { //Page.ClientScript.RegisterStartupScript(this.GetType(), "", "javascript:confirm('Are You Sure? Want To Delete.');", true); //Page.ClientScript.RegisterStartupScript(this.GetType(), "confirm", "javascript:Confirmation();", true); //int competition_Id = 0; //int.TryParse(str, out competition_Id); //CompRegInfo.DeleteCompetitionReg(competition_Id); //FillGridView(); } }