implement integration test for backend

[MuChenZhangg]

[MuChenZhangg]

Inital test for controllers, viewmodels ,and services done.

Tools:
xunit for basic framework
moq for service call in controller
sq lite in memory database for integration test for services.

[MuChenZhangg]

The most recent failing test is based on woobenskyp's change regarding adding logic for checking for "who can see the course schedule" in the backend. Test failed for current develop branch but succeed after implementing change to the files necessary to apply logic check for course schedule.

Note:
changes applied to make test work:

1. since AuthUtils.cs has static class methods, using moq to simulate authentication process is not possible so manually creating User has to be done.
   2.since it's based on a potentially merging branch some changes have to be applied in order for test to work such as adding method to the schedule interface and and scheduleservice.

[MuChenZhangg]

So far regarding the test framework Dr.Tuck suggests focusing on the controller test which does not require any extra change to the original code.

[MuChenZhangg]

Dr.Tuck also suggest the potential of integrating the test to be ran auotmatically when commiting or pushing.

[MuChenZhangg]

brief summary on functionality of test frameworks:

xunit:
functions well as basic tools for writing test and operating test. No encountering issue so far.

moq:
used for simulating a real method call, works well so far with the controller tests.
Major drawback--cannot work with anything involving EF core.

sq lite in-memory-database:{no longer in use but reference for future}
sq lite is like a light database which can't do the full simulation of microsoft sql , but were able to run the test for services--just require to comment out this line(modelBuilder.HasSequence("Information_Change_Request_Seq", "dbo"); ) from CCT context which does not support by sq lite.

[MuChenZhangg]

This serves as a record of how integration test is done:
#both service test and profile test has been done but the idea is to connect them and build an integration test
note: since it's for record only some controller test is not working

[MuChenZhangg]

for future reference as we migrate to salesforece it would be valuable to look into integration test with real database for testing