protected void Page_Load(object sender, EventArgs e)
{
clsSponsorController spo = new clsSponsorController();
DataTable dt = spo.GetSponsorListForUserSide();
if (dt.Rows.Count > 0)
{
SponsorList.DataSource = dt;
SponsorList.DataBind();
}
}
private void FillTeamMember(int TeamID)
{
clsSponsor e = new clsSponsor();
clsSponsorController ec = new clsSponsorController();
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 FillClub(int SportID)
{
clsSponsor e = new clsSponsor();
clsSponsorController ec = new clsSponsorController();
DataTable dt = new DataTable();
dt = ec.GetClubIDAndClubName(SportID);
if (dt.Rows.Count > 0)
{
ddlClub.DataSource = dt;
ddlClub.DataTextField = "ClubName";
ddlClub.DataValueField = "ClubId";
ddlClub.DataBind();
ddlClub.Items.Insert(0, new ListItem("-- Select --", "0"));
}
}
private void FillPlayer(int TeamID)
{
clsSponsor e = new clsSponsor();
clsSponsorController ec = new clsSponsorController();
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()
{
clsSponsor e = new clsSponsor();
clsSponsorController ec = new clsSponsorController();
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)
{
hdnSponsorID.Value = ((Label)((DropDownList)sender).Parent.FindControl("lblddlActionSponsorID")).Text;
string ddlSelectedValue = ((DropDownList)sender).SelectedValue;
if (ddlSelectedValue == "Edit")
{
funClearData();
FillSport();
FillEvent();
FillSeason();
FillCompetition();
FillClub();
FillClubOwner();
FillClubMember();
FillTeam();
FillTeamMember();
FillPlayer();
FillSponsorLevel();
FillSponsorType();
LinkButton btn = sender as LinkButton;
clsSponsor cs = new clsSponsor();
clsSponsorController csc = new clsSponsorController();
DataTable dt = new DataTable();
dt = csc.GetSponsorDataBySponsorID(sponsorID);
if (dt.Rows.Count > 0)
{
hidRegID.Value = dt.Rows[0]["SponsorId"].ToString();
ddlSports.SelectedValue = dt.Rows[0]["SportsId"].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();
ddlSponsorLevel.SelectedValue = dt.Rows[0]["SponsorLevelId"].ToString();
ddlSponsorType.SelectedValue = dt.Rows[0]["SponsorTypeId"].ToString();
txtSponsorName.Text = dt.Rows[0]["SponsorName"].ToString();
txtSponsorAbbreviation.Text = dt.Rows[0]["SponsorAbbr"].ToString();
txtSponsorDetail.Text = dt.Rows[0]["SponsorDesc"].ToString();
txtSponsorLogoName.Text = dt.Rows[0]["SponsorLogoName"].ToString();
SponsorLogoImage.ImageUrl = dt.Rows[0]["SponsorLogoFile"].ToString();
string ufname = dt.Rows[0]["SponsorLogoFile"].ToString().Replace(" ", "");
SponsorLogoFile.ResolveUrl("ufname");
txtSponsorStartDate.Text = dt.Rows[0]["SponsorStartDate"].ToString();
txtSponsorEndDate.Text = dt.Rows[0]["SponsorEndDate"].ToString();
txtSponsorAmount.Text = dt.Rows[0]["SponsorAmt"].ToString();
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;
}
pnlSponsorEntry.Visible = true;
PnlGridSponsor.Visible = false;
btnUpdateSponsor.Visible = true;
btnSaveSponsor.Visible = false;
}
}
else if (ddlSelectedValue == "Delete")
{
if (csc.IsSponsorHasOtherData(sponsorID).Rows[0]["RefData"].ToString() != "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "DeleteConfirm('" + "Delete" + "');;", true);
}
else
{
DeleteSponsor();
}
//int competition_Id = 0;
//int.TryParse(str, out competition_Id);
//CompRegInfo.DeleteCompetitionReg(competition_Id);
//FillGridView();
}
}
