Classifieds Starter Kit

Re: Improving on the default Classifieds site

po10cy — Wed, 08 Jul 2009 12:13:02 GMT

ok so i managed to finally get the ads to sort by level.

what i did was i made duplicates of teh grid to display the search results in search .aspx. then i duplicated the datasource the same amount of times, changing each grid to point to each datasource. Then in each datasource is a field "adlevel=0" which basically is default and tells it to display ALL adlevels. so i changed each grid to display the adlevel i wanted by changed each grid's data source to point to "adlevel=50".."adlevel=30".."adlevel=20" etc. 50 being the featured ads level and the rest being my custom adlevels i created.

however i still cannot get it to list more than 1 featured ad on the home page...if i duplicate the repeater to have 5 repeaters on the home page, it sometimes lists the same ad twice on the home page at the same time...i really need help to get it so the one repeater can list up to 5 different featured ads on the home page at the same time.

Re: Improving on the default Classifieds site

po10cy — Thu, 25 Jun 2009 10:00:28 GMT

Howsit guys, for the life of me I still cannot get the site to list the ads by AdLevel and not DateCreated whenever you search for something. And I have changed the procedure which sorts by DateCreated to AdLevel, I have searched the entire project for anything to do with AdLevel and DateCreated and still doesnt do what it needs.

So now i have another thought, how about instead of having code to list all the ad's and sort them then by DateCreated, how about i have code to list only ads of a certain level? eg when you search how do I have it only list Ads thats featured Ads, then it sorts by datecreated. what i want to do then, is have the code to display featured ads first, then another section of code to only display guest ads, that way it would appear to be sorting by AdLevel but in actual fact its only displaying featured ads first, then normal ads afterwards because of the code.

Also i still cannot get it to display up to 5 featured ads on the homepage at the same time, it only display ones featured ad, and i have used all the code examples listed on this site including the line of code which says "GetMaxNumAds" from "GetMaxNumAds(1)" to "(5)" and still no joy.

this is the only 2 issues im struggling with then my site can go live. Please any advise on how to go about this or code would be awesome. Ive sat many nights up now fiddling with this code.

Re: Improving on the default Classifieds site

sangam100 — Tue, 02 Jun 2009 11:57:21 GMT

Hi po10cy ,

I have just downloaded the classified ad starter kit and like you I also won't enjoy the default only. First of all thanks for the questions for being the weighty ones because all most all of we developers would like to have the features you mentioned. I am not going to answer any of your question since I am new to this starter site and am just playing with the default features. However in the future I would also go for the deep feautures.

One thing I would like to request. If you have already got them work or if you are on the way, it would be a great work if you could give some walkthrough or sort of tips and tricks or have a series-articles somewhere. I don't know whether it is feasible or not but I would like to ask wheter you make the code you have achieved by now available for other developers also.

With great appreciation! Thanks. Happy Programming!

Re: Improving on the default Classifieds site

lingyun2003 — Mon, 01 Jun 2009 15:57:21 GMT

the featured ads including photos can be displayed in the default.aspx , otherwise ,they cant be displayed though marked with the feature

Re: Improving on the default Classifieds site

po10cy — Mon, 01 Jun 2009 14:21:34 GMT

cool shot ill look thru it. the featured ad problem my code is all standard code that it came as. in the app_code/bbl/ads feature, i have looked for the store procedure, and changed it to sort by AdLevel instead of the date, still no joy. ill continue scratching until it gets sorted.

Re: Improving on the default Classifieds site

darkknight187 — Mon, 01 Jun 2009 14:06:10 GMT

po10cy:
another issue i cant get sorted, on my home page it only lists 1 featured ad when it should list 5. any reason why

Probably because your code is wrong.
But you didn't post any, so not sure what's wrong.

po10cy:
for some reason when i make a search with no search term, it still lists by date.

Take a look at how it gets the ads in App_Code/BLL/Ads

There's a bit of code if no search term is entered . . .

Re: Improving on the default Classifieds site

po10cy — Mon, 01 Jun 2009 06:35:28 GMT

tnx ill give that a try. for some reason when i make a search with no search term, it still lists by date. another issue i cant get sorted, on my home page it only lists 1 featured ad when it should list 5. any reason why?

