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 int getAlbumID(string albumName, int albumYear) { Database db = new Database(); Album a = db.getAlbumByNameAndYear(albumName, albumYear); if (a != null) { return(a.ID); } return(-1); }
private void showAlbumStickers() { clearRepeater(); string albumName = ddName.SelectedItem.Text.ToString(); int albumYear = -1; Int32.TryParse(ddYear.SelectedItem.Text.ToString(), out albumYear); Database db = new Database(); Album album = db.getAlbumByNameAndYear(albumName, albumYear); if (album != null) { List <Slika> sliki = db.getAllPicturesByAlbumID(album.ID); if (sliki != null) { int n = sliki.Count; for (int i = 0; i < n; i += 2) { if (n % 2 == 1 && i + 1 == n) { albumElementHalf el = (albumElementHalf)LoadControl("albumElementHalf.ascx"); el.AlbumID = album.ID; el.AlbumName = albumName; el.SlikaID = sliki[i].Broj; el.imgUrl = sliki[i].Url; el.Year = albumYear; repeaterAlbum.Controls.Add(el); } else { albumElement el = (albumElement)LoadControl("albumElement.ascx"); el.AlbumID = album.ID; el.AlbumName = albumName; el.Year = albumYear; el.SlikaID1 = sliki[i].Broj; el.imgUrl_1 = sliki[i].Url; el.SlikaID2 = sliki[i + 1].Broj; el.imgUrl_2 = sliki[i + 1].Url; repeaterAlbum.Controls.Add(el); } } } } }
private bool validatePicture(string albumName, int albumYear, int pictureID) { Database db = new Database(); Album album = db.getAlbumByNameAndYear(albumName, albumYear); //System.Diagnostics.Debug.WriteLine( // String.Format("AlbumName:{0}, AlbumYear:{1}, AlbumID:{2}, PictureID:{3}", // album.Name.ToString(), album.Year.ToString(), album.ID.ToString(), pictureID.ToString() // )); if (album != null) { return(db.checkIfPictureExists(album.ID, pictureID)); } return(false); }
protected void btnNewOfferSubmit_Click(object sender, EventArgs e) { if (validateOffer()) { Database db = new Database(); Album album = db.getAlbumByNameAndYear(ddAlbumName.SelectedItem.Text.Trim(), Int32.Parse(ddAlbumYear.SelectedItem.Text.Trim())); string offerDesc = txbNewOfferDescription.Text.Trim(); int price = -1; Int32.TryParse(txbNewOfferPrice.Text.Trim(), out price); string name = ddAlbumName.SelectedItem.Text; int albumid = album.ID; int brslika = Int32.Parse(ddPictureNumber.SelectedItem.Text.Trim()); int exchange = chkNewOfferExchange.Checked ? 1 : 0; String username = Session["UserName"].ToString(); DateTime datum = DateTime.Now; int quantity = 1; bool executeQuery = db.addOffer(offerDesc, price, name, albumid, brslika, exchange, username, datum, quantity); System.Diagnostics.Debug.WriteLine("executeQuery" + executeQuery.ToString()); if (executeQuery) { lblErrorInput.Text = "Успешно додадена нова понуда."; lblErrorInput.ForeColor = Color.Green; pnlErrorInput.Update(); clearNewOffer(); // TODO: Review this new feature... refreshPage(); } else { lblErrorInput.Text = "Понудата не е додадена успешно."; } } else { System.Diagnostics.Debug.WriteLine("Paga na validacija..."); lblErrorInput.Text = "Грешка во валидација"; } }
private bool validatePicture(string albumName, int albumYear, int pictureID) { Database db = new Database(); Album album = db.getAlbumByNameAndYear(albumName, albumYear); //System.Diagnostics.Debug.WriteLine( // String.Format("AlbumName:{0}, AlbumYear:{1}, AlbumID:{2}, PictureID:{3}", // album.Name.ToString(), album.Year.ToString(), album.ID.ToString(), pictureID.ToString() // )); if (album != null) return db.checkIfPictureExists(album.ID, pictureID); return false; }
private int getAlbumID(string albumName, int albumYear) { Database db = new Database(); Album a = db.getAlbumByNameAndYear(albumName, albumYear); if (a != null) return a.ID; return -1; }
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 void showAlbumStickers() { clearRepeater(); string albumName = ddName.SelectedItem.Text.ToString(); int albumYear = -1; Int32.TryParse(ddYear.SelectedItem.Text.ToString(), out albumYear); Database db = new Database(); Album album = db.getAlbumByNameAndYear(albumName, albumYear); if (album != null) { List<Slika> sliki = db.getAllPicturesByAlbumID(album.ID); if (sliki != null) { int n = sliki.Count; for (int i = 0; i < n; i += 2) { if (n % 2 == 1 && i + 1 == n) { albumElementHalf el = (albumElementHalf)LoadControl("albumElementHalf.ascx"); el.AlbumID = album.ID; el.AlbumName = albumName; el.SlikaID = sliki[i].Broj; el.imgUrl = sliki[i].Url; el.Year = albumYear; repeaterAlbum.Controls.Add(el); } else { albumElement el = (albumElement)LoadControl("albumElement.ascx"); el.AlbumID = album.ID; el.AlbumName = albumName; el.Year = albumYear; el.SlikaID1 = sliki[i].Broj; el.imgUrl_1 = sliki[i].Url; el.SlikaID2 = sliki[i + 1].Broj; el.imgUrl_2 = sliki[i + 1].Url; repeaterAlbum.Controls.Add(el); } } } } }