protected void fillOffers()
{
clearScreen();
Database db = new Database();
List <Ponuda> offers = db.getAllOffersForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
if (offers == null)
{
return;
}
if (offers.Count == 0)
{
Response.Write("<div class='alert alert-warning'>" +
"<strong>Внимание!</strong> Оваа порака се испишува само во случај кога нема понуди кои што вас би ве интересирале<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a> </div>");
}
foreach (Ponuda o in offers)
{
offer offerElem = (offer)LoadControl("offer.ascx");
Album a = db.getAlbumByID(o.AlbumID);
Slika s = db.getPicture(o.AlbumID, o.BrojSlika);
offerElem.imgUrl = s.Url;
offerElem.Name = o.BrojSlika + " - " + o.Name + " " + a.Year;
offerElem.Owner = o.Username;
offerElem.Description = o.Desc;
offerElem.Price = o.Price;
offerElem.Trust = 5;
offerElem.Datum = o.Datum;
offerElem.thisPonuda = o;
repeaterHomepage.Controls.Add(offerElem);
}
}
protected void fillOffers()
{
clearScreen();
Database db = new Database();
List<Ponuda> offers = db.getAllOffersForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
if (offers == null) return;
if (offers.Count == 0)
{
Response.Write("<div class='alert alert-warning'>" +
"<strong>Внимание!</strong> Оваа порака се испишува само во случај кога нема понуди кои што вас би ве интересирале<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a> </div>");
}
foreach (Ponuda o in offers)
{
offer offerElem = (offer)LoadControl("offer.ascx");
Album a = db.getAlbumByID(o.AlbumID);
Slika s = db.getPicture(o.AlbumID, o.BrojSlika);
offerElem.imgUrl = s.Url;
offerElem.Name = o.BrojSlika + " - " + o.Name + " " + a.Year;
offerElem.Owner = o.Username;
offerElem.Description = o.Desc;
offerElem.Price = o.Price;
offerElem.Trust = 5;
offerElem.Datum = o.Datum;
offerElem.thisPonuda = o;
repeaterHomepage.Controls.Add(offerElem);
}
}
private string getImageUrl(int albumID, int pictureID)
{
Database db = new Database();
Slika s = db.getPicture(albumID, pictureID);
if (s != null)
{
return(s.Url);
}
return("");
}
protected void fillTransakcii()
{
clearScreen();
Database db = new Database();
List <Transakcija> transakcii;
int tab = -1;
if (ViewState["tab"] != null)
{
Int32.TryParse(ViewState["tab"].ToString(), out tab);
}
if (tab != -1)
{
if (tab == 0)
{
transakcii = db.getAllTransakciiKupuvamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
else if (tab == 1)
{
transakcii = db.getAllTransakciiProdavamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
// TODO: ovde za istorija
else
{
transakcii = db.getAllTransakciiHistoryForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
}
else
{
return;
}
if (transakcii == null)
{
return;
}
foreach (Transakcija t in transakcii)
{
if (tab == 1) // Prodavam opcii
{
if (t.AlbumID == -1) //E obicna buy transakcija
{
transakciiElementHalfProdavam tranElem = (transakciiElementHalfProdavam)LoadControl("transakciiElementHalfProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiExchangeElementHalfProdavam tranElem = (transakciiExchangeElementHalfProdavam)LoadControl("transakciiExchangeProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else if (tab == 0)
{
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else
{ // history
if (t.AlbumID == -1) //E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
}
//repeaterTransakcii.Controls.Add(tranElem);
}
}
protected void fillTransakcii()
{
clearScreen();
Database db = new Database();
List<Transakcija> transakcii;
int tab = -1;
if (ViewState["tab"] != null)
Int32.TryParse(ViewState["tab"].ToString(), out tab);
if (tab != -1)
{
if (tab == 0)
transakcii = db.getAllTransakciiKupuvamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
else if (tab == 1)
transakcii = db.getAllTransakciiProdavamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
// TODO: ovde za istorija
else
{
transakcii = db.getAllTransakciiHistoryForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
}
else return;
if (transakcii == null) return;
foreach (Transakcija t in transakcii)
{
if (tab == 1) // Prodavam opcii
{
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiElementHalfProdavam tranElem = (transakciiElementHalfProdavam)LoadControl("transakciiElementHalfProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiExchangeElementHalfProdavam tranElem = (transakciiExchangeElementHalfProdavam)LoadControl("transakciiExchangeProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else if(tab == 0)
{
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else
{ // history
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
}
//repeaterTransakcii.Controls.Add(tranElem);
}
}
protected void fillMyOffers(string username)
{
Database db = new Database();
List <Ponuda> ponudi = db.getAllOffersByUsername(username);
for (int i = 0; i < ponudi.Count; i += 2) //example usage
{
if (ponudi.Count % 2 == 1 && i + 1 == ponudi.Count) //dokolku treba da se loadiraat neparen
{ //broj ponudi, poslednata ponuda e
Ponuda p = ponudi[i]; //myOfferHalf.ascx
myOfferHalf offer = (myOfferHalf)LoadControl("myOfferHalf.ascx");
offer.Name = p.Name;
offer.Description = p.Desc;
offer.Price = p.Price;
offer.Offer1ID = p.ID;
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
if (s != null)
{
offer.imgUrl = s.Url;
}
offer.albumID = p.AlbumID;
offer.pictureID = p.BrojSlika;
repeaterMyOffers.Controls.Add(offer);
}
else
{
Ponuda p1 = ponudi[i];
Ponuda p2 = ponudi[i + 1];
myOffer offer = (myOffer)LoadControl("myOffer.ascx");
offer.Name1 = p1.Name;
offer.Description1 = p1.Desc;
offer.Price1 = p1.Price;
offer.Offer1ID = p1.ID;
Slika s1 = db.getPicture(p1.AlbumID, p1.BrojSlika);
if (s1 != null)
{
offer.imgUrl_1 = s1.Url;
}
offer.albumID_1 = p1.AlbumID;
offer.pictureID_1 = p1.BrojSlika;
offer.Name2 = p2.Name;
offer.Description2 = p2.Desc;
offer.Price2 = p2.Price;
offer.Offer2ID = p2.ID;
Slika s2 = db.getPicture(p2.AlbumID, p2.BrojSlika);
if (s2 != null)
{
offer.imgUrl_2 = s2.Url;
}
offer.albumID_2 = p2.AlbumID;
offer.pictureID_2 = p2.BrojSlika;
repeaterMyOffers.Controls.Add(offer);
//TODO: fill offer with picture
// somethink like this:
//img.ImgUrl = db.getPictureUrl(p.AlbumID, p.BrojSlika);
}
}
}
private string getImageUrl(int albumID, int pictureID)
{
Database db = new Database();
Slika s = db.getPicture(albumID, pictureID);
if (s != null)
return s.Url;
return "";
}
protected void fillMyOffers(string username)
{
Database db = new Database();
List<Ponuda> ponudi = db.getAllOffersByUsername(username);
for (int i = 0; i < ponudi.Count; i += 2) //example usage
{
if (ponudi.Count % 2 == 1 && i + 1 == ponudi.Count) //dokolku treba da se loadiraat neparen
{ //broj ponudi, poslednata ponuda e
Ponuda p = ponudi[i]; //myOfferHalf.ascx
myOfferHalf offer = (myOfferHalf)LoadControl("myOfferHalf.ascx");
offer.Name = p.Name;
offer.Description = p.Desc;
offer.Price = p.Price;
offer.Offer1ID = p.ID;
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
if (s != null)
offer.imgUrl = s.Url;
offer.albumID = p.AlbumID;
offer.pictureID = p.BrojSlika;
repeaterMyOffers.Controls.Add(offer);
}
else
{
Ponuda p1 = ponudi[i];
Ponuda p2 = ponudi[i + 1];
myOffer offer = (myOffer)LoadControl("myOffer.ascx");
offer.Name1 = p1.Name;
offer.Description1 = p1.Desc;
offer.Price1 = p1.Price;
offer.Offer1ID = p1.ID;
Slika s1 = db.getPicture(p1.AlbumID, p1.BrojSlika);
if (s1 != null)
offer.imgUrl_1 = s1.Url;
offer.albumID_1 = p1.AlbumID;
offer.pictureID_1 = p1.BrojSlika;
offer.Name2 = p2.Name;
offer.Description2 = p2.Desc;
offer.Price2 = p2.Price;
offer.Offer2ID = p2.ID;
Slika s2 = db.getPicture(p2.AlbumID, p2.BrojSlika);
if (s2 != null)
offer.imgUrl_2 = s2.Url;
offer.albumID_2 = p2.AlbumID;
offer.pictureID_2 = p2.BrojSlika;
repeaterMyOffers.Controls.Add(offer);
//TODO: fill offer with picture
// somethink like this:
//img.ImgUrl = db.getPictureUrl(p.AlbumID, p.BrojSlika);
}
}
}