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();
}
}
