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 = "Грешка во валидација";
}
}
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);
}
}
}
}
}
