Development of a working time accounting system. At what level to implement the logic?

Question

SQL

Hello.
He began to develop a system for recording the working time of employees. The database stores information about employees (name, card key, work schedule (beginning / end of the working day, lunch)) and passages (date, time, direction (entry / exit)).
Based on these data, it is required to calculate how long each employee was inside the controlled perimeter, taking into account his work schedule. The system is an application on asp.net web forms.
Where is it better to implement time counting: inside the application itself or in a sql query?

Answer 1

The server must count. The application should only be an interface to the user.

Answer 2

It would be easier for me to do this in the application, but if you know sql well, then you can write a trigger that fires when a person leaves the territory and counts the time.