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

            }
        }