develop a small cms(content management system) using c# dot net + mysql

the design should be responsive and similar to this website: [login to view URL] , with one exception, on desktop, when scrolling down, the sidebar only scrolls while there is more content so it’s always on the screen, while the post content is scrollable. the sidebar should behave like the one you can see in [login to view URL]

key features:

- add/delete/modify posts and categories

- posts have the following data:

- title

- excerpt

- content (text and/or html)

- content can have other media (uploaded photos)

- date of insertion

- user who inserted it

- thumbnail image

- meta data for facebook and google

- category

- tags (when clicking a tag or category user should be shown a list of posts of the same category/tag)

- number of views

- post language

- url ([login to view URL] or [login to view URL] if possible)

- notes (only viewable in edition mode by editors)

- the system should support 2 types of user, normal and editor

- normal users cannot perform any operations except register and login. They may also add new posts but they will only be displayed once aproved by an editor

- user registration and login can be made via normal form or using a third party like oAuth(login using facebook, etc)

- users can add their own photos to a post (even if it’s not his post), but normal user's photos need to be aproved by an editor before being displayed

- photos should be uploaded to a third party service api such as dropbox or similar, not to the local server

Information about users to be stored:

name

email

password (automatically generated if user registered using third party)

site should try to detect user location and be multi-language friendly, this should be done according to a table of countries. you have to create the table with a few records, for example usa and uk, and i'll add other countries later. I for example user is from usa, site should be in english and when browsing throw posts he should only see english posts, he can only see another language's posts only if he accesses it directly. If the country isn't detected, the default language assumed is english. In the same example, if user is from portugal or brasil, language should be portuguese and he'll see the site in portuguese. Every word in the site that isn't related to the post itself should be in an array, so i can add the equivalent word or expression in other languages.

main menu should display a home button and 3 or 4 categories, when clicking a category, user should see a list of posts from that category

- the solution should be made considering good engineering principles such as scalability, layering and safety. It should be easy to scale and add features.

if the solution created is good, in the future you can have another job of creating webservices and a mobile app related to this cms.

- solution should support cookies to maintaing user logged in and only if a user is logged in, he can see special features, such as adding new posts or aprove posts in case of an editor

- post must save data of who was the editor who aproved it, if it's a normal user's post

- normal users can be forbidden by an editor of adding new content

- when logging in or registering using normal form, user has to use some kind of “recaptcha” form to confirm he is human

sidebar should have a small list of top posts (with most views) in the last 7 days, today or all month, according to user preference, default should be for today but user can choose using some kind of selector

in each post a facebook like/share button and comment form should be seen

at the bottom of the post, users should see a small list of related posts wich should be selected randomly from same category posts

payment will be made once the cms is fully tested. You must deliver full solution source code and a text file containing the sql table creates.

C# Programming Graphic Design HTML MySQL Website Design

Project ID: #10961958

About the project