/SportUnity

Database project EERD, SQL procedures and a website using ASP.NET

Primary LanguageC#

System Admin:

  1. Add a new club using its name and location.
  2. Delete a club using its name.
  3. Add a new stadium using its name, location, and capacity.
  4. Delete a stadium using its name.
  5. Block a fan using its national ID number.

Sports Association Manager:

  1. Register with a name, username and password.
  2. Add a new match with a host club name, guest club name, start time, and end time.
  3. Delete a match with a host club name, guest club name, start time, and end time.
  4. View All upcoming matches (in the form of host club name, guest club name, start time, and end time).
  5. View already played matches (in the form of the host club name, guest club name, start time, and end time).
  6. View a pair of club names who never scheduled to play with each other.

Club Representative:

  1. Register with a name, username, password, and the name of an already existing club.
  2. View all related information about the club he is representing.
  3. View all upcoming matches for the club he is representing (in the form of host club name, guest club name, start time, and end time) with the stadium name that hosts the match (if available).
  4. View all available stadiums starting at a specific date (in the form of stadium name, location, and capacity).
  5. Send a request to a stadium manager to host an upcoming match his club is hosting.

Stadium Manager:

  1. Register with a name, username, password, and name of an already existing stadium.
  2. View all related information about the Stadium he is managing.
  3. View all requests he has already received (in the form of the name of the sending club representative, name of the host club of the requested match, name of the guest club of the requested match,start time of the match, end time of the match and the status of the request).
  4. Accept an already sent unhandled request.
  5. Reject an already sent unhandled request.

Fan:

  1. Register with a name, username, password, national ID number, phone number, birth date, and an address.
  2. View all matches that have available tickets starting at a given time (in the form of host club name, guest club name, name of the stadium hosting the match, and the location of that stadium).
  3. Purchase a ticket for a match.

Tools and Technologies:

  • Backend: C# (ASP.NET MVC), Entity Framework
  • Frontend: HTML, CSS, JavaScript, Razor syntax
  • Database: MSSQL
  • Authentication: ASP.NET Identity
  • Version Control: Git
  • Development Environment: Visual Studio