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 + ""); } } }