Technical Case Study
ymetro.com
Client:ymetro
Technologies Used: HTML, Asp. NET, SQL Server, Java Script
Tools:
Situation
The client required a site through which users can post advertisements in a selected area of a city under a category name. Other users can view these advertisements by selecting a city and a subcategory name. Users can flag postings and the admin can delete these flagged postings.
Solution
There are two types of users in this site:
a. Admin
b. General users
The admin user can create countries, cities, areas under each city, subject categories, subject sub categories etc. If a posting is flagged by a user as misplaced, spam or prohibited, the admin has the option to delete this advertisement.
General users can search advertisements. They can post/view advertisements and flag an advertisement as misplaced, spam or prohibited. Users also have option to email the advertisements to a friend.
The main functionalities in this site are:
ADMIN SECTION
Admin Login
Admin can login with the username: Admin and password. Administrator can login by checking the IP address. If the IP address has not been added, then the admin cannot login.
hai
1. Super Region
- Add Super Region
The Administrator can add super regions like America, UK, Asia etc. After adding a new super region, a mail will be sent with a link to the admin mail id. By clicking the link, the added super region will be activated and displayed in the user section. A super region that has already been added cannot be added again.
- Edit Super Region
The Administrator can view/edit/update the super regions that are already added. After editing a new super region, a mail will be sent with a link to the mail id. By clicking the link, the updated super region will be displayed. A search option is also provided to search for a particular super region.
- Activate/De-activate Super region
Administrators can activate/de-activate the added super region. Only after the activation of super regions by admin will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the email id. Through this, we can activate/de-activate the added super regions. A search option is also provided to search for a particular super region.
- Total Posting count
Here, the user gets a display of all the added super regions. By clicking the button ‘view count’, the user can see the nations under that super region and total postings added in the nation from the user side.
2. Nation
- Add Nation
The Administrator can add nations by selecting a particular super region like America, Asia. After adding a new nation, a mail will be sent with a link to the admin mail id. By clicking the link, the added nation will be activated and displayed in the user section. A nation that has already been added cannot be added again.
- Edit/view nation
The Administrator can view/edit/update the nations that are already added. After editing a nation, a mail will be sent with a link to the admin mail id. By clicking the link, the updated nation will be displayed. A search option is also provided to search for a particular nation under the selected super region.
- Activate/de-activate nation
Administrators can activate/de-activate the added nation under a particular super region. Only after the activation of nation by admin will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the email id. Through this, we can activate/de-activate the added nation. A search option is also provided to search for a particular nation.
3. State
- Add State
By selecting a super region and nation, the administrator can add a state like Alaska under nation US and super region America by selecting a display order (default display order will be 1). A state that has already been added cannot be added again.
After adding a new state, a mail will be sent with a link to the admin mail id. By clicking the link, the added state will be activated and displayed in the user section.
- Edit/view state
The Administrator can view/edit/update the states that are already added, according to the display order. After editing a state, a mail will be sent with a link to the admin mail id. By clicking the link, the updated state will be displayed. A search option is also provided to search for a particular state under the selected super region and nation.
- Activate/de-activate state
Administrators can activate/de-activate the added state under a particular super region and nation. Only after the activation of state by admin, will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the admin email id. Through this, we can activate/de-activate the added state. A search option is also provided to search for a particular state under the selected super region and nation.
- Set Display order
The Administrator can change the display order of the state by dragging the selected state up or down and save the changes made.
4. Region
- Add Region
The Administrator can add a region under a selected nation and state like Boston under state Washington and nation US by selecting display order (default display order will be 1). A region that has already been added cannot be added again. After adding a new region, a mail will be sent with a link to the admin mail id. By clicking the link, the added region will be activated and displayed in the user section.
- Edit/view Region
The Administrator can view/edit/update the regions that are already added, according to the display order. After editing a region, a mail will be sent with a link to the admin mail id. By clicking the link, the updated region will be displayed. A search option is also provided to search for a particular region under the selected nation and state.
- Activate/de-activate Region
Administrators can activate/de-activate the added Region under a particular nation and state. Only after the activation of region by admin, will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the admin email id. Through this, we can activate/de-activate the added region. A search option is also provided to search for a particular region under the selected nation and state.
- Set Display order
Administrator can change the display order of the Region by dragging the selected region up or down and save the changes made.
5. Area
- Add Area
Administrator can add an area under selected region like Sfc under Sf bay area by selecting display order (default display order will be 1). An area that has already been added cannot be added again. After adding new area, a mail will be sent with a link to the admin mail id. By clicking the link, the added area will be activated and displayed in the user section.
- Edit/view Area
The Administrator can view/edit/update the areas that are already added, according to the display order. After editing an area, a mail will be sent with a link to the admin mail id. By clicking the link, the updated area will be displayed. A search option is also provided to search for a particular area under the selected region.
- Activate/de-activate Area
Administrators can activate/de-activate the added area under a particular region. Only after the activation of area by admin will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the email id. Through this, we can activate/de-activate the added area. A search option is also provided to search for a particular area under the selected region.
6. Sub Area
- Add Sub Area
The Administrator can add a sub area under a selected region, selected area, and by selecting display order, (default display order will be 1). A sub area that has already been added cannot be added again. After adding new sub area, a mail will be sent with a link to the admin mail id. By clicking the link, the added sub area will be activated and displayed in the user section.
- Edit/view Sub Area
The Administrator can view/edit/update the sub areas that have been added, according to the display order. After editing a sub area, a mail will be sent with a link to the admin mail id. By clicking the link, the updated sub area will be displayed. A search option is also provided to search for a particular sub area under the selected region.
- Activate/de-activate Area
Administrators can activate/de-activate the added sub area under a particular region. Only after the activation of sub area by admin will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the email id. Through this, we can activate/de-activate the added area. A search option is also provided to search for a particular area under the selected region.
7. Category
- Add category
The Administrator can add a category (e.g. college, gigs) by selecting a display order. After adding a new category, a mail will be sent with a link to the admin mail id. By clicking the link, the added category will be activated and displayed in the user section.
- Edit/view Category
The Administrator can view a category displayed according to the display order. After editing a category, a mail will be sent with a link to the admin mail id. By clicking the link, the added category will be activated and displayed in the user section.
- Activate/de-activate Category
The Administrator can activate/de-activate the already added category by clicking the activate/de-activate button. Then a mail will be send with link to the admin mail id. By clicking the link, the edited category will be activated and displayed in the user section.
- Set display order
The Administrator can change the display order of the category by dragging the selected category up or down and save the changes made.
8. Subcategory
- Add Subcategory
The Administrator can add a subcategory under a selected category by selecting the posting type (posting type that are static listed as General, Job listing, Matrimonial, personals, Real Estate, transportation). After adding a new subcategory, a mail will be sent with a link to the admin mail id. By clicking the link, the added subcategory will be activated and displayed in the user section.
- Edit/view subcategory
The Administrator can view/edit/update the added subcategory by selecting the category. After editing a subcategory, a mail will be sent with a link to the admin mail id. By clicking the link, the updated subcategory will be displayed. A search option is also provided to search for a particular subcategory under the selected category.
- Activate/De-activate Subcategory
Administrators can activate/de-activate the added subcategory under a particular category. Only after the activation of subcategory by admin will it be published in the user section. After clicking the activate/de-activate button, a mail will be sent to the admin email id. Through this we can activate/de-activate the added subcategory. A search option is also provided to search for a particular subcategory under the selected category.
9. Relation
- Set Relation
The Administrator can set a relation between a state, region, category and subcategory. For e.g. state US, region New York, category community and subcategory sports/ sports partners. After setting a relation, it will be displayed in the user section according to the relation. After setting the relation, it will be sent as mail with a link to the admin mail id. Through this we can set a relation.
- Remove Relation
The Administrator can de-activate the selected relation, which is sent as mail to the admin mail id. Through this, we can de-activate the relation that will then not be displayed in the user section.
10. View Postings
- Spam Postings
The Spam postings displayed in the user section can be deleted. After deleting a mail, it will be sent to the admin mail id. By clicking the link, the posting will be deleted.
- Misplaced Postings
The Misplaced postings displayed in the user section can be deleted. After deleting a mail, it will be sent to admin mail id. By clicking the link, the posting will be deleted.
- Prohibited Content Postings
The prohibited postings displayed in the user section can be deleted. After deleting a mail, it will be sent to the admin mail id. By clicking the link, the posting will be deleted.
11. Admin Settings
- Change Password
The Administrator can change the password that will be sent to the admin mail. By clicking the link the password will be activated.
- Add IP address
The Administrator can add the IP address, which will be sent as mail. By clicking the link, the IP address will be activated. Admin can login by checking the IP address. If admin cannot login just check that IP address and add it.
- View IP address
The Administrator can edit and activate/de-activate IP address that will then be sent as mail to the admin mail id. By clicking the link, the process will be complete.
12. Logout
- Session will be clear and goes to login page.
User Section
1. Ymetro Home
- The right side of the home page displays all the cities in US added by the administrator. When we click a particular city, the entire categories under the city and the subcategories under the categories will be displayed.
- Details of Sf Bay Area, like its sub area, category, and subcategory are displayed as default when the home page is loaded.
1. Bottom Link
- About us
- Terms of use
- Your Privacy
- Help
- JS
- XML
2. Ymetro Category Display
- When we click on a particular region in the Ymetro home page, it will direct to the page of Ymetro Category display where all the categories and subcategories of that particular region will be displayed. The total postings in all categories will also be displayed.

