Simple Profile Connection Web App

Create a .NET web app that allows visitors to register, update their profile, post messages to other users, share public messages, send private messages, add users as favourites, rate one another and search for shared messages based on location and tag. ## Deliverables Technical Requirements and Feature Summary 1) To be written in C# (.NET 4.0, VS2010). 2) Must use a relational SQL database (can be Express but it will be converted to 2008 during esting) and be LINQ/Stored Procedure driven. 3) Must follow good coding conventions (ideally OOP/MVC) as our own developers will be adding additional functionality and modifying classes once delivered. 4) User Registration, Login, Profiles and Roles to be based on the Microsoft Membership Provider controls and classes. 5) Application needs to be light and efficiently programmed. 6) Short codes/URLs should be used when viewing profiles, consisting of the username i.e. "[login to view URL]". 7) Short codes/URLs should be used when viewing shared messages, consisting of message title and ID i.e. "[login to view URL]". 8) The login page will support the MS Membership Provider and Facebook login using OAuth (see Login section below for more detail). 9) Site styling, look & feel: The basic structure should be good and the relevant CSS should be in place ready for our designers to use at a later date. Please model the colours, buttons, fonts etc on this website [[login to view URL]][1]. Important Note You can create the solution from the asp.net SQL Table Profile example which is explained and is available to download here <[login to view URL]>. This allows a user to register, login and create a basic profile. The download also includes the ASPNETDB.MDF. Login and Profile creation The login page will consist of a username and password (MS Membership) login box (this already exists in the solution) and a button to login with Facebook (using OAuth). If the Facebook username does not exist in the local database then it must be created silently by pulling the Username, Firstname, Lastname, Email address and profile picture from the Facebook profile and saving it into the local database. The user will then be redirected to their Profile homepage where they will be able to complete additional information. If the username already exists in the local database then the user needs to be prompted and redirected to the standard local registration page. On subsequent Facebook logins a user's profile information can be pulled directly from the local database. During Profile creation the user must be asked to set their location which consists of Country, Region and City (see Locations below). User Roles Based on ASP.NET Membership Roles. Users are either anonymous or registered (Premium). Anonymous users can view and search for messages but when clicking on a message or profile link they are redirected: - Anonymous users will take a user to their own profile homepage, a message at the top of the page will appear: "To message your new connection(s) you are required to upgrade to a Premium account." Clicking on the message will take the user to a PayPal screen to make payment (see PayPal comment below). - Registered users will see a users First Name, Last Name, Location, Expertise, Rating, Add as Favourite, plus the button "Send Message" button. Which will allow them to send private messages (see Private Messages). - When clicking send message a message can be created and sent to the user. The message control on [login to view URL] can be used to manage the conversation. Homepage ([login to view URL]) Add a textbox and a button to the top of the page, this is where registered users will search for shared messages (see Shared Messages below). By default the homepage displays the latest 25 shared messages. There will be a drop down "Number of Messages" (25, 50, 100); please use paging. Add a second drop down called "Location" (Default: "UK". See locations below). For example, typing "painter" into the search box returns Shared Messages posted from users with a location matching the same Country and Region with a "painter" tag. Changing the number of messages or location will automatically refresh the list. Locations: Country, Region, City. The data should be based on the [login to view URL] City/Show List text box as an example of how this should work. Selecting the Message title OR Profile username hyperlink will work as follows - Anonymous users will be taken to their own profile homepage, a message at the top of the page will appear: "To message your new connection you are required to upgrade to a Premium account." Clicking on the message will take the user to a PayPal screen to make payment (see PayPal comment below). - Premium users will see a users First Name, Last Name, Location, Expertise, Rating, Add as Favourite, plus the button "Send Message" button. Which will allow them to send private messages (see Private Messages). - When clicking send message a message can be created and sent to the user. The message control on [login to view URL] can be used to manage the conversation. PayPal The payment element will be managed by PayPal. I will configure this nearer the time; you will just need to create the relevant process so that a user is redirected as required. Profile Homepage ([login to view URL] for registered users): This page will contain the following hyperlinks, "All Updates", "My Information", "Profile Picture", "Account Settings", "Messages", "Visitors", "Favourites". Selecting a hyperlink will update the content below it. All Updates: This tab will replicate the Homepage (see above). This page will also include a "Share Message textbox and button (see Shared Messages below). My Information: Fields within this tab should appear "Read only", however, when clicking on a field the textbox will appear. Any text entered will automatically save when the cursor leaves the box - NO save button required. Please use JQuery to accomplish this. Basic Information (sub heading): * First Name: (textbox, populated by Facebook if used during registration) * Last Name: (textbox, populated by Facebook if used during registration) * Email Address (textbox, populated by Facebook if used during registration) * Gender: (drop down list, "Male", "Female", to be populated from a Gender table) Location: (This should work as per the [login to view URL] City lookup). What is your area of expertise?: (text area, regex should be used to stop a predefined number of non-alpha numeric characters. Do not allow ~ and @ characters, this should be configurable), users can add words and split by #, comma, space, etc I do not mind. Profile Picture Populated from Facebook profile if used during registration. Allow a user to upload/delete a profile picture, maximum of 2mb in size, it should resize if greater than 200px by 200px. A blank person placeholder should be used by default. The image should be stored in a binary/blob format within the database. Save Changes (button). Account Settings: Security: (sub heading) * Password: (password box) * Confirm Password: (password box) Privacy: (sub heading): Make my profile visible in search: (checkbox, "Checked, "Unchecked") Save Changes (button) Private Messages The Messages tab heading should have the number of messages in brackets i.e. Messages (7) Reading and responding to messages: The messages page should include all profiles that have messaged or have been messaged by the user, with their associated messages. The layout should be in a conversation style (similar to iPhone SMS) so that incoming and outgoing messages are indented, with each the sender and receiver having a different coloured message background speech box. On selecting a profile in messages the conversation should expand so that the conversation can be viewed - this should use AJAX or JQUERY to enable asynchronous updates to a conversation. Users who have not upgraded will only see a count of the messages that they have been sent. Premium users will see a list of profiles and can click through to view. If a profile is selected and "Send Message" then select sharing is not an option. It will only be sent to the recipient, it will also appear in the senders Messages page. Messages between users should be private and secure. You cannot see other peoples messages; unless it is a "Shared Message". Shared Messages Registered logged in users will be a "Share Message" button at the top of the page. A Shared Message should consist of: The users profile picture Profile name (a hyperlink to the users profile) Message title (textbox) Message expertise tag(s). (textbox, these can be seaprated with commas) Message location (typing the city will use Jquery to lookup the city, see [login to view URL]) Send button Once posted the message appears on the senders Messages page. It will appear also on the profile homepage for all registered users to see (see All Updates above). Linking Shared Messages with Profiles When a registered user logs in they should see a notification panel listing all shared messages that have been posted by other users with an expertise tag which matches the logged in users tag. For example. If a user has added "painter" in their expertise field they will see all shared messages that have been posted with that expertise tag. Visitors The Visitors tab heading should have the number of messages in brackets i.e. Visitors (15). Users who have not upgraded will only see a count of the messages. Premium users will see a list of profiles and can click through to view. Favourites Create a Favourites function so that Premium users can add a profile as a favourite. Base this on the Google Chrome browser bookmarks i.e. grey star which is yellow if selected. The profiles thumbnail pictures should be displayed with the username. Favourites will consist of a small profile picture and the username, a "Send Message" link will appear on mouse-over if you are a Premium user. Clicking on the star will prompt you with "Are you sure you want to remove this [username] from you favourites list?". Clicking "Yes" will remove them, clicking "No" will leave them in place. Please note: When the mouse is passed over a profile picture a "Send Message" link should appear. A message can be written in a box and sent to the user. Rating Connected users should be able to rate other users. I'm fairly flexible on how this should work, but in essence a Premium user should be able to rate a user using a five star type of system (see the AJAX rating control). The user control should then be able to work out an average rating for a user based on the amount of feedback i.e. 4.7 out of 5. Search Users of this site will be looking for users based on a users expertise tags and location. The expertise field may contain multiple tags so the search mechanism needs to take this into account. The result should be displayed in a grid and sorted by rating (if relevant). On selection of a profile a user should be taken to the profile page. Premium users will see full profiles; normal users will see limited profiles (Name, location, expertise). Thanks * * *This broadcast message was sent to all bidders on Friday May 20, 2011 7:24:04 AM: To all bidders: I have just simplified the requirements slightly. The app now focuses on displaying and searching for messages rather than searching for profiles and messages. If your able to deliver this application within 25 days for a maximum of $350 then please bid (bidding will close tomorrow). If you have any questions then please let me know. * * *This broadcast message was sent to all bidders on Monday May 23, 2011 3:53:39 PM: Final update to requirements applied. To make the application simpler there are now two users roles rather than three. "Anonymous" and "Registered" (aka Premium) - Previously there were Anonymous, Registerd and Premium. This makes the application simpler. Please make your final bids. Thank you.