Table Of Contents

Getting Started

How to use ExamEase

Change Log

Requirement

Setup & Configuration

Technical Information

Code Editing

FAQ

Credits

FAQ > What to do after download the file?

Unzip the file. Follow steps in Localhost section below if you want to do customization in your local environment. Otherwise, follow the steps in Hosting section below if you want to publish the project to hosting server so that everyone can access to the site.

Local Host

Video version of detailed configuration steps: https://youtu.be/V8uZvonAL70

Text version of detailed configuration steps are as below.

Database Connection String Configuration

  1. Open ExamEase.sln with Visual studio

  2. Click View > Click SQL Server Object Explorer

    Untitled

  3. Expand the SQL Server, right click on Databases, click “Add New Database”. Give it a name, click OK.

    Untitled

  4. Expand the database that you created just now. Right click on the database > Click Properties.

  5. Find the connection string and copy the value

    Untitled

  6. Open appsettings.json, paste the connection string value for “DefaultConnection”

    Untitled

Time Zone Configuration

  1. Go to this site: https://dotnetfiddle.net/iwXfjO

  2. Find your time zone ID and copy the time zone. Open appsettings.json, replace the “timeZone” value

    Untitled

<aside> 💡 This system time zone value is only for the developer to check and understand the date and time value easily from the database. When the system displays the date and time to the user, it will use the UTC date and time that is saved in the database and convert it to the user's local time. (To understand more, you can read the example given below.)

</aside>

<aside> 💡 Example of how timeZone in step 2 above works: (1) Assume timeZone in appsettings.json = "Singapore Standard Time," and we want to save a record's creation date and time. (2) Save SingaporeDateTime in the database. (3) Save UtcDateTime in the database. (4) Get UTCDateTime from the database when displaying it to the user (we have a general JavaScript function that converts UTCDateTime to the user's local date and time). (5) The developers want to know the record’s creation date and time from the database, but they are too lazy to convert the UtcDateTime to their local date and time, so they can directly check the SingaporeDateTime column (which is relevant to their local date and time).

</aside>

SMTP Email Configuration

  1. Login to your SMTP email service account, for example, we are using SendInBlue. You can use other SMTP service provider like sendgrid too.
  2. Go to the page where you can get the SMTP username and password. Copy the value and paste the value accordingly in appsettings.json smtp settings section.
"smtpUserName": "**[email protected]**",
"smtpPassword": "**yourpassword**",
"smtpHost": "**smtp-relay.sendinblue.com**",
"smtpPort": 587,

Done! Press CTRL + F5 to build and run the project.

Hosting

For detailed configuration steps, please watch this video: https://youtu.be/GQWjeV62Clk

Thank you.