Image2: shows all categories and sub categories coming under Atlanta
Challenges faced in the section above:
XHTML design is difficult to be integrated in the data list controls with repeat columns as it affects the width of columns. We resolved this problem by implementing a feature that is not commonly used with HTML designs.
3. Ymetro Advanced Search
- When we click a subcategory in Ymetro category display, it will direct to the Ymetro advanced search page where all the postings under that particular subcategory will be displayed. When we click on the posting title it will direct to the web page where the details of the posting will be displayed. The user can also search Posting based on Titles and images.

Image3: Shows the search result of community connect category.
Keyword Search
By selecting the subcategory and giving a keyword, it will display the postings according to the keyword given.
Challenges faced in the section above:
We implemented the search of all categories in a single user control with different search criteria for all categories. “Full” and “Brief” view of all advertisement in search results is available in this page.
4. New Post
Posting Types are:
- General
- Events
- Groups
- Local News
- Artists
- Politics
- Lost/found etc…
When a user clicks on new post link it will direct to the subcategory display page. From that page, select the subcategory and then select the area nearer to his/her location that fits best for the user. After posting, a mail is sent to user’s mail id with a link for activation. Clicking the link in the mail id, will direct to the page posting activate page. The user can also edit or delete his/her posting through this link.

Image4: - shows the web page for selecting category for a new post.

Image4: - shows the web page for selecting category for a new post.
Challenges faced in the section above:
We implemented a text area with bold, italics and underlining facilities in this page, because the free text box might create many problems in the user side design.
- Posting activate
During the page load it will check the id in the key table and activate the posting in the posting table. A new html page will be created in the folder postings where the entire posting type folder is set to save the HTML pages in the corresponding path. From that path, the posted HTML pages are shown in the user section.

Image5
In this section, when we select a region and subcategory and click the button ‘generate’, it will generate html code. When we copy the html code in a separate html page, we can see separately all the postings that come under the selected subcategory.

Image5
In this section, the user can select Region and subcategory and when he clicks on the ‘generate’ button, it will generate the path. Just take the path and copy it in RSS reader. We get all the postings of that particular sub category. This is a great advantage of this site.