private void FillClubOwner(int ClubID) { clsPictures e = new clsPictures(); clsPicturesController ec = new clsPicturesController(); DataTable dt = new DataTable(); dt = ec.GetClubOwnerIDAndClubOwnerName(ClubID); 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() { clsPictures e = new clsPictures(); clsPicturesController ec = new clsPicturesController(); DataTable dt = new DataTable(); dt = ec.FillTeamMemberIDAndTeamMemberName(); 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) { clsPictures e = new clsPictures(); clsPicturesController ec = new clsPicturesController(); DataTable dt = new DataTable(); dt = ec.GetTeamIDAndTeamName(SportID, ClubID); 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 FillCompetition(int SportID) { clsPictures e = new clsPictures(); clsPicturesController ec = new clsPicturesController(); DataTable dt = new DataTable(); dt = ec.GetCompetitionIDAndCompetitionName(SportID); 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 FillPlayer(int TeamID) { clsPictures e = new clsPictures(); clsPicturesController ec = new clsPicturesController(); DataTable dt = new DataTable(); dt = ec.GetPlayerIDAndPlayerNameByTeamID(TeamID); 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 FillSeason() { clsPictures e = new clsPictures(); clsPicturesController ec = new clsPicturesController(); 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("lblddlActionPictureID")).Text; string ddlSelectedValue = ((DropDownList)sender).SelectedValue; if (ddlSelectedValue == "Edit") { funClearData(); FillSport(); FillCountry(); FillEvent(); FillSeason(); FillCompetition(); FillClub(); FillClubOwner(); FillClubMember(); FillTeam(); FillTeamMember(); FillPlayer(); FillSponsor(); int PictureID = 0; int.TryParse(str, out PictureID); LinkButton btn = sender as LinkButton; clsPictures cs = new clsPictures(); clsPicturesController csc = new clsPicturesController(); DataTable dt = new DataTable(); dt = csc.GetPictureDataByPictureID(PictureID); if (dt.Rows.Count > 0) { hidRegID.Value = dt.Rows[0]["PictureId"].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(); ddlPicturePriority.SelectedValue = dt.Rows[0]["PictureLevelId"].ToString(); txtPictureTitle.Text = dt.Rows[0]["PictureTitle"].ToString(); txtPictureDesc.Text = dt.Rows[0]["PictureDesc"].ToString(); txtPictureDate.Text = dt.Rows[0]["PictureDate"].ToString(); PictureLogoImage.ImageUrl = dt.Rows[0]["PictureFile"].ToString(); string ufname = dt.Rows[0]["PictureFile"].ToString().Replace(" ", ""); PictureLogoFile.ResolveUrl("ufname"); 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; } pnlEntryPicture.Visible = true; PnlGridPicture.Visible = false; btnUpdatePicture.Visible = true; btnSavePicture.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(); } }