.net home work

CIS 5612 Homework 4     The purpose of this assignment is to practice these skills: -Use of databases in ASP.NET -Creating secure applications   You will need: - Northwind database (file: [login to view URL]), available in this HW link.     Web site specifications   In this assignment, you will develop an application that supports the inventory management and human resources departments of the “ASP Your Design” company. The web site allows employees from the Inventory Management department to log in and view data related to suppliers/shippers and allows Human Resources (HR) department employees to access data related to employees. We are assuming that Inventory Management employees can self-register in the web site, while HR employees have to be registered by web site administrator.   This web site will consist of the following pages:   1. Home page (named [login to view URL]). This page is the entry point for all users and includes a welcome message. The home page allows registered Inventory Management employees to log in, new Inventory Management employees to register and provides the login for HR employees. (You can create separate web pages for login/register or you can include some of the login controls in the home page).   2. After successful registration or authentication, inventory management employees are directed to the Inventory page (named [login to view URL]).  In this page: Display supplier and product information from the Northwind database. When the user selects a supplier name from a drop down list, the rest of the information about that supplier is displayed in a detailsview control. In addition, the list of products of that supplier is displayed in a gridview. Display all fields with data about products. Select a formatting style and use appropriate headers for the columns (including spaces between words, for example ‘Product Name’, instead of ‘ProductName’). Implement this functionality using SqlDataSources and configuration wizard.       Displays information about shipping companies from the Shippers table. Display in a DetailsView control. Include pagination and set it to allow to edit, delete and add a new record. Implement this functionality using SqlDataSources and configuration wizard.    3. After successful authentication, HR department employees are directed to a page named Employees.aspx.  In this page: Display data about employees, using the Employees table. Display employee ID in a dropdownlist. When an ID is selected, the following is displayed in labels: first name, last name, title, birth date and hire date. Use the disconnected data access approach (dataset) programmatically.   Both Inventory and Employees pages should be secured and only accessible by registered users.   Additional requirements:   1-Required users -Inventory management employees can be registered either using the login controls or WAT. -HR employees should only be created using WAT. -Create the following registered users (for testing purposes):  1- Inventory management employee  name: yourfirstname        password: yourfirstname*        role: IM    2- HR employee  name: yourlastname         password: yourlastName*        role: HR   Note that you need to use YOUR actual first name and last name as user id and passwords. If your first or last name is not long enough for the password add numbers (1-9). For example, my password would be: faja12*.  Your login IDs and passwords should show on the page where they need to be used.   2- You need to implement each database-related functionality using the approach that I have specified for that task (for example, disconnected programmatically or binding to a grid view using configuration wizards). You will not get full points if the task is not implemented as specified, even if the page shows the correct results.   3- Make sure the database in the App_Data folder and the connection string in the [login to view URL] file looks like this:   <add name="Northwind" connectionString="Data Source=(localdb)\v11.0; AttachDbFilename=|DataDirectory|\[login to view URL];Integrated Security=True;Connect Timeout=30"/> If you do not provide the credentials for test users or have the right connection string, then site cannot be tested and I will not consider your HW.