protected void ddAlbumYear_SelectedIndexChanged(object sender, EventArgs e)
        {
            ddPictureNumber.Items.Clear();
            if (ddAlbumYear.SelectedIndex != 0)
            {
                db = new Database();
                int    x         = db.getPictureNumbers(ddAlbumName.SelectedItem.Text, Int32.Parse(ddAlbumYear.SelectedItem.Text));
                int    albumYear = Int32.Parse(ddAlbumYear.SelectedItem.Text);
                string albumName = ddAlbumName.SelectedItem.Text;
                string username  = Session["UserName"].ToString();
                int    albumID   = -1;
                Album  a         = db.getAlbumByNameAndYear(albumName, albumYear);
                if (a != null)
                {
                    albumID = a.ID;
                }
                ddPictureNumber.Items.Add("--Избери");
                for (int i = 1; i <= x; i++)
                {
                    int q = db.getQuantity(username, albumID, i);

                    if (q < 1)
                    {
                        continue;
                    }

                    ddPictureNumber.Items.Add(i + "");
                }
            }
        }
        protected void ddAlbumYear_SelectedIndexChanged(object sender, EventArgs e)
        {
            ddPictureNumber.Items.Clear();
            if (ddAlbumYear.SelectedIndex != 0)
            {
                db = new Database();
                int x = db.getPictureNumbers(ddAlbumName.SelectedItem.Text, Int32.Parse(ddAlbumYear.SelectedItem.Text));
                int albumYear = Int32.Parse(ddAlbumYear.SelectedItem.Text);
                string albumName = ddAlbumName.SelectedItem.Text;
                string username = Session["UserName"].ToString();
                int albumID = -1;
                Album a = db.getAlbumByNameAndYear(albumName, albumYear);
                if (a != null)
                    albumID = a.ID;
                ddPictureNumber.Items.Add("--Избери");
                for (int i = 1; i <= x; i++)
                {
                    int q = db.getQuantity(username, albumID, i);

                    if (q < 1)
                        continue;

                    ddPictureNumber.Items.Add(i + "");
                }
            }
        }