220858 Half-complete ASP.Net page/DB
N/A
Teslim sırasında ödenir
I have a half-complete ASP.Net page, and I need the database part of it done. I have already completed the [url removed, login to view] page and a few others as I want them. Here is a list of what needs to be completed. These are mostly simple tasks. After the project is complete, I will need you to explain to me how to: Add/Remove/Edit the Roles and Users.
**Note: I have already created and linked the database, and most of the SQL statements. However, if it will be easier for you to create your own, then feel free to do so**
1) Use the default ASP.Net Roles/Membership and add 11 Roles and 8 users (I will e-mail the Roles, and users/passwords at start of project). 8 of the Roles will be different team names. The remaining 3 will be: Admin, Coaches, Coordinator. All users will additionaly be a part of the "Coaches" Role.
2) Each user will be part of a diffrent team from Roles. When the user logs in, they will be able to directly edit information regarding their team ONLY.
3) [url removed, login to view] - This page is already made, and the data is already populated. However, if a user logs in as team 1, then they should be able to edit this table directly.
4) [url removed, login to view] - This page is already made, and the standings are generated by a SQL statement. If using a new database, simply change the "FROM" field in the SQL statement to get data from your new database.
5a) [url removed, login to view] - This page is already made. I currently run 2 SQL Statements: 1 gets games that have already happened, the other gets games that have yet to be played. For the games that have already happened, directly on this page I need logged in users to have the ability to input scores for their teams. Since two teams will be involved for every entry, either of the two users can input the score for each game. Once a score is entered by either team, it will display the score and no one will be able to edit it anymore. I have already implemented that the winning team must be bolded. In case of a tie, neither team is bolded.
6) [url removed, login to view] - This page is already made, and the player stats are generated by a SQL statement. If using a new database, simply change the "FROM" field in the SQL statement to get data from your new database.
7) /Coordinator/[url removed, login to view] - This page will only be accessible to users in the Coordinator role. This page will have two parts. At the top, there will be a link "Add new" which will take you to /Coordinator/[url removed, login to view] . On [url removed, login to view] you will simply be able to add a new game where you pick the date from a calendar (able to click the date). You can then pick the Visitor and Home teams from the list of teams from the database. You will then be able to input the Diamond, and time of the game as simply strings.
Below this link, the current schedule will show with the ability to edit any of the games. Once the user clicks to edit a game, he will be able to change all of the fields (in the same way as [url removed, login to view]).
8) /Admin/[url removed, login to view] - This page will only be accessible to users in the Admin role. This page allows the admin to edit the bulletin that displays on default.aspx.
9) [url removed, login to view] - This page simply displays the most recent bulletin entry, and is already completed.
10) /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.
11) /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.**
Proje NO: #1967092
