Reference no: EM131268811

PART1 - Initial signup page should be arranged in this fashion:

This page will contain fields so that the user can provide you a username and an e-mail address. Make sure you connect to the database to check if the username exists. If the username exists in the database an error label should be displayed to the user. Also, make sure the user cannot enter an e-mail address with an invalid format.

After this, the user should be redirected to another page:

This page will contain some extra fields. Here the user will type his/her first name, last name, country and password. All fields are required. Implement countries (a few of them, perhaps 2-3 countries) using Visual Studio (add new items through Visual Studio, not DBM Tool). Passwords should match so include a second textbox for retyping the password. Passwords should begin with a letter, should include an uppercase letter, a lowercase letter and a digit. Passwords should at least be 8 characters long.

Another important point here: The form should have Username and Email section as well but these textboxes should be read-only. You will be fetching this information from the previous page. Use session state here.

After the user signs up you should display a new page with some text ("Signup successful" page).

The database should include a table named User. This table should include the following fields:

• User_ID
• User_Username
• User_Password
• User_Email
• User_FName
• User_LName
• User_Country

Do not include any other tables as I will be checking your projects by using a database with this structure.

PART2 - Once you are on the login page, provide another link named Admin Login. admin username should be: admin001 and password should be: Admin*3351. Once you are authenticated you should be taken to the management console of the website where you can see the list of users with their personal information. Usage of Gridviews is a must. Like what we saw on slides, provide functionality for insertion alongside edition and deletion. Implement field checking for empty fields. -We talked about this on slides and the video contains some information regarding this-.

Create another table called Admin and include columns similar to that of the User table. (Rather than User_Username you will have Admin_Username,etc.).

Important thing to note: Check the previous assignment and you will see the names of the fields that I wish you to use for the database. Follow the naming convention that I provided. You cannot create a table called User and FirstName as its field. This is blasphemy! What if you have another table called admin and it also has FirstName as a field? Underscore would help: Admin_FirstName. Use naming conventions properly .

Another thing to note: Zip your ENTIRE project and submit the assignment. Do not try to pick individual files.

Potential bonuses: Views other than Gridview (Listview, Detailsview, Formview if you use them meaningfully. +5 points for Listview and Detailsview, +10 points for Formview with an appropriate template). Use Master Pages. If you have a meaningful design with a Master Page, you will earn 10 additional points.