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