private void FillTeamMember()
        {
            clsEvent           e  = new clsEvent();
            clsEventController ec = new clsEventController();
            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 FillClubOwner(int ClubID)
        {
            clsEvent           e  = new clsEvent();
            clsEventController ec = new clsEventController();
            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 FillTeam(int SportID, int ClubID)
        {
            clsEvent           e  = new clsEvent();
            clsEventController ec = new clsEventController();
            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)
        {
            clsEvent           e  = new clsEvent();
            clsEventController ec = new clsEventController();
            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 Competition --", "0"));
            }
        }
        private void FillSeason()
        {
            clsEvent           e  = new clsEvent();
            clsEventController ec = new clsEventController();
            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)
        {
            hdnEventID.Value = ((Label)((DropDownList)sender).Parent.FindControl("lblddlActionEventID")).Text;

            string ddlSelectedValue = ((DropDownList)sender).SelectedValue;

            if (ddlSelectedValue == "Edit")
            {
                funClearData();
                FillSport();
                FillSeason();
                FillCompetition();
                FillClub();
                FillClubOwner();
                FillClubMember();
                FillTeam();
                FillTeamMember();
                FillSponsor();



                LinkButton btn = sender as LinkButton;

                clsEvent           cs  = new clsEvent();
                clsEventController csc = new clsEventController();

                DataTable dt = new DataTable();

                dt = csc.GetEventDataByEventID(eventID);

                if (dt.Rows.Count > 0)
                {
                    hidRegID.Value = dt.Rows[0]["EventID"].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();
                    ddlSponsor.SelectedValue     = dt.Rows[0]["SponsorId"].ToString();

                    txtEventName.Text          = dt.Rows[0]["EventName"].ToString();
                    txtEventDetail.Text        = dt.Rows[0]["EventDetail"].ToString();
                    txtEventStartDateTime.Text = dt.Rows[0]["EventStartDateTime"].ToString();
                    txtEventEndDateTime.Text   = dt.Rows[0]["EventEndDateTime"].ToString();


                    if (dt.Rows[0]["EventActive"].ToString() == "1")
                    {
                        ChkIsActive.Checked = true;
                    }
                    else
                    {
                        ChkIsActive.Checked = false;
                    }

                    ddlEventPriority.SelectedValue = dt.Rows[0]["EventPriority"].ToString();

                    pnlEventEntry.Visible  = true;
                    PnlGridEvent.Visible   = false;
                    btnUpdateEvent.Visible = true;
                    btnSaveEvent.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();

                if (csc.IsEventHasOtherData(eventID).Rows[0]["RefData"].ToString() != "")
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "DeleteConfirm('" + "Delete" + "');;", true);
                }
                else
                {
                    DeleteEvent();
                }
            }
        }