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();
}
}
protected void btnUpdateSponsor_Click(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "UpdateSuccessfully()", true);
Boolean FileOK = false;
Boolean FileSaved = false;
cs.SponsorId = Convert.ToInt32(hidRegID.Value);
if (ddlSports.SelectedValue == "")
{
cs.SportsId = 0;
}
else
{
cs.SportsId = Convert.ToInt32(ddlSports.SelectedValue);
}
if (ddlEvent.SelectedValue == "")
{
cs.EventId = 0;
}
else
{
cs.EventId = Convert.ToInt32(ddlEvent.SelectedValue);
}
if (ddlSeason.SelectedValue == "")
{
cs.SeasonId = 0;
}
else
{
cs.SeasonId = Convert.ToInt32(ddlSeason.SelectedValue);
}
if (ddlCompetition.SelectedValue == "")
{
cs.CompetitionId = 0;
}
else
{
cs.CompetitionId = Convert.ToInt32(ddlCompetition.SelectedValue);
}
if (ddlClub.SelectedValue == "")
{
cs.ClubId = 0;
}
else
{
cs.ClubId = Convert.ToInt32(ddlClub.SelectedValue);
}
if (ddlClubOwner.SelectedValue == "")
{
cs.ClubOwnersId = 0;
}
else
{
cs.ClubOwnersId = Convert.ToInt32(ddlClubOwner.SelectedValue);
}
if (ddlClubMember.SelectedValue == "")
{
cs.ClubMemberId = 0;
}
else
{
cs.ClubMemberId = Convert.ToInt32(ddlClubMember.SelectedValue);
}
if (ddlTeam.SelectedValue == "")
{
cs.TeamId = 0;
}
else
{
cs.TeamId = Convert.ToInt32(ddlTeam.SelectedValue);
}
if (ddlTeamMember.SelectedValue == "")
{
cs.TeamMemberId = 0;
}
else
{
cs.TeamMemberId = Convert.ToInt32(ddlTeamMember.SelectedValue);
}
if (ddlPlayer.SelectedValue == "")
{
cs.PlayerId = 0;
}
else
{
cs.PlayerId = Convert.ToInt32(ddlPlayer.SelectedValue);
}
if (ddlSponsorLevel.SelectedValue == "")
{
cs.SponsorLevelId = 0;
}
else
{
cs.SponsorLevelId = Convert.ToInt32(ddlSponsorLevel.SelectedValue);
}
if (ddlSponsorType.SelectedValue == "")
{
cs.SponsorTypeId = 0;
}
else
{
cs.SponsorTypeId = Convert.ToInt32(ddlSponsorType.SelectedValue);
}
cs.SponsorName = txtSponsorName.Text.Trim();
cs.SponsorAbbr = txtSponsorAbbreviation.Text.Trim();
cs.SponsorDesc = txtSponsorDetail.Text.Trim();
cs.SponsorLogoName = txtSponsorLogoName.Text.Trim();
if (SponsorLogoFile.PostedFile.FileName == "")
{
DataTable dt1 = new DataTable();
cs.SponsorId = Convert.ToInt32(hidRegID.Value);
dt1 = csc.GetSponsorLogoBySponsorID(cs);
SponsorLogoImage.ImageUrl = dt1.Rows[0]["SponsorLogoFile"].ToString();
string ufname = dt1.Rows[0]["SponsorLogoFile"].ToString().Replace(" ", "");
SponsorLogoFile.ResolveUrl("ufname");
cs.SponsorLogoFile = ufname.Replace(" ", "");
FileOKForUpdate = true;
}
else
{
cs.SponsorLogoFile = imhpathDB + SponsorLogoFile.PostedFile.FileName.Replace(" ", "");
if (SponsorLogoFile.PostedFile != null)
{
String FileExtension = Path.GetExtension(SponsorLogoFile.PostedFile.FileName.Replace(" ", "")).ToLower();
String[] allowedExtensions = { ".png", ".jpg", ".gif", ".jpeg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (FileExtension == allowedExtensions[i])
{
FileOK = true;
break;
}
}
}
if (!string.IsNullOrEmpty(SponsorLogoFile.PostedFile.FileName))
{
if (!FileOK)
{
//Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Alert", "alert('Please choose only .jpg, .png and .gif images For Competition !')", true);
return;
}
}
if (FileOK)
{
if (SponsorLogoFile.PostedFile.ContentLength > 10485760)
{
//dvMsg.Attributes.Add("style", "display:block;");
//return;
}
else
{
//dvMsg.Attributes.Add("style", "display:none;");
}
try
{
SponsorLogoFile.PostedFile.SaveAs(physicalpath + ImageUploadFolder + SponsorLogoFile.PostedFile.FileName.Replace(" ", ""));
FileSaved = true;
}
catch (Exception ex)
{
FileSaved = false;
}
}
}
cs.SponsorStartDate = txtSponsorStartDate.Text.Trim();
cs.SponsorEndDate = txtSponsorEndDate.Text.Trim();
cs.SponsorAmt = Convert.ToInt32(txtSponsorAmount.Text.Trim());
if (ChkIsActive.Checked == true)
{
cs.ActiveFlagId = 1;
}
else
{
cs.ActiveFlagId = 0;
}
if (ChkIsShow.Checked == true)
{
cs.ShowFlagId = 1;
}
else
{
cs.ShowFlagId = 0;
}
cs.PortalID = PortalId;
cs.ModifiedById = currentUser.Username;
int eventid = csc.UpdateSponsor(cs);
int evid = csc.UpdateSponsorSport(cs);
pnlSponsorEntry.Visible = false;
PnlGridSponsor.Visible = true;
FillGridView();
funClearData();
}
