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 + ""); } } }
private string initElementNumber(int pictureID) { Database db = new Database(); int res = db.getQuantity(Session["UserName"].ToString(), albumID, pictureID); if (res > 0) { return res.ToString(); } return "0"; }
private string initElementNumber(int pictureID) { Database db = new Database(); int res = db.getQuantity(Session["UserName"].ToString(), albumID, pictureID); if (res > 0) { return(res.ToString()); } return("0"); }
private string initElementNumber(int pictureID) { Database db = new Database(); int res = db.getQuantity(Session["UserName"].ToString(), albumID, pictureID); System.Diagnostics.Debug.WriteLine("-->>AlbumID:" + albumID.ToString() + " pictureID:" + pictureID.ToString() + " Q:" + res.ToString()); if (res >= 0) { return(res.ToString()); } return("0"); }
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 + ""); } } }
private string initElementNumber(int pictureID) { Database db = new Database(); int res = db.getQuantity(Session["UserName"].ToString(), albumID, pictureID); System.Diagnostics.Debug.WriteLine("-->>AlbumID:" + albumID.ToString() + " pictureID:" + pictureID.ToString() + " Q:"+res.ToString()); if (res >= 0) { return res.ToString(); } return "0"; }