skills reg. [url removed, login to view] MS SQL, LINQ C#
1. We need to work on the test site of [url removed, login to view]
a. City Drop down changes→Currently the system allows to select only one city from the selected drop down list. This needs to be changed so that a user can select multiple cities to display the ad listings from. We would change the drop down list to a custom drop down list with checkboxes and it will look like below screen shot. As soon as the user selects few list items and hits the “Save’ or “Go” button, the page will be refreshed and the new page will list all the classifieds present in the selection made by the end user.
b. The purple bar, displaying the location will maintain only one line of text. If the information is exceeding the one line, then there will be a “…” at the end and a magnifying class icon with mouseover capability will display all the information in a 250x125 size box max. the same apply to the top right corner where the current classified search area in displayed – only one line of text with magnifying glass icon. Need to change the order in which text is displayed in the purple bars. Will provide that order.
c. On the description of every ad, we will show the ad ID in the bottom left corner and a text in bottom right corner.
d. Abuse/Spam system→ The abuse/flag system is a way to allow users to filter the site with good content and remove bad/offensive ads from the site. Every ad will show a link as “Flag abuse or Spam” when the user views the description of the ad in the top right corner of ad description. An ad can be flagged by authenticated as well as no authenticated users. When the user clicks on this link, the entire description changes dynamically to a new area as present in screen shot below:
e. The user needs to choose the abuse reason and enter the email address, comments for abusing and the captcha. Also, this screen shows the ad ID. The comments need to be minimum 150 characters in length to allow user to abuse the classified. We will do IP tracking and allow an ad to be flagged if the IP address and the mail address are not matching in our existing database for this specific post. If it is found that for an ad, 2 users with different mail addresses are trying to abuse with same IP address then there has to be a time difference of at least 1 hour. If the time difference will be less than 1 hour, then the user action of marking the ad as flagged will not work. After the user enters all the details and hit the submit button, we will validate from the database as mentioned above for IP and the mail address and if the validation is passed, the flag count for the ad will increase by 1.
f. After the ad has been flagged, the below screen will be displayed to the end user.
g. Every time an ad has been marked as spam, an mail will go to the ad owner. The mail template will be as follows:
Hi Ad Owner,
Your Ad has been marked as spam. This is your 1 out of 5 warnings. Please modify the ad, else your ad will be removed from the site after 5 users have flagged it.
In case you think you ad should not be flagged, please do not hesitate to contact us at flaggedads at [url removed, login to view]
h. When an ad has been flagged for 1st time, the same email will also go to the site admin.
i. After an ad has been flagged by 5 different users, the ad will be removed from the database and will not be shown in the admin section, front end section, user’s my listing and anywhere else on the site.
j. In the site admin section, we would add a new column in “Classified Upgrade” page to show the flagged status of each ad. By default every ad will show a red “X” symbol. As soon as an ad has been flagged, the red “X” will change to green “V” displaying the admin user that which ad has been flagged or not.
k. Also, we will add a new button at the bottom that would allow the admin user to un-flag an ad if the admin user thinks that the ad is not a spamming ad.
l. If an admin user has un-flagged an ad, the “Report abuse/Spam” link will not be displayed on the ad description in the front e