The goal of this assignment is to practice how to add master pages and also how to connect the ASP.NET application to SQL Server database using ADO.NET. Design and develop a multi page ASP.NET web application that allows the users to sign up, login, and update their account details at any time. Here are the specific requirements: o Create a master page that contains the following: o Banner (attached in the assignment description) o Menu with 3 menu items - Sign Up, Login and My Account o Create 3 content pages using the above master page - SignUp.aspx, Login.aspx, MyAccount.aspx o In your SQL Server database, create a Users table and insert some records into it by executing the queries in Users.sql (attached in assignment description) o When the user clicks on Login menu item, load the Login.aspx content page, which allows the user to enter their username and password. If the login is successful, hide the username and password entry textboxes and show a message saying that login is successful and provide a button to Logout. If the entered username doesn't exist in the database, display an appropriate error message indicating the same. If the username exists in the database but the entered password doesn't match, display an appropriate error message indicating the same. Below is the SQL SELECT command you can use in your ADO.NET code to fetch the password of a given username: "SELECT password FROM Users WHERE username=@username" Note: When the user clicks on Logout button, hide the Logout button and show again the username and password entry textboxes along with the button to Login. o When the user clicks on Sign Up menu item, load the SignUp.aspx content page, which allows the user to enter all their details and insert a new record into the Users table. If the entered username is already taken, display an appropriate error message indicating the same. Below is the SQL INSERT command that you can use in your ADO.NET code: "INSERT INTO Users VALUES (@username, @password, @lastname, @firstname, @address, @birthdate, @phone)" o When the user clicks on My Account menu item, load the MyAccount.aspx content page, which shows all the details of the logged in user, and allow them to update any of those details except their username. Below is the SQL UPDATE command you can use in your ADO.NET code to update the record of a given username: "Update Users SET password=@password, lastName=@lastName, firstName=@firstName, address=@address, birthDate=@birthDate, phone=@phone WHERE username = @username" Note: If the user navigates to My Account page without logging in, you shouldn't show any account details and just display a message saying 'You must login to see account details!' o Make sure you perform appropriate validations on the pages to prevent the user from entering erroneous data into the database. For example the username, password, lastname and firstname cannot be empty. The birthdate should be in the format mm/dd/yyyy. The phone number must be a 10-digit number. The password must be at least 8 characters long and should contain at least one uppercase character, one digit, and one special character.

Expert Answer

An expert answer will be posted here