Re: Improving on the default Classifieds site

darkknight187 — Sun, 31 May 2009 14:26:58 GMT

So I was making an upgrade to handle another image size and I didn't know you could set it this easily.
I figured you could just set one parameter, but as you can see,
it sorts by preview, then by date. Nice.
But take a look at the storedprocedure GetPhotosByAdId
At the bottom it tells the app how to order the results.

ORDER BY IsMainPreview DESC, DateCreated

You could do the same thing for your Featured Ads.
By the way the DESC is for descending, use ASC if you want to sort by ascending.

Re: Improving on the default Classifieds site

po10cy — Thu, 21 May 2009 06:27:21 GMT

ok great that fixes that.

yeah ok what i think ill do is ill add a string somewhere which tells me what user type each user is. Then on the page i approve ads before it gets posted ill add a option for "gold" "silver" "bronze" underneath "featured" which will give it the level it needs based on the user, as just approving it while "normal" is selected will give it a level of 10.

thanks for all the help. I am now, happy lol

Re: Improving on the default Classifieds site

darkknight187 — Thu, 21 May 2009 01:31:46 GMT

It already sorts by those numbers.
As far as flagging the member as silver or whatever, it's to involved to do a walk through.
Make a backup of your project just in case you screw it up.
And start playing with anything that has to do with members.
Besides, you'll learn a lot more that way.

And I just downloaded the users.zip file again.
Works fine.

http://home.mchsi.com/~j.roal/Users.zip

If it doesn't work for you, send me a private message and I'll email it to you.

Re: Improving on the default Classifieds site

po10cy — Wed, 20 May 2009 13:42:47 GMT

Brilliant thanks alot that will help big time!

I understand that featured ads are listed as priority of 50, and normal ads as 10. is there anyway to make it sort by those numbers and not just "Featured"? this way, i can have it so that perhaps gold users ads are priority of 40, silver as 30, bronze 20 and featured on 50. then it will list all ads in that order based on priority level.

sorry man, what i said was the "LINK" to the zip file doesnt work, not that the actual file doesnt work, just that I am unable to download it. :)

All i need now is a way to flag users as bronze, silver or gold when they register, and automatically set the priority level of any ads they post based on that, and my site will be ready to go.

any help to do that would be hugely appreciated.

Re: Improving on the default Classifieds site

darkknight187 — Wed, 20 May 2009 13:18:42 GMT

For the featured ads sorting change the stored procedure getalladsbyquery.
At the bottom it tells the system to sort by DateCreated.
Make it sort by Featured

And the users.aspx file DOES work, I use it all the time.

Again you are not giving any information.
"Doesn't work" is not a statement that anyone can help you with.

What happens?
Why do you think it doesn't work?

Write a complete question.

Re: Improving on the default Classifieds site

po10cy — Tue, 19 May 2009 07:06:33 GMT

oh btw the link to the users.zip file to enable me to delete and manage users once the site is live doesnt work?

Re: Improving on the default Classifieds site

po10cy — Tue, 19 May 2009 06:51:21 GMT

Thanks for the help so far. Another question i have is: when you flag an AD as featured, it is listed on the home page, is there any way to make the featured Ad listed at the top of all the Ads when you browse the categories and have a different background color? I dont want featured Ads to only stand out on the homepage but throughout the entire site. Thanks alot.

Re: Improving on the default Classifieds site

darkknight187 — Sun, 17 May 2009 00:00:05 GMT

You'll never learn anything if you don't try.
And if you don't know C# why are you using it?
There's more helpers in Visual Web Developer for developing using VB.

Try this for coverting code.

http://www.developerfusion.com/tools/convert/vb-to-csharp/

Make backups, and try.
When coding you have to think of it as a very specific map to get to a point.

I recommend using pen and paper to map it out.
I find it easier that way.

I would store your user status, premium or whatever, in the members table.
Follow the path when a user registers.
Look for anything that has to do with members.

One step at a time, your going to have a lot of issues when things don't work.
And you made a ton of upgrades at a time.
Pick one upgrade, and work on that.

Good Luck

-Daniel