Normal User Login Issue

[chirayu-parmar]

Describe the bug
Normal users can’t login. The reason for the bug is that in ConnectionFactory class the checkLogin method is having hard-coded SQL query for ADMINISTRATOR instead of ADMINISTRATOR or Normal User. Therefore, if a Normal User tries to login into the application. This query returns a NULL result.

To Reproduce
Steps to reproduce the behavior:

1. Enter Username : (Normal User's username)
2. Enter password : (Normal User's password)
3. User gets login error.

Expected behavior
Users should allow logging into the system if their Username and password associated with the Username is correct.

Screenshots

[ronknight]

I think this is not maintained anymore. It's good to fix the issue and make a pull request.