#JDE #.NET Core #C# #MS SQL Server #Exchange Server
#Email #Web System #License Management #Workday
Different employees may need to have a valid license for their job based on the legal or job requirement. Our client has adopted a customized web based system for the maintenance of the license details for different employees. This License Maintenance System was built by using dot NET core technology with MS SQL server.
The license details of different employees of different departments are stored in a MS SQL server database, each department will be responsible for the maintainance of their own license.
The system contains a notification function, it will check for the license validitity in a daily basis. With integratoin to MS exchange server, it will send out the notification email to different personnel based on different situation, e.g. send to supervisor for 7 days before expired, send to supervisor and team head for 3 days before expired, send to supervisor, team head and department head for expired licenses...etc. With the configurable notification matrix, it can ensure the appropriate level of management will be get informed for the license status of the employees.
The system also has integration with other systems. The employees information is interfaced from the Workday System so that the employee information will keep updated and aligned with the HR system's records. The login credentials is based on the the Windows AD (Active Directory), it will verify the login credentials by against the Windows AD thru LDAP. Thus user can simply use their Windows AD account for login the License Maintenance System.