I have started an [url removed, login to view] page, and I need help with the database part of it. I have already completed the [url removed, login to view] page and have the SQL Statements ready. I will need you to set up the Roles/Membership part of this, and **ONCE COMPLETED explain to me how to Add/Remove/Edit the Roles and Users.****
1) Use the default [url removed, login to view] Roles/Membership and add 11 Roles and 8 users (I will e-mail the Roles, and users/passwords at start of project).
2) /Coaches/[url removed, login to view] - This page will only be accessible to users in the Coaches role. This page will have two parts. At the top, there will be a link "Add new" which will take you to /Coaches/[url removed, login to view] . On [url removed, login to view] you will simply be able to add a new player to your team. The user will need to input the player's Number (int), First Name (string), Last Name (string). This will add the player to the roster.
Below the "add new" link will be a list of players in alphabetical order, with an "edit" button next to each of them. Clicking on edit will allow you to edit that player's Number, First Name, or Last Name.
3) /Coaches/[url removed, login to view] - This page will only be accessible to users in the Coaches role. This page will list each player on the team alphabetically. It will then display the player's current stats (games played, hits, runs, doubles, etc.) beside his name. UNDER each stat for EVERY player will be an input field. Here, the user will be able to input the NEW stats for EVERY player. At the bottom of this page should be an "UPDATE" button. This will update all of the stats in the database.
**Please ask for clarification for any step if you are unsure before you get started as I will feel bad if a page needs to be redone. Bonuses offered to programmers who go above and beyond.**