Group Team
GroupID
GroupName
ID
TeamName
Point
GroupID
Position
Role: Administrator = 1; Staff = 2; Manager=3;
1. (1.0 mark) Authentication function. Using Email, Password, Status (active) for authentication process.
If user with a Administrator Role or Staff Role logs in successfully, save this information to a temporary parameter. In the case login unsuccessfully, display "You do not have permission to do this function!".
.
All CRUD actions are required with Administrator Role,
Staff Role is required for only Read action.
2. (2.0 marks) Check if login successfully (Staff or Administrator role), list all team information in Teams table (ID, TeamName, Point, GroupName, Position). Paging is required for this function,8 records/page.
3. (1.0 mark) If user with a Administrator role logs in successfully, search all team with 2 conditions: Position and GroupName (using relative search)
Close
+ 100%
Zoom
