protected void AddSubGenre_Click(object sender, EventArgs e)
        {
            using (Database db = new MySqlDatabase())
            {
                db.AddSubGenre(addSubGenreText.Text.Trim(), Convert.ToInt32(ViewState["GenreID"]));

                SubGenreList.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["GenreID"]));
                SubGenreList.DataTextField = "Value";
                SubGenreList.DataValueField = "Key";
                SubGenreList.DataBind();
                SubGenreList.Items.Insert(0, new ListItem("--Select--", "Select"));
                SubGenreList.Items.Insert(1, new ListItem("--Add New Sub Genre--", "Add"));

                GenreList.SelectedValue = Convert.ToString(ViewState["GenreID"]);
            }

            divAddSubGenre.Visible = false;
        }
        protected void Genre3_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (!((DropDownList)sender).SelectedItem.Value.Contains("Select"))
            {
                ViewState["Genre3"] = ((DropDownList)sender).SelectedItem.Value;

                using (Database db = new MySqlDatabase())
                {
                    SubGenre3.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["Genre3"]));
                    SubGenre3.DataTextField = "Value";
                    SubGenre3.DataValueField = "Key";
                    SubGenre3.DataBind();
                    SubGenre3.Items.Insert(0, new ListItem("--Select--", null));
                }
            }
            else
            {
                ViewState["Genre3"] = null;
            }

            if (cbxSendToFacebook.Checked)
                divFBSharing.Attributes.Add("style", "display:block");
            else
                divFBSharing.Attributes.Add("style", "display:none");
        }
        protected void Genre1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (!((DropDownList)sender).SelectedItem.Value.Contains("Select"))
            {
                ViewState["Genre1"] = ((DropDownList)sender).SelectedItem.Value;

                using (Database db = new MySqlDatabase())
                {
                    SubGenre1.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["Genre1"]));
                    SubGenre1.DataTextField = "Value";
                    SubGenre1.DataValueField = "Key";
                    SubGenre1.DataBind();
                    SubGenre1.Items.Insert(0, new ListItem("--Select--", null));

                    int fbPageId = 0;

                    try
                    {
                        fbPageId = db.getAdminFBPageIdBYGenreIdandType(Convert.ToInt32(ViewState["Genre1"]), "genre");
                    }
                    catch { }

                    if (fbPageId != 0 && Convert.ToBoolean(ViewState["isSoundCloudActive"]) == true && Convert.ToBoolean(ViewState["isFacebookActive"]) == true)
                    {
                        IDictionary<string, string> pageCred = db.getAdminFBPageCredByPageID(fbPageId);

                        Session["GenrePageName"] = ViewState["GenrePageName"] = pageCred["PageName"];
                        ViewState["GenrePageID"] = pageCred["PageID"];
                        ViewState["GenrePageToken"] = pageCred["PageToken"];

                        cbxSendToGenreCommunityPage.Visible = true;
                        cbxGenreCross.Visible = true;
                        CommunityGenrePageLabel.Visible = true;
                        CommunityGenrePageLabel.Text = Convert.ToString(ViewState["GenrePageName"]);
                    }
                    else
                    {
                        ViewState["GenrePageName"] = null;
                        ViewState["GenrePageID"] = null;
                        ViewState["GenrePageToken"] = null;

                        cbxSendToGenreCommunityPage.Visible = false;
                        cbxGenreCross.Visible = false;
                        CommunityGenrePageLabel.Visible = false;
                        CommunityGenrePageLabel.Text = string.Empty;
                    }

                    ViewState["SubGenre1"] = null;

                    cbxSendToSubGenreCommunityPage.Visible = false;
                    cbxSubGenreCross.Visible = false;
                    CommunitySubGenrePageLabel.Visible = false;
                    CommunitySubGenrePageLabel.Text = string.Empty;
                }
            }
            else
            {
                ViewState["Genre1"] = null;

                cbxSendToGenreCommunityPage.Visible = false;
                cbxGenreCross.Visible = false;
                CommunityGenrePageLabel.Visible = false;
                CommunityGenrePageLabel.Text = string.Empty;

                ViewState["SubGenre1"] = null;

                cbxSendToSubGenreCommunityPage.Visible = false;
                cbxSubGenreCross.Visible = false;
                CommunitySubGenrePageLabel.Visible = false;
                CommunitySubGenrePageLabel.Text = string.Empty;
            }

            if (cbxSendToFacebook.Checked)
                divFBSharing.Attributes.Add("style", "display:block");
            else
                divFBSharing.Attributes.Add("style", "display:none");
        }
        protected void Genre3_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (!((DropDownList)sender).SelectedItem.Value.Contains("Select"))
            {
                ViewState["Genre3"] = ((DropDownList)sender).SelectedItem.Value;

                using (Database db = new MySqlDatabase())
                {
                    SubGenre3.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["Genre3"]));
                    SubGenre3.DataTextField = "Value";
                    SubGenre3.DataValueField = "Key";
                    SubGenre3.DataBind();
                    SubGenre3.Items.Insert(0, new ListItem("--Select--", null));
                }
            }
            else
            {
                ViewState["Genre3"] = null;
            }
        }
        protected void GenreList_SelectedIndexChanged(object sender, EventArgs e)
        {
            ViewState["GenreID"] = ((DropDownList)sender).SelectedItem.Value;

            if (Convert.ToString(ViewState["GenreID"]).Contains("Select"))
            {
                EditGenre.Visible = false;
                divAddGenre.Visible = false;
                divDeleteGenre.Visible = false;
                divSubGenre.Visible = false;
            }
            else if (Convert.ToString(ViewState["GenreID"]).Contains("Add"))
            {
                EditGenre.Visible = false;
                divAddGenre.Visible = true;
                divDeleteGenre.Visible = false;
                divSubGenre.Visible = false;
            }
            else if (Convert.ToInt32(ViewState["GenreID"]) > 0)
            {
                EditGenre.Visible = true;
                divAddGenre.Visible = false;
                divDeleteGenre.Visible = false;
                divSubGenre.Visible = true;

                EditSubGenre.Visible = false;
                divAddSubGenre.Visible = false;
                divDeleteSubGenre.Visible = false;

                SubGenreList.DataSource = null;
                SubGenreList.DataBind();

                using (Database db = new MySqlDatabase())
                {
                    SubGenreList.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["GenreID"]));
                    SubGenreList.DataTextField = "Value";
                    SubGenreList.DataValueField = "Key";
                    SubGenreList.DataBind();
                    SubGenreList.Items.Insert(0, new ListItem("--Select--", "Select"));
                    SubGenreList.Items.Insert(1, new ListItem("--Add New Sub Genre--", "Add"));
                }
            }
        }
        protected void DeleteSubgenre_Click(object sender, EventArgs e)
        {
            using (Database db = new MySqlDatabase())
            {
                SubGenreList.DataSource = null;
                SubGenreList.DataBind();

                MappingGrid.DataSource = null;
                MappingGrid.DataBind();

                db.DeleteSubGenre(Convert.ToInt32(ViewState["SubGenreID"]));

                SubGenreList.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["GenreID"]));
                SubGenreList.DataTextField = "Value";
                SubGenreList.DataValueField = "Key";
                SubGenreList.DataBind();
                SubGenreList.Items.Insert(0, new ListItem("--Select--", "Select"));
                SubGenreList.Items.Insert(1, new ListItem("--Add New Sub Genre--", "Add"));

                MappingGrid.DataSource = db.getPageGenreMapping();
                MappingGrid.DataBind();

            }

            EditSubGenre.Visible = false;
            divAddSubGenre.Visible = false;
            divDeleteSubGenre.Visible = false;
